I_PRODUCTIONVERSION

CDS View
72 Fields 29 CDS Views

Production Version

I_PRODUCTIONVERSION is a CDS View in S/4HANA. Production Version. It contains 72 fields. 29 CDS views read from this table.

CDS Views using this table (29)

ViewTypeJoinVDMDescription
C_MassMaintCapProdnVersionVH view_entity from CONSUMPTION Value Help for Production Version
C_MfgOrderProdVersionObjPg view_entity from CONSUMPTION Production Version
C_MM_ProductionVersValueHelp view from CONSUMPTION Production Version Value Help
C_MntrWrkCtrSourceSchedule view from CONSUMPTION Free Slots in Work Center Reschedule
C_ProdnSupplyAreaProdnVersCnt view_entity left_outer CONSUMPTION Count of Production Versions use PSA
C_ProdnSupplyAreaProdnVersion view_entity from CONSUMPTION Production Version of PSA Where Used
C_SchedProdnProdVersDay view from CONSUMPTION Production Versions In Day Bucket
C_SchedProdnProdVersShift view from CONSUMPTION Production versions in shift bucket
C_SchedProdnProdVersWeek view from CONSUMPTION Production Versions In Week Bucket
C_WrkCtrMntrReschedule view from CONSUMPTION Monitor Work Center Reschedule
I_CapEvalByAreaOfRespy view inner COMPOSITE Work Center By Area Of Responsibility
I_ChgRecdMstrRcpProdnVersion view from COMPOSITE Production Version for CR Master Recipe
I_ChgRecdProductionVersion view from COMPOSITE Change Record: Production Version
I_EvaltCapWrkCtrGrpAreaOfRespy view_entity inner COMPOSITE Work Center Group Area of Responsibility
I_MassMaintCapAreaOfRespy view_entity inner COMPOSITE Work Center Capacity AOR
I_ProdnVersTP view from TRANSACTIONAL Manage Production Version
I_ProductionVersionStdVH view from COMPOSITE Production Version
I_SchedProdnVersRtgDetails view from COMPOSITE Production Version Routing Details
I_SchedProdnWrkCtrSqncVH view from COMPOSITE Work Ctr Filter for dispatch by sequence
I_SchedProdnWrkCtrSqncVH view union_all COMPOSITE Work Ctr Filter for dispatch by sequence
I_WrkCtrCapByAreaOfRespy view inner COMPOSITE Work Center By Area Of Responsibility
P_ALTERNATEPRODLINES view inner BASIC
P_DDMaterialSOS view inner CONSUMPTION
P_NumberOfSourcesOfSupply view from COMPOSITE
P_ProductionVersion view from COMPOSITE
P_SchedProdnAltvProdnVers view from BASIC
P_WrkCtrMntrAlternateWrkCtr view inner CONSUMPTION
P_WrkCtrMntrIndstryType view from CONSUMPTION Industry Type for Alternate Routings
R_ProductionVersionTP view_entity from TRANSACTIONAL Production Version Header

Fields (72)

KeyField CDS FieldsUsed in Views
KEY Material Material,MaterialForEdit,Product 11
KEY Plant AlternatePlant,Plant,PlantForEdit 12
KEY ProductionLine AlternateWorkCenter,ProductionLine,WorkCenter 10
KEY ProductionVersion ProductionVersion,ProductionVersionForEdit 11
_BillOfOperations _BillOfOperations 2
_BillOfOperationsGroup _BillOfOperationsGroup 2
_BillOfOperationsType _BillOfOperationsType 2
_ChangeMaster _ChangeMaster 2
_IssuingStorageLocation _IssuingStorageLocation 2
_MainProduct _MainProduct 2
_Material _Material 2
_MaterialBaseUnit _MaterialBaseUnit 1
_MatlCostApportionmentStruc _MatlCostApportionmentStruc 2
_MatlProcurementProfile _MatlProcurementProfile 1
_OriglBatchReferenceMaterial _OriglBatchReferenceMaterial 2
_Plant _Plant 2
_Product _Product 2
_ProductionLine _ProductionLine 2
_ProductionSupplyArea _ProductionSupplyArea 2
_ProductionVersionGroup _ProductionVersionGroup 2
_ProductPlant _ProductPlant 2
_QuantityDistributionKey _QuantityDistributionKey 1
_ReceivingStorageLocation _ReceivingStorageLocation 2
_TargetProductionSupplyArea _TargetProductionSupplyArea 1
BillOfMaterialVariant BillOfMaterialVariant 3
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 3
BillOfOperationsGroup BillOfOperationsGroup 3
BillOfOperationsType BillOfOperationsType 4
BillOfOperationsVariant BillOfOperationsVariant 3
BOMCheckStatus BOMCheckStatus 3
ChangeHistoryCount ChangeHistoryCount 3
ChangeNumber ChangeNumber 3
ConfigblProdProductionVersion ConfigblProdProductionVersion 1
CostingLotSize CostingLotSize 1
CreatedByUser CreatedByUser 3
CreationDate CreationDate 3
DestinationStorageBin DestinationStorageBin 2
DistributionKey DistributionKey 2
ExecBillOfMaterialVariant ExecBillOfMaterialVariant 2
ExecBillOfMaterialVariantUsage ExecBillOfMaterialVariantUsage 2
ExecBillOfOperationsGroup ExecBillOfOperationsGroup 2
ExecBillOfOperationsType ExecBillOfOperationsType 2
ExecBillOfOperationsVariant ExecBillOfOperationsVariant 2
HasVersionCtrldBOMAndRouting HasVersionCtrldBOMAndRouting 3
IssuingStorageLocation IssuingStorageLocation 3
LastChangeDate LastChangeDate 3
LastChangedByUser LastChangedByUser 3
MainProduct MainProduct 3
MaterialBaseUnit MaterialBaseUnit 2
MaterialCostApportionmentStruc MaterialCostApportionmentStruc 3
MaterialMaxLotSizeQuantity MaterialMaxLotSizeQuantity 3
MaterialMinLotSizeQuantity MaterialMinLotSizeQuantity 3
MaterialProcurementProfile MaterialProcurementProfile 1
OriginalBatchReferenceMaterial OriginalBatchReferenceMaterial 3
PlanningAndExecutionBOMIsDiff PlanningAndExecutionBOMIsDiff 2
PreliminaryPlanningStatus PreliminaryPlanningStatus 3
ProcurementType ProcurementType 1
ProdnVersIsAllowedForRptvMfg ProdnVersIsAllowedForRptvMfg 3
ProductionSupplyArea ProductionSupplyArea 3
ProductionVersionGroup ProductionVersionGroup 3
ProductionVersionIsLocked ProductionVersionIsLocked 2
ProductionVersionLastCheckDate ProductionVersionLastCheckDate 3
ProductionVersionStatus ProductionVersionStatus 2
ProductionVersionText ProductionVersionText 8
QuantityDistributionKey QuantityDistributionKey 2
RateBasedPlanningStatus RateBasedPlanningStatus 3
ReceivingStorageLocation ReceivingStorageLocation,StorageLocation 4
TargetProductionSupplyArea TargetProductionSupplyArea 1
UsgeProbltyWthVersCtrlInPct UsgeProbltyWthVersCtrlInPct 1
ValidityEndDate ValidityEndDate 3
ValidityStartDate ValidityStartDate 3
Warehouse EWMWarehouse 2

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.

-- Production Version
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PRODUCTIONVERSION (
    MATERIAL,
    PLANT,
    PRODUCTIONLINE,
    PRODUCTIONVERSION,
    _BILLOFOPERATIONS,
    _BILLOFOPERATIONSGROUP,
    _BILLOFOPERATIONSTYPE,
    _CHANGEMASTER,
    _ISSUINGSTORAGELOCATION,
    _MAINPRODUCT,
    _MATERIAL,
    _MATERIALBASEUNIT,
    _MATLCOSTAPPORTIONMENTSTRUC,
    _MATLPROCUREMENTPROFILE,
    _ORIGLBATCHREFERENCEMATERIAL,
    _PLANT,
    _PRODUCT,
    _PRODUCTIONLINE,
    _PRODUCTIONSUPPLYAREA,
    _PRODUCTIONVERSIONGROUP,
    _PRODUCTPLANT,
    _QUANTITYDISTRIBUTIONKEY,
    _RECEIVINGSTORAGELOCATION,
    _TARGETPRODUCTIONSUPPLYAREA,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVARIANTUSAGE,
    BILLOFOPERATIONSGROUP,
    BILLOFOPERATIONSTYPE,
    BILLOFOPERATIONSVARIANT,
    BOMCHECKSTATUS,
    CHANGEHISTORYCOUNT,
    CHANGENUMBER,
    CONFIGBLPRODPRODUCTIONVERSION,
    COSTINGLOTSIZE,
    CREATEDBYUSER,
    CREATIONDATE,
    DESTINATIONSTORAGEBIN,
    DISTRIBUTIONKEY,
    EXECBILLOFMATERIALVARIANT,
    EXECBILLOFMATERIALVARIANTUSAGE,
    EXECBILLOFOPERATIONSGROUP,
    EXECBILLOFOPERATIONSTYPE,
    EXECBILLOFOPERATIONSVARIANT,
    HASVERSIONCTRLDBOMANDROUTING,
    ISSUINGSTORAGELOCATION,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    MAINPRODUCT,
    MATERIALBASEUNIT,
    MATERIALCOSTAPPORTIONMENTSTRUC,
    MATERIALMAXLOTSIZEQUANTITY,
    MATERIALMINLOTSIZEQUANTITY,
    MATERIALPROCUREMENTPROFILE,
    ORIGINALBATCHREFERENCEMATERIAL,
    PLANNINGANDEXECUTIONBOMISDIFF,
    PRELIMINARYPLANNINGSTATUS,
    PROCUREMENTTYPE,
    PRODNVERSISALLOWEDFORRPTVMFG,
    PRODUCTIONSUPPLYAREA,
    PRODUCTIONVERSIONGROUP,
    PRODUCTIONVERSIONISLOCKED,
    PRODUCTIONVERSIONLASTCHECKDATE,
    PRODUCTIONVERSIONSTATUS,
    PRODUCTIONVERSIONTEXT,
    QUANTITYDISTRIBUTIONKEY,
    RATEBASEDPLANNINGSTATUS,
    RECEIVINGSTORAGELOCATION,
    TARGETPRODUCTIONSUPPLYAREA,
    USGEPROBLTYWTHVERSCTRLINPCT,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    WAREHOUSE,
    PRIMARY KEY (MATERIAL, PLANT, PRODUCTIONLINE, PRODUCTIONVERSION)
);

Learn More