I_ProductSalesDelivery

DDL: CRMS4V_SOM_E_IPRODSALESDELIV Type: extend_view Package: CRMS4_SOM_LEGACY
8 Fields

Extension View for I_ProductSalesDelivery

I_ProductSalesDelivery is a CDS View that provides data about "Extension View for I_ProductSalesDelivery" in SAP S/4HANA. Part of development package CRMS4_SOM_LEGACY.

SAP Help Documentation

CategoryCDS Views for Product Master
Data CategorySAP_CMD_BC_PR_MAINT_PC
StatusDimension
Data Extraction TypeReleased
Purpose
This CDS view provides the consumer with list of distribution chain records along with Product, Sales Organization and Distribution Channel. Customers can use this information to find out the distribution chain details of the products.

Prerequisites
Users who want to run reports using this CDS view must have a role based on the business role template listed in the table above. These restriction types are edited in the Maintain Business Roles app.

Structure
Object types This view relates to the following SAP object types: Material Product Sales Organization Distribution Channel

SAP Business Warehouse (SAP BW) Extraction
Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. In case you are interested in the details of the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Application Help SAP Library BI Content . For more information on extraction, see Extracting Data Through CDS Views to SAP BW/4HANA .

View on SAP Help Portal →

Annotations (3)

NameValueLevelField
AbapCatalog.internal.setChange FLDADD_NO_ASS_INFLUENCE view
AbapCatalog.sqlViewAppendName CRMS4VSOMIPRDSD view
EndUserText.label Extension View for I_ProductSalesDelivery view

Fields (8)

KeyFieldSource TableSource FieldDescription
SubscrpnContrDfltDuration mvke ctr_term_def Def Contract Term
SubscrpnContrAltvDuration1 mvke ctr_term_alt1 Contract Term 1
SubscrpnContrAltvDuration2 mvke ctr_term_alt2 Contract Term 2
SubscrpnContrDurationUnit mvke ctr_term_unit Unit Contract Term
SubscrpnContrDfltExtnDurn mvke ext_period_def Def Extension Period
SubscrpnContrAltvExtnDurn1 mvke ext_period_alt1 Extension Period 1
SubscrpnContrAltvExtnDurn2 mvke ext_period_alt2 Extension Period 2
SubscrpnContrExtnDurnUnit mvke ext_period_unit Unit for Extension

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ProductSalesDelivery.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_ProductSalesDelivery AS
SELECT
  mvke.ctr_term_def AS SubscrpnContrDfltDuration,
  mvke.ctr_term_alt1 AS SubscrpnContrAltvDuration1,
  mvke.ctr_term_alt2 AS SubscrpnContrAltvDuration2,
  mvke.ctr_term_unit AS SubscrpnContrDurationUnit,
  mvke.ext_period_def AS SubscrpnContrDfltExtnDurn,
  mvke.ext_period_alt1 AS SubscrpnContrAltvExtnDurn1,
  mvke.ext_period_alt2 AS SubscrpnContrAltvExtnDurn2,
  mvke.ext_period_unit AS SubscrpnContrExtnDurnUnit
;

Learn More