C_PurchaseOrderFs

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_PurchaseOrderFs.
-- 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: CPURORDERFS

CREATE VIEW C_PurchaseOrderFs AS
SELECT
  I_PurchaseOrderEnhanced.PurchaseOrder AS PurchaseOrder,
  PurchaseOrder AS PurchasingDocument,
  PurchaseOrderType,
  PurchaseOrderSubtype,
  PurchasingDocumentOrigin,
  _PurchaseOrderType.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _PurchaseOrderType.PurchasingDocumentType AS PurchasingDocumentType,
  CreatedByUser,
  CreationDate,
  PurchaseOrderDate,
  Language,
  PurchasingDocumentDeletionCode,
  ReleaseIsNotCompleted,
  PurchasingCompletenessStatus,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  Supplier,
  _SupplierHeadOffice.FullName AS SupplierName,
  ManualSupplierAddressID,
  SupplierAddressID,
  SupplyingSupplier,
  SupplyingPlant,
  InvoicingParty,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  cast('' as mm_pur_paymenttermstext) AS PaymentTermsDescription,
  IncotermsClassification,
  IncotermsTransferLocation,
  DocumentCurrency,
  I_PurchaseOrderEnhanced.PurchasingHasItemHierarchy AS PurchasingHasItemHierarchy,
  PurchaseOrderNetAmount,
  PurchasingDocumentStatus,
  _User.UserDescription AS UserFullName,
  cast (_PurchasingDocumentStatusText.PurchasingDocumentStatusName as mm_po_status) AS PurchasingDocumentStatusName,
  I_PurchaseOrderEnhanced._PurchaseOrderType.PurgHasFlxblWorkflowApproval AS PurgHasFlxblWorkflowApproval,
  _PurchaseOrderType._Text AS _PurchaseOrderTypeText
FROM I_PurchaseOrderEnhanced
LEFT OUTER JOIN C_SuplInvPurOrdRef AS _SuplInvPurOrdRef ON PurchaseOrder = _SuplInvPurOrdRef.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN C_PurOrdItemEnh AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN C_PurchaseOrderLimitItem AS _PurchaseOrderLimitItem ON PurchaseOrder = _PurchaseOrderLimitItem.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN C_PurOrdSuplrConfDisplay AS _PurOrdSuplrConfDisplay ON PurchaseOrder = _PurOrdSuplrConfDisplay.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN C_PurReqItemByPurOrder AS _PurReqItemByPurOrder ON PurchaseOrder = _PurReqItemByPurOrder.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN C_PurOrdRefPurConItm AS _PurOrdRefPurConItm ON PurchaseOrder = _PurOrdRefPurConItm.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN C_PurchaseOrderGoodsReceipt AS _PurchaseOrderGoodsReceipt ON PurchaseOrder = _PurchaseOrderGoodsReceipt.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncotermsClassificationText ON IncotermsClassification = _IncotermsClassificationText.IncotermsClassification  -- association [0..*]
LEFT OUTER JOIN I_PurchasingDocumentStatusText AS _PurchasingDocumentStatusText ON PurchasingDocumentStatus = _PurchasingDocumentStatusText.PurchasingDocumentStatus AND _PurchasingDocumentStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PaymentTermsText AS _PaymentTermsText ON PaymentTerms = _PaymentTermsText.PaymentTerms  -- association [0..*]
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 [0..1]
LEFT OUTER JOIN I_SupplierOrAddressContactCard AS _SupplierHeadOffice ON ( _SupplierHeadOffice.ContactCardType = 'Supplier' AND _SupplierHeadOffice.ContactCardID = Supplier AND _SupplierHeadOffice.ContactCardRole = 'Supplier' )  -- association [1..1]
LEFT OUTER JOIN E_PurchasingDocument AS _HeaderExtension ON PurchaseOrder = _HeaderExtension.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN C_PurOrderItemHierFactSheet AS _PurchaseOrderItemHierarchy ON PurchaseOrder = _PurchaseOrderItemHierarchy.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN E_PurchasingDocument AS _PurchaseOrderExtension ON PurchaseOrder = _PurchaseOrderExtension.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN C_PurOrderPartnerFactSheet AS _PurchaseOrderPartner ON PurchaseOrder = _PurchaseOrderPartner.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN C_POSupplierAddressFactSheet AS _POSupplierAddressFactSheet ON PurchaseOrder = _POSupplierAddressFactSheet.PurchaseOrder  -- association [1..1]
;