Functional specs

[Former Member]

I want to create a sale register report. I do not know how to create FS.

I want report which includes below points -

Sale order no,delivery no,billing no,accounting doc no,excise inv no,batch no,sold to party,

billed qty,cancelled invoice no,excise condition details (JEXP,JCEP,JEAP) with values,other tax(JCST,JLST),material code & description,

Pls help for the logics for above requirements.

Raju

[Former Member]

not clear

[Former Member]

Hi

If you have the VBAK-VBELN (Sales Doc Number) then pass the VBELN into VBRP table in the field VBRP-AUBEL and in this VBRP table you will get the delivery number VBRP-VGBEL. And the billing number is VBRP-VBELN.

Similarly if you can pass the VBRP-VBELN into J_1IEXCDTL you will get the excise number J_1IEXCDTL-EXNUM.

For Billed qty the field is VBRP-FKIMG.

For cancelled invoice the field is VBRK-FKSTO if the invoice is cnacelled the field will be flagged so that you can ignore the invoice details.

For material and description VBRP-MATNR and for description VBRP-ARKTX

regards

Prashanth

[Former Member]

hi,

take this one into consideration.

please take the tables and fields in such a manner in sequence it appears.

Sale order no - vbak-vbeln

delivery no -likp - vbeln

billing no - vbrk - vbeln

accounting doc no - BKPF-BELNR

excise inv no - j_1iexchdr-exnum : ex Invoice No

batch no - likp - charg

sold to party - vbrk - kunnr

billed qty - VBRP-FKIMG

cancelled invoice no - j_1iexchdr-exnum : ex Invoice No

excise condition details (JEXP,JCEP,JEAP) with values,other tax(JCST,JLST) - KSCHL

material code & description - VBRP-ARKTX

balajia

[Former Member]

Hi,

In order to write FS, please go through the concerned Tables and identify the field and put it in the FS.

Ex: Sales order no: VBAK-VBEKN, similarly LIKP(Delivery Header), VBRK(Billing Header), J_1IEXCHDR(Excise Header) etc.

This way find out the necessary fields and write FS.

In case of any clarifications, revert back.

Best Regards

Sreekanth