- 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)
/CPD/AVR_DS_ERP_DATA
Extractor for ERP Data (Plan and Actuals) |
#TRAN |
Extraction method: F2 |
Delta: AIE
| Component: null
Tables used:
TKA01 → show details
| Column Name | Description | |
|---|---|---|
| MANDT FK | Client | |
| KOKRS | Controlling Area |
| Column Name | Description | |
|---|---|---|
| 💲 Transaction Currency (TWAER): | ||
| WTGBTR | Total Value in Transaction Currency | |
| ACTTCUR | /CPD/AVR_ACTTCUR | |
| AREVTC | Actual Revenue in Transaction Crcy | |
| PCTTCUR | Plan Cost in Transaction Currency | |
| PLRVNTCR | Planned Revenue Transaction Crcy | |
| 💲 Currency Key (OWAER): | ||
| WOGBTR | Total Value in Object Currency | |
| ACTOBCUR | Actual Cost in Object Currency | |
| AREVOC | Actual Revenue in Object Crcy | |
| PCTOBCUR | Plan Cost in Object Currency | |
| PLRVNOBC | Planned Revenue in Object Crcy | |
| 💲 Currency Key (WAERS): | ||
| WKGBTR | Total Value in Controlling Area Currency | |
| WKFBTR | Fixed Value in Controlling Area Currency | |
| PAGBTR | Total Price Variance in CO Area Currency | |
| PAFBTR | Price Variance, Fixed | |
| ACTCACUR | Actual Cost in CO Area Currency | |
| AREVCA | Actual Revenue in CO Area Crcy | |
| PCTCACUR | Plan Cost in Controlling Area Currency | |
| PLRVNCO | Planned Revenue In CO Area Crcy | |
| 💲 Project Currency (PROJ_CURRENCY): | ||
| ACST | Actual Cost | |
| AREV | Actual Revenue | |
| PCT | Plan Cost | |
| PLRVN | Planned Revenue | |
| 💲 Plan Currency (PLAN_CURRENCY): | ||
| ACSTFPC | Actual Cost in Plan Crcy | |
| AREVFPC | Actual Revenue in Plan Crcy | |
| Column Name | Description | |
|---|---|---|
| 📏 Unit of Measure for Display (MEINH): | ||
| MEGBTR | Total Quantity | |
| MEFBTR | Fixed Quantity | |
| FAQTY | Total quantity entered | |
| 📏 Posted Unit of Measure (MEINB): | ||
| MBGBTR | Total quantity entered | |
| MBFBTR | Fixed quantity entered | |
| Column Name | Description | |
|---|---|---|
| BLDAT | Document Date in Document | |
| BUDAT | Posting Date in the Document |
| Column Name | Description | |
|---|---|---|
| LEDNR | Ledger for Controlling Objects | Show values |
| WRTTP | Value Type | Show values |
| VRGNG | Indicator controls: X = activity " " = element | Show values |
| BEKNZ | Debit/credit indicator | Show values |
| STOKZ | Indicator: Document was reversed | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| BELNR | Document Number | CO_BELNR | |
| BUZEI | Posting Row | BUZEI | |
| PERIO | Period | PERBL | |
| OBJNR | Object number | J_OBJNR | |
| GJAHR | Fiscal Year | GJAHR | |
| VERSN | Version | COVERSI | |
| KSTAR | Cost Element | KSTAR | |
| TMSTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | |
| TIMESTMP | Time created (Greenwich Meantime) | RKE_TSTMP | |
| MATNR | Material Number | MATNR | |
| WERKS | Plant | WERKS | |
| BUKRS | Company Code | BUKRS | |
| PERNR | Personnel Number | PERNR | |
| PAROB | Partner Object | J_OBJNR | |
| PAROB1 | Partner object (always filled) | J_OBJNR | |
| USPOB | Source Object (Cost Center/Activity Type) | J_OBJNR | |
| VBUND | Company ID of Trading Partner | RCOMP | |
| PARGB | Trading partner's business area | GSBER | |
| MPID | Commercial Project ID | /CPD/MP_ID | |
| MPGUID | NodeID | /BOBF/CONF_KEY | |
| FPOID | Financial Plan ID | /CPD/PFP_PLAN_ID | |
| FPSCEN | Plan Scenario | /CPD/PFP_PLAN_SCEN_ID | |
| FVER | Version | /CPD/PFP_PLAN_VERSION | |
| FISCPER | Fiscal Period | ||
| CALMONTH | Calendar Month | ||
| FVARNT | Fiscal Variant | ||
| KFEL | Key Figure Element | /CPD/AVR_ELEM | |
| RES | Resource | /CPD/PFP_RESOURCE_ID | |
| RESTYP | Resource Type | /CPD/PFP_RES_TYPE | |
| STAGR | Statistical key figure | STAGR |