I_PRODUCTPLANT

CDS View
53 Fields 43 CDS Views

Product Plant

I_PRODUCTPLANT is a CDS View in S/4HANA. Product Plant. It contains 53 fields. 43 CDS views read from this table.

CDS Views using this table (43)

ViewTypeJoinVDMDescription
A_ATPChkRlvtProductPlant view_entity from CONSUMPTION ATP Check Data Definition
A_ATPRlvtProductMRPArea view_entity inner CONSUMPTION Product Availability per MRP Area
A_ATPRlvtProductMRPArea view_entity union_all CONSUMPTION Product Availability per MRP Area
A_ClfnProductPlant view from COMPOSITE Plant Data
A_ProductPlant view from COMPOSITE Plant Data
C_CustomerReturnPlantVH view inner CONSUMPTION
C_CustomerReturnProductVH view inner CONSUMPTION
C_JITMaterialValueHelp view_entity from CONSUMPTION Material
C_JITOutbMaterialVH view from CONSUMPTION Value help for Material
C_JITOutbSqncCompGrpMatlVH view_entity from CONSUMPTION Component Group material
C_MDQltyProductPlantDetail view from CONSUMPTION Master Data Quality - Prod. Plant Details
C_ProductObjPgPlant view from CONSUMPTION Product Object Page - Plant
C_ProductObjPgSite view from CONSUMPTION Product Object Page - Site
C_SchedProdnProductGroupVH view inner CONSUMPTION Value Help for Product Group
C_SchedProdnProductVH view from CONSUMPTION VH - Product
C_SchedProdnSalesDocumentVH view inner CONSUMPTION Sales Document
I_ATPRlvtProdAssgdSalesDocItem view_entity inner TRANSACTIONAL ATP Product Assigned SalesDocItem
I_ATPRlvtProdAssgdSoldToParty view_entity inner TRANSACTIONAL ATP Product Assigned Sold-to Party
I_ATPRlvtProdMRPArea view_entity inner TRANSACTIONAL ATP Relevant Product with MRP Areas
I_ATPRlvtProdPlant view_entity from TRANSACTIONAL ATP Relevant Product with Plants
I_MRPMfgOrder view inner COMPOSITE MRP Manufacturing Order
I_ProductsForSaleInRtlStore view from COMPOSITE Retail Store Products available for sale
I_SchedProdnWrkCtrAreaOfRespy view inner COMPOSITE Work Centers By Area of Responsibilty
I_StorePkngReqSubstnItem view from COMPOSITE Picking Request Subst item
P_AssgblDCForSuplr view left_outer CONSUMPTION
P_AssgblReceivingDCFromDC view left_outer CONSUMPTION
P_AssgblStoreForProcmtProdExt view left_outer CONSUMPTION
P_AssgblStoreForProcmtProdInt view left_outer CONSUMPTION
P_BR_ReportingItem view inner CONSUMPTION EFD - Product with Valuation and Plant
P_ConfigurableProductPlantBase view from CONSUMPTION
P_MaintJobCompProdPlntStrgloc view_entity from BASIC
P_MaterialPlant view from CONSUMPTION Private View for Material Plant
P_MaterialPriceVariance view inner CONSUMPTION Material Price Variance
P_MPE_MaterialStorageLocation view_entity from CONSUMPTION Material Plant with Storage Location
P_MPE_MaterialStorageLocation view_entity inner CONSUMPTION Material Plant with Storage Location
P_MPE_MaterialStorageLocation view_entity union_all CONSUMPTION Material Plant with Storage Location
P_MPEMaterial view_entity from CONSUMPTION Private view for Material pop over
P_MSPWSellableProduct view from BASIC
P_Plant_Fs view from BASIC
P_ProductPlantWD view from COMPOSITE
P_ProductsByWorkCenter view inner COMPOSITE
P_SerialNumberProfileProcedure view_entity from COMPOSITE
P_SOTFieldCatalog_OFR view from BASIC

Fields (53)

KeyField CDS FieldsUsed in Views
KEY Plant ActivePlant,MRPArea,MRPPlant,Plant,Store 17
KEY Product ActiveProduct,Material,Product 14
_ABCIndicator _ABCIndicator 1
_ABCIndicatorDesc _ABCIndicatorDesc 1
_CFOPDesc _CFOPDesc 1
_PeriodTypeText _PeriodTypeText 1
_Plant _Plant 1
_Product _Product 3
ABCIndicator ABCIndicator 2
AvailabilityCheckType AvailabilityCheckType 2
Commodity Commodity 1
ConfigurableProduct ConfigurableProduct 1
ConsignmentControl ConsignmentControl 1
ConsumptionTaxCtrlCode ConsumptionTaxCtrlCode 1
CountryOfOrigin CountryOfOrigin 3
DistrCntrDistributionProfile DistrCntrDistributionProfile 1
FiscalYearVariant FiscalYearVariant 2
GoodIssueProcessingDays GoodIssueProcessingDays 1
GoodsIssueUnit GoodsIssueUnit 1
GoodsReceiptBlockedStockQty GoodsReceiptBlockedStockQty 1
HasConsignmentCtrl HasConsignmentCtrl 1
HasPostToInspectionStock HasPostToInspectionStock 1
IsBatchManagementRequired IsBatchManagementRequired 2
IsCoProduct IsCoProduct 1
IsInternalBatchManaged IsInternalBatchManaged 1
IsMarkedForDeletion IsMarkedForDeletion 2
IsNegativeStockAllowed IsNegativeStockAllowed 1
IsPurgAcrossPurgGroup IsPurgAcrossPurgGroup 1
MaintenanceStatusName MaintenanceStatusName 1
MRPResponsible MRPResponsible 3
MRPType MRPType 2
OverDelivToleranceLimit OverDelivToleranceLimit 1
PeriodType PeriodType 2
ProcurementType ProcurementType 1
ProductCFOPCategory ProductCFOPCategory 2
ProductionInvtryManagedLoc ProductionInvtryManagedLoc 1
ProductionSchedulingProfile ProductionSchedulingProfile 1
ProductionSupervisor ProductionSupervisor 2
ProductIsConfigurable ProductIsConfigurable 1
ProductUnitGroup ProductUnitGroup 1
ProfileCode ProfileCode 2
ProfileValidityStartDate ProfileValidityStartDate 2
ProfitCenter ProfitCenter 1
PurchasingGroup PurchasingGroup 4
RegionOfOrigin RegionOfOrigin 2
SafetyStockQuantity SafetyStockQuantity 1
SerialNumberProfile SerialNumberProfile 5
SourceOfSupplyCategory SourceOfSupplyCategory 1
SpecialProcurementType SpecialProcurementType 1
StockDeterminationGroup StockDeterminationGroup 1
StockInTransferQuantity StockInTransferQuantity 1
StockInTransitQuantity StockInTransitQuantity 1
UnderDelivToleranceLimit UnderDelivToleranceLimit 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.

-- Product Plant
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PRODUCTPLANT (
    PLANT,
    PRODUCT,
    _ABCINDICATOR,
    _ABCINDICATORDESC,
    _CFOPDESC,
    _PERIODTYPETEXT,
    _PLANT,
    _PRODUCT,
    ABCINDICATOR,
    AVAILABILITYCHECKTYPE,
    COMMODITY,
    CONFIGURABLEPRODUCT,
    CONSIGNMENTCONTROL,
    CONSUMPTIONTAXCTRLCODE,
    COUNTRYOFORIGIN,
    DISTRCNTRDISTRIBUTIONPROFILE,
    FISCALYEARVARIANT,
    GOODISSUEPROCESSINGDAYS,
    GOODSISSUEUNIT,
    GOODSRECEIPTBLOCKEDSTOCKQTY,
    HASCONSIGNMENTCTRL,
    HASPOSTTOINSPECTIONSTOCK,
    ISBATCHMANAGEMENTREQUIRED,
    ISCOPRODUCT,
    ISINTERNALBATCHMANAGED,
    ISMARKEDFORDELETION,
    ISNEGATIVESTOCKALLOWED,
    ISPURGACROSSPURGGROUP,
    MAINTENANCESTATUSNAME,
    MRPRESPONSIBLE,
    MRPTYPE,
    OVERDELIVTOLERANCELIMIT,
    PERIODTYPE,
    PROCUREMENTTYPE,
    PRODUCTCFOPCATEGORY,
    PRODUCTIONINVTRYMANAGEDLOC,
    PRODUCTIONSCHEDULINGPROFILE,
    PRODUCTIONSUPERVISOR,
    PRODUCTISCONFIGURABLE,
    PRODUCTUNITGROUP,
    PROFILECODE,
    PROFILEVALIDITYSTARTDATE,
    PROFITCENTER,
    PURCHASINGGROUP,
    REGIONOFORIGIN,
    SAFETYSTOCKQUANTITY,
    SERIALNUMBERPROFILE,
    SOURCEOFSUPPLYCATEGORY,
    SPECIALPROCUREMENTTYPE,
    STOCKDETERMINATIONGROUP,
    STOCKINTRANSFERQUANTITY,
    STOCKINTRANSITQUANTITY,
    UNDERDELIVTOLERANCELIMIT,
    PRIMARY KEY (PLANT, PRODUCT)
);

Learn More