_CONSTRAINT

_CONSTRAINT is an SAP database table in S/4HANA. It contains 21 fields.

Fields (21)

KeyField CDS FieldsUsed in Views
_Supplier _Supplier 3
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
MaterialGroup MaterialGroup 1
MRPArea MRPArea 1
Plant Plant 1
PMRPConstraintCategory PMRPConstraintCategory 4
PMRPConstraintIsDisregarded PMRPConstraintIsDisregarded 1
PMRPConstraintPeriodType PMRPConstraintPeriodType 3
PMRPConstraintProductSelection PMRPConstraintProductSelection 3
PMRPConstraintTolerancePercent PMRPConstraintTolerancePercent 1
PMRPConstraintType PMRPConstraintType 4
PMRPFlexibleConstraintScope PMRPFlexibleConstraintScope 4
PMRPSupplyGroup PMRPSupplyGroup 1
PMRPSupplyGroupCategory PMRPSupplyGroupCategory 1
Product Product 1
ProductionLine ProductionLine 2
Supplier Supplier 4
SupplyingPlant SupplyingPlant 4

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 _CONSTRAINT (
    _SUPPLIER,
    CREATEDBYUSER,
    CREATIONDATETIME,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    MATERIALGROUP,
    MRPAREA,
    PLANT,
    PMRPCONSTRAINTCATEGORY,
    PMRPCONSTRAINTISDISREGARDED,
    PMRPCONSTRAINTPERIODTYPE,
    PMRPCONSTRAINTPRODUCTSELECTION,
    PMRPCONSTRAINTTOLERANCEPERCENT,
    PMRPCONSTRAINTTYPE,
    PMRPFLEXIBLECONSTRAINTSCOPE,
    PMRPSUPPLYGROUP,
    PMRPSUPPLYGROUPCATEGORY,
    PRODUCT,
    PRODUCTIONLINE,
    SUPPLIER,
    SUPPLYINGPLANT
);