P_PRODUCTPLANTD

CDS View
40 Fields 10 CDS Views

Draft

P_PRODUCTPLANTD is a CDS View in S/4HANA. Draft. It contains 40 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
P_Productplantprocurementwd view inner COMPOSITE Product Plant Procurement Union (draft)
P_Productplantqtmanagement view inner COMPOSITE 'Product Plant Quality Managment Union (draft)
P_Productplantsaleswd view inner COMPOSITE Product Plant Sales Union (draft)
P_Productplantstoragewd view inner COMPOSITE Product Plant Storage Union (draft)
P_Productplanttextwd view inner COMPOSITE Product plant text Union
P_ProductPlantWD view left_outer COMPOSITE Union
P_ProductPlantWD view union_all COMPOSITE Union
P_ProductStorageLocationWD view inner COMPOSITE Product Storage Location Union (draft)
P_ProductSupplyPlanningWD view inner COMPOSITE Union
P_ProductWorkSchedulingWD view inner COMPOSITE union

Fields (40)

KeyField CDS FieldsUsed in Views
KEY ActivePlant ActivePlant 2
KEY ActiveProduct ActiveProduct 1
availabilitychecktype availabilitychecktype 1
consignmentcontrol consignmentcontrol 1
consumptiontaxctrlcode consumptiontaxctrlcode 1
countryoforigin countryoforigin 1
distrcntrdistributionprofile distrcntrdistributionprofile 1
distributionchannel distributionchannel 1
fiscalyearvariant fiscalyearvariant 1
goodissueprocessingdays goodissueprocessingdays 1
goodsreceiptblockedstockqty goodsreceiptblockedstockqty 1
hasconsignmentctrl hasconsignmentctrl 1
hasposttoinspectionstock hasposttoinspectionstock 1
iscoproduct iscoproduct 1
isinternalbatchmanaged isinternalbatchmanaged 1
ispurgacrosspurggroup ispurgacrosspurggroup 1
isreferencedistributioncenter isreferencedistributioncenter 1
isreferencestore isreferencestore 1
maintenancestatusname maintenancestatusname 1
Parentdraftkey Parentdraftkey 1
periodtype periodtype 1
plant plant 8
plantcategory plantcategory 1
product product 1
productcfopcategory productcfopcategory 1
productioninvtrymanagedloc productioninvtrymanagedloc 1
productisconfigurable productisconfigurable 1
productunitgroup productunitgroup 1
profilecode profilecode 1
profilevaliditystartdate profilevaliditystartdate 1
profitcenter profitcenter 1
purchasinggroup purchasinggroup 1
referencedistributioncenter referencedistributioncenter 1
referencestore referencestore 1
regionoforigin regionoforigin 1
salesorganization salesorganization 1
sourceofsupplycategory sourceofsupplycategory 1
stockdeterminationgroup stockdeterminationgroup 1
stockintransferquantity stockintransferquantity 1
stockintransitquantity stockintransitquantity 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.

-- Draft
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PRODUCTPLANTD (
    ACTIVEPLANT,
    ACTIVEPRODUCT,
    AVAILABILITYCHECKTYPE,
    CONSIGNMENTCONTROL,
    CONSUMPTIONTAXCTRLCODE,
    COUNTRYOFORIGIN,
    DISTRCNTRDISTRIBUTIONPROFILE,
    DISTRIBUTIONCHANNEL,
    FISCALYEARVARIANT,
    GOODISSUEPROCESSINGDAYS,
    GOODSRECEIPTBLOCKEDSTOCKQTY,
    HASCONSIGNMENTCTRL,
    HASPOSTTOINSPECTIONSTOCK,
    ISCOPRODUCT,
    ISINTERNALBATCHMANAGED,
    ISPURGACROSSPURGGROUP,
    ISREFERENCEDISTRIBUTIONCENTER,
    ISREFERENCESTORE,
    MAINTENANCESTATUSNAME,
    PARENTDRAFTKEY,
    PERIODTYPE,
    PLANT,
    PLANTCATEGORY,
    PRODUCT,
    PRODUCTCFOPCATEGORY,
    PRODUCTIONINVTRYMANAGEDLOC,
    PRODUCTISCONFIGURABLE,
    PRODUCTUNITGROUP,
    PROFILECODE,
    PROFILEVALIDITYSTARTDATE,
    PROFITCENTER,
    PURCHASINGGROUP,
    REFERENCEDISTRIBUTIONCENTER,
    REFERENCESTORE,
    REGIONOFORIGIN,
    SALESORGANIZATION,
    SOURCEOFSUPPLYCATEGORY,
    STOCKDETERMINATIONGROUP,
    STOCKINTRANSFERQUANTITY,
    STOCKINTRANSITQUANTITY,
    PRIMARY KEY (ACTIVEPLANT, ACTIVEPRODUCT)
);

Learn More