I_CndnContrType

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_CndnContrType.
-- 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.

CREATE VIEW I_CndnContrType AS
SELECT
  CndnContrType,
  CndnContrTypeBlockUsage,
  CndnContrPartnerCat,
  CndnContrEligibleCat,
  CndnContrClassfctnType,
  CndnContrHasNoConditions,
  CndnContrSettlmtType,
  CndnContrChangeability,
  BusVolFldCombnSet,
  CndnContrPrtlSettlmtCat,
  CndnContrItemCategory,
  CndnContrAccrRvslCat
FROM R_CndnContrType
LEFT OUTER JOIN I_CndnContrTypeText AS _Text ON CndnContrType = _Text.CndnContrType  -- association [0..*]
LEFT OUTER JOIN I_CndnContrTypeBlockUsage AS _CndnContrTypeBlockUsage ON CndnContrTypeBlockUsage = _CndnContrTypeBlockUsage.CndnContrTypeBlockUsage  -- association [0..1]
LEFT OUTER JOIN I_CndnContrPartnerCat AS _CndnContrPartnerCat ON CndnContrPartnerCat = _CndnContrPartnerCat.CndnContrPartnerCat  -- association [0..1]
LEFT OUTER JOIN I_CndnContrChangeability AS _CndnContrChangeability ON CndnContrChangeability = _CndnContrChangeability.CndnContrChangeability  -- association [0..1]
LEFT OUTER JOIN I_BusVolFldCombnSet AS _BusVolFldCombnSet ON BusVolFldCombnSet = _BusVolFldCombnSet.BusVolFldCombnSet  -- association [0..1]
LEFT OUTER JOIN I_CndnContrClassfctnType AS _CndnContrClassfctnType ON CndnContrClassfctnType = _CndnContrClassfctnType.CndnContrClassfctnType  -- association [0..1]
LEFT OUTER JOIN I_CndnContrItemCategory AS _CndnContrItemCategory ON CndnContrItemCategory = _CndnContrItemCategory.CndnContrItemCategory  -- association [0..1]
LEFT OUTER JOIN I_CndnContrEligibleCat AS _CndnContrEligibleCat ON CndnContrEligibleCat = _CndnContrEligibleCat.CndnContrEligibleCat  -- association [0..1]
LEFT OUTER JOIN I_CndnContrSettlmtType AS _CndnContrSettlmtType ON CndnContrSettlmtType = _CndnContrSettlmtType.CndnContrSettlmtType  -- association [0..1]
LEFT OUTER JOIN I_CndnContrPrtlSettlmtCat AS _CndnContrPrtlSettlmtCat ON CndnContrPrtlSettlmtCat = _CndnContrPrtlSettlmtCat.CndnContrPrtlSettlmtCat  -- association [0..1]
LEFT OUTER JOIN I_CndnContrAccrRvslCat AS _CndnContrAccrRvslCat ON CndnContrAccrRvslCat = _CndnContrAccrRvslCat.CndnContrAccrRvslCat  -- association [0..1]
;