Hi All,
The goal of this document is to provide field level details for ACC_DOCUMENT03 idoc, used to load and extract data of Account Receivable and Account Payable in SAP ECC.
We understand that data in SAP are stored in SAP tables, with specific field requirement like data type and Length of field.
Often it’s difficult to memorize the field level details for any table.
In my sincere attempt, I have tried to include the field level details for a particular case of AP/AR
Please find attached the document, to understand the meaning of each and every field in IDOC, its system requirement (mandatory/non Mandatory), field name, description, segment name and table name where the field lies in SAP.
The document is designed segment wise,with each segment differentiated by colors.
|
System Required |
Text Description |
SAP Technical |
Field Length |
Segment Name |
|
E1BPACHE09 – Header (BSIK) |
|
|
|
|
|
|
Accounting Document Number |
BELNR |
10 |
E1BPACHE09 |
|
|
Reference Transaction |
AWTYP |
5 |
E1BPACHE09 |
|
|
Reference Key |
AWKEY |
20 |
E1BPACHE09 |
|
|
Logical system of source document |
AWSYS |
10 |
E1BPACHE09 |
|
|
Business Transaction |
GLVOR |
4 |
E1BPACHE09 |
|
* |
User Name |
USNAM |
12 |
E1BPACHE09 |
|
|
Document Header Text |
BKTXT |
25 |
E1BPACHE09 |
|
* |
Company Code |
BUKRS |
4 |
E1BPACHE09 |
|
* |
Document Date in Document |
BLDAT |
24 |
E1BPACHE09 |
|
* |
Posting Date in the Document |
BUDAT |
24 |
E1BPACHE09 |
|
|
Translation Date |
WWERT |
24 |
E1BPACHE09 |
|
|
Fiscal Year |
GJAHR |
4 |
E1BPACHE09 |
|
|
Fiscal Period |
MONAT |
2 |
E1BPACHE09 |
|
* |
Document Type |
BLART |
2 |
E1BPACHE09 |
|
|
Reference Document Number |
XBLNR |
16 |
E1BPACHE09 |
|
|
Cancel: object key (AWREF_REV and AWORG_REV) |
OBJ_KEY_R |
20 |
E1BPACHE09 |
|
|
Reason for reversal |
STGRD |
2 |
E1BPACHE09 |
|
|
Component in ACC Interface |
COMPO_ACC |
4 |
E1BPACHE09 |
|
|
Reference Document Number (for Dependencies see Long Text) |
REF_DOC_NO_LONG |
35 |
E1BPACHE09 |
|
|
Accounting Principle |
ACC_PRINCIPLE |
4 |
E1BPACHE09 |
|
|
Indicator: Negative posting |
XNEGP |
1 |
E1BPACHE09 |
|
|
Invoice Ref.: Object Key (AWREF_REB and AWORG_REB) |
OBJ_KEY_INV |
20 |
E1BPACHE09 |
|
|
Billing category |
BILL_CATEGORY |
1 |
E1BPACHE09 |
|
|
Tax Reporting Date |
VATDATE |
24 |
E1BPACHE09 |
|
E1BPACGL09 – G/L account item (BSIS) |
|
|
|
|
|
* |
Accounting_Document_Number |
BELNR |
10 |
E1BPACGL09 |
|
* |
Accounting_Document_Line_Item_Number |
BUZEI |
10 |
E1BPACGL09 |
|
* |
General_Ledger_Account |
HKONT |
10 |
E1BPACGL09 |
|
|
Item_Text |
SGTXT |
50 |
E1BPACGL09 |
|
|
Indicator for statistical line items |
STAT_CON |
1 |
E1BPACGL09 |
|
|
Logical Transaction |
LOG_PROC |
6 |
E1BPACGL09 |
|
|
Business partner reference key |
REF_KEY_1 |
12 |
E1BPACGL09 |
|
|
Business partner reference key |
REF_KEY_2 |
12 |
E1BPACGL09 |
|
|
Reference_key_for_line_item |
XREF3 |
20 |
E1BPACGL09 |
|
|
Transaction Key |
ACCT_KEY |
3 |
<span |
