topic Table Fields in Application Development and Automation Discussions

Table Fields

Former Member — Mon, 19 Nov 2007 05:11:48 GMT

Hi All,

In my report, i m using Document No. & Clearing Doc., fields are BELNR & AUGBL from BSEG Table.....But it is Cluster table......

If any other table has same fields BELNR & AUGBL, plz tell me........

Regards,

Anil Kumar

Former Member — Mon, 19 Nov 2007 05:13:32 GMT

Hi,

Check out BSAD, BSIS table

regards,

Santosh

naimesh_patel — Mon, 19 Nov 2007 05:13:47 GMT

It depends on your requirment.. what you are trying to access:

LIKE:

BSAD - For Customer

BSAK - For Vendor

BSAS - For GL account

Regards,

Naimesh Patel

Former Member — Mon, 19 Nov 2007 05:21:13 GMT

Hi,

You can get the BELNR & AUGBL from this tables :

BKPF: Accounting Doc.Header(BUKRS,GJAHR,BELNR,MONAT)

BSIS: G/L Open Items (BELNR,AUGBL,HKONT,BUZEI,BUKRS,ZUONR,GJAHR)

BSAS: G/L Closed Items(BELNR,AUGBL,HKONT,BUZEI,BUKRS,GJAHR,ZUONR)

BSID: Customer Open Items(A/Receivables)(BELNR,AUGBL,KUNNR,VBELN)

BSAD: Customer Closed Items(A/Receivables)(BELNR,AUGBL,KUNNR,VBELN)

BSIK: Vendor Open Items(A/Payables)(BELNR,AUGBL,LIFNR,EBELN)

BSAK: Vendor Open Items(A/Payables)(BELNR,AUGBL,LIFNR,EBELN)

Thanks,

Sakthi.C

*Rewards for useful answers*