Table Fields

[Former Member]

Hi All,

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

If any other table has same fields <b>BELNR & AUGBL</b>, plz tell me........

Regards,

<b>Anil Kumar</b>

[Former Member]

Hi,

Check out BSAD, BSIS table

regards,

Santosh

[naimesh_patel]

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]

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*