I_SubordinateCntrlContrTP

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_SubordinateCntrlContrTP.
-- 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: ISUBORDCCTRTP

CREATE VIEW I_SubordinateCntrlContrTP AS
SELECT
  PurchasingParentDocument,
  SubordCntrlPurContract,
  ProcmtHubCompanyCodeGroupingID,
  PurchaseContractType,
  CompanyCode,
  PurchasingDocumentSubtype,
  PurchasingOrganization,
  ValidityStartDate,
  ValidityEndDate,
  PurchasingGroup,
  ' ' AS IsEndOfPurposeBlocked,
  CntrlPurContrDescription,
  SubordCntrlPurContrLastUpdtSts,
  _SubordCntrlContrUpdtStsTxt.SubordCntrlContrLastUpdtStsTxt AS SubordCntrlContrLastUpdtStsTxt,
  SubordCntrlContrLastUpdtDteTme,
  DistrResponseMessageUUID
FROM I_SubordinateCntrlContr
LEFT OUTER JOIN I_CentralPurchaseContractTP AS _ParentContractTP ON _ParentContractTP.CentralPurchaseContract = PurchasingParentDocument  -- association [1..1]
LEFT OUTER JOIN I_ProcmtHubCompanyCodeGroup AS _ProcmtHubCompanyCodeGroup ON _ProcmtHubCompanyCodeGroup.ProcmtHubCompanyCodeGroupingID = ProcmtHubCompanyCodeGroupingID  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON _PurchasingOrganization.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SubordCntrlContrUpdtStsTxt AS _SubordCntrlContrUpdtStsTxt ON _SubordCntrlContrUpdtStsTxt.SubordCntrlPurContrLastUpdtSts = SubordCntrlPurContrLastUpdtSts  -- association [0..1]
;