- Accounting - General (AC)
- Controlling (CO)
- Cross-Application Sources (OCA)
- Customer Service (0CS)
- Enterprise Controlling (EC)
- Financial Accounting (FI)
- Investment Management (IM)
- Logistics - General (LO)
- Materials Management (MM)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Quality Management (QM)
- Real Estate Management (0RE)
- Sales and Distribution (SD)
- Time Management (PT)
- Training and Event Management (PE)
- Treasury (TR)
0FI_AR_4
Customers: Line Items with Delta Extraction |
#TRAN |
Extraction method: F1 |
Delta: AIE
| Component: Financial Accounting: Customers
- 🔑 Keys (8)
- 💰 Amounts (13)
- ∑ Quantities
- 📅 Dates (9)
- ☰ Categorical (7)
- Other (38)
- 🔗 Relations
| Column Name | Description | |
|---|---|---|
| BUKRS | Company Code | |
| FISCPER | Fiscal year / period | |
| BELNR | Accounting Document Number | |
| BUZEI | Number of Line Item Within Accounting Document | |
| UPOSZ | Subitem Number | |
| KUNNR | Customer Number | |
| KKBER | Credit control area | |
| GJAHR | Fiscal Year |
| Column Name | Description | |
|---|---|---|
| 💲 Currency key of the local currency (LCURR): | ||
| DMSOL | Debit Amount in Local Currency | |
| DMHAB | Credit Amount in Local Currency | |
| DMSHB | Amount in Local Currency with +/- Signs | |
| SKNTO | Cash Discount Amount in Local Currency | |
| DMBTR | Amount in local currency | |
| 💲 Currency Key (WAERS): | ||
| WRSOL | Debit Amount in Document Currency | |
| WRHAB | Credit Amount in Document Currency | |
| WRSHB | Foreign Currency Amount with Signs (+/-) | |
| SKFBT | Amount Eligible for Cash Discount in Document Currency | |
| WSKTO | Cash Discount Amount in Document Currency | |
| WRBTR | Amount in document currency | |
| 💲 Currency Key of Second Local Currency (HWAE2): | ||
| DMBE2 | Amount in Second Local Currency or Global Currency | |
| 💲 Currency Key of Third Local Currency (HWAE3): | ||
| DMBE3 | Amount in Third Local Currency or First Freely-Def. Currency | |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| BLDAT | Document Date in Document | |
| BUDAT | Posting Date in the Document | |
| CPUDT | Day On Which Accounting Document Was Entered | |
| AUGDT | Clearing Date | |
| MADAT | Date of Last Dunning Notice | |
| NETDT | Net Due Date | |
| SK1DT | Due date according to cash discount terms 1 | |
| SK2DT | Due date according to cash discount terms 2 | |
| ZFBDT | Baseline Date for Due Date Calculation |
| Column Name | Description | |
|---|---|---|
| STATUSPS | Status of FI Item | Show values |
| KOART | Account type | Show values |
| XNEGP | Indicator: Negative Posting | Show values |
| XARCH | Indicator: Document Already Archived? | Show values |
| UPDMOD | BW Delta Process: Record Mode | Show values |
| BSTAT | Document Status | Show values |
| SHKZG | Debit/Credit Indicator | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| MABER | Dunning Area | MABER | |
| UMSKZ | Special G/L Indicator | UMSKZ | |
| BLART | Document Type | BLART | |
| BSCHL | Posting Key | BSCHL | |
| FISCVAR | Fiscal year variant | RSFISCVAR | |
| ZBD1T | Days for First Cash Discount | ZBDXT | |
| ZBD2T | Days for Second Cash Discount | ZBDXT | |
| ZBD3T | Net Payment Terms Period | ZBDXT | |
| ZBD1P | Cash Discount Percentage 1 | PRZ23 | |
| ZBD2P | Cash Discount Percentage 2 | PRZ23 | |
| LAND1 | Country/Region Key | LAND1 | |
| ZLSCH | Payment Method | ZLSCH | |
| ZTERM | Terms of Payment Key | ZTERM | |
| ZLSPR | Payment Block Key | ZAHLS | |
| RSTGR | Reason Code for Payments | RSTGR | |
| MANSP | Dunning Block | MANSP | |
| MSCHL | Dunning Key | MSCHL | |
| MANST | Dunning Level | MAHNS | |
| KTOPL | Chart of Accounts | KTOPL | |
| HKONT | General Ledger Account | SAKNR | |
| SAKNR | G/L Account Number | SAKNR | |
| FILKD | Account Number of the Branch | MAXKK | |
| AUGBL | Document Number of the Clearing Document | BELNR | |
| XBLNR | Reference Document Number | XBLNR | |
| REBZG | Document No. of the Invoice to Which the Transaction Belongs | BELNR | |
| REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | GJAHR | |
| REBZZ | Line Item in the Relevant Invoice | BUZEI | |
| VBELN | Sales and Distribution Document Number | VBELN | |
| XREF1 | Business Partner Reference Key | CHAR12 | |
| XREF2 | Business Partner Reference Key | CHAR12 | |
| XREF3 | Reference key for line item | CHAR20 | |
| SGTXT | Item Text | TEXT50 | |
| UMSKS | Special G/L Transaction Type | UMSKS | |
| ZUONR | Assignment Number | ZUONR | |
| AWTYP | Reference procedure | AWTYP | |
| AWKEY | Reference Key | AWKEY | |
| MONAT | Fiscal period | MONAT | |
| PROJK | Work Breakdown Structure Element (WBS Element) | PS_POSNR |