CMM_EM_EPO_HDR_D
Expense Planning Object Header
CMM_EM_EPO_HDR_D is an SAP database table in S/4HANA. Expense Planning Object Header. It contains 88 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CommodityExpenseHeaderBuffer | view_entity | from | BASIC | Commodity Expense Header Buffer |
Fields (88)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | expnplngheaderuuid | CMM_EM_HEADER_UUID | Expense Header UUID | |||
| expnplngreferenceuuid | CMM_EM_REFERENCE_UUID | Reference UUID | ||||
| expnplngreferenceitemuuid | CMM_EM_REFERENCE_ITEM_UUID | Reference Item UUID | ||||
| expnplngobjectuuid | CMM_EM_BTP_HDR_UUID | BTP Header UUID | ||||
| expnplngremotesystemid | CMM_EM_REMOTE_SYSID | Remote System ID | ||||
| expnplngtemplateid | CMM_EM_TEMPLATE_ID | Template ID | ||||
| commodityexpenseaction | CMM_EM_ACTION_CODE | Action Code | ||||
| cmmdtyexpncallingapplication | CMM_EM_CALLING_APPL | Calling Application | ||||
| commodityexpensestatus | CMM_EM_STATUS_CODE | Status | ||||
| cmmdtyexpensetransactiontype | CMM_EM_DM_TRANSACTION_TYPE | Transaction Type | ||||
| expensedeterminationisrequired | CMM_EM_REDETERMINATION | Redertermination Req | ||||
| expenseisinlinesaveenabled | CMM_EM_INLINE_SAVE | Expense Inline Save | ||||
| expenseeventstatus | CMM_EM_EVENT_STATUS | Event Status | ||||
| expenseplanningobjectisamended | CMM_EM_EPO_AMEND | Is Amended | ||||
| commodityexpenseissplit | CMM_EM_IS_SPLIT_SCENARIO | Recover | ||||
| commodityexpensehaspricelot | CMM_EM_HAS_PRICE_LOT | Price Lot Indicator | ||||
| expnplngprocessingstatus | CMM_EM_PROCESSING_STATUS | Processing Status | ||||
| expnplngsourcedocumentuuid | CMM_EM_SRC_DOC_HDR_UUID | Src Doc Header UUID | ||||
| expnplngsourcedocumentitemuuid | CMM_EM_SRC_DOC_ITM_UUID | Src Doc Item UUID | ||||
| expnplngsourcedocumentnumber | CMM_EM_SRC_DOC_NO | Source Document No. | ||||
| expnplngsourcedocumentitem | CMM_EM_SRC_DOC_ITM_NO | Source Doc. Item No. | ||||
| expnplngsourcedocumenttype | CMM_EM_SRC_DOC_TYPE | Source Document Type | ||||
| expnplngsourcedocumenttypetext | CMM_EM_SRC_DOC_TYPE_DESC | Source Doc Type Desc | ||||
| expnplngsrcedocumentobjecttype | CMM_EM_SRC_DOC_OBJTYPE | Src Doc Object Type | ||||
| expnplngsrcedocobjecttypetext | CMM_EM_SRC_DOC_OBJTYPE_DESC | Src Doc Obj Ty Desc | ||||
| expnplngsourcedocumentitemside | CMM_EM_SRC_DOC_SIDE | Source Document Side | ||||
| expnplngsrcedocitemchilditem | CMM_EM_SRC_DOC_SUBITEM | Source Doc Sub Item | ||||
| expnplngsrcechangedatdatetime | CMM_EM_SOURCE_CHANGEDATTIME | Source Changed At | ||||
| expnplngrootdocumentuuid | CMM_EM_ROOT_DOC_HDR_UUID | Root Doc Header UUID | ||||
| expnplngrootdocumentitemuuid | CMM_EM_ROOT_DOC_ITM_UUID | Root Doc Item UUID | ||||
| expnplngrootdocumentnumber | CMM_EM_ROOT_DOC_NO | Root Document No. | ||||
| expnplngrootdocumentitem | CMM_EM_ROOT_DOC_ITM_NO | Root Doc. Item No. | ||||
| expnplngrootdocumenttype | CMM_EM_ROOT_DOC_TYPE | Root Document Type | ||||
| expnplngrootdocumenttypetext | CMM_EM_ROOT_DOC_TYPE_DESC | Root Doc Type Desc | ||||
| expnplngrootdocumentobjecttype | CMM_EM_ROOT_DOC_OBJTYPE | Root Doc Object Type | ||||
| expnplngrootdocobjecttypetext | CMM_EM_ROOT_DOC_OBJTYPE_DESC | Root Doc Obj Ty Desc | ||||
| expnplngprecdgdocumentnumber | CMM_EM_PRECED_DOC_NO | Preceding Document | ||||
| expnplngprecedingdocumentitem | CMM_EM_PRECED_DOC_ITEM_NO | Preceding Item No. | ||||
| expnplngprecedingdocumenttype | CMM_EM_PRECDG_DOC_TYPE | Precdg Document Type | ||||
| expnplngprecdgdocumenttypetext | CMM_EM_PRECDG_DOC_TYPE_DESC | Precdg Doc Typ Desc | ||||
| expnplngprecdgdocobjecttype | CMM_EM_PRECDG_DOC_OBJTYPE | Precdg Doc Obj Type | ||||
| expnplngprecdgdocobjtypetext | CMM_EM_PRECDG_DOC_OBJTYPE_DESC | Prcdg Doc Obj Ty Des | ||||
| companycode | BUKRS | Company Code | ||||
| commodityexpensequantity | CMM_EM_QUANTITY | Quantity | ||||
| expensequantityunitofmeasure | MEINS | Base Unit | ||||
| expensepricingdate | CMM_EM_PRICING_DATE | Pricing Date | ||||
| material | MATNR | Material | ||||
| commodity | TBA_STOEFFCHEN | Commodity | ||||
| modeoftransport | VKTRA | Mode of Transp. | ||||
| incoterms | INCO1 | Incoterms | ||||
| attributecode1 | CMM_EM_ATTRIBUTE_CODE | Attributes Code | ||||
| attributevalue1 | CMM_EM_ATTRIBUTE_VALUE | Attributes Value | ||||
| attributecode2 | CMM_EM_ATTRIBUTE_CODE | Attributes Code | ||||
| attributevalue2 | CMM_EM_ATTRIBUTE_VALUE | Attributes Value | ||||
| attributecode3 | CMM_EM_ATTRIBUTE_CODE | Attributes Code | ||||
| attributevalue3 | CMM_EM_ATTRIBUTE_VALUE | Attributes Value | ||||
| attributecode4 | CMM_EM_ATTRIBUTE_CODE | Attributes Code | ||||
| attributevalue4 | CMM_EM_ATTRIBUTE_VALUE | Attributes Value | ||||
| attributecode5 | CMM_EM_ATTRIBUTE_CODE | Attributes Code | ||||
| attributevalue5 | CMM_EM_ATTRIBUTE_VALUE | Attributes Value | ||||
| attributecode6 | CMM_EM_ATTRIBUTE_CODE | Attributes Code | ||||
| attributevalue6 | CMM_EM_ATTRIBUTE_VALUE | Attributes Value | ||||
| attributecode7 | CMM_EM_ATTRIBUTE_CODE | Attributes Code | ||||
| attributevalue7 | CMM_EM_ATTRIBUTE_VALUE | Attributes Value | ||||
| attributecode8 | CMM_EM_ATTRIBUTE_CODE | Attributes Code | ||||
| attributevalue8 | CMM_EM_ATTRIBUTE_VALUE | Attributes Value | ||||
| attributecode9 | CMM_EM_ATTRIBUTE_CODE | Attributes Code | ||||
| attributevalue9 | CMM_EM_ATTRIBUTE_VALUE | Attributes Value | ||||
| attributecode10 | CMM_EM_ATTRIBUTE_CODE | Attributes Code | ||||
| attributevalue10 | CMM_EM_ATTRIBUTE_VALUE | Attributes Value | ||||
| attributecode11 | CMM_EM_ATTRIBUTE_CODE | Attributes Code | ||||
| attributevalue11 | CMM_EM_ATTRIBUTE_VALUE | Attributes Value | ||||
| attributecode12 | CMM_EM_ATTRIBUTE_CODE | Attributes Code | ||||
| attributevalue12 | CMM_EM_ATTRIBUTE_VALUE | Attributes Value | ||||
| attributecode13 | CMM_EM_ATTRIBUTE_CODE | Attributes Code | ||||
| attributevalue13 | CMM_EM_ATTRIBUTE_VALUE | Attributes Value | ||||
| attributecode14 | CMM_EM_ATTRIBUTE_CODE | Attributes Code | ||||
| attributevalue14 | CMM_EM_ATTRIBUTE_VALUE | Attributes Value | ||||
| attributecode15 | CMM_EM_ATTRIBUTE_CODE | Attributes Code | ||||
| attributevalue15 | CMM_EM_ATTRIBUTE_VALUE | Attributes Value | ||||
| expensecreatedondate | CMM_EM_CREATEDON_DATE | Created On | ||||
| expensecreatedattime | CMM_EM_CREATEDAT_TIME | Created On | ||||
| expensechangedondate | CMM_EM_CHANGEDON_DATE | Changed On | ||||
| expensechangedondatetime | CMM_EM_CHANGEDAT_TIME | Changed On | ||||
| plant | WERKS_D | Plant | ||||
| purchasingorganization | EKORG | Purchasing Org. | ||||
| purchasinggroup | EKGRP | Purch. Group |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Expense Planning Object Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMM_EM_EPO_HDR_D (
CLIENT, -- Client [MANDT]
EXPNPLNGHEADERUUID, -- Expense Header UUID [CMM_EM_HEADER_UUID]
EXPNPLNGREFERENCEUUID, -- Reference UUID [CMM_EM_REFERENCE_UUID]
EXPNPLNGREFERENCEITEMUUID, -- Reference Item UUID [CMM_EM_REFERENCE_ITEM_UUID]
EXPNPLNGOBJECTUUID, -- BTP Header UUID [CMM_EM_BTP_HDR_UUID]
EXPNPLNGREMOTESYSTEMID, -- Remote System ID [CMM_EM_REMOTE_SYSID]
EXPNPLNGTEMPLATEID, -- Template ID [CMM_EM_TEMPLATE_ID]
COMMODITYEXPENSEACTION, -- Action Code [CMM_EM_ACTION_CODE]
CMMDTYEXPNCALLINGAPPLICATION, -- Calling Application [CMM_EM_CALLING_APPL]
COMMODITYEXPENSESTATUS, -- Status [CMM_EM_STATUS_CODE]
CMMDTYEXPENSETRANSACTIONTYPE, -- Transaction Type [CMM_EM_DM_TRANSACTION_TYPE]
EXPENSEDETERMINATIONISREQUIRED, -- Redertermination Req [CMM_EM_REDETERMINATION]
EXPENSEISINLINESAVEENABLED, -- Expense Inline Save [CMM_EM_INLINE_SAVE]
EXPENSEEVENTSTATUS, -- Event Status [CMM_EM_EVENT_STATUS]
EXPENSEPLANNINGOBJECTISAMENDED, -- Is Amended [CMM_EM_EPO_AMEND]
COMMODITYEXPENSEISSPLIT, -- Recover [CMM_EM_IS_SPLIT_SCENARIO]
COMMODITYEXPENSEHASPRICELOT, -- Price Lot Indicator [CMM_EM_HAS_PRICE_LOT]
EXPNPLNGPROCESSINGSTATUS, -- Processing Status [CMM_EM_PROCESSING_STATUS]
EXPNPLNGSOURCEDOCUMENTUUID, -- Src Doc Header UUID [CMM_EM_SRC_DOC_HDR_UUID]
EXPNPLNGSOURCEDOCUMENTITEMUUID, -- Src Doc Item UUID [CMM_EM_SRC_DOC_ITM_UUID]
EXPNPLNGSOURCEDOCUMENTNUMBER, -- Source Document No. [CMM_EM_SRC_DOC_NO]
EXPNPLNGSOURCEDOCUMENTITEM, -- Source Doc. Item No. [CMM_EM_SRC_DOC_ITM_NO]
EXPNPLNGSOURCEDOCUMENTTYPE, -- Source Document Type [CMM_EM_SRC_DOC_TYPE]
EXPNPLNGSOURCEDOCUMENTTYPETEXT, -- Source Doc Type Desc [CMM_EM_SRC_DOC_TYPE_DESC]
EXPNPLNGSRCEDOCUMENTOBJECTTYPE, -- Src Doc Object Type [CMM_EM_SRC_DOC_OBJTYPE]
EXPNPLNGSRCEDOCOBJECTTYPETEXT, -- Src Doc Obj Ty Desc [CMM_EM_SRC_DOC_OBJTYPE_DESC]
EXPNPLNGSOURCEDOCUMENTITEMSIDE, -- Source Document Side [CMM_EM_SRC_DOC_SIDE]
EXPNPLNGSRCEDOCITEMCHILDITEM, -- Source Doc Sub Item [CMM_EM_SRC_DOC_SUBITEM]
EXPNPLNGSRCECHANGEDATDATETIME, -- Source Changed At [CMM_EM_SOURCE_CHANGEDATTIME]
EXPNPLNGROOTDOCUMENTUUID, -- Root Doc Header UUID [CMM_EM_ROOT_DOC_HDR_UUID]
EXPNPLNGROOTDOCUMENTITEMUUID, -- Root Doc Item UUID [CMM_EM_ROOT_DOC_ITM_UUID]
EXPNPLNGROOTDOCUMENTNUMBER, -- Root Document No. [CMM_EM_ROOT_DOC_NO]
EXPNPLNGROOTDOCUMENTITEM, -- Root Doc. Item No. [CMM_EM_ROOT_DOC_ITM_NO]
EXPNPLNGROOTDOCUMENTTYPE, -- Root Document Type [CMM_EM_ROOT_DOC_TYPE]
EXPNPLNGROOTDOCUMENTTYPETEXT, -- Root Doc Type Desc [CMM_EM_ROOT_DOC_TYPE_DESC]
EXPNPLNGROOTDOCUMENTOBJECTTYPE, -- Root Doc Object Type [CMM_EM_ROOT_DOC_OBJTYPE]
EXPNPLNGROOTDOCOBJECTTYPETEXT, -- Root Doc Obj Ty Desc [CMM_EM_ROOT_DOC_OBJTYPE_DESC]
EXPNPLNGPRECDGDOCUMENTNUMBER, -- Preceding Document [CMM_EM_PRECED_DOC_NO]
EXPNPLNGPRECEDINGDOCUMENTITEM, -- Preceding Item No. [CMM_EM_PRECED_DOC_ITEM_NO]
EXPNPLNGPRECEDINGDOCUMENTTYPE, -- Precdg Document Type [CMM_EM_PRECDG_DOC_TYPE]
EXPNPLNGPRECDGDOCUMENTTYPETEXT, -- Precdg Doc Typ Desc [CMM_EM_PRECDG_DOC_TYPE_DESC]
EXPNPLNGPRECDGDOCOBJECTTYPE, -- Precdg Doc Obj Type [CMM_EM_PRECDG_DOC_OBJTYPE]
EXPNPLNGPRECDGDOCOBJTYPETEXT, -- Prcdg Doc Obj Ty Des [CMM_EM_PRECDG_DOC_OBJTYPE_DESC]
COMPANYCODE, -- Company Code [BUKRS]
COMMODITYEXPENSEQUANTITY, -- Quantity [CMM_EM_QUANTITY]
EXPENSEQUANTITYUNITOFMEASURE, -- Base Unit [MEINS]
EXPENSEPRICINGDATE, -- Pricing Date [CMM_EM_PRICING_DATE]
MATERIAL, -- Material [MATNR]
COMMODITY, -- Commodity [TBA_STOEFFCHEN]
MODEOFTRANSPORT, -- Mode of Transp. [VKTRA]
INCOTERMS, -- Incoterms [INCO1]
ATTRIBUTECODE1, -- Attributes Code [CMM_EM_ATTRIBUTE_CODE]
ATTRIBUTEVALUE1, -- Attributes Value [CMM_EM_ATTRIBUTE_VALUE]
ATTRIBUTECODE2, -- Attributes Code [CMM_EM_ATTRIBUTE_CODE]
ATTRIBUTEVALUE2, -- Attributes Value [CMM_EM_ATTRIBUTE_VALUE]
ATTRIBUTECODE3, -- Attributes Code [CMM_EM_ATTRIBUTE_CODE]
ATTRIBUTEVALUE3, -- Attributes Value [CMM_EM_ATTRIBUTE_VALUE]
ATTRIBUTECODE4, -- Attributes Code [CMM_EM_ATTRIBUTE_CODE]
ATTRIBUTEVALUE4, -- Attributes Value [CMM_EM_ATTRIBUTE_VALUE]
ATTRIBUTECODE5, -- Attributes Code [CMM_EM_ATTRIBUTE_CODE]
ATTRIBUTEVALUE5, -- Attributes Value [CMM_EM_ATTRIBUTE_VALUE]
ATTRIBUTECODE6, -- Attributes Code [CMM_EM_ATTRIBUTE_CODE]
ATTRIBUTEVALUE6, -- Attributes Value [CMM_EM_ATTRIBUTE_VALUE]
ATTRIBUTECODE7, -- Attributes Code [CMM_EM_ATTRIBUTE_CODE]
ATTRIBUTEVALUE7, -- Attributes Value [CMM_EM_ATTRIBUTE_VALUE]
ATTRIBUTECODE8, -- Attributes Code [CMM_EM_ATTRIBUTE_CODE]
ATTRIBUTEVALUE8, -- Attributes Value [CMM_EM_ATTRIBUTE_VALUE]
ATTRIBUTECODE9, -- Attributes Code [CMM_EM_ATTRIBUTE_CODE]
ATTRIBUTEVALUE9, -- Attributes Value [CMM_EM_ATTRIBUTE_VALUE]
ATTRIBUTECODE10, -- Attributes Code [CMM_EM_ATTRIBUTE_CODE]
ATTRIBUTEVALUE10, -- Attributes Value [CMM_EM_ATTRIBUTE_VALUE]
ATTRIBUTECODE11, -- Attributes Code [CMM_EM_ATTRIBUTE_CODE]
ATTRIBUTEVALUE11, -- Attributes Value [CMM_EM_ATTRIBUTE_VALUE]
ATTRIBUTECODE12, -- Attributes Code [CMM_EM_ATTRIBUTE_CODE]
ATTRIBUTEVALUE12, -- Attributes Value [CMM_EM_ATTRIBUTE_VALUE]
ATTRIBUTECODE13, -- Attributes Code [CMM_EM_ATTRIBUTE_CODE]
ATTRIBUTEVALUE13, -- Attributes Value [CMM_EM_ATTRIBUTE_VALUE]
ATTRIBUTECODE14, -- Attributes Code [CMM_EM_ATTRIBUTE_CODE]
ATTRIBUTEVALUE14, -- Attributes Value [CMM_EM_ATTRIBUTE_VALUE]
ATTRIBUTECODE15, -- Attributes Code [CMM_EM_ATTRIBUTE_CODE]
ATTRIBUTEVALUE15, -- Attributes Value [CMM_EM_ATTRIBUTE_VALUE]
EXPENSECREATEDONDATE, -- Created On [CMM_EM_CREATEDON_DATE]
EXPENSECREATEDATTIME, -- Created On [CMM_EM_CREATEDAT_TIME]
EXPENSECHANGEDONDATE, -- Changed On [CMM_EM_CHANGEDON_DATE]
EXPENSECHANGEDONDATETIME, -- Changed On [CMM_EM_CHANGEDAT_TIME]
PLANT, -- Plant [WERKS_D]
PURCHASINGORGANIZATION, -- Purchasing Org. [EKORG]
PURCHASINGGROUP, -- Purch. Group [EKGRP]
PRIMARY KEY (CLIENT, EXPNPLNGHEADERUUID)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA