C_CntrlPurContrHierHdrTP

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 C_CntrlPurContrHierHdrTP.
-- 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: CPCHIERHDR

CREATE VIEW C_CntrlPurContrHierHdrTP AS
SELECT
  CentralPurchaseContract,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  DocumentCurrency,
  Currency,
  IncotermsClassification,
  IncotermsTransferLocation,
  PaymentTerms,
  _PaymentTermsText[1: Language = $session.system_language].PaymentTermsName AS PaymentTermsName,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PurchaseContractTargetAmount,
  ReleaseCode,
  CreatedByUser,
  UserDescription,
  IsCancelled,
  PurchasingDocumentDeletionCode,
  SupplierAddressID,
  SupplyingSupplier,
  InvoicingParty,
  ExchangeRateIsFixed,
  QuotationSubmissionDate,
  SupplierQuotation,
  ReleaseIsNotCompleted,
  CorrespncExternalReference,
  CorrespncInternalReference,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  PurchasingDocumentName,
  LastChangeDateTime,
  PurchasingProcessingStatus,
  cast(_CntrlPurContrAggrgnDistrSts.CntrlPurContrDistributionSts as me_distribution_status ) AS CntrlPurContrOvrlDistrStsTxt,
  _CntrlPurContrAggrgnDistrSts._CntrlPurContrDistrStatusText.ItemDistributionStatusName AS ItemDistributionStatusName,
  _CntrlPurContrAggrgnDistrSts._CntrlPurContrDistrStatusText.ItemDistributionStatusName AS PurchasingDocumentStatusName,
  CntrlPurContrStatusCriticality,
  CntrlPurContrValdtyStatusText,
  cast ( CntrlPurContrValidityStatus as mm_pur_cpc_validity_status ) AS CntrlPurContrValidityStatus,
  ValidityStartDate,
  ValidityEndDate,
  PurchasingDocumentTypeName,
  AccWorkflowApprover,
  AccWorkflowApproverFirstName,
  ApprovalStatusName,
  ApproverUser,
  CntrlPurContrFlxblDistrIsAllwd,
  cast( 0 as abap.dec( 18,3 )) AS ContractConsumptionInPct,
  IsEndOfPurposeBlocked,
  cast( '' as abap.char( 450 ) ) AS NoteTypeListText,
  cast( '' as boolean) AS TargetValueIsRelevantForVers,
  cast( '' as boolean) AS ValdtyEndDateIsRelevantForVers,
  cast( '0' as abap.int4(10)) AS NmbrOfSubordCntrlPurContracts,
  cast( '' as mm_pur_hub_matnr ) AS CntrlPurContrHierarchyMaterial,
  cast( '' as matkl ) AS CntrlPurContrHierMaterialGroup,
  _CntrlPurContrDistrStatusText.StatusCriticality AS StatusCriticality,
  _CntrlPurContrStatusText.DocumentStatusName AS DocumentStatusName,
  _CntrlPurContrStatusText.DocumentStatusName AS PurchasingDocumentStatus,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _IncotermsClassification.IncotermsClassificationName AS IncotermsClassificationName,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName
FROM I_CentralPurchaseContractTP AS CentralPurchaseContractTP
LEFT OUTER JOIN C_CntrlPurContrHierItemTP AS _CntrlPurchaseContractItemTP ON CentralPurchaseContract = _CntrlPurchaseContractItemTP.CentralPurchaseContract  -- association [1..*]
LEFT OUTER JOIN C_CntrlPurContrHierHdrDistrTP AS _CntrlPurContrHdrDistrTP ON _CntrlPurContrHdrDistrTP.CentralPurchaseContract = CentralPurchaseContract  -- association [0..*]
LEFT OUTER JOIN C_CntrlPurContrHierDistrOvwTP AS _DistributionOvw ON _DistributionOvw.CentralPurchaseContract = CentralPurchaseContract  -- association [0..*]
LEFT OUTER JOIN C_CntrlPurContrHierTypeVH AS _CntrlPurContrTypeValueHelp ON PurchaseContractType = _CntrlPurContrTypeValueHelp.PurchaseContractType  -- association [1..1]
LEFT OUTER JOIN C_SubordinateCntrlContrTP AS _SubordinateCntrlContrTP ON CentralPurchaseContract = _SubordinateCntrlContrTP.PurchasingParentDocument  -- association [0..*]
LEFT OUTER JOIN C_CPurConHierHdrCndnValdtyTP AS _CPurConHierHdrCndnValdtyTP ON CentralPurchaseContract = _CPurConHierHdrCndnValdtyTP.CentralPurchaseContract  -- association [1..*]
LEFT OUTER JOIN C_MM_SupplierValueHelp AS _SupplierValueHelp ON _SupplierValueHelp.Supplier = Supplier AND _SupplierValueHelp.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PurCtrIncoVersion AS _PurCtrIncoVersion ON IncotermsVersion = _PurCtrIncoVersion.IncotermsVersion  -- association [1..1]
LEFT OUTER JOIN C_MM_IncotermValueHelp AS _IncotermsClassification ON _IncotermsClassification.IncotermsClassification = IncotermsClassification AND _IncotermsClassification.IncotermsVersion = IncotermsVersion  -- association [0..1]
LEFT OUTER JOIN C_PurchasingGroupValueHelp AS _PurchasingGroupValueHelp ON _PurchasingGroupValueHelp.PurchasingGroup = PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN C_LegalTransactionIntegFacet AS _LegalTransaction ON _LegalTransaction.LglCntntMLinkdObj = CentralPurchaseContract AND _LegalTransaction.LglCntntMIntegrationLink = 'CPC'  -- association [0..*]
LEFT OUTER JOIN I_CntrlPurContrDocStsValHelp AS _CntrlPurContrDocStsValHelp ON _CntrlPurContrDocStsValHelp.PurchasingDocumentStatus = PurchasingDocumentStatus  -- association [0..1]
LEFT OUTER JOIN C_CntrlPurContrHierVersHistory AS _CntrlPurContrVersionHistory ON ActivePurchasingDocument = _CntrlPurContrVersionHistory.ActivePurchasingDocument  -- association [1..*]
LEFT OUTER JOIN C_PurgDocVersionReasonValHelp AS _VersionReasonVH ON PurchasingDocVersionReasonCode = _VersionReasonVH.PurchasingDocVersionReasonCode  -- association [0..1]
;