I_ProductSalesDeliveryWD

DDL: CRMS4V_SOM_E_IPRODSALESDELIVWD Type: extend_view
8 Fields

Extension View for I_ProductSalesWD

I_ProductSalesDeliveryWD is a CDS View that provides data about "Extension View for I_ProductSalesWD" in SAP S/4HANA.

Annotations (3)

NameValueLevelField
AbapCatalog.internal.setChange FLDADD_NO_ASS_INFLUENCE view
AbapCatalog.sqlViewAppendName CRMS4VSOMIPRDSDW view
EndUserText.label Extension View for I_ProductSalesWD view

Fields (8)

KeyFieldSource TableSource FieldDescription
SubscrpnContrDfltDuration SalesDelivery SubscrpnContrDfltDuration Def Contract Term
SubscrpnContrAltvDuration1 SalesDelivery SubscrpnContrAltvDuration1 Contract Term 1
SubscrpnContrAltvDuration2 SalesDelivery SubscrpnContrAltvDuration2 Contract Term 2
SubscrpnContrDurationUnit SalesDelivery SubscrpnContrDurationUnit Unit Contract Term
SubscrpnContrDfltExtnDurn SalesDelivery SubscrpnContrDfltExtnDurn Def Extension Period
SubscrpnContrAltvExtnDurn1 SalesDelivery SubscrpnContrAltvExtnDurn1 Extension Period 1
SubscrpnContrAltvExtnDurn2 SalesDelivery SubscrpnContrAltvExtnDurn2 Extension Period 2
SubscrpnContrExtnDurnUnit SalesDelivery SubscrpnContrExtnDurnUnit 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_ProductSalesDeliveryWD.
-- 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_ProductSalesDeliveryWD AS
SELECT
  SalesDelivery.SubscrpnContrDfltDuration AS SubscrpnContrDfltDuration,
  SalesDelivery.SubscrpnContrAltvDuration1 AS SubscrpnContrAltvDuration1,
  SalesDelivery.SubscrpnContrAltvDuration2 AS SubscrpnContrAltvDuration2,
  SalesDelivery.SubscrpnContrDurationUnit AS SubscrpnContrDurationUnit,
  SalesDelivery.SubscrpnContrDfltExtnDurn AS SubscrpnContrDfltExtnDurn,
  SalesDelivery.SubscrpnContrAltvExtnDurn1 AS SubscrpnContrAltvExtnDurn1,
  SalesDelivery.SubscrpnContrAltvExtnDurn2 AS SubscrpnContrAltvExtnDurn2,
  SalesDelivery.SubscrpnContrExtnDurnUnit AS SubscrpnContrExtnDurnUnit
;

Learn More