C_PurchaseOrderTP

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_PurchaseOrderTP.
-- 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_PurchaseOrderTP AS
SELECT
  PurchaseOrderTP.PurchaseOrder AS PurchaseOrder,
  PurchaseOrderTP.PurchaseOrderType AS PurchaseOrderType,
  PurchaseOrderTP.PurchaseOrderTypeName AS PurchaseOrderTypeName,
  PurchaseOrderTP.PurchaseOrderType AS PurchasingDocumentType,
  PurchaseOrderTP.CompanyCode AS CompanyCode,
  cast (PurchaseOrderTP.PurchasingOrganization as ekorg_ll preserving type ) AS PurchasingOrganization,
  PurchaseOrderTP.PurchasingGroup AS PurchasingGroup,
  PurchaseOrderTP.Supplier AS Supplier,
  PurchaseOrderTP.DocumentCurrency AS DocumentCurrency,
  PurchaseOrderTP._DocumentCurrency._Text[1:Language = $session.system_language].CurrencyName AS DocumentCurrencyName,
  _OverduePurchaseOrder.NumberOfOverduePurOrdItm AS NumberOfOverduePurOrdItm_H,
  cast( 0 as abap.int4 ) AS NumberOfOverduePurOrdItm,
  cast ( '' as abap.char(2)) AS PurchaseOrderStatus,
  cast ( '' as mmpur_ord_status ) AS PurchaseOrderStatusName,
  _PurchaseOrderStatus.PurchasingDocumentStatus AS PurchaseOrderStatus_H,
  _PurchaseOrderStatus.PurchasingDocumentStatus AS PurchasingDocumentStatus,
  PurchaseOrderTP.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  PurchaseOrderTP.PurchasingProcessingStatus AS PurchasingProcessingStatus,
  _PurOrdProcessingStatusTxt.PurchasingProcessingStatusName AS PurchasingProcessingStatusName,
  PurchaseOrderTP.PurchasingCompletenessStatus AS PurchasingCompletenessStatus,
  cast( 0 as mm_pur_order_tot_net_amount ) AS PurchaseOrderNetAmount,
  cast( 0 as vdm_weightedrelevance ) AS WeightedRelevance,
  _OverduePurchaseOrder.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  cast( '' as abap.sstring( 260 ) ) AS ManufacturerMaterial,
  cast( '' as abap.sstring( 260 ) ) AS Plant,
  cast ('' as abap.char( 1 ) ) AS PurOrdOutputCtrlType,
  cast ('' as abap.char( 1 ) ) AS PurchaseOrderOutputStatus,
  cast ('' as abap.char( 60 ) ) AS PurchaseOrderOutputStatusName,
  cast ('00000000000000' as timestamp) AS PurchaseOrderOutputDateTime,
  cast( '' as abap.char( 02 ) ) AS ApprovalStatus,
  cast( '' as mm_approval_status ) AS ApprovalStatusName,
  cast( '' as mm_approver_name ) AS ApproverName,
  cast( 0 as mmpur_approver_count ) AS PurchaseOrderNumberOfApprovers,
  cast( '' as mm_approver_comment ) AS POApproverCommentText,
  PurchaseOrderTP.POReworkCommentText AS POReworkCommentText,
  _PurchaseOrderType.PurgHasFlxblWorkflowApproval AS PurgHasFlxblWorkflowApproval,
  PurchaseOrderTP.CreatedByUserFullName AS CreatedByUserFullName,
  PurchaseOrderTP.CreationDate AS CreationDate,
  PurchaseOrderTP.PurchaseOrderDate AS PurchaseOrderDate,
  PurchaseOrderTP.Language AS Language,
  PurchaseOrderTP._Language._Text[1:Language = $session.system_language].LanguageName AS LanguageName,
  PurchaseOrderTP.CashDiscount1Days AS CashDiscount1Days,
  cast (PurchaseOrderTP.CashDiscount1Percent as dzbd1p_ll preserving type) AS CashDiscount1Percent,
  PurchaseOrderTP.CashDiscount2Days AS CashDiscount2Days,
  cast(PurchaseOrderTP.CashDiscount2Percent as dzbd2p_ll preserving type) AS CashDiscount2Percent,
  PurchaseOrderTP.NetPaymentDays AS NetPaymentDays,
  PurchaseOrderTP.IncotermsVersion AS IncotermsVersion,
  PurchaseOrderTP._IncotermsVersion._Text[1:Language = $session.system_language].IncotermsVersionName AS IncotermsVersionName,
  PurchaseOrderTP.IncotermsClassification AS IncotermsClassification,
  PurchaseOrderTP._IncotermsClassification._Text[1:Language = $session.system_language].IncotermsClassificationName AS IncotermsClassificationName,
  PurchaseOrderTP.IncotermsLocation1Identifier AS IncotermsLocation1Identifier,
  PurchaseOrderTP.IncotermsSupChnLoc1AddlUUID AS IncotermsSupChnLoc1AddlUUID,
  PurchaseOrderTP.IncotermsLocation1 AS IncotermsLocation1,
  PurchaseOrderTP.IncotermsDvtgLocIdentifier AS IncotermsDvtgLocIdentifier,
  PurchaseOrderTP.IncotermsSupChnDvtgLocAddlUUID AS IncotermsSupChnDvtgLocAddlUUID,
  PurchaseOrderTP.IncotermsDvtgLocDescription AS IncotermsDvtgLocDescription,
  PurchaseOrderTP.IncotermsLocation2Identifier AS IncotermsLocation2Identifier,
  PurchaseOrderTP.IncotermsSupChnLoc2AddlUUID AS IncotermsSupChnLoc2AddlUUID,
  PurchaseOrderTP.IncotermsLocation2 AS IncotermsLocation2,
  PurchaseOrderTP.InvoicingParty AS InvoicingParty,
  _Supplier.SupplierName AS InvoicingPartyName,
  PurchaseOrderTP.ExchangeRateForEdit AS ExchangeRateForEdit,
  PurchaseOrderTP.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  PurchaseOrderTP.IsIntrastatReportingRelevant AS IsIntrastatReportingRelevant,
  PurchaseOrderTP.IsIntrastatReportingExcluded AS IsIntrastatReportingExcluded,
  IsEndOfPurposeBlocked,
  PurchaseOrderTP.PurchaseOrderHasCommitmentItem AS PurchaseOrderHasCommitmentItem,
  MsgOnGoodsReceiptIsRequested,
  PurchaseOrderTP.SupplierPhoneNumber AS SupplierPhoneNumber,
  PurchaseOrderTP.CorrespncExternalReference AS CorrespncExternalReference,
  PurchaseOrderTP.CorrespncInternalReference AS CorrespncInternalReference,
  PurgAggrgdProdCmplncSuplrSts,
  _POProdComplianceCriticality.UICT_PurgAggrgdCmplncSuplrSts AS UICT_PurgAggrgdCmplncSuplrSts,
  _PurgTotProdMarketabilityStsT.PurgTotMarketabilityStsName AS PurgTotMarketabilityStsName,
  PurgAggrgdProdMarketabilitySts,
  _POProdComplianceCriticality.UICT_PurgAggrgMarketabilitySts AS UICT_PurgAggrgMarketabilitySts,
  _PurgAggrgdSftyDataSheetStsT.PurgAggrgdSftyDataSheetStsName AS PurgAggrgdSftyDataSheetStsName,
  PurgAggrgdSftyDataSheetStatus,
  _POProdComplianceCriticality.UICT_PurgAggrgSftyDataSheetSts AS UICT_PurgAggrgSftyDataSheetSts,
  _PurgTotDangerousGoodsStsT.PurgTotDangerousGoodsStsName AS PurgTotDangerousGoodsStsName,
  PurgProdCmplncTotDngrsGoodsSts,
  _POProdComplianceCriticality.UICT_PurgCmplncTotDngrsGdsSts AS UICT_PurgCmplncTotDngrsGdsSts,
  cast ('' as ehfnd_boolean) AS ProductComplianceIsActive,
  cast ('' as ehfnd_bf_pcs_is_active) AS BusFtreProdCmplncSuplrIsActive,
  cast ('' as ehfnd_bf_pma_is_active) AS BusFtreProdMarketabilityIsActv,
  cast ('' as ehfnd_bf_dg_is_active) AS BusFtreDngrsGoodsIsActive,
  cast ('' as ehfnd_bf_sds_is_active) AS BusFtreSftyDataShtMgmtIsActive,
  PurchaseOrderTP.PurchasingDocumentOrigin AS PurchasingDocumentOrigin,
  PurchaseOrderTP.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  PurchaseOrderTP.ManualSupplierAddressID AS ManualSupplierAddressID,
  PurchaseOrderTP.SupplierAddressID AS SupplierAddressID,
  PurchaseOrderTP.SupplyingSupplier AS SupplyingSupplier,
  PurchaseOrderTP.SupplyingPlant AS SupplyingPlant,
  PurchaseOrderTP.PurchasingDocumentCondition AS PurchasingDocumentCondition,
  PurchaseOrderTP.PricingProcedure AS PricingProcedure,
  PurchaseOrderTP.ValidityStartDate AS ValidityStartDate,
  PurchaseOrderTP.ValidityEndDate AS ValidityEndDate,
  PurchaseOrderTP.IncotermsTransferLocation AS IncotermsTransferLocation,
  PurchaseOrderTP.PurchasingHasItemHierarchy AS PurchasingHasItemHierarchy,
  cast ('' as boolean) AS SrvcProcmtItmHierIsEnbld,
  cast ('' as boolean) AS PurchaseOrderPrtnFuncIsEnbld,
  cast ('' as boolean) AS PurOrderOutputPreviewIsEnabled,
  PurchaseOrderTP._DocumentCurrency AS _DocumentCurrency,
  PurchaseOrderTP._IncotermsClassification AS _IncotermsClassification,
  PurchaseOrderTP._IncotermsVersion AS _IncotermsVersion,
  PurchaseOrderTP._Language AS _Language,
  PurchaseOrderTP._PurchaseOrderType AS _PurchaseOrderType,
  _Supplier.SupplierName AS SupplierName
FROM I_PurchaseOrderTP AS PurchaseOrderTP
LEFT OUTER JOIN C_PurchaseOrderItemTP AS _PurchaseOrderItemTP ON _PurchaseOrderItemTP.PurchaseOrder = PurchaseOrder  -- association [1..*]
LEFT OUTER JOIN C_PurchaseOrderItemHierarchyTP AS _PurchaseOrderItemHierarchyTP ON _PurchaseOrderItemHierarchyTP.PurchaseOrder = PurchaseOrder  -- association [1..*]
LEFT OUTER JOIN C_PurOrdSupplierAddressTP AS _PurOrdSupplierAddressTP ON _PurOrdSupplierAddressTP.PurchaseOrder = PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN C_PurOrdRefDocPO AS _PurOrdRefDocPO ON _PurOrdRefDocPO.Supplier = Supplier  -- association [0..*]
LEFT OUTER JOIN C_PurOrdRefDocIR AS _PurOrdRefDocIR ON _PurOrdRefDocIR.Supplier = Supplier  -- association [0..*]
LEFT OUTER JOIN C_PurOrdRefDocPC AS _PurOrdRefDocPC ON _PurOrdRefDocPC.Supplier = Supplier  -- association [0..*]
LEFT OUTER JOIN I_UserContactCard AS _UserContactCard ON _UserContactCard.ContactCardType = 'User' AND _UserContactCard.ContactCardID = CreatedByUser AND _UserContactCard.ContactCardRole = 'Creator'  -- association [0..1]
LEFT OUTER JOIN C_OverduePurchaseOrder AS _OverduePurchaseOrder ON PurchaseOrder = _OverduePurchaseOrder.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderRelevance AS _PurchaseOrderRelevance ON PurchaseOrder = _PurchaseOrderRelevance.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderStatus AS _PurchaseOrderStatus ON PurchaseOrder = _PurchaseOrderStatus.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentStatus AS _PurchasingDocumentStatus ON PurchaseOrderStatus_H = _PurchasingDocumentStatus.PurchasingDocumentStatus  -- association [0..1]
LEFT OUTER JOIN C_PurchaseOrderFeature AS _PurchaseOrderFeature ON PurchaseOrder = _PurchaseOrderFeature.PurchaseOrder  -- association [1..*]
LEFT OUTER JOIN C_PurchaseOrderCommitment AS _PurchaseOrderCommitment ON PurchaseOrder = _PurchaseOrderCommitment.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN I_PaymentTerms AS _PaymentTerms ON _PaymentTerms.PaymentTerms = PaymentTerms  -- association [0..1]
LEFT OUTER JOIN C_PurchaseOrderNoteTP AS _PurchaseOrderNote ON _PurchaseOrderNote.PurchaseOrder = PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN C_PurchaseOrderPartnerTP AS _PurchaseOrderPartnerTP ON _PurchaseOrderPartnerTP.PurchaseOrder = PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN C_MM_CompanyCodeValueHelp AS _CompanyCodeValueHelp ON _CompanyCodeValueHelp.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_SupplierPurchOrgVH AS _SupplierValueHelp ON _SupplierValueHelp.Supplier = Supplier AND _SupplierValueHelp.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN C_PurchasingOrgValueHelp AS _PurgOrgValueHelp ON _PurgOrgValueHelp.PurchasingOrganization = PurchasingOrganization AND _PurgOrgValueHelp.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_PurchasingGroupValueHelp AS _PurchasingGrpValueHelp ON _PurchasingGrpValueHelp.PurchasingGroup = PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN C_PurOrdCreatedByValHelp AS _CreatedByValueHelp ON _CreatedByValueHelp.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN I_PurgTotProdCmplncSuplrStsT AS _PurgTotProdCmplncSuplrStsT ON PurgAggrgdProdCmplncSuplrSts = _PurgTotProdCmplncSuplrStsT.PurgAggrgdProdCmplncSuplrSts AND _PurgTotProdCmplncSuplrStsT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PurgTotProdMarketabilityStsT AS _PurgTotProdMarketabilityStsT ON PurgAggrgdProdMarketabilitySts = _PurgTotProdMarketabilityStsT.PurgAggrgdProdMarketabilitySts AND _PurgTotProdMarketabilityStsT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PurgAggrgdSftyDataSheetStsT AS _PurgAggrgdSftyDataSheetStsT ON PurgAggrgdSftyDataSheetStatus = _PurgAggrgdSftyDataSheetStsT.PurgAggrgdSftyDataSheetStatus AND _PurgAggrgdSftyDataSheetStsT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PurgTotDangerousGoodsStsT AS _PurgTotDangerousGoodsStsT ON PurgProdCmplncTotDngrsGoodsSts = _PurgTotDangerousGoodsStsT.PurgProdCmplncTotDngrsGoodsSts AND _PurgTotDangerousGoodsStsT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_POProdComplianceCriticality AS _POProdComplianceCriticality ON PurchaseOrder = _POProdComplianceCriticality.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN C_PurchaseOrderApprover AS _POApprover ON PurchaseOrder = _POApprover.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN I_PurgProcessingStatusText AS _PurOrdProcessingStatusTxt ON _PurOrdProcessingStatusTxt.PurchasingProcessingStatus = PurchasingProcessingStatus AND _PurOrdProcessingStatusTxt.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN C_PurchaseOrderStatus AS _POStatus ON PurchaseOrder = _POStatus.PurchaseOrder  -- association [1..1]
;