Fields (45)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ChangeDocDatabaseTableField | ChangeDocDatabaseTableField | 1 |
| KEY | ChangeDocument | ChangeDocument | 1 |
| KEY | ConsolidationGroupHierarchy | ConsolidationGroupHierarchy | 1 |
| KEY | ConsolidationStructureVersion | ConsolidationStructureVersion | 1 |
| KEY | hier_catg | HierarchyCategory | 2 |
| KEY | hier_hid | HierarchyId | 2 |
| KEY | InspectionCharacteristic | InspectionCharacteristic | 1 |
| KEY | InspectionSubsetInternalID | InspectionSubsetInternalID | 1 |
| KEY | InspResultValueInternalID | InspResultValueInternalID | 1 |
| KEY | ManufacturingOrder | ManufacturingOrder | 1 |
| KEY | MfgProcgExecAction | MfgProcgExecAction | 1 |
| KEY | OrderOperationInternalID | OrderOperationInternalID | 1 |
| ChangeDocNewFieldValue | ChangeDocNewFieldValue | 1 | |
| ChangeDocPreviousFieldValue | ChangeDocPreviousFieldValue | 1 | |
| CharacteristicAttributeCode | CharacteristicAttributeCode | 1 | |
| ConsolidationDimension | ConsolidationDimension | 1 | |
| ConsolidationGroup | ConsolidationGroup | 1 | |
| ConsolidationUnit | ConsolidationUnit | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDateTime | CreationDateTime,EventDateTime | 1 | |
| InspectionResultMeanValue | InspectionResultMeanValue | 1 | |
| InspectionResultMeasuredValue | InspectionResultMeasuredValue | 1 | |
| InspectionSpecificationText | InspectionSpecificationText | 1 | |
| InspectionSpecificationUnit | InspectionSpecificationUnit | 1 | |
| InspectionValuationResult | InspectionValuationResult | 1 | |
| InspSpecDecimalPlaces | InspSpecDecimalPlaces | 1 | |
| MfgExecHistMsgVarblField1 | MfgExecHistMsgVarblField1 | 1 | |
| MfgExecHistMsgVarblField2 | MfgExecHistMsgVarblField2 | 1 | |
| MfgExecHistMsgVarblField3 | MfgExecHistMsgVarblField3 | 1 | |
| MfgExecHistMsgVarblField4 | MfgExecHistMsgVarblField4 | 1 | |
| OpActyNtwkElement | OpActyNtwkElement | 1 | |
| OpActyNtwkElementExternalID | OpActyNtwkElementExternalID | 1 | |
| OpActyNtwkInstance | OpActyNtwkInstance | 1 | |
| OpActyNtwkSegmentType | OpActyNtwkSegmentType | 1 | |
| OpActyNtwkVersionCounter | OpActyNtwkVersionCounter | 1 | |
| OperationActivity | OperationActivity | 1 | |
| OperationActivityName | OperationActivityName | 1 | |
| OperationActivityNetwork | OperationActivityNetwork | 1 | |
| OperationActyVersionCounter | OperationActyVersionCounter | 1 | |
| ShopFloorItem | ShopFloorItem | 1 | |
| StatusAndActionSchema | StatusAndActionSchema | 1 | |
| SystemMessageIdentification | SystemMessageIdentification | 1 | |
| SystemMessageNumber | SystemMessageNumber | 1 | |
| vtext | vtext | 1 | |
| WorkCenterTypeCode | WorkCenterTypeCode | 1 |
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.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE H (
CHANGEDOCDATABASETABLEFIELD,
CHANGEDOCUMENT,
CONSOLIDATIONGROUPHIERARCHY,
CONSOLIDATIONSTRUCTUREVERSION,
HIER_CATG,
HIER_HID,
INSPECTIONCHARACTERISTIC,
INSPECTIONSUBSETINTERNALID,
INSPRESULTVALUEINTERNALID,
MANUFACTURINGORDER,
MFGPROCGEXECACTION,
ORDEROPERATIONINTERNALID,
CHANGEDOCNEWFIELDVALUE,
CHANGEDOCPREVIOUSFIELDVALUE,
CHARACTERISTICATTRIBUTECODE,
CONSOLIDATIONDIMENSION,
CONSOLIDATIONGROUP,
CONSOLIDATIONUNIT,
CREATEDBYUSER,
CREATIONDATETIME,
INSPECTIONRESULTMEANVALUE,
INSPECTIONRESULTMEASUREDVALUE,
INSPECTIONSPECIFICATIONTEXT,
INSPECTIONSPECIFICATIONUNIT,
INSPECTIONVALUATIONRESULT,
INSPSPECDECIMALPLACES,
MFGEXECHISTMSGVARBLFIELD1,
MFGEXECHISTMSGVARBLFIELD2,
MFGEXECHISTMSGVARBLFIELD3,
MFGEXECHISTMSGVARBLFIELD4,
OPACTYNTWKELEMENT,
OPACTYNTWKELEMENTEXTERNALID,
OPACTYNTWKINSTANCE,
OPACTYNTWKSEGMENTTYPE,
OPACTYNTWKVERSIONCOUNTER,
OPERATIONACTIVITY,
OPERATIONACTIVITYNAME,
OPERATIONACTIVITYNETWORK,
OPERATIONACTYVERSIONCOUNTER,
SHOPFLOORITEM,
STATUSANDACTIONSCHEMA,
SYSTEMMESSAGEIDENTIFICATION,
SYSTEMMESSAGENUMBER,
VTEXT,
WORKCENTERTYPECODE,
PRIMARY KEY (CHANGEDOCDATABASETABLEFIELD, CHANGEDOCUMENT, CONSOLIDATIONGROUPHIERARCHY, CONSOLIDATIONSTRUCTUREVERSION, HIER_CATG, HIER_HID, INSPECTIONCHARACTERISTIC, INSPECTIONSUBSETINTERNALID, INSPRESULTVALUEINTERNALID, MANUFACTURINGORDER, MFGPROCGEXECACTION, ORDEROPERATIONINTERNALID)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- 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