C_CentralPurchaseContractTP

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_CentralPurchaseContractTP.
-- 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: CCNTRLPCONTP

CREATE VIEW C_CentralPurchaseContractTP AS
SELECT
  CentralPurchaseContract,
  ActivePurchasingDocument,
  PurchasingDocumentVersion,
  PurgContractIsInPreparation,
  PurchaseContractType,
  PurchasingDocumentCategory,
  PurchasingDocumentSubtype,
  ProcmtHubCompanyCodeGroupingID,
  CreationDate,
  Supplier,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  DocumentCurrency,
  Currency,
  IncotermsClassification,
  IncotermsTransferLocation,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PurchaseContractTargetAmount,
  ReleaseCode,
  CreatedByUser,
  IsCancelled,
  PurchasingDocumentDeletionCode,
  SupplierAddressID,
  SupplyingSupplier,
  InvoicingParty,
  ExchangeRateIsFixed,
  PurgSingleCardinalityDistrType,
  _CePuCoLineItemDistrTxt.CePuCoLineItemDistrText AS CePuCoLineItemDistrText,
  QuotationSubmissionDate,
  SupplierQuotation,
  ReleaseIsNotCompleted,
  CorrespncExternalReference,
  CorrespncInternalReference,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  PurchasingDocumentName,
  LastChangeDateTime,
  PurchasingProcessingStatus,
  _CntrlPurContrStatusText.DocumentStatusName AS DocumentStatusName,
  _CntrlPurContrStatusText.DocumentStatusName AS PurchasingDocumentStatus,
  cast( '' as me_distribution_status ) AS CntrlPurContrOvrlDistrStsTxt,
  cast( '' as val_text ) AS ItemDistributionStatusName,
  cast( '' as val_text ) AS PurchasingDocumentStatusName,
  cast( 0 as int2 ) AS StatusCriticality,
  CntrlPurContrStatusCriticality,
  CntrlPurContrValdtyStatusText,
  CntrlPurContrValidityStatus,
  ValidityStartDate,
  ValidityEndDate,
  PurchasingDocumentTypeName,
  AccWorkflowApprover,
  AccWorkflowApproverFirstName,
  ApprovalStatusName,
  ApproverUser,
  CntrlPurContrFlxblDistrIsAllwd,
  ContrCnsmpnCheckOnChangeIsRqd,
  PurchasingParentDocument,
  cast ( '' as abap.char( 10 ) ) AS PurchasingTargetDocumentID,
  cast ( '' as abap.char( 40 ) ) AS CntrlPurContrDescription,
  IsEndOfPurposeBlocked,
  cast( '' as boolean) AS IsLglTransIntegEnabled,
  cast( '' as abap.char( 450 ) ) AS NoteTypeListText,
  cast( '' as boolean) AS VersionIsEnabled,
  cast( '' as boolean) AS TargetValueIsRelevantForVers,
  cast( '' as boolean) AS ValdtyEndDateIsRelevantForVers,
  PurgDocChangeRequestStatus,
  PurgDocIsChgVers,
  PurchasingDocVersionReasonCode,
  _DocumentCurrency._Text[1: Language = $session.system_language].CurrencyName AS CurrencyName,
  ChangeRequestNote,
  IsExtPurgScenario,
  _CreatedByUser.UserDescription AS UserDescription,
  cast( 0 as abap.dec( 18,3 )) AS ContractConsumptionInPct,
  cast( '' as mm_pur_hub_matnr ) AS PurchasingCentralMaterial,
  cast( '' as abap.char( 10 ) ) AS ExtContractForPurg,
  cast( '' as mm_pur_hub_matnr ) AS CntrlPurContrHierarchyMaterial,
  cast( '' as matkl ) AS MaterialGroup,
  cast( '' as matkl ) AS CntrlPurContrHierMaterialGroup,
  cast( '' as xfeld ) AS CePuCoSimulationIsInProcess,
  cast( '' as xfeld ) AS CePuCoSimlnResultIsAvailable,
  PurchasingItemHasHierarchy,
  cast ( '' as xfeld ) AS CntrlProcmtItmHierIsEnbld
FROM I_CentralPurchaseContractTP
LEFT OUTER JOIN C_CntrlPurContrHdrCndnValdty AS _CntrlPurContrHdrCndnValdtyTP ON CentralPurchaseContract = _CntrlPurContrHdrCndnValdtyTP.CentralPurchaseContract  -- association [1..*]
LEFT OUTER JOIN C_CntrlPurchaseContractItemTP AS _CntrlPurchaseContractItemTP ON CentralPurchaseContract = _CntrlPurchaseContractItemTP.CentralPurchaseContract  -- association [1..*]
LEFT OUTER JOIN C_CntrlPurContrItemHierarchyTP AS _CntrlPurContrItemHierarchyTP ON CentralPurchaseContract = _CntrlPurContrItemHierarchyTP.CentralPurchaseContract  -- association [1..*]
LEFT OUTER JOIN C_CntrlPurContrHdrDistrTP AS _CntrlPurContrHdrDistrTP ON _CntrlPurContrHdrDistrTP.CentralPurchaseContract = CentralPurchaseContract  -- association [0..*]
LEFT OUTER JOIN C_SupplierPurchOrgVH AS _SupplierValueHelp ON _SupplierValueHelp.Supplier = Supplier AND _SupplierValueHelp.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN C_CntrlPurContrSuplrValueHelp AS _SupplierText ON _SupplierText.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN C_DistrdContrForCntrlPurContr AS _DistrdContrForCntrlPurContr ON CentralPurchaseContract = _DistrdContrForCntrlPurContr.CentralPurchaseContract  -- association [1..*]
LEFT OUTER JOIN C_LegalTransactionIntegFacet AS _LegalTransaction ON _LegalTransaction.LglCntntMLinkdObj = CentralPurchaseContract AND _LegalTransaction.LglCntntMIntegrationLink = 'CPC'  -- association [0..*]
LEFT OUTER JOIN C_CntrlPurContrVersionHistory AS _CntrlPurContrVersionHistory ON ActivePurchasingDocument = _CntrlPurContrVersionHistory.ActivePurchasingDocument  -- association [1..*]
LEFT OUTER JOIN I_CustomerPaymentTermsText AS _CustomerPaymentTermsText ON _CustomerPaymentTermsText.CustomerPaymentTerms = PaymentTerms AND _CustomerPaymentTermsText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_CePuCoPurchasingGroupVH AS _CePuCoPurchasingGroupVH ON _CePuCoPurchasingGroupVH.PurchasingGroup = PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN C_CntrlPurContrCoCodeVH AS _CntrlPurContrCoCodeVH ON _CntrlPurContrCoCodeVH.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_CePuCoPurchasingOrgVH AS _CePuCoPurchasingOrgVH ON _CePuCoPurchasingOrgVH.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
;