C_CentralPurchaseOrderTP

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_CentralPurchaseOrderTP.
-- 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 C_CentralPurchaseOrderTP AS
SELECT
  PurchasingDocumentCategory,
  cast (PurchaseOrderTP.PurchasingOrganization as ekorg_ll preserving type ) AS PurchasingOrganization,
  cast( '' as abap.sstring( 260 ) ) AS Plant,
  cast( '' as abap.sstring( 260 ) ) AS ProcmtHubProduct,
  cast( '' as abap.sstring( 260 ) ) AS ProcmtHubProductGroup,
  cast( '' as purchaseorderoutputstatusname ) AS PurchaseOrderOutputStatusName,
  cast( '' as mmpur_cpo_output_indicatorname ) AS PurchaseOrderOutputIndDesc,
  cast ( _PurOrdStatusValueHelp.PurchasingDocumentStatusName as purchaseorderstatusname ) AS PurchaseOrderStatusName,
  cast( '' as abap.char( 02 ) ) AS ApprovalStatus,
  cast( '' as mm_approval_status ) AS ApprovalStatusName,
  cast( '' as abap_boolean ) AS PrmtHbRpldPOIsCntrlApprvlRlvt,
  cast( '' as abap.sstring( 450 ) ) AS PurgDocCompltnStsName,
  IsEndOfPurposeBlocked,
  cast( '' as abap.sstring( 450 ) ) AS NoteTypeListText,
  cast ('' as mmpur_d_ukms_enabled) AS PrmtHbIsUKMSEnabled,
  cast( '' as swd_wfd_id) AS WorkflowScenarioDefinition,
  PurchaseOrderTP.PurchaseOrder AS ProcurementHubPO,
  PurchaseOrderTP.ExtSourceSystem AS ExtSourceSystem,
  PurchaseOrderTP.Supplier AS Supplier,
  PurchaseOrderTP.CompanyCode AS CompanyCode,
  PurchaseOrderTP.CompanyCodeCountry AS CompanyCodeCountry,
  PurchaseOrderTP.PurchasingGroup AS PurchasingGroup,
  PurchaseOrderTP.DocumentCurrency AS DocumentCurrency,
  PurchaseOrderTP.PurchaseOrderType AS PurchaseOrderType,
  PurchaseOrderTP.NumberOfOverduePurOrdItm AS NumberOfOverduePurOrdItm,
  PurchaseOrderTP.PurchaseOrderNetAmount AS PurchaseOrderNetAmount_H,
  PurchaseOrderTP.PurchaseOrderNetAmount AS PurchaseOrderNetAmount,
  PurchaseOrderTP.WeightedRelevance AS WeightedRelevance,
  PurchaseOrderTP.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  PurchaseOrderTP.PurchaseOrderOutputDateTime AS PurchaseOrderOutputDateTime,
  PurchaseOrderTP.ApproverName AS ApproverName,
  PurchaseOrderTP.CreatedByUserFullName AS CreatedByUserFullName,
  PurchaseOrderTP.CreationDate AS CreationDate,
  PurchaseOrderTP.PurchaseOrderDate AS PurchaseOrderDate,
  PurchaseOrderTP.Language AS Language,
  PurchaseOrderTP.PurchaseOrderOutputStatus AS PurchaseOrderOutputStatus,
  PurchaseOrderTP.PurchaseOrderStatus AS PurchaseOrderStatus,
  PurchaseOrderTP.PurchasingProcessingStatus AS PurchasingProcessingStatus,
  PurchaseOrderTP.ApproverUser AS ApproverUser,
  PurchaseOrderTP.PurchasingCompletenessStatus AS PurchasingCompletenessStatus,
  PurchaseOrderTP.CashDiscount1Days AS CashDiscount1Days,
  PurchaseOrderTP.CashDiscount1Percent AS CashDiscount1Percent,
  PurchaseOrderTP.CashDiscount2Days AS CashDiscount2Days,
  PurchaseOrderTP.CashDiscount2Percent AS CashDiscount2Percent,
  PurchaseOrderTP.NetPaymentDays AS NetPaymentDays,
  PurchaseOrderTP.IncotermsVersion AS IncotermsVersion,
  PurchaseOrderTP.IncotermsClassification AS IncotermsClassification,
  PurchaseOrderTP.IncotermsLocation1 AS IncotermsLocation1,
  PurchaseOrderTP.IncotermsLocation2 AS IncotermsLocation2,
  PurchaseOrderTP.IncotermsTransferLocation AS IncotermsTransferLocation,
  PurchaseOrderTP.InvoicingParty AS InvoicingParty,
  PurchaseOrderTP.ExchangeRateForEdit AS ExchangeRateForEdit,
  PurchaseOrderTP.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  PurchaseOrderTP.IsIntrastatReportingRelevant AS IsIntrastatReportingRelevant,
  PurchaseOrderTP.IsIntrastatReportingExcluded AS IsIntrastatReportingExcluded,
  PurchaseOrderTP.HasNote AS HasNote,
  PurchaseOrderTP.HasAttachment AS HasAttachment,
  PurchaseOrderTP.ProcmtHubLastExtractionTime AS ProcmtHubLastExtractionTime,
  PurchaseOrderTP.PurchasingDocumentOrigin AS PurchasingDocumentOrigin,
  PurchaseOrderTP.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  PurchaseOrderTP.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  PurchaseOrderTP.ManualSupplierAddressID AS ManualSupplierAddressID,
  PurchaseOrderTP.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  PurchaseOrderTP.SupplierPhoneNumber AS SupplierPhoneNumber,
  PurchaseOrderTP.SupplyingSupplier AS SupplyingSupplier,
  PurchaseOrderTP.SupplyingPlant AS SupplyingPlant,
  PurchaseOrderTP.DeliveryDocumentCondition AS DeliveryDocumentCondition,
  PurchaseOrderTP.PricingProcedure AS PricingProcedure,
  PurchaseOrderTP.ValidityStartDate AS ValidityStartDate,
  PurchaseOrderTP.ValidityEndDate AS ValidityEndDate,
  _BusinessSystem.ProcurementHubSourceSystemName AS ProcurementHubSourceSystemName,
  _CompanyCodeValueHelp.ProcmtHubCompanyCodeName AS ProcmtHubCompanyCodeName,
  _CompanyCodeValueHelp.ProcmtHubCompanyCode AS ProcmtHubCompanyCode,
  _DocumentType.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  _ProcmtHubIncotermsClsfctnVH.IncotermsClassificationName AS IncotermsClassificationName,
  _ProcmtHubSupplierVH.ProcmtHubSupplierName AS ProcmtHubSupplierName,
  _ProcurementHubPaymentTermsVH.PaymentTermsName AS PaymentTermsName,
  _PurchaseOrderOutputInd.PurchaseOrderOutputIndCode AS PurchaseOrderOutputIndCode,
  _PurchasingGrpValueHelp.PurchasingGroupName AS PurchasingGroupName,
  _PurgOrgValueHelp.ProcmtHubPurgOrgName AS ProcmtHubPurgOrgName,
  _PurOrdStatusValueHelp.PurchasingDocumentStatus AS PurchasingDocumentStatus
FROM I_CentralPurchaseOrderTP AS PurchaseOrderTP
LEFT OUTER JOIN C_CentralPurchaseOrderItemTP AS _PurchaseOrderItemTP ON _PurchaseOrderItemTP.ProcurementHubPO = ProcurementHubPO AND _PurchaseOrderItemTP.ExtSourceSystem = ExtSourceSystem  -- association [1..*]
LEFT OUTER JOIN C_ProcmtHubCompanyCodeVH AS _CompanyCodeValueHelp ON _CompanyCodeValueHelp.ProcmtHubCompanyCode = CompanyCode AND _CompanyCodeValueHelp.ProcurementHubSourceSystem = ExtSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubBackendSrceSystemVH AS _BusinessSystem ON _BusinessSystem.ProcurementHubSourceSystem = ExtSourceSystem  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubPurgOrgVH AS _PurgOrgValueHelp ON _PurgOrgValueHelp.ProcmtHubPurchasingOrg = PurchasingOrganization AND _PurgOrgValueHelp.ProcurementHubSourceSystem = ExtSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubPurgGroupVH AS _PurchasingGrpValueHelp ON _PurchasingGrpValueHelp.ProcmtHubPurchasingGroup = PurchasingGroup AND _PurchasingGrpValueHelp.ProcurementHubSourceSystem = ExtSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubSupplierVH AS _ProcmtHubSupplierVH ON _ProcmtHubSupplierVH.ProcmtHubFixedSupplier = Supplier AND _ProcmtHubSupplierVH.ProcurementHubSourceSystem = ExtSourceSystem AND _ProcmtHubSupplierVH.ProcmtHubPurchasingOrg = PurchasingOrganization AND _ProcmtHubSupplierVH.ProcmtHubCompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubPurOrdProcgStsVH AS _ProcmtHubPurOrdProcgStsVH ON _ProcmtHubPurOrdProcgStsVH.DomainValue = PurchasingProcessingStatus AND _ProcmtHubPurOrdProcgStsVH.ProcurementHubSourceSystem = ExtSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubPurOrdDocTypeVH AS _DocumentType ON _DocumentType.ExtSourceSystem = ExtSourceSystem AND _DocumentType.PurchasingDocumentType = PurchaseOrderType  -- association [1..1]
LEFT OUTER JOIN C_ProcurementHubPaymentTermsVH AS _ProcurementHubPaymentTermsVH ON _ProcurementHubPaymentTermsVH.PaymentTerms = PaymentTerms AND _ProcurementHubPaymentTermsVH.ProcurementHubSourceSystem = ExtSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubIncotermsClsfctnVH AS _ProcmtHubIncotermsClsfctnVH ON _ProcmtHubIncotermsClsfctnVH.IncotermsClassification = IncotermsClassification AND _ProcmtHubIncotermsClsfctnVH.ProcurementHubSourceSystem = ExtSourceSystem  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderStatusValueHelp AS _PurOrdStatusValueHelp ON _PurOrdStatusValueHelp.PurchasingDocumentStatus = PurchaseOrderStatus  -- association [0..1]
LEFT OUTER JOIN E_PrmtHbRpldPurchaseOrder AS _PrmtHbRpldPurchaseOrder ON _PrmtHbRpldPurchaseOrder.PurchaseOrder = ProcurementHubPO AND _PrmtHbRpldPurchaseOrder.ExtSourceSystem = ExtSourceSystem  -- association [1..1]
LEFT OUTER JOIN C_PrmtHbRpldPurOrdPlantVH AS _PrmtHbRpldPurOrdPlantVH ON _PrmtHbRpldPurOrdPlantVH.ProcmtHubPlant = Plant AND _PrmtHbRpldPurOrdPlantVH.ProcmtHubCompanyCode = CompanyCode AND _PrmtHbRpldPurOrdPlantVH.ProcurementHubSourceSystem = ExtSourceSystem  -- association [0..1]
LEFT OUTER JOIN P_PrmtHbRpldPOOutputStatusInd AS _PurchaseOrderOutputInd ON _PurchaseOrderOutputInd.PurchaseOrder = ProcurementHubPO AND _PurchaseOrderOutputInd.ExtSourceSystem = ExtSourceSystem  -- association [0..1]
LEFT OUTER JOIN I_PrmtHbRpldPOOutputStsIndVH AS _PurchaseOrderOutputIndVH ON _PurchaseOrderOutputIndVH.PurchaseOrderOutputIndCode = PurchaseOrderOutputIndCode  -- association [0..1]
;