I_PRODUCTSALESDELIVERY

CDS View
58 Fields 18 CDS Views

Extension View for I_ProductSalesDelivery

I_PRODUCTSALESDELIVERY is a CDS View in S/4HANA. Extension View for I_ProductSalesDelivery. It contains 58 fields. 18 CDS views read from this table.

CDS Views using this table (18)

ViewTypeJoinVDMDescription
A_ClfnProductSalesDelivery view from COMPOSITE Sales Organization Data
A_ProductSalesDelivery view from COMPOSITE Sales Organization Data
C_MaterialBySlsOrgDistrChnl view inner CONSUMPTION Materials By Sales Org and Distr Channel
C_ProductBufferSalesData view from CONSUMPTION DDMRP Product Sales Data
C_ProductObjPgDistrChain view from CONSUMPTION Product Object Page - Distribution Chain
C_SlsDocItemCustomerMaterialVH view inner CONSUMPTION Customer Material
Crms4v_ProductSales view inner Product Sales
ESH_N_SOR_PRODUCT view from
I_LastMileLoadPrpslProductVH view_entity from COMPOSITE LMD Load Proposal Product Value Help
I_LstMiRldReqProductVH view_entity from COMPOSITE LMD Reload Request Product
I_ProductByDistributionChainVH view from COMPOSITE Product assigned to Distribution Chain
I_ProductSalesDeliverySalesTax view inner COMPOSITE Product Sales Delivery Sales Tax
I_ProductSalesDeliveryVH view_entity from BASIC Product Sales Data
I_ProductSalesDeliveryWD view from TRANSACTIONAL Product BO - Sales Delivery Node (draft)
P_ProductSalesDeliveryWD view from COMPOSITE
P_SrvcProdComDistrChnl view from CONSUMPTION Common distribution Channel for Product
P_SrvcProdComDistrChnl view union CONSUMPTION Common distribution Channel for Product
R_ProductSalesDeliveryTP view_entity from TRANSACTIONAL Product Sales Delivery

Fields (58)

KeyField CDS FieldsUsed in Views
KEY Product ActiveProduct,Product,ProductForEdit 3
KEY ProductDistributionChnl ActiveProductDistributionChnl,DistributionChannel,ProductDistributionChnl,ProductDistributionChnlForEdit 5
KEY ProductSalesOrg ActiveProductSalesOrg,ProductSalesOrg,ProductSalesOrgForEdit,SalesOrganization 5
_ItemCategoryGroup _ItemCategoryGroup 1
_ItemCategoryGroupText _ItemCategoryGroupText 1
_ProductSalesStatus _ProductSalesStatus 1
AccountDetnProductGroup AccountDetnProductGroup 3
AssortmentGrade AssortmentGrade 2
BaseUnit BaseUnit 1
CashDiscountIsDeductible CashDiscountIsDeductible 3
CompetitionPressureCategory CompetitionPressureCategory 2
DeliveryNoteProcMinDelivQty DeliveryNoteProcMinDelivQty 2
DeliveryQuantity DeliveryQuantity 2
DeliveryQuantityUnit DeliveryQuantityUnit 3
DistrCntrListingEndDate DistrCntrListingEndDate 2
DistrCntrListingProcedure DistrCntrListingProcedure 2
DistrCntrListingStartDate DistrCntrListingStartDate 2
DistrCntrSaleEndDate DistrCntrSaleEndDate 2
DistrCntrSaleStartDate DistrCntrSaleStartDate 2
FifthSalesSpecProductGroup FifthSalesSpecProductGroup,ProductGroup5 3
FirstSalesSpecProductGroup FirstSalesSpecProductGroup,ProductGroup1 3
FourthSalesSpecProductGroup FourthSalesSpecProductGroup,ProductGroup4 3
IsMarkedForDeletion IsMarkedForDeletion 2
ItemCategoryGroup ItemCategoryGroup 4
LogisticsStatisticsGroup LogisticsStatisticsGroup 2
MaxDeliveryQtyStoreOrder MaxDeliveryQtyStoreOrder 2
MinimumMakeToOrderOrderQty MinimumMakeToOrderOrderQty 2
MinimumOrderQuantity MinimumOrderQuantity 3
PriceFixingCategory PriceFixingCategory 2
PriceSpecificationProductGroup PriceSpecificationProductGroup,ProductGroup 3
PricingReferenceProduct PricingReferenceProduct 3
ProdExtAssortmentPriority ProdExtAssortmentPriority 1
ProdIsEntlmntRlvt ProdIsEntlmntRlvt 1
ProductCommissionGroup ProductCommissionGroup 3
ProductHierarchy ProductHierarchy 3
ProductSalesStatus ProductSalesStatus 4
ProductSalesStatusValidityDate ProductSalesStatusValidityDate 4
ProductUnitGroup ProductUnitGroup 2
RoundingProfile RoundingProfile 2
SalesMeasureUnit SalesMeasureUnit 5
SecondSalesSpecProductGroup ProductGroup2,SecondSalesSpecProductGroup 2
StoreListingEndDate StoreListingEndDate 2
StoreListingProcedure StoreListingProcedure 2
StoreListingStartDate StoreListingStartDate 2
StoreSaleEndDate StoreSaleEndDate 2
StoreSaleStartDate StoreSaleStartDate 2
SubscrpnContrAltvDuration1 SubscrpnContrAltvDuration1 1
SubscrpnContrAltvDuration2 SubscrpnContrAltvDuration2 1
SubscrpnContrAltvExtnDurn1 SubscrpnContrAltvExtnDurn1 1
SubscrpnContrAltvExtnDurn2 SubscrpnContrAltvExtnDurn2 1
SubscrpnContrDfltDuration SubscrpnContrDfltDuration 1
SubscrpnContrDfltExtnDurn SubscrpnContrDfltExtnDurn 1
SubscrpnContrDurationUnit SubscrpnContrDurationUnit 1
SubscrpnContrExtnDurnUnit SubscrpnContrExtnDurnUnit 1
SupplyingPlant SupplyingPlant 3
ThirdSalesSpecProductGroup ProductGroup3,ThirdSalesSpecProductGroup 2
VariableSalesUnitIsNotAllowed VariableSalesUnitIsNotAllowed 3
VolumeRebateGroup VolumeRebateGroup 3

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.

-- Extension View for I_ProductSalesDelivery
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PRODUCTSALESDELIVERY (
    PRODUCT,
    PRODUCTDISTRIBUTIONCHNL,
    PRODUCTSALESORG,
    _ITEMCATEGORYGROUP,
    _ITEMCATEGORYGROUPTEXT,
    _PRODUCTSALESSTATUS,
    ACCOUNTDETNPRODUCTGROUP,
    ASSORTMENTGRADE,
    BASEUNIT,
    CASHDISCOUNTISDEDUCTIBLE,
    COMPETITIONPRESSURECATEGORY,
    DELIVERYNOTEPROCMINDELIVQTY,
    DELIVERYQUANTITY,
    DELIVERYQUANTITYUNIT,
    DISTRCNTRLISTINGENDDATE,
    DISTRCNTRLISTINGPROCEDURE,
    DISTRCNTRLISTINGSTARTDATE,
    DISTRCNTRSALEENDDATE,
    DISTRCNTRSALESTARTDATE,
    FIFTHSALESSPECPRODUCTGROUP,
    FIRSTSALESSPECPRODUCTGROUP,
    FOURTHSALESSPECPRODUCTGROUP,
    ISMARKEDFORDELETION,
    ITEMCATEGORYGROUP,
    LOGISTICSSTATISTICSGROUP,
    MAXDELIVERYQTYSTOREORDER,
    MINIMUMMAKETOORDERORDERQTY,
    MINIMUMORDERQUANTITY,
    PRICEFIXINGCATEGORY,
    PRICESPECIFICATIONPRODUCTGROUP,
    PRICINGREFERENCEPRODUCT,
    PRODEXTASSORTMENTPRIORITY,
    PRODISENTLMNTRLVT,
    PRODUCTCOMMISSIONGROUP,
    PRODUCTHIERARCHY,
    PRODUCTSALESSTATUS,
    PRODUCTSALESSTATUSVALIDITYDATE,
    PRODUCTUNITGROUP,
    ROUNDINGPROFILE,
    SALESMEASUREUNIT,
    SECONDSALESSPECPRODUCTGROUP,
    STORELISTINGENDDATE,
    STORELISTINGPROCEDURE,
    STORELISTINGSTARTDATE,
    STORESALEENDDATE,
    STORESALESTARTDATE,
    SUBSCRPNCONTRALTVDURATION1,
    SUBSCRPNCONTRALTVDURATION2,
    SUBSCRPNCONTRALTVEXTNDURN1,
    SUBSCRPNCONTRALTVEXTNDURN2,
    SUBSCRPNCONTRDFLTDURATION,
    SUBSCRPNCONTRDFLTEXTNDURN,
    SUBSCRPNCONTRDURATIONUNIT,
    SUBSCRPNCONTREXTNDURNUNIT,
    SUPPLYINGPLANT,
    THIRDSALESSPECPRODUCTGROUP,
    VARIABLESALESUNITISNOTALLOWED,
    VOLUMEREBATEGROUP,
    PRIMARY KEY (PRODUCT, PRODUCTDISTRIBUTIONCHNL, PRODUCTSALESORG)
);

Learn More