R_ProdSpecPrptyHdrWithUsage

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 R_ProdSpecPrptyHdrWithUsage.
-- 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: RPSPRPHWUSG

CREATE VIEW R_ProdSpecPrptyHdrWithUsage AS
SELECT
  cast(ProdSpecCmpstnHeader as /plmb/spc_prop_head_int_id preserving type ) AS ProdSpecPrptyHeader,
  cast(ProdSpecCmpstnHdrChangeState as /plmb/spc_prop_head_chg_state preserving type ) AS ProdSpecPrptyHdrChangeState,
  SpecValAssgmtUsageChangeState,
  SpecValAssgmtUsageInternalID,
  ProductSpecificationInternalID,
  cast(ProdSpecCmpstnHdrValAssgmtType as /plmb/spc_prop_head_name preserving type ) AS ProdSpecPrptyHdrValAssgmtType,
  SpecValAssgmtUsgeValdtyStrtDte,
  SpecValAssgmtUsgeValdtyEndDte,
  cast(ProdSpecCmpstnHdrRating as /plmb/spc_prpty_hdr_rating preserving type ) AS ProdSpecPrptyHdrRating,
  cast(ProdSpecCmpstnHdrValidityArea as /plmb/spc_prpty_hdr_val_area preserving type ) AS ProdSpecPrptyHdrValidityArea,
  SpecValAssgmtUsageIsActive,
  SpecValAssgmtUsageIsDeleted,
  SpecValAssgmtUsageIsRelevant,
  ProdSpecCmpstnHdrIsDeleted AS ProdSpecPrptyHdrIsDeleted,
  cast(ProdSpecCmpstnHdrChangeNumber as /plmb/spc_prpty_hdr_ch_number preserving type ) AS ProdSpecPrptyHdrChangeNumber,
  cast(ProdSpecCmpstnHdrSortSequence as /plmb/spc_prpty_sort_sequence preserving type ) AS ProdSpecPrptyHdrSortSequence,
  cast(ProdSpecCmpstnHdrValdtyStrtDte as /plmb/spc_prpty_hval_strt_dat preserving type ) AS ProdSpecPrptyHdrValdtyStrtDte,
  cast(ProdSpecCmpstnHdrValdtyEndDte as /plmb/spc_prpty_hval_end_dat preserving type ) AS ProdSpecPrptyHdrValdtyEndDte,
  SpecValAssgmtRefValueCode
FROM R_ProdSpecCmpstnHdrWithUsage
;