C_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 C_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: CSPRODSPECTP

CREATE VIEW C_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.Product AS SubscrpnProductSpecification,
  SubscrpnProdSpec.ProductType AS ProductType,
  SubscrpnProdSpec.ProductGroup AS ProductGroup,
  SubscrpnProdSpec.AuthorizationGroup AS AuthorizationGroup,
  SubscrpnProdSpec.SubscrpnProdTechRsceSchema AS SubscrpnProdTechRsceSchema,
  _ProductDescription.ProductDescription AS ProductDescription,
  _ProductTypeName.MaterialTypeName AS ProductTypeName,
  SubscrpnProdSpec._CreatedByUser.UserDescription AS CreatedByUserName,
  SubscrpnProdSpec._LastChangedByUser.UserDescription AS LastChangedByUserName,
  _SubsProdTechRsceSchema._SubsProdTechRsceSchmText[1: Language=$session.system_language].SubscrpnProdTechRsceSchemaText AS SubscrpnProdTechRsceSchemaText,
  _Product.IsMarkedForDeletion AS MaterialIsMarkedForDeletion,
  SubscrpnProdSpec.ProductIsConfigurable AS ProductIsConfigurable,
  SubscrpnProdSpec.BaseUnit AS BaseUnit,
  SubscrpnProdSpec.CABillgCycle AS CABillgCycle,
  SubscrpnProdSpec.SubscrpnProdBillgCycDetn AS SubscrpnProdBillgCycDetn,
  SubscrpnProdSpec.SubscriptionProductPurpose AS SubscriptionProductPurpose,
  SubscrpnProdSpec.ContractAutoRenewalType AS ContractAutoRenewalType
FROM I_SubscrpnProdSpecTP 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_ProductDescription AS _ProductDescription ON _ProductDescription.Product = Product AND _ProductDescription.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductTypeText AS _ProductTypeName ON _ProductTypeName.ProductType = ProductType AND _ProductTypeName.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_SubscrpnProdSpecVH AS _SubscrpnProdSpecVH ON _SubscrpnProdSpecVH.Product = SubscrpnProductSpecification  -- association [0..1]
LEFT OUTER JOIN C_SubscrpnProdWthoutSpecVH AS _SubscrpnProdWthoutSpecVH ON _SubscrpnProdWthoutSpecVH.Product = Product  -- association [0..1]
LEFT OUTER JOIN C_SubscrpnProductTypeVH AS _SubscrpnProductTypeVH ON _SubscrpnProductTypeVH.ProductType = ProductType  -- association [0..1]
LEFT OUTER JOIN C_SubscrpnProductChargeTP AS _SubscrpnProductChargeTP ON _SubscrpnProductChargeTP.SubscrpnProdSpecUUID = SubscrpnProdSpecUUID  -- association [0..*]
LEFT OUTER JOIN C_SubscrpnProdDiscountTP AS _SubscrpnProdDiscountTP ON _SubscrpnProdDiscountTP.SubscrpnProdSpecUUID = SubscrpnProdSpecUUID  -- association [0..*]
LEFT OUTER JOIN C_CrsCtlgMappingVersionTP AS _CrsCtlgMappingVersionTP ON _CrsCtlgMappingVersionTP.SubscrpnProdSpecUUID = SubscrpnProdSpecUUID  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _BaseUnitOfMeasureText ON _BaseUnitOfMeasureText.UnitOfMeasure = BaseUnit AND _BaseUnitOfMeasureText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CABillgCycleText AS _CABillgCycleText ON _CABillgCycleText.CABillgCycle = CABillgCycle AND _CABillgCycleText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SubsProdBillgCycDetnText AS _SubsProdBillgCycDetnText ON _SubsProdBillgCycDetnText.SubscrpnProdBillgCycDetn = SubscrpnProdBillgCycDetn AND _SubsProdBillgCycDetnText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_SubscrpnProdSlsDelivery AS _SubscrpnProdSlsDelivery ON _SubscrpnProdSlsDelivery.Product = Product  -- association [0..*]
LEFT OUTER JOIN C_SubscrpnSharingProductTP AS _SubscrpnSharingProductTP ON _SubscrpnSharingProductTP.SubscrpnProdSpecUUID = SubscrpnProdSpecUUID  -- association [0..*]
LEFT OUTER JOIN C_SubscrpnProductPurposeVH AS _SubscrpnProductPurposeVH ON _SubscrpnProductPurposeVH.SubscriptionProductPurpose = SubscriptionProductPurpose  -- association [0..1]
LEFT OUTER JOIN C_SubscrpnProdDepdntItmTypeTP AS _SubscrpnProdDepdntItmTypeTP ON _SubscrpnProdDepdntItmTypeTP.SubscrpnProdSpecUUID = SubscrpnProdSpecUUID  -- association [0..*]
LEFT OUTER JOIN I_SOM_ContrAutoRnwlTypeT AS _SOM_ContrAutoRnwlTypeT ON _SOM_ContrAutoRnwlTypeT.ContractAutoRenewalType = ContractAutoRenewalType AND _SOM_ContrAutoRnwlTypeT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_SubscrpnProdTechRsceSchemaVH AS _SubscrpnProdTechRsceSchemaVH ON _SubscrpnProdTechRsceSchemaVH.SubscrpnProdTechRsceSchema = SubscrpnProdTechRsceSchema  -- association [0..1]
;