I_SubscrpnProdSpec

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_SubscrpnProdSpec.
-- 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: ISPRODSPEC

CREATE VIEW I_SubscrpnProdSpec 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 P_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_ProductText AS _ProductText ON _ProductText.Product = Product  -- association [0..*]
LEFT OUTER JOIN I_ProductGroup AS _ProductGroup ON _ProductGroup.MaterialGroup = ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON _CreatedByUser.UserID = CreatedByUser  -- association [1..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON _LastChangedByUser.UserID = LastChangedByUser  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON CreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUserContactCard ON LastChangedByUser = _LastChangedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_SubsProdTechRsceSchema AS _SubsProdTechRsceSchema ON _SubsProdTechRsceSchema.SubscrpnProdTechRsceSchema = SubscrpnProdTechRsceSchema  -- association [0..1]
;