Z-report purchase format register.

[former_member209909]

Hi All,

I am a SAP SD consultant. I tried to prepare a Z-report on purchase register based on item level. I analyzed no. of tables likes BSEG, BSET, BSIS, BSIK etc but there is no link between the tables for create single z-report. Please help for the logic. I attached my format here. Format is below:

Plant Code

Document Number

G/L Account

Vendor Code

Vendor Name

TIN No.

Vendor State Name

Posting Date/Value date

Reference/Assignment(Invoice No.)

Baseline payment dte (Invoice Date)

Purchasing Document

Quantity

Material

Text (Material Description)

Tax base amount

Service Tax Rate

BED  Rate

Cess Rate

SH Cess Rate

VAT Rate

CST Rate

Service Tax Amount

BED Amount

Education Cess

SHE Cess

VAT Amount

CST Amount

Tax Code

Tax Description

Thanks,

Rajeev Singh

[former_member198650]

Hi Rajeev,

In addition to the above tables, you have to check the tables RBKP,RSEG,LFA1 & T007A.

Regards,

Mukthar

[former_member209909]

Hi Mukthar Sir,

I am working on it and once i get the result, i ll get back to you.

Thanks

[former_member209909]

Hi Sir,

I analyzed the table but how can i get the separate tax value in table form according to my document no. i can get the all tax details values in BSET but how can i make in single sheet by link. Please help and give me the more explanation. It ll be great help for me. Thanks

[former_member198650]

Hi Rajeev,

If you want line item wise tax details, then you have to link RSEG-LFPOS field with BSET-BUZEI field, if the value matches then it will show tax details.

Regards,

Mukthar

[former_member209909]

Sir,

According to this logic RSEG-LFPOS field with BSET-BUZEI field, irrelevant value are populated. Any field there we can extract the data based on item, tax details, current amount. Tax team looking a GST implementation and i need this this report for analysis.