FI Document & MM Invoice

EKBE- get Invoice document,

BSEG & BKPF- FI document details

BSAK & BSIK- Payment details

Note 1  :

Use table BKPF there input document type “RE”  and then use field AWKEY i.e. Reference Key, it contains MIRO Document No with Fiscal Year.

That is if your LIV document is say 5605100011 and fiscal year is 2011 AWKEY is 56051000112011

You will get the Accounting document number (BKPF -BELNR and year BKPF- GJAHR) for your LIV document

 

Note – Cancel Document:

tcode cancel paid : that stored in BKPF-TCODE

MR8M – Cancel Invoice Document

FB08 – Reverse Financial Document

FBRA – Reset Cleared Items

if the tcode above exist in the BKPF-TCODE, that document canceled.

 

Collector : @linzyxer

 

 

 

URL Keren

CSS Facebook Tagging Picture

http://www.designers-chair.com/2009/03/facebook-picture-tagging-system/

auto logout with session

http://www.vijayjoshi.org/2008/12/12/automatic-session-timeout-logout-using-php-and-ajax-part-ii/

Check it dot

http://css-tricks.com/examples/SelectPrintable/

http://chandrajatnika.com/2009/09/create-update-dan-delete-data-master-dengan-ajax/

PHP Link :

http://blackphp.wordpress.com

http://9lessons.blogspot.com/

http://chandrajatnika.com

Oracle

http://www.klik-oracle.com/?cat=14

-

MySQL DBA

http://manztiara.wordpress.com

http://noryahya.wordpress.com

http://dollyaswin.net

Query Optimazion (Tabel dgn record BESAR)
Optimasi Left Join Dengan Subquery di MySQL

http://dollyaswin.net/blog/optimasi_left_join_dengan_subquery_di_mysql#comment-582

INDEX Mysql

http://hackmysql.com/documents

URL Rewrite

http://www.ilmuwebsite.com/detil_php_tutorial/30/Membuat_URL_Mod_Rewrite_Part_1_-_http_conf/

http://www.ilmuwebsite.com

Sinau CSS

http://preaxz.com/2009/01/desain-website-dengan-css/

http://www.ilmuwebsite.com/html/

Apriori

http://wargabasdat2009.wordpress.com/2009/06/10/data-mining-firdi/

downloten

http://ivan.siregar.biz/?p=56

Simple trick-trick

http://jnet99.wordpress.com/

temp table mysql

http://daunsalam.net/artikel/mysqlselect.htm

http://blog.amikom.info/sukrisno/archives/8

http://www.ducea.com/2007/07/25/dumping-mysql-stored-procedures-functions-and-triggers/

http://manztiara.wordpress.com

http://noryahya.wordpress.com

Catatan Kecil

Keikhlasan ibarat air hujan yang turun dari awan, 
ia tak mengharapkan curahan air hujan itu kembali padanya. 
by sir @ 9 Ramadhan 1432 H
---------------------------------------------------------

Ide Artikel php, javascript, jquery, extjs, mysql

Ada ide artikel yang menarik ngak? silahkan curhat di comment.

misalnya aja… buat apa gitu… (topik seputar php, javascript, jquery, extjs, mysql)

seee ya…. (by blackphp)

 

Online Webhost

Biar lebih mudah logon, q taruh disini ja link q

WEbhost gratis q : 000webhost

linzyxer : 11suse