P_PRODUCTSALESDELIVERYD

CDS View
45 Fields 3 CDS Views

Draft

P_PRODUCTSALESDELIVERYD is a CDS View in S/4HANA. Draft. It contains 45 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_Productsalesdeliveryposwd view inner COMPOSITE Product Sales Delivery POS union(draft)
P_ProductSalesDeliveryWD view left_outer COMPOSITE Union
P_ProductSalesDeliveryWD view union_all COMPOSITE Union

Fields (45)

KeyField CDS FieldsUsed in Views
accountdetnproductgroup accountdetnproductgroup 1
ActiveProduct ActiveProduct 1
ActiveProductDistributionChnl ActiveProductDistributionChnl 1
ActiveProductSalesOrg ActiveProductSalesOrg 1
assortmentgrade assortmentgrade 1
cashdiscountisdeductible cashdiscountisdeductible 1
competitionpressurecategory competitionpressurecategory 1
deliverynoteprocmindelivqty deliverynoteprocmindelivqty 1
deliveryquantity deliveryquantity 1
deliveryquantityunit deliveryquantityunit 1
distrcntrlistingenddate distrcntrlistingenddate 1
distrcntrlistingprocedure distrcntrlistingprocedure 1
distrcntrlistingstartdate distrcntrlistingstartdate 1
distrcntrsaleenddate distrcntrsaleenddate 1
distrcntrsalestartdate distrcntrsalestartdate 1
fifthsalesspecproductgroup fifthsalesspecproductgroup 1
firstsalesspecproductgroup firstsalesspecproductgroup 1
fourthsalesspecproductgroup fourthsalesspecproductgroup 1
hasactiveentity HasActiveEntity 1
itemcategorygroup itemcategorygroup 1
logisticsstatisticsgroup logisticsstatisticsgroup 1
maxdeliveryqtystoreorder maxdeliveryqtystoreorder 1
minimummaketoorderorderqty minimummaketoorderorderqty 1
minimumorderquantity minimumorderquantity 1
ParentDraftKey ParentDraftKey 1
pricefixingcategory pricefixingcategory 1
pricespecificationproductgroup pricespecificationproductgroup 1
pricingreferenceproduct pricingreferenceproduct 1
productcommissiongroup productcommissiongroup 1
producthierarchy producthierarchy 1
productsalesstatus productsalesstatus 1
productsalesstatusvaliditydate productsalesstatusvaliditydate 1
productunitgroup productunitgroup 1
roundingprofile roundingprofile 1
salesmeasureunit salesmeasureunit 1
secondsalesspecproductgroup secondsalesspecproductgroup 1
storelistingenddate storelistingenddate 1
storelistingprocedure storelistingprocedure 1
storelistingstartdate storelistingstartdate 1
storesaleenddate storesaleenddate 1
storesalestartdate storesalestartdate 1
supplyingplant supplyingplant 1
thirdsalesspecproductgroup thirdsalesspecproductgroup 1
variablesalesunitisnotallowed variablesalesunitisnotallowed 1
volumerebategroup volumerebategroup 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_PRODUCTSALESDELIVERYD (
    ACCOUNTDETNPRODUCTGROUP,
    ACTIVEPRODUCT,
    ACTIVEPRODUCTDISTRIBUTIONCHNL,
    ACTIVEPRODUCTSALESORG,
    ASSORTMENTGRADE,
    CASHDISCOUNTISDEDUCTIBLE,
    COMPETITIONPRESSURECATEGORY,
    DELIVERYNOTEPROCMINDELIVQTY,
    DELIVERYQUANTITY,
    DELIVERYQUANTITYUNIT,
    DISTRCNTRLISTINGENDDATE,
    DISTRCNTRLISTINGPROCEDURE,
    DISTRCNTRLISTINGSTARTDATE,
    DISTRCNTRSALEENDDATE,
    DISTRCNTRSALESTARTDATE,
    FIFTHSALESSPECPRODUCTGROUP,
    FIRSTSALESSPECPRODUCTGROUP,
    FOURTHSALESSPECPRODUCTGROUP,
    HASACTIVEENTITY,
    ITEMCATEGORYGROUP,
    LOGISTICSSTATISTICSGROUP,
    MAXDELIVERYQTYSTOREORDER,
    MINIMUMMAKETOORDERORDERQTY,
    MINIMUMORDERQUANTITY,
    PARENTDRAFTKEY,
    PRICEFIXINGCATEGORY,
    PRICESPECIFICATIONPRODUCTGROUP,
    PRICINGREFERENCEPRODUCT,
    PRODUCTCOMMISSIONGROUP,
    PRODUCTHIERARCHY,
    PRODUCTSALESSTATUS,
    PRODUCTSALESSTATUSVALIDITYDATE,
    PRODUCTUNITGROUP,
    ROUNDINGPROFILE,
    SALESMEASUREUNIT,
    SECONDSALESSPECPRODUCTGROUP,
    STORELISTINGENDDATE,
    STORELISTINGPROCEDURE,
    STORELISTINGSTARTDATE,
    STORESALEENDDATE,
    STORESALESTARTDATE,
    SUPPLYINGPLANT,
    THIRDSALESSPECPRODUCTGROUP,
    VARIABLESALESUNITISNOTALLOWED,
    VOLUMEREBATEGROUP
);

Learn More