Order master data — the header record shared by every SAP order type (internal order, maintenance order, service order, WBS-linked order): order number, order type, controlling area, responsible/settlement cost center, status, and settlement cost element. This is the SAP analogue the CDK repair order keys on directly (AUFK-AUFNR).
Hover a canonical name to see the legacy SAP field name
| Canonical name | Concept | Description | Data element | Type | Check table |
|---|---|---|---|---|---|
| CLI key | cliens | Client | MANDT | CLNT 3 | T000 |
| MND_NUM key | mandatum numerus | Order Number | AUFNR | CHAR 12 | — |
| GMD | genus mandati | Order Type | AUFART | CHAR 4 | T003O |
| MND_CTG | mandatum categoria | Order category | AUFTYP | NUMC 2 | — |
| RFR_MND_NUM | referentia mandatum numerus | Reference order number | AUFREFNR | CHAR 12 | AUFK |
| ERNAM | Entered by | AUFERFNAM | CHAR 12 | — | |
| CRE | creatus | Created on | AUFERFDAT | DATS 8 | — |
| ULT_MUT | ultimus mutatus | Last changed by | AUFAENAM | CHAR 12 | — |
| DIE_MND | dies mandatum | Change date for Order Master | AUFAEDAT | DATS 8 | — |
| DSC | descriptio | Description | AUFTEXT | CHAR 40 | — |
| TXT | textus | Long Text Exists | AUFLTEXT | CHAR 1 | — |
| SOC | codex societatis | Company Code | BUKRS | CHAR 4 | T001 |
| OFC | officina | Plant | WERKS_D | CHAR 4 | T001W |
| ANG | area negotii | Business Area | GSBER | CHAR 4 | TGSB |
| AMD | area moderationis | Controlling Area | KOKRS | CHAR 4 | TKA01 |
| CSM | centrum sumptus | Responsible cost center | AUFKOSTV | CHAR 10 | CSKS |
| MND_MON | mandatum moneta | Order Currency | AUFWAERS | CUKY 5 | TCURC |
| MND_STA | mandatum status | Order status | AUFASTNR | NUMC 2 | — |
| DIE_ULT_STA | dies ultimus status | Date of last status change | AUFSTDAT | DATS 8 | — |
| MND_CRE | mandatum creatus | Phase "Order created" | AUFPHAS0 | CHAR 1 | — |
| MND | mandatum | Phase "Order released" | AUFPHAS1 | CHAR 1 | — |
| MND2 | mandatum | Phase "order completed" | AUFPHAS2 | CHAR 1 | — |
| MND3 | mandatum | Phase "order closed" | AUFPHAS3 | CHAR 1 | — |
| EMS_DIE | emissio dies | Planned release date | AUFPDAT1 | DATS 8 | — |
| DIE | dies | Planned completion date | AUFPDAT2 | DATS 8 | — |
| DIE2 | dies | Planned closing date | AUFPDAT3 | DATS 8 | — |
| EMS_DIE2 | emissio dies | Release date | AUFIDAT1 | DATS 8 | — |
| DIE3 | dies | Technical completion date | AUFIDAT2 | DATS 8 | — |
| DIE4 | dies | Close date | AUFIDAT3 | DATS 8 | — |
| OBI | obiectum | Object ID | CCOBJID | CHAR 1 | — |
| SGN | signum | Deletion flag | AUFLOEKZ | CHAR 1 | — |
| KALSM | Costing Sheet | AUFKALSM | CHAR 6 | T683 | |
| CLV | clavis | Overhead key | AUFZSCHL | CHAR 6 | — |
| TSC_SMP_ELM | transactio sumptus elementum | Settlement cost element | AUFKSTAR | CHAR 10 | CSKB |
| CSM_TSC | centrum sumptus transactio | Cost center for basic settlement | AUFKOSTL | CHAR 10 | CSKS |
| RAT_TSC | ratio transactio | G/L account for basic settlement | AUFSAKNR | CHAR 10 | SKB1 |
| ATB | attributio | Allocation set | AUFSETNM | CHAR 12 | — |
| USER0 | Applicant | AUFUSER0 | CHAR 20 | — | |
| PSN | persona | Person responsible | AUFUSER2 | CHAR 20 | — |
| TOT_MND | summa totalis mandatum | Estimated total costs of order | AUFUSER4 | CURR 11,2 | — |
| USER6 | Department | AUFUSER6 | CHAR 15 | — | |
| OBI_NUM | obiectum numerus | Object number | J_OBJNR | CHAR 22 | ONR00 |
| CLU | centrum lucri | Profit Center | PRCTR | CHAR 10 | CEPC |
| OPS_ELM_EOP | opus elementum elementum operis | Work breakdown structure element (WBS element) | PS_PSP_ELE | NUMC 8 | PRPS |
| AFN | area functionis | Functional Area | FKBER | CHAR 16 | TFKB |
| VDT_MND_NUM | venditio mandatum numerus | Sales Order Number | KDAUF | CHAR 10 | VBUK |
| POS_NUM_VDT | positio numerus venditio | Item Number in Sales Order | KDPOS | NUMC 6 | — |
| MND_NUM2 | mandatum numerus | External order number | AUFEX | CHAR 20 | — |
| LOGSYSTEM | Logical System | LOGSYSTEM | CHAR 10 | TBDLS |
Foreign keys
| Field | Check table | Check field |
|---|---|---|
AUART | T003O | AUART |
BUKRS | T001 | BUKRS |
FUNC_AREA | TFKB | FKBER |
GSBER | TGSB | GSBER |
KALSM | T683 | KALSM |
KDAUF | VBUK | VBELN |
KOKRS | TKA01 | KOKRS |
KOSTL | CSKS | KOSTL |
KOSTV | CSKS | KOSTL |
KSTAR | CSKB | KSTAR |
LOGSYSTEM | TBDLS | LOGSYS |
MANDT | T000 | MANDT |
OBJNR | ONR00 | OBJNR |
PRCTR | CEPC | PRCTR |
PSPEL | PRPS | PSPNR |
REFNR | AUFK | AUFNR |
SAKNR | SKB1 | SAKNR |
WAERS | TCURC | WAERS |
WERKS | T001W | WERKS |