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 Name

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

E1BPACGL09

Account Type

ACCT_TYPE

1

E1BPACGL09

Document_Type

BLART

2

E1BPACGL09

*

Company_Code

BUKRS

4

E1BPACGL09

Business_Area

GSBER

4

E1BPACGL09

Functional_Area

FKBER

4

E1BPACGL09

Plant

WERKS

4

E1BPACGL09

Fiscal_Period

MONAT

2

E1BPACGL09

*

Fiscal_Year

GJAHR

4

E1BPACGL09

Posting_Date_in_the_Document

BUDAT

24

E1BPACGL09

Value_date

VALUT

24

E1BPACGL09

Financial Management Area

FM_AREA

4

E1BPACGL09

Customer Number 1

CUSTOMER

10

E1BPACGL09

Indicator: Line item not liable to cash discount?

CSHDIS_IND

1

E1BPACGL09

Account Number of Vendor or Creditor

VENDOR_NO

10

E1BPACGL09

*

Assignment_Number

ZUONR

18

E1BPACGL09

Sales_Tax_Code

MWSKZ

2

E1BPACGL09

Tax Jurisdiction

TAXJURCODE

15

E1BPACGL09

Technical Key of External Object

EXT_OBJECT_ID

34

E1BPACGL09

Business Scenario in Controlling for Logistical Objects

BUS_SCENARIO

16

E1BPACGL09

Cost Object

COSTOBJECT

12

E1BPACGL09

Cost_Center

KOSTL

10

E1BPACGL09

Activity Type

ACTTYPE

6

E1BPACGL09

Profit_Center

PRCTR

10

E1BPACGL09

Partner_Profit_Center

PPRCT

10

E1BPACGL09

Network Number for Account Assignment

NETWORK

12

E1BPACGL09

Work_Breakdown_Structure_Element_(WBS_Element)

PROJK

24

E1BPACGL09

Order_Number

AUFNR

12

E1BPACGL09

Order Item Number

ORDER_ITNO

4

E1BPACGL09

Routing number of operations in the order

ROUTING_NO

10

E1BPACGL09

Operation/Activity Number

ACTIVITY

4

E1BPACGL09

Condition type

COND_TYPE

4

E1BPACGL09

Condition Counter

COND_COUNT

2

E1BPACGL09

Level Number

COND_ST_NO

3

E1BPACGL09

Fund

FISTL

10

E1BPACGL09

Funds_Center

GEBER

16

E1BPACGL09

Commitment_Item

FIPOS

14

E1BPACGL09

Business Process

CO_BUSPROC

12

E1BPACGL09

Main Asset Number

ASSET_NO

12

E1BPACGL09

Asset Subnumber

SUB_NUMBER

4

E1BPACGL09

Billing Type

BILL_TYPE

4

E1BPACGL09

Sales_Order_Number

KDAUF

10

E1BPACGL09

Item_Number_in_Sales_Order

KDPOS

6

E1BPACGL09

Distribution Channel

DISTR_CHAN

2

E1BPACGL09

Division

DIVISION

2

E1BPACGL09

Sales Organization

SALESORG

4

E1BPACGL09

Sales Group

SALES_GRP

3

E1BPACGL09

Sales Office

SALES_OFF

4

E1BPACGL09

Sold-to party

SOLD_TO

10

E1BPACGL09

Indicator: subsequent debit/credit

DE_CRE_IND

1

E1BPACGL09

Partner profit center for elimination of internal business

P_EL_PRCTR

10

E1BPACGL09

Indicator: Update quantity in RW

XMFRW

1

E1BPACGL09

Quantity

MBGBTR

48

E1BPACGL09

Base_Unit_of_Measure

MEINB

3

E1BPACGL09

Actual Invoiced Quantity

INV_QTY

48

E1BPACGL09

Billing quantity in stockkeeping unit

INV_QTY_SU

48

E1BPACGL09

Sales unit

SALES_UNIT

3

E1BPACGL09

Quantity in order price quantity unit

PO_PR_QNT

48

E1BPACGL09

Order price unit (purchasing)

PO_PR_UOM

3

E1BPACGL09

Quantity in Unit of Entry

ENTRY_QNT

48

E1BPACGL09

Unit of Entry

ENTRY_UOM

3

E1BPACGL09

Volume

VOLUME

48

E1BPACGL09

Volume unit

VOLUMEUNIT

3

E1BPACGL09

Gross Weight

GROSS_WT

48

E1BPACGL09

Net weight

NET_WEIGHT

48

E1BPACGL09

Weight unit

UNIT_OF_WT

3

E1BPACGL09

Item category in purchasing document

ITEM_CAT

1

E1BPACGL09

Material_Number

MATNR

18

E1BPACGL09

Material Type

MATL_TYPE

4

E1BPACGL09

Movement Indicator

MVT_IND

1

E1BPACGL09

Revaluation

REVAL_IND

1

E1BPACGL09

Origin Group as Subdivision of Cost Element

ORIG_GROUP

4

E1BPACGL09

Material-related origin

ORIG_MAT

1

E1BPACGL09

Sequential number of account assignment

SERIAL_NO

2

E1BPACGL09

Partner account number

PART_ACCT

10

E1BPACGL09

Trading partner’s business area

TR_PART_BA

4

E1BPACGL09

Company ID of trading partner

TRADE_ID

6

E1BPACGL09

Valuation Area

VAL_AREA

4

E1BPACGL09

Valuation Type

VAL_TYPE

10

E1BPACGL09

Reference Date

ASVAL_DATE

24

E1BPACGL09

Purchasing Document Number

PO_NUMBER

10

E1BPACGL09

Item Number of Purchasing Document

PO_ITEM

5

E1BPACGL09

Item number of the SD document

ITM_NUMBER

6

E1BPACGL09

Condition Category (Examples: Tax, Freight, Price, Cost)

COND_CATEGORY

1

E1BPACGL09

Functional Area Long

FUNC_AREA_LONG

16

E1BPACGL09

Commitment Item Long

CMMT_ITEM_LONG

24

E1BPACGL09

Grant

GRANT_NBR

20

E1BPACGL09

Transaction Type

CS_TRANS_T

3

E1BPACGL09

Funded Program

MEASURE

24

E1BPACGL09

Segment for Segmental Reporting

SEGMENT

10

E1BPACGL09

Partner Segment for Segmental Reporting

PARTNER_SEGMENT

10

E1BPACGL09

Document Number for Earmarked Funds

RES_DOC

10

E1BPACGL09

Earmarked Funds: Document Item

RES_ITEM

3

E1BPACGL09

Billing Period of Performance Start Date

BILLING_PERIOD_START_DATE

24

E1BPACGL09

Billing Period of Performance End Date

BILLING_PERIOD_END_DATE

24

E1BPACGL09

PPA Exclude Indicator

PPA_EX_IND

1

E1BPACGL09

PPA Fast Pay Indicator

FASTPAY

1

E1BPACGL09

E1BPACAR09 – Customer Item (BSID)

Accounting Document Number

BELNR

10

E1BPACAR09

*

Accounting Document Line Item Number

ITEMNO_ACC

10

E1BPACAR09

Customer Number 1

KUNNR

10

E1BPACAR09

General Ledger Account

HKONT

10

E1BPACAR09

Business partner reference key

XREF1

12

E1BPACAR09

Business partner reference key

XREF2

12

E1BPACAR09

Reference key for line item

XREF3

20

E1BPACAR09

Company Code

BUKRS

4

E1BPACAR09

Business Area

GSBER

4

E1BPACAR09

Terms of Payment Key

ZTERM

4

E1BPACAR09

Baseline Date For Due Date Calculation

ZFBDT

24

E1BPACAR09

Days for first cash discount

ZBD1T

3

E1BPACAR09

Days for second cash discount

ZBD2T

3

E1BPACAR09

Deadline for net conditions

ZBD3T

3

E1BPACAR09

Percentage for First Cash Discount

ZBD1P

5

E1BPACAR09

Percentage for Second Cash Discount

ZBD2P

5

E1BPACAR09

Payment method

ZLSCH

1

E1BPACAR09

Payment Method Supplement

UZAWE

2

E1BPACAR09

Payment Reference

KIDNO

30

E1BPACAR09

Dunning keys

MSCHL

1

E1BPACAR09

Dunning block

MANSP

1

E1BPACAR09

Payment block key

ZLSPR

1

E1BPACAR09

VAT Registration Number

STCEG

20

E1BPACAR09

Assignment Number

ZUONR

18

E1BPACAR09

Item Text

SGTXT

50

E1BPACAR09

Partner Bank Type

BVTYP

4

E1BPACAR09

State Central Bank Indicator

LZBKZ

3

E1BPACAR09

Stores

BUPLA

4

E1BPACAR09

Section Code

SECCO

4

E1BPACAR09

Account number of the branch

FILKD

10

E1BPACAR09

Currency for automatic payment

PYCUR

5

E1BPACAR09

Amount in Payment Currency

DMBTR

23

E1BPACAR09

Credit control area

KKBER

4

E1BPACAR09

Short Key for a House Bank

HBKID

5

E1BPACAR09

Supplying Country

LANDL

3

E1BPACAR09

Sales Tax Code

MWSKZ

2

E1BPACAR09

Tax Jurisdiction

TAXJURCODE

15

E1BPACAR09

Date Relevant for Determining the Tax Rate

TAX_DATE

24

E1BPACAR09

Special G/L Indicator

UMSKZ

1

E1BPACAR09

  1. Com. Interface: Business Partner GUID

PARTNER_GUID

32

E1BPACAR09

Alternative payee

KNRZA

10

E1BPACAR09

Bank type of alternative payer

ALT_PAYEE_BANK

4

E1BPACAR09

Dunning Area

MABER

2

E1BPACAR09

Technical Case Key (Case GUID)

CASE_GUID

32

E1BPACAR09

Profit Center

PRCTR

10

E1BPACAR09

Fund

GEBER

10

E1BPACAR09

Grant

GRANT_NBR

20

E1BPACAR09

Funded Program

MEASURE

24

E1BPACAR09

ID for account details

HKTID

5

E1BPACAR09

Document Number for Earmarked Funds

KBLNR

10

E1BPACAR09

Earmarked Funds: Document Item

KBLPOS

3

E1BPACAR09

Long Fund (Obsolete)

FUND_LONG

20

E1BPACAR09

Dispute Management: Dispute Interface Category

DISPUTE_IF_TYPE

1

E1BPACAR09

E1BPACAP09 – Vendor Item (BSIK)

Accounting Document Number

BELNR

10

E1BPACAP09

*

Accounting Document Line Item Number

ITEMNO_ACC

10

E1BPACAP09

Account Number of Vendor or Creditor

LIFNR

10

E1BPACAP09

General Ledger Account

HKONT

10

E1BPACAP09

Business partner reference key

XREF1

12

E1BPACAP09

Business partner reference key

XREF2

12

E1BPACAP09

Reference key for line item

XREF3

20

E1BPACAP09

Company Code

BUKRS

4

E1BPACAP09

Business Area

GSBER

4

E1BPACAP09

Terms of Payment Key

ZTERM

4

E1BPACAP09

Baseline Date For Due Date Calculation

ZFBDT

24

E1BPACAP09

Days for first cash discount

ZBD1T

3

E1BPACAP09

Days for second cash discount

ZBD2T

3

E1BPACAP09

Deadline for net conditions

ZBD3T

3

E1BPACAP09

Percentage for First Cash Discount

ZBD1P

5

E1BPACAP09

Percentage for Second Cash Discount

ZBD2P

5

E1BPACAP09

Payment Method

ZLSCH

1

E1BPACAP09

Payment Method Supplement

UZAWE

2

E1BPACAP09

Payment Block Key

ZLSPR

1

E1BPACAP09

State Central Bank Indicator

LZBKZ

3

E1BPACAP09

Supplying Country

LANDL

3

E1BPACAP09

Service Indicator (Foreign Payment)

DIEKZ

1

E1BPACAP09

Assignment Number

ZUONR

18

E1BPACAP09

Item Text

SGTXT

50

E1BPACAP09

ISR Subscriber Number

PO_SUB_NO

11

E1BPACAP09

ISR Check Digit

PO_CHECKDG

2

E1BPACAP09

ISR Reference Number

PO_REF_NO

27

E1BPACAP09

Withholding Tax Code

QSSKZ

2

E1BPACAP09

Stores

BUPLA

4

E1BPACAP09

Section Code

SECCO

4

E1BPACAP09

Instruction key 1

DTWS1

2

E1BPACAP09

Instruction key 2

DTWS2

2

E1BPACAP09

Instruction key 3

DTWS3

2

E1BPACAP09

Instruction key 4

DTWS4

2

E1BPACAP09

Account number of the branch

FILKD

10

E1BPACAP09

Currency for Automatic Payment

PYCUR

5

E1BPACAP09

Amount in Payment Currency

DMBTR

23

E1BPACAP09

Special G/L Indicator

UMSKZ

1

E1BPACAP09

Sales Tax Code

MWSKZ

2

E1BPACAP09

Date Relevant for Determining the Tax Rate

TAX_DATE

24

E1BPACAP09

Tax Jurisdiction

TAXJURCODE

15

E1BPACAP09

Alternative Payee

ALT_PAYEE

10

E1BPACAP09

Bank type of alternative payer

ALT_PAYEE_BANK

4

E1BPACAP09

Partner Bank Type

BVTYP

4

E1BPACAP09

Short Key for a House Bank

HBKID

5

E1BPACAP09

  1. Com. Interface: Business Partner GUID

PARTNER_GUID

32

E1BPACAP09

Profit Center

PRCTR

10

E1BPACAP09

Fund

GEBER

10

E1BPACAP09

Grant

GRANT_NBR

20

E1BPACAP09

Funded Program

MEASURE

24

E1BPACAP09

ID for Account Details

HKTID

5

E1BPACAP09

E1BPACCR09 – Currency Items (BSIK)

Accounting Document Number

BELNR

10

E1BPACCR09

Accounting Document Line Item Number

BUZEI

10

E1BPACCR09

Currency Type and Valuation View

CURR_TYPE

2

E1BPACCR09

Currency Key

WAERS

5

E1BPACCR09

Amount in document currency

WRBTR

23

E1BPACCR09

Exchange rate

EXCH_RATE

9

E1BPACCR09

Indirect quoted exchange rate

EXCH_RATE_V

9

E1BPACCR09

Tax Base Amount in Document Currency

AMT_BASE

23

E1BPACCR09

Amount eligible for cash discount in document currency

SKFBT

23

E1BPACCR09

Cash discount amount in the currency of the currency types

DISC_AMT

23

E1BPACCR09

Amount in document currency

TAX_AMT

23

E1BPACCR09

Hope this would be helpful to all of us.

Regards,

Mayank Mehta

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply