I_SubscrpnProdSpecTP

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_SubscrpnProdSpecTP.
-- 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.
-- SQL view name: ISPRODSPECTP

CREATE VIEW I_SubscrpnProdSpecTP AS
SELECT
  SubscrpnProdSpec.SubscrpnProdSpecUUID AS SubscrpnProdSpecUUID,
  SubscrpnProdSpec.CreatedByUser AS CreatedByUser,
  SubscrpnProdSpec.CreationDateTime AS CreationDateTime,
  SubscrpnProdSpec.LastChangedByUser AS LastChangedByUser,
  SubscrpnProdSpec.LastChangeDateTime AS LastChangeDateTime,
  SubscrpnProdSpec.Product AS Product,
  SubscrpnProdSpec.ProductUUID AS ProductUUID,
  SubscrpnProdSpec.ProductType AS ProductType,
  SubscrpnProdSpec.ProductGroup AS ProductGroup,
  SubscrpnProdSpec.AuthorizationGroup AS AuthorizationGroup,
  SubscrpnProdSpec.SubscrpnProdTechRsceSchema AS SubscrpnProdTechRsceSchema,
  SubscrpnProdSpec.ProductIsConfigurable AS ProductIsConfigurable,
  SubscrpnProdSpec.BaseUnit AS BaseUnit,
  SubscrpnProdSpec.CABillgCycle AS CABillgCycle,
  SubscrpnProdSpec.SubscrpnProdBillgCycDetn AS SubscrpnProdBillgCycDetn,
  SubscrpnProdSpec.SubscriptionProductPurpose AS SubscriptionProductPurpose,
  SubscrpnProdSpec.ContractAutoRenewalType AS ContractAutoRenewalType,
  SubscrpnProdSpec.SubscrpnProdTechRsceIsActive AS SubscrpnProdTechRsceIsActive
FROM I_SubscrpnProdSpec AS SubscrpnProdSpec
LEFT OUTER JOIN I_Product AS _Product ON _Product.Product = Product  -- association [0..1]
LEFT OUTER JOIN I_Producttype AS _ProductType ON _ProductType.ProductType = ProductType  -- association [1..1]
LEFT OUTER JOIN I_ProductGroup AS _ProductGroup ON _ProductGroup.MaterialGroup = ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_SubscrpnProductChargeTP AS _SubscrpnProductChargeTP ON _SubscrpnProductChargeTP.SubscrpnProdSpecUUID = SubscrpnProdSpecUUID  -- association [0..*]
LEFT OUTER JOIN I_SubscrpnProdDiscountTP AS _SubscrpnProdDiscountTP ON _SubscrpnProdDiscountTP.SubscrpnProdSpecUUID = SubscrpnProdSpecUUID  -- association [0..*]
LEFT OUTER JOIN I_CrsCtlgMappingVersionTP AS _CrsCtlgMappingVersionTP ON _CrsCtlgMappingVersionTP.SubscrpnProdSpecUUID = SubscrpnProdSpecUUID  -- association [0..*]
LEFT OUTER JOIN I_SubscrpnSharingProductTP AS _SubscrpnSharingProductTP ON _SubscrpnSharingProductTP.SubscrpnProdSpecUUID = SubscrpnProdSpecUUID  -- association [0..*]
LEFT OUTER JOIN I_SubscrpnProdDepdntItmTypeTP AS _SubscrpnProdDepdntItmTypeTP ON _SubscrpnProdDepdntItmTypeTP.SubscrpnProdSpecUUID = SubscrpnProdSpecUUID  -- association [0..*]
;