P_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 P_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: PSPRODSPEC

CREATE VIEW P_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,
  Product.mtart AS ProductType,
  Product.matkl AS ProductGroup,
  Product.begru AS AuthorizationGroup,
  Product.scm_matid_guid16 AS ProductUUID,
  Product.kzkfg AS ProductIsConfigurable,
  Product.meins AS BaseUnit,
  Product.som_cycle AS CABillgCycle,
  Product.som_cycle_rule AS SubscrpnProdBillgCycDetn,
  Product.som_ctr_autorenewal AS ContractAutoRenewalType,
  SubscrpnProdSpec.subscrpnprodtechrsceisactive AS SubscrpnProdTechRsceIsActive
FROM crms4d_som_spsd AS SubscrpnProdSpec
INNER JOIN mara AS Product ON /* join condition not captured in parsed metadata */
INNER JOIN t134 AS ProductType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN crms4c_som_prcat AS SubscriptionProductPurpose ON /* join condition not captured in parsed metadata */
;