R_PPS_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 R_PPS_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 R_PPS_PurchaseOrderTP AS
SELECT
  cast ( hextobin( '00000000000000000000000000000000' ) as sysuuid_x16 ) AS PurchaseOrderUUID,
  cast(_PurchaseOrderNetAmount.PurchaseOrderNetAmount as mm_pur_order_tot_net_amount) AS PurchaseOrderNetAmount,
  _PaymentTerms._Text[ 1: Language = $session.system_language ].PaymentTermsName AS PaymentTermsName,
  cast( PurchaseOrder.ExchangeRate as fis_exchange_rate preserving type ) AS ExchangeRate,
  cast( '' as tminco_loc_1_id ) AS IncotermsLocation1Identifier,
  cast( '' as tminco_loc_2_id ) AS IncotermsLocation2Identifier,
  cast( '' as tminco_loc_d_id ) AS IncotermsDvtgLocIdentifier,
  cast( '' as tminco_loc_d_descr ) AS IncotermsDvtgLocDescription,
  cast(PurchaseOrder.ExchangeRate as abap.char( 12 )) AS ExchangeRateForEdit,
  IsEndOfPurposeBlocked,
  cast ('' as boolean) AS PPSPurOrdIsInPrep,
  cast ( '' as podraftisreverted ) AS PODraftIsReverted,
  cast ( '' as purchaseorderhascommitmentitem ) AS PurchaseOrderHasCommitmentItem,
  cast ( '' as mm_rework_comment ) AS POReworkCommentText,
  cast ( '' as purchaseorderapprovalstatus ) AS ApprovalStatus,
  cast ( '' as mm_approval_status ) AS ApprovalStatusName,
  cast ( hextobin( PPSFieldChangeIndicatorString ) as pps_e_control_flag preserving type ) AS PPSFieldChangeIndicatorBinary,
  PPSFieldChangeIndicatorString,
  PurchaseOrder.PurchaseOrder AS PurchaseOrder,
  PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  PurchaseOrder.PurchaseOrderSubtype AS PurchaseOrderSubtype,
  PurchaseOrder.PurchasingDocumentOrigin AS PurchasingDocumentOrigin,
  PurchaseOrder.CreatedByUser AS CreatedByUser,
  PurchaseOrder.CreationDate AS CreationDate,
  PurchaseOrder.PurchaseOrderDate AS PurchaseOrderDate,
  PurchaseOrder.LastChangeDateTime AS LastChangeDateTime,
  PurchaseOrder.ValidityStartDate AS ValidityStartDate,
  PurchaseOrder.ValidityEndDate AS ValidityEndDate,
  PurchaseOrder.Language AS Language,
  PurchaseOrder.PurchaseOrderDeletionCode AS PurchaseOrderDeletionCode,
  PurchaseOrder.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  PurchaseOrder.PurchasingCompletenessStatus AS PurchasingCompletenessStatus,
  PurchaseOrder.PurchasingProcessingStatus AS PurchasingProcessingStatus,
  PurchaseOrder.PurgReleaseSequenceStatus AS PurgReleaseSequenceStatus,
  PurchaseOrder.ReleaseCode AS ReleaseCode,
  PurchaseOrder.PurchasingReleaseStrategy AS PurchasingReleaseStrategy,
  PurchaseOrder.PurgReasonForDocCancellation AS PurgReasonForDocCancellation,
  PurchaseOrder.ActivePurchasingDocument AS ActivePurchasingDocument,
  PurchaseOrder.PurgDocChangeRequestStatus AS PurgDocChangeRequestStatus,
  PurchaseOrder.PurchasingDocumentVersion AS PurchasingDocumentVersion,
  PurchaseOrder.CompanyCode AS CompanyCode,
  PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  PurchaseOrder.Supplier AS Supplier,
  PurchaseOrder.ManualSupplierAddressID AS ManualSupplierAddressID,
  PurchaseOrder.SupplierAddressID AS SupplierAddressID,
  PurchaseOrder.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  PurchaseOrder.SupplierPhoneNumber AS SupplierPhoneNumber,
  PurchaseOrder.SupplyingSupplier AS SupplyingSupplier,
  PurchaseOrder.SupplyingPlant AS SupplyingPlant,
  PurchaseOrder.InvoicingParty AS InvoicingParty,
  PurchaseOrder.Customer AS Customer,
  PurchaseOrder.PurchaseContract AS PurchaseContract,
  PurchaseOrder.SupplierQuotationExternalID AS SupplierQuotationExternalID,
  PurchaseOrder.QuotationSubmissionDate AS QuotationSubmissionDate,
  PurchaseOrder.ItemNumberIntervalForSubItems AS ItemNumberIntervalForSubItems,
  PurchaseOrder.PaymentTerms AS PaymentTerms,
  PurchaseOrder.CashDiscount1Days AS CashDiscount1Days,
  PurchaseOrder.CashDiscount2Days AS CashDiscount2Days,
  PurchaseOrder.NetPaymentDays AS NetPaymentDays,
  PurchaseOrder.CashDiscount1Percent AS CashDiscount1Percent,
  PurchaseOrder.CashDiscount2Percent AS CashDiscount2Percent,
  PurchaseOrder.DownPaymentType AS DownPaymentType,
  PurchaseOrder.DownPaymentPercentageOfTotAmt AS DownPaymentPercentageOfTotAmt,
  PurchaseOrder.DownPaymentAmount AS DownPaymentAmount,
  PurchaseOrder.DownPaymentDueDate AS DownPaymentDueDate,
  PurchaseOrder.IncotermsClassification AS IncotermsClassification,
  PurchaseOrder.IncotermsTransferLocation AS IncotermsTransferLocation,
  PurchaseOrder.IncotermsVersion AS IncotermsVersion,
  PurchaseOrder.IncotermsLocation1 AS IncotermsLocation1,
  PurchaseOrder.IncotermsLocation2 AS IncotermsLocation2,
  PurchaseOrder.IsIntrastatReportingRelevant AS IsIntrastatReportingRelevant,
  PurchaseOrder.IsIntrastatReportingExcluded AS IsIntrastatReportingExcluded,
  PurchaseOrder.CorrespncExternalReference AS CorrespncExternalReference,
  PurchaseOrder.CorrespncInternalReference AS CorrespncInternalReference,
  PurchaseOrder.PricingDocument AS PricingDocument,
  PurchaseOrder.PricingProcedure AS PricingProcedure,
  PurchaseOrder.DocumentCurrency AS DocumentCurrency,
  PurchaseOrder.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  PurchaseOrder.PurgReleaseTimeTotalAmount AS PurgReleaseTimeTotalAmount,
  PurchaseOrder.TaxReturnCountry AS TaxReturnCountry,
  PurchaseOrder.VATRegistrationCountry AS VATRegistrationCountry,
  PurchaseOrder.PurgAggrgdProdCmplncSuplrSts AS PurgAggrgdProdCmplncSuplrSts,
  PurchaseOrder.PurgAggrgdProdMarketabilitySts AS PurgAggrgdProdMarketabilitySts,
  PurchaseOrder.PurgAggrgdSftyDataSheetStatus AS PurgAggrgdSftyDataSheetStatus,
  PurchaseOrder.PurgProdCmplncTotDngrsGoodsSts AS PurgProdCmplncTotDngrsGoodsSts,
  PurchaseOrder.IncotermsSupChnLoc1AddlUUID AS IncotermsSupChnLoc1AddlUUID,
  PurchaseOrder.IncotermsSupChnLoc2AddlUUID AS IncotermsSupChnLoc2AddlUUID,
  PurchaseOrder.IncotermsSupChnDvtgLocAddlUUID AS IncotermsSupChnDvtgLocAddlUUID,
  PurchaseOrder.RequestForQuotation AS RequestForQuotation,
  PurchaseOrder._CompanyCode AS _CompanyCode,
  PurchaseOrder._CreatedByUser AS _CreatedByUser,
  PurchaseOrder._DocumentCurrency AS _DocumentCurrency,
  PurchaseOrder._IncotermsClassification AS _IncotermsClassification,
  PurchaseOrder._IncotermsVersion AS _IncotermsVersion,
  PurchaseOrder._InvoicingParty AS _InvoicingParty,
  PurchaseOrder._Language AS _Language,
  PurchaseOrder._PaymentTerms AS _PaymentTerms,
  PurchaseOrder._PurchaseOrderCalcFields AS _PurchaseOrderCalcFields,
  PurchaseOrder._PurchaseOrderDeletionCode AS _PurchaseOrderDeletionCode,
  PurchaseOrder._PurchasingGroup AS _PurchasingGroup,
  PurchaseOrder._PurchasingOrganization AS _PurchasingOrganization,
  PurchaseOrder._Supplier AS _Supplier,
  PurchaseOrder._SupplyingPlant AS _SupplyingPlant,
  PurchaseOrder._SupplyingSupplier AS _SupplyingSupplier,
  _PurchaseOrderHeaderExtension.PPSPurchaseOrderDescription AS PPSPurchaseOrderDescription,
  _PurchaseOrderHeaderExtension.PPSPurgDocClassfctnCode AS PPSPurgDocClassfctnCode,
  _PurchaseOrderHeaderExtension.PPSFuturePostingDate AS PPSFuturePostingDate,
  _PurchaseOrderHeaderExtension.PPSPerdOfPerfStartDate AS PPSPerdOfPerfStartDate,
  _PurchaseOrderHeaderExtension.PPSPerdOfPerfEndDate AS PPSPerdOfPerfEndDate,
  _PurchaseOrderHeaderExtension.PPSSmartNumberHeader AS PPSSmartNumberHeader,
  _PurchaseOrderHeaderExtension.PPSSmartNumberHeaderIsManual AS PPSSmartNumberHeaderIsManual,
  _PurchaseOrderHeaderExtension.PurchasingDocVersionReasonCode AS PurchasingDocVersionReasonCode,
  _PurchaseOrderHeaderExtension.PPSRevisionComment AS PPSRevisionComment,
  _PurchaseOrderHeaderExtension.PPSSmartDocumentNumber AS PPSSmartDocumentNumber,
  _PurchaseOrderHeaderExtension.PPSNumberOfModification AS PPSNumberOfModification,
  _PurchaseOrderHeaderExtension.PPSModificationType AS PPSModificationType,
  _PurchaseOrderHeaderExtension.PPSModificationTypeText AS PPSModificationTypeText,
  _PurchaseOrderHeaderExtension.PPSModificationIdentifierCode AS PPSModificationIdentifierCode,
  _PurchaseOrderHeaderExtension.PPSPurOrderHeaderStatus AS PPSPurOrderHeaderStatus,
  _PurchaseOrderHeaderExtension.PPSFedSystApprvlDate AS PPSFedSystApprvlDate,
  _PurchaseOrderHeaderExtension.PPSFedSystStatus AS PPSFedSystStatus,
  _PurchaseOrderHeaderExtension.PPSFedSystLogHandle AS PPSFedSystLogHandle,
  _PurchaseOrderTypeText.PurchasingDocumentTypeName AS PurchaseOrderTypeName,
  _PurOrdHasItemHierarchy.PurchasingHasItemHierarchy AS PurchasingHasItemHierarchy,
  _User.UserDescription AS CreatedByUserFullName
FROM R_PPS_PurchaseOrder AS PurchaseOrder
LEFT OUTER JOIN R_PurOrdHasItemHierarchy AS _PurOrdHasItemHierarchy ON PurchaseOrder = _PurOrdHasItemHierarchy.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderNetAmount AS _PurchaseOrderNetAmount ON _PurchaseOrderNetAmount.PurchaseOrder = PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchaseOrderTypeText ON _PurchaseOrderTypeText.PurchasingDocumentType = PurchaseOrderType AND _PurchaseOrderTypeText.PurchasingDocumentCategory = 'F' AND _PurchaseOrderTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON _User.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurchaseOrderType ON PurchaseOrderType = _PurchaseOrderType.PurchasingDocumentType AND _PurchaseOrderType.PurchasingDocumentCategory = 'F'  -- association [1..1]
LEFT OUTER JOIN I_PPS_PurchaseOrderStatus AS _PurchaseOrderStatus ON PurchaseOrder = _PurchaseOrderStatus.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_PPS_PurgDocHdrStatusText AS _PurOrderStatusText ON ppspurorderheaderstatus = _PurOrderStatusText.PurchasingDocumentStatus AND _PurOrderStatusText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_PPS_PurOrdChgVersDrft AS _ChgDocDraft ON ActivePurchasingDocument = _ChgDocDraft.ActivePurchasingDocument  -- association [1..*]
LEFT OUTER JOIN E_PurchasingDocument AS _PurchaseOrderExtension ON PurchaseOrder = _PurchaseOrderExtension.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN R_PPS_PurOrderHeaderExtension AS _PurchaseOrderHeaderExtension ON PurchaseOrder = _PurchaseOrderHeaderExtension.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN I_PPS_PurgDocClassificationTxt AS _Classification ON PPSPurgDocClassfctnCode = _Classification.PPSPurgDocClassfctnCode AND _Classification.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_PPS_PurgDocVersionReasonVH AS _VersionReasonValHelp ON purchasingdocversionreasoncode = _VersionReasonValHelp.PurchasingDocVersionReasonCode  -- association [0..1]
LEFT OUTER JOIN I_PPS_PurgDocModifTypeVH AS _ModificationType ON ppsmodificationtype = _ModificationType.PPSModificationType  -- association [0..1]
LEFT OUTER JOIN I_PPS_PurgDocModifTypeText AS _ModificationTypeText ON ppsmodificationtype = _ModificationTypeText.PPSModificationType AND _ModificationTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PPS_PurOrdDocType AS _PurchaseOrderDocType ON _PurchaseOrderDocType.PurchaseOrderType = PurchaseOrderType AND _PurchaseOrderDocType.PurchasingDocumentCategory = 'F'  -- association [1..1]
LEFT OUTER JOIN I_PPS_FedSystApprvlStatusVH AS _FedSystApprvlStatus ON ppsmodificationtype = _FedSystApprvlStatus.PPSFedSystStatus  -- association [0..1]
LEFT OUTER JOIN I_PPS_FedSystApprvlStatusText AS _FedSystApprvlStatusText ON ppsfedsyststatus = _FedSystApprvlStatusText.PPSFedSystStatus AND _FedSystApprvlStatusText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN R_PPS_PurchaseOrderItemTP AS _PurchaseOrderItem ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_PPS_PurOrdSupplierAddressTP AS _SupplierAddress ON /* condition not available in parsed metadata */  -- association [1..1]
LEFT OUTER JOIN R_PPS_PurchaseOrderNoteTP AS _PurchaseOrderNote ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_PPS_PurchaseOrderPartnerTP AS _PurchaseOrderPartner ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_PPS_PurchaseOrderContactTP AS _PurchaseOrderContact ON /* condition not available in parsed metadata */  -- association [1..*]
;