- 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_GL_4
General Ledger: Line Items with Delta Extraction |
#TRAN |
Extraction method: F1 |
Delta: AIE
| Component: Financial Accounting: General Ledger
| Column Name | Description | |
|---|---|---|
| BUKRS | Company Code | |
| BELNR | Accounting Document Number | |
| GJAHR | Fiscal Year | |
| MANDT FK | Client |
| 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 | |
| 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 (+/-) | |
| WRBTR | Amount in document currency | |
| SKNTO | Cash Discount Amount in Local Currency | |
| 💲 Currency Key of Second Local Currency (HWAE2): | ||
| DMSO2 | Debit Amount in Second Local Currency | |
| DMHA2 | Credit Amount in Second Local Currency | |
| DMSH2 | Amount in Second Local Currency with +/- Sign | |
| DMBE2 | Amount in Second Local Currency or Global Currency | |
| 💲 Currency Key of Third Local Currency (HWAE3): | ||
| DMSO3 | Debit Amount in Third Local Currency | |
| DMHA3 | Credit Amount in Third Local Currency | |
| DMSH3 | Amount in Third Local Currency with +/- Sign | |
| 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 | |
| VALUT | Value date | |
| AUGDT | Clearing Date | |
| ZFBDT | Baseline Date for Due Date Calculation | |
| REINDAT | Invoice Receipt Date |
| Column Name | Description | |
|---|---|---|
| STATUSPS | Status of FI Item | Show values |
| KOART | Account type | Show values |
| CURT2 | Currency Type of Second Local Currency | Show values |
| CURT3 | Currency Type of Third Local Currency | Show values |
| XNEGP | Indicator: Negative Posting | Show values |
| UPDMOD | BW Delta Process: Record Mode | Show values |
| MWART | Tax Type | Show values |
| XREVERSAL | Specifies Whether Document Is Reversal Doc. or Reversed Doc. | Show values |
| BSTAT | Document Status | Show values |
| SHKZG | Debit/Credit Indicator | Show values |
| XZAHL | Indicator: Is Posting Key Used in a Payment Transaction? | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| FISCPER | Fiscal year / period | RSFISCPER | |
| BUZEI | Number of Line Item Within Accounting Document | BUZEI | |
| HKONT | General Ledger Account | SAKNR | |
| UMSKZ | Special G/L Indicator | UMSKZ | |
| BLART | Document Type | BLART | |
| BSCHL | Posting Key | BSCHL | |
| FISCVAR | Fiscal year variant | RSFISCVAR | |
| AUGBL | Document Number of the Clearing Document | BELNR | |
| KOKRS | Controlling Area | CACCD | |
| KOSTL | Cost Center | KOSTL | |
| PRCTR | Profit Center | PRCTR | |
| AUFNR | Order Number | AUFNR | |
| PROJK | Work Breakdown Structure Element (WBS Element) | PS_POSNR | |
| WERKS | Plant | WERKS | |
| GSBER | Business Area | GSBER | |
| FKBER | Functional Area | FKBER | |
| PPRCT | Partner Profit Center | PRCTR | |
| PARGB | Trading partner's business area | GSBER | |
| VBUND | Company ID of Trading Partner | RCOMP | |
| XBLNR | Reference Document Number | XBLNR | |
| XREF3 | Reference key for line item | CHAR20 | |
| AWREF | Reference document number | AWREF | |
| AWGJA | Document Year for Reference Document Number | GJAHR | |
| AWBUK | Company Code for Reference Document Number | BUKRS | |
| AWKOK | Controlling Area for Reference Document Number | CACCD | |
| SGTXT | Item Text | TEXT50 | |
| PS_POSID | Work Breakdown Structure Element (WBS Element) | PS_POSID | |
| ZUONR | Assignment Number | ZUONR | |
| STBLG | Reverse Document Number | BELNR | |
| STJAH | Fiscal Year of Reversal Document | GJAHR | |
| REBZG | Document No. of the Invoice to Which the Transaction Belongs | BELNR | |
| REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | GJAHR | |
| REBZT | Follow-On Document Type | REBZT | |
| BUZID | Identification of the Line Item | CHAR1 | |
| TXGRP | Group Indicator for Tax Line Items | NUM03 | |
| ZBD1T | Cash discount days 1 | ZBDXT | |
| ZBD2T | Cash discount days 2 | ZBDXT | |
| ZBD3T | Net Payment Terms Period | ZBDXT | |
| AWTYP | Reference procedure | AWTYP | |
| AWKEY | Reference Key | AWKEY | |
| MONAT | Fiscal period | MONAT | |
| BKTXT | Document Header Text | TEXT25 | |
| GLVOR | Business Transaction | CHAR4 | |
| PERNR | Personnel Number | PERNR | |
| FISTL | Funds Center | FISTL | |
| GEBER | Fund | BP_GEBER | |
| KTOSL | Transaction Key | CHAR3 | |
| BUDGET_PD | Budget Period | FM_BUDGET_PERIOD | |
| MWSKZ | Tax on sales/purchases code | MWSKZ | |
| LIFNR | Account Number of Supplier | LIFNR | |
| ZTERM | Terms of payment key | ZTERM |