I_PRODNVERSTP

CDS View
33 Fields 1 CDS Views

Manage Production Version

I_PRODNVERSTP is a CDS View in S/4HANA. Manage Production Version. It contains 33 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_ProdnVersObjPgTP view from CONSUMPTION Manage Production Version

Fields (33)

KeyField CDS FieldsUsed in Views
KEY Material Material 1
KEY Plant Plant 1
KEY ProductionVersion ProductionVersion 1
BillOfMaterialVariant BillOfMaterialVariant 1
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 1
ChangeNumber ChangeNumber 1
CreationDate CreationDate 1
DestinationStorageBin DestinationStorageBin 1
DistributionKey DistributionKey 1
EWMWarehouse EWMWarehouse 1
ExecBillOfMaterialVariant ExecBillOfMaterialVariant 1
ExecBillOfMaterialVariantUsage ExecBillOfMaterialVariantUsage 1
ExecBillOfOperationsType ExecBillOfOperationsType 1
ExecBillOfOperationsVariant ExecBillOfOperationsVariant 1
HasVersionCtrldBOMAndRouting HasVersionCtrldBOMAndRouting 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
MaterialForEdit MaterialForEdit 1
MaterialMaxLotSizeQuantity MaterialMaxLotSizeQuantity 1
MaterialMinLotSizeQuantity MaterialMinLotSizeQuantity 1
PlanningAndExecutionBOMIsDiff PlanningAndExecutionBOMIsDiff 1
PlantForEdit PlantForEdit 1
PreliminaryPlanningStatus PreliminaryPlanningStatus 1
ProdnVersIsAllowedForRptvMfg ProdnVersIsAllowedForRptvMfg 1
ProductionLine ProductionLine 1
ProductionSupplyArea ProductionSupplyArea 1
ProductionVersionForEdit ProductionVersionForEdit 1
ProductionVersionGroup ProductionVersionGroup 1
QuantityDistributionKey QuantityDistributionKey 1
RateBasedPlanningStatus RateBasedPlanningStatus 1
ReceivingStorageLocation ReceivingStorageLocation 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 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.

-- Manage Production Version
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PRODNVERSTP (
    MATERIAL,
    PLANT,
    PRODUCTIONVERSION,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVARIANTUSAGE,
    CHANGENUMBER,
    CREATIONDATE,
    DESTINATIONSTORAGEBIN,
    DISTRIBUTIONKEY,
    EWMWAREHOUSE,
    EXECBILLOFMATERIALVARIANT,
    EXECBILLOFMATERIALVARIANTUSAGE,
    EXECBILLOFOPERATIONSTYPE,
    EXECBILLOFOPERATIONSVARIANT,
    HASVERSIONCTRLDBOMANDROUTING,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    MATERIALFOREDIT,
    MATERIALMAXLOTSIZEQUANTITY,
    MATERIALMINLOTSIZEQUANTITY,
    PLANNINGANDEXECUTIONBOMISDIFF,
    PLANTFOREDIT,
    PRELIMINARYPLANNINGSTATUS,
    PRODNVERSISALLOWEDFORRPTVMFG,
    PRODUCTIONLINE,
    PRODUCTIONSUPPLYAREA,
    PRODUCTIONVERSIONFOREDIT,
    PRODUCTIONVERSIONGROUP,
    QUANTITYDISTRIBUTIONKEY,
    RATEBASEDPLANNINGSTATUS,
    RECEIVINGSTORAGELOCATION,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (MATERIAL, PLANT, PRODUCTIONVERSION)
);

Learn More