SUPPLYPROTECTION

SUPPLYPROTECTION is an SAP database table in S/4HANA. It contains 41 fields.

Fields (41)

KeyField CDS FieldsUsed in Views
KEY SupplyProtectionUUID SupplyProtectionUUID 1
Batch Batch 1
CharcValAuthznGroup CharcValAuthznGroup 1
CoreCharc01CtlgPathIntID CoreCharc01CtlgPathIntID 1
CoreCharc02CtlgPathIntID CoreCharc02CtlgPathIntID 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
Material Material 1
Plant Plant 1
PoolSegment PoolSegment 1
StorageLocation StorageLocation 1
SupplyProtectionName SupplyProtectionName 1
SupProtActivationDate SupProtActivationDate 1
SupProtAutomActivationDate SupProtAutomActivationDate 1
SupProtAutomActivationIsActive SupProtAutomActivationIsActive 1
SupProtCnsmpnDateTimeType SupProtCnsmpnDateTimeType 1
SupProtConsumedQuantity SupProtConsumedQuantity 1
SupProtCoreCharc01Name SupProtCoreCharc01Name 1
SupProtCoreCharc01Text SupProtCoreCharc01Text 1
SupProtCoreCharc01ValueID SupProtCoreCharc01ValueID 1
SupProtCoreCharc02Name SupProtCoreCharc02Name 1
SupProtCoreCharc02Text SupProtCoreCharc02Text 1
SupProtCoreCharc02ValueID SupProtCoreCharc02ValueID 1
SupProtExtensionRuleName SupProtExtensionRuleName 1
SupProtExtensionRuleUUID SupProtExtensionRuleUUID 2
SupProtIsPlanningContextSlsOrd SupProtIsPlanningContextSlsOrd 1
SupProtIsPlanningContextSTO SupProtIsPlanningContextSTO 1
SupProtLifecycleStatus SupProtLifecycleStatus 1
SupProtPlanningLevel SupProtPlanningLevel 1
SupProtPlanningPeriodEndDate SupProtPlanningPeriodEndDate 1
SupProtPlanningPeriodStartDate SupProtPlanningPeriodStartDate 1
SupProtPlanningPeriodTimeZone SupProtPlanningPeriodTimeZone 1
SupProtPlanningPeriodType SupProtPlanningPeriodType 1
SupProtPlngContextIsConsistent SupProtPlngContextIsConsistent 1
SupProtProtectedQuantity SupProtProtectedQuantity 1
SupProtRemainingProtectedQty SupProtRemainingProtectedQty 1
SupProtSelfRestrictionType SupProtSelfRestrictionType 1
UnitOfMeasure UnitOfMeasure 1
UnitOfMeasureISOCode UnitOfMeasureISOCode 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 SUPPLYPROTECTION (
    SUPPLYPROTECTIONUUID,
    BATCH,
    CHARCVALAUTHZNGROUP,
    CORECHARC01CTLGPATHINTID,
    CORECHARC02CTLGPATHINTID,
    CREATEDBYUSER,
    CREATIONDATETIME,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    MATERIAL,
    PLANT,
    POOLSEGMENT,
    STORAGELOCATION,
    SUPPLYPROTECTIONNAME,
    SUPPROTACTIVATIONDATE,
    SUPPROTAUTOMACTIVATIONDATE,
    SUPPROTAUTOMACTIVATIONISACTIVE,
    SUPPROTCNSMPNDATETIMETYPE,
    SUPPROTCONSUMEDQUANTITY,
    SUPPROTCORECHARC01NAME,
    SUPPROTCORECHARC01TEXT,
    SUPPROTCORECHARC01VALUEID,
    SUPPROTCORECHARC02NAME,
    SUPPROTCORECHARC02TEXT,
    SUPPROTCORECHARC02VALUEID,
    SUPPROTEXTENSIONRULENAME,
    SUPPROTEXTENSIONRULEUUID,
    SUPPROTISPLANNINGCONTEXTSLSORD,
    SUPPROTISPLANNINGCONTEXTSTO,
    SUPPROTLIFECYCLESTATUS,
    SUPPROTPLANNINGLEVEL,
    SUPPROTPLANNINGPERIODENDDATE,
    SUPPROTPLANNINGPERIODSTARTDATE,
    SUPPROTPLANNINGPERIODTIMEZONE,
    SUPPROTPLANNINGPERIODTYPE,
    SUPPROTPLNGCONTEXTISCONSISTENT,
    SUPPROTPROTECTEDQUANTITY,
    SUPPROTREMAININGPROTECTEDQTY,
    SUPPROTSELFRESTRICTIONTYPE,
    UNITOFMEASURE,
    UNITOFMEASUREISOCODE,
    PRIMARY KEY (SUPPLYPROTECTIONUUID)
);