H

H is an SAP database table in S/4HANA. It contains 45 fields.

Fields (45)

KeyField CDS FieldsUsed 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)
);