R_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 R_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 R_CndnContrType AS
SELECT
  contract_type AS CndnContrType,
  bo_type AS SAPObjectType,
  type_block AS CndnContrTypeBlockUsage,
  owner_type AS CndnContrPartnerCat,
  eligible_type AS CndnContrEligibleCat,
  category AS CndnContrClassfctnType,
  no_condition AS CndnContrHasNoConditions,
  cast( rebate_type as wb2_rebate_type_fio preserving type ) AS CndnContrSettlmtType,
  ui_change AS CndnContrChangeability,
  busvolbase_type AS BusVolFldCombnSet,
  settl_part_type AS CndnContrPrtlSettlmtCat,
  contract_items AS CndnContrItemCategory,
  accr_rev_type AS CndnContrAccrRvslCat,
  visibility_group AS ApplElmntBehaviorGrp,
  cast( man_settl_docs as wb2_mnl_settlmt_allowance preserving type ) AS CnConMnlSettlmtAllwncCat
FROM twcbcontrtype
LEFT OUTER JOIN R_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 R_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]
LEFT OUTER JOIN I_CndnContrElmntBehaviorGrp AS _ApplElmntBehaviorGrp ON ApplElmntBehaviorGrp = _ApplElmntBehaviorGrp.ApplElmntBehaviorGrp  -- association [0..1]
LEFT OUTER JOIN I_CnConMnlSettlmtAllwncCat AS _CnConMnlSettlmtAllwncCat ON CnConMnlSettlmtAllwncCat = _CnConMnlSettlmtAllwncCat.CnConMnlSettlmtAllwncCat  -- association [0..1]
;