Field in BSEG

[Former Member]

Hello experts,

I m developing the report on landed cost, I want one field namely 'Freight' included the service tax , for which data is in BSEG, for freight amount, material, po num and its service tax and transaction is there.But the problem is against service tax field these fields r not there except transaction & taxcode.

Scenario is:

A/c Doc No Taxcode FreightAmount Transaction G/l Amount Material No.Plant Po Num Line Item

700073334 S9 9999.96(Rs.) FR1 0000270301 10001477 1010 112345678 001

700073334 S9 100 ESA 0000270300

700073334 S9 10 ESA 0000330300

700073334 S9 1000.96(Rs.) FR1 0000270301 2000000 1010 112345678 001

700073334 S9 100 ESA 0000270300

I want to sum up the freight included the service tax for one particular material number.

I m not able to differentiate that one particular service tax exists for which particular material.

Plz tell any field by which I can differentiate.

Aastha

[ThomasZloch]

Just a guess out of the blue, does table BSET maybe contain the desired information?

Thomas

[Former Member]

Hello Thomas,

BSET is a cluster table.

Can u tell BSET is a combination of which tables and can u tell in which table i get maerial number & freight amount included service tax amount.

Aastha

[ThomasZloch]

BSET is a cluster table just like BSEG, both are contained in cluster RFBLG.

BSET holds additional tax related data for tax relevant BSEG entries (same primary key, if you noticed).

Regarding any specifics I cannot help, we don't have that business case here.

Thomas

[P561888]

Hi ,

To search for the any fields in SAP goto SE15->ABAP DDIC->FIELDS-->TABLE FIELDS.

You will get the all the all tables where fields is preseneted.

Regards,

Bharani