R_PPS_PurContrForCloseoutTP

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_PPS_PurContrForCloseoutTP.
-- 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_PPS_PurContrForCloseoutTP AS
SELECT
  PurchaseContract,
  PurchaseContract AS PPSRootPurchaseContract,
  cast( ActivePurchasingDocument as vdm_purchasecontract preserving type ) AS ActivePurchasingDocument,
  PurchaseContractType,
  PurchasingDocumentType,
  PurchasingDocumentCategory,
  Supplier,
  ValidityEndDate,
  PurchaseContractTargetAmount,
  DocumentCurrency,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  PurchasingProcessingStatus,
  _PurchasingProcessingStatus.PurchasingProcessingStatusName AS PurchasingProcessingStatusName,
  CreatedByUser,
  CreationDate,
  PurchasingDocumentName,
  IncotermsClassification,
  PPSPurgDocApprovalStatusText,
  PPSPurContractApprovalDate,
  PPSSmartNumberHeader,
  _PurchaseContractHdrExtension.PPSSmartDocumentNumber AS PPSSmartDocumentNumber,
  PPSRevisionComment,
  PPSPerdOfPerfStartDate,
  PPSPerdOfPerfEndDate,
  PPSPurgDocClassfctnCode,
  PurchasingDocVersionReasonText,
  PurchasingDocVersionReasonCode,
  PPSFiscalYear,
  PPSPurContrHeaderStatus,
  _CloseOutGrp .PPSPurgDocNumber AS PPSPurgDocNumber,
  _CloseOutGrp .PPSGroupUUID AS PPSGroupUUID,
  _PurchaseContractHdrExtension.PPSPurgDocHdrCloseoutStatus AS PPSPurgDocHdrCloseoutStatus,
  _CloseOutGrp.PPSGroupName AS PPSGroupName,
  _CloseOutGrp .PPSOrigin AS PPSOrigin,
  cast( _CloseOutGrp .ApplicationLogHandle as pps_e_closeout_log_handle preserving type ) AS ApplicationLogHandle,
  cast( _CloseOutGrp .ApplicationJobDescription as pps_e_closeout_log_id_desc preserving type ) AS ApplicationJobDescription,
  _CloseOutGrp.CreationDateTime AS CreationDateTime,
  _CloseOutGrp .PPSGroupStatusCode AS PPSGroupStatusCode,
  _ReleaseOrderStatus.PPSReleaseOrderCloseoutStatus AS PPSReleaseOrderCloseoutStatus,
  _IncotermsText.IncotermsClassificationName AS IncotermsClassificationName,
  _UserDetails.PersonFullName AS PersonFullName,
  _Supplier.SupplierName AS SupplierName
FROM R_PPS_PurContrForCloseout AS PURCHASECONTRACT
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Purchasecontracttype_Vh AS _PurContrTypeVH ON PurchasingDocumentType = _PurContrTypeVH.PurchasingDocumentType  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_PPS_GroupItemDetail AS _CloseOutGrp ON PurchaseContract = _CloseOutGrp.PPSPurgDocNumber  -- association [0..*]
LEFT OUTER JOIN I_PPSGroupStatusText AS _GroupStatusText ON ppsgroupstatuscode = _GroupStatusText.DomainValue  -- association [0..*]
LEFT OUTER JOIN I_PPSGroupItemStatusText AS _GroupItemStatusText ON PPSGroupItemStatusCode = _GroupItemStatusText.DomainValue AND _GroupItemStatusText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN balhdr AS _ApplicationLogHeader ON ApplicationLogHandle = _ApplicationLogHeader.log_handle  -- association [1..1]
LEFT OUTER JOIN R_PPS_PurContractHdrExtension AS _PurchaseContractHdrExtension ON PurchaseContract = _PurchaseContractHdrExtension.PurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_PPS_PurgDocHdrStatusText AS _PurContrHdrStatusText ON PPSPurContrHeaderStatus = _PurContrHdrStatusText.DomainValue AND _PurContrHdrStatusText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_PPS_ReleaseOrdCloseoutStatus AS _ReleaseOrderStatus ON PurchaseContract = _ReleaseOrderStatus.PurchaseContract AND PurchasingDocumentType = _ReleaseOrderStatus.PurchaseContractType  -- association [1..1]
LEFT OUTER JOIN I_PPSPurgDocHdrCloseoutStsTxt AS _PurgDocHdrCloseoutStsText ON PPSPurgDocHdrCloseoutStatus = _PurgDocHdrCloseoutStsText.DomainValue  -- association [0..*]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganizationVH ON _PurchasingOrganizationVH.PurchasingOrganization = PurchasingOrganization AND _PurchasingOrganizationVH.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PurgProcessingStatusText AS _PurchasingProcessingStatus ON PurchasingProcessingStatus = _PurchasingProcessingStatus.DomainValue AND _PurchasingProcessingStatus.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncotermsText ON IncotermsClassification = _IncotermsText.IncotermsClassification AND _IncotermsText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PPS_UserVH AS _UserDetails ON CreatedByUser = _UserDetails.UserID  -- association [1..1]
;