C_PPS_DirectPurchaseOrderTP_2

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_PPS_DirectPurchaseOrderTP_2.
-- 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_PPS_DirectPurchaseOrderTP_2 AS
SELECT
  PurchaseOrder,
  ActivePurchasingDocument,
  PurchaseOrderType,
  _PurchaseOrderTypeText.PurchasingDocumentTypeName AS PurchaseOrderTypeName,
  CreatedByUser,
  CreationDate,
  PurchaseOrderDate,
  LastChangeDateTime,
  Language,
  _WorkflowDetail.PPSPurgDocApprovalStatusText AS PPSPurgDocApprovalStatusText,
  _WorkflowDetail.PPSPurgDocApprovalDate AS PPSPurOrderApprovalDate,
  _WorkflowDetail.PPSPurgDocApprovalStatus AS PPSPurgDocApprovalStatus,
  PurchaseOrderDeletionCode,
  IsDeleted,
  ReleaseIsNotCompleted,
  PurchasingCompletenessStatus,
  PurchasingProcessingStatus,
  PurgReleaseSequenceStatus,
  ReleaseCode,
  PurchasingReleaseStrategy,
  PurgReasonForDocCancellation,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  cast( _SupplierCurrency.PurchaseOrderCurrency as pps_e_po_source_currency preserving type ) AS PPSSupplierCurrency,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  SupplyingSupplier,
  SupplyingPlant,
  InvoicingParty,
  Customer,
  PurchaseContract,
  SupplierQuotationExternalID,
  QuotationSubmissionDate,
  ItemNumberIntervalForSubItems,
  PaymentTerms,
  _PaymentTerms._Text[ 1: Language = $session.system_language ].PaymentTermsName AS PaymentTermsName,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  DownPaymentType,
  DownPaymentPercentageOfTotAmt,
  PPSDocumentCurrency,
  DownPaymentAmount,
  DownPaymentDueDate,
  IncotermsClassification,
  _IncotermsClassificationText.IncotermsClassificationName : localized AS IncotermsClassificationNamelocalized,
  IncotermsTransferLocation,
  IncotermsVersion,
  IncotermsLocation1,
  PricingDocument,
  PricingProcedure,
  DocumentCurrency,
  ExchangeRate,
  ExchangeRateIsFixed,
  PurgReleaseTimeTotalAmount,
  TaxReturnCountry,
  VATRegistrationCountry,
  PurgAggrgdProdCmplncSuplrSts,
  PurgAggrgdProdMarketabilitySts,
  PurgAggrgdSftyDataSheetStatus,
  PurgProdCmplncTotDngrsGoodsSts,
  PurchaseOrderHasCommitmentItem,
  PPSIsDirectPurchaseOrder,
  POReworkCommentText,
  PPSPurchaseOrderDescription,
  PPSPurgDocClassfctnCode,
  _Classification.PPSPurgDocClassfctnTxt AS PPSPurgDocClassfctnTxt,
  PPSPurOrdIsInPrep,
  PurchasingDocVersionReasonCode,
  _VersionReasonValHelp.PurchasingDocVersionReasonText AS PurchasingDocVersionReasonText,
  PPSRevisionComment,
  PurgDocChangeRequestStatus,
  PPSDocumentIsNovated,
  PurgDocIsChgVers,
  PurchasingDocumentVersion,
  _PurchaseOrderStatus.PurchasingDocumentStatus AS PurchaseOrderStatus_H,
  _PurchaseOrderStatus.PurchasingDocumentStatus AS PurchasingDocumentStatus,
  virtual ApproverName : mm_approver_name AS virtualApproverNamemm_approver_name,
  virtual ManufacturerMaterial : ematn AS virtualManufacturerMaterialematn,
  virtual Plant : werks_d AS virtualPlantwerks_d,
  virtual MaterialGroup : matkl AS virtualMaterialGroupmatkl,
  virtual PurchaseOrderLegalDocument : abap.char( 1 ) AS char1,
  virtual NumberOfPurchaseOrderItems : abap.int4 AS int4,
  virtual UICT_VersionIsNotEnabled : boolean AS virtualUICT_VersionIsNotEnabledboolean,
  virtual UICT_HideExchangeRate : boolean AS virtualUICT_HideExchangeRateboolean,
  virtual UICT_HideFixedExchangeRate : boolean AS virtualUICT_HideFixedExchangeRateboolean,
  virtual PurgDocHasActnRstrcn : boole_d AS virtualPurgDocHasActnRstrcnboole_d,
  virtual UICT_HideFedSystFacet : boolean AS virtualUICT_HideFedSystFacetboolean,
  virtual UICT_Hide_OpentextFacet : boolean AS virtualUICT_Hide_OpentextFacetboolean
FROM R_PPS_PurchaseOrderTP
LEFT OUTER JOIN C_PurOrdRefDocPO AS _PurOrdRefDocPurchaseOrder ON _PurOrdRefDocPurchaseOrder.Supplier = Supplier  -- association [0..*]
LEFT OUTER JOIN C_PurOrdRefDocIR AS _PurOrdRefDocInfoRecord ON _PurOrdRefDocInfoRecord.Supplier = Supplier  -- association [0..*]
LEFT OUTER JOIN C_PurOrdRefDocPC AS _PurOrdRefDocPurchaseContract ON _PurOrdRefDocPurchaseContract.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_MM_CompanyCodeValueHelp AS _CompanyCodeValueHelp ON _CompanyCodeValueHelp.CompanyCode = CompanyCode  -- 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 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]
LEFT OUTER JOIN C_PPS_SupplierDetail AS _SupplierDetail ON Supplier = _SupplierDetail.Supplier  -- association [1..1]
LEFT OUTER JOIN C_PPS_PaymentTerm AS _PaymentTerm ON PaymentTerms = _PaymentTerm.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN C_PPS_DrctPOVersionHistory_2 AS _PurOrdVersionHistory ON ActivePurchasingDocument = _PurOrdVersionHistory.ActivePurchasingDocument  -- association [1..*]
LEFT OUTER JOIN C_PPS_PurOrdDocumentTotal_2 AS _DocumentTotal ON ActivePurchasingDocument = _DocumentTotal.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN C_PPS_PurOrdDocTotalOptional_2 AS _OptionalDocumentTotal ON PurchaseOrder = _OptionalDocumentTotal.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN C_PPS_PurOrdItmDocTot AS _ItemDocumentTotal ON ActivePurchasingDocument = _ItemDocumentTotal.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN C_PPS_PurgDocBudgetOverviewC AS _PurgDocBudgetOverview ON PurchaseOrder = _PurgDocBudgetOverview.ReferenceDocument  -- association [0..*]
LEFT OUTER JOIN C_PPS_PricingArrangementTypeVH AS _PricingArrangementType ON PPSPricingArrangementType = _PricingArrangementType.PPSPricingArrangementType  -- association [1..1]
LEFT OUTER JOIN C_LegalTransactionIntegFacet AS _LegalTransaction ON _LegalTransaction.LglCntntMLinkdObj = PurchaseOrder AND _LegalTransaction.LglCntntMIntegrationLink = 'POR'  -- association [0..*]
LEFT OUTER JOIN C_LegalDocumentIntegFacet AS _LegalDocuments ON _LegalDocuments.LglCntntMLinkdObj = PurchaseOrder AND _LegalDocuments.LglCntntMIntegrationLink = 'POR'  -- association [0..*]
;