11-19-2007 5:11 AM
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>
11-19-2007 5:13 AM
11-19-2007 5:13 AM
11-19-2007 5:13 AM
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
11-19-2007 5:21 AM
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*