SEPMRA_I_PurchaseOrderWD

DDL: SEPMRA_I_PURCHASEORDERWD Type: view Package: S_EPMRA_COMMON
29 Fields 1 Data Sources 1 Associations

Purchase Order

SEPMRA_I_PurchaseOrderWD is a CDS View that provides data about "Purchase Order" in SAP S/4HANA. It reads from 1 data source (SEPMRA_I_PurchaseOrderHeader) and exposes 29 fields with key field PurchaseOrder. It has 1 association to related views. Part of development package S_EPMRA_COMMON.

Data Sources (1)

SourceAliasJoin Type
SEPMRA_I_PurchaseOrderHeader PurchaseOrder from

Associations (1)

CardinalityTargetAliasCondition
[0..*] SEPMRA_I_PurchaseOrderItemWD _Items _Items.PurchaseOrder = $projection.PurchaseOrder

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName SEPMRA_IPOWD view
AbapCatalog.compiler.compareFilter true view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Purchase Order view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeDraftPersistence SEPMRA_PO view
ObjectModel.draftEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.entityChangeStateId LastChangedDateTime view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #NOT_REQUIRED view
Consumption.semanticObject EPMPurchaseOrder view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder SEPMRA_I_PurchaseOrderHeader PurchaseOrder Purchasing Document
Supplier SEPMRA_I_PurchaseOrderHeader Supplier Supplier
TransactionCurrency SEPMRA_I_PurchaseOrderHeader TransactionCurrency Transaction Currency
GrossAmountInTransacCurrency SEPMRA_I_PurchaseOrderHeader GrossAmountInTransacCurrency
NetAmountInTransactionCurrency SEPMRA_I_PurchaseOrderHeader NetAmountInTransactionCurrency
TaxAmountInTransactionCurrency SEPMRA_I_PurchaseOrderHeader TaxAmountInTransactionCurrency
PurchaseOrderLifeCycleStatus SEPMRA_I_PurchaseOrderHeader PurchaseOrderLifeCycleStatus
PurchaseOrderApprovalStatus SEPMRA_I_PurchaseOrderHeader PurchaseOrderApprovalStatus
PurchaseOrderConfStatus SEPMRA_I_PurchaseOrderHeader PurchaseOrderConfStatus
PurchaseOrderOrderingStatus SEPMRA_I_PurchaseOrderHeader PurchaseOrderOrderingStatus
PurchaseOrderInvoicingStatus SEPMRA_I_PurchaseOrderHeader PurchaseOrderInvoicingStatus
PurchaseOrderOverallStatus SEPMRA_I_PurchaseOrderHeader PurchaseOrderOverallStatus
CreatedByUser SEPMRA_I_PurchaseOrderHeader CreatedByUser User Name
CreationDateTime SEPMRA_I_PurchaseOrderHeader CreationDateTime Timestamp
LastChangedByUser SEPMRA_I_PurchaseOrderHeader LastChangedByUser User Name
LastChangedDateTime SEPMRA_I_PurchaseOrderHeader LastChangedDateTime Time Stamp
Associations_Items
_TransactionCurrency SEPMRA_I_PurchaseOrderHeader _TransactionCurrency
_Supplier SEPMRA_I_PurchaseOrderHeader _Supplier
_LifeCycleStatus SEPMRA_I_PurchaseOrderHeader _LifeCycleStatus
_ApprovalStatus SEPMRA_I_PurchaseOrderHeader _ApprovalStatus
_InvoicingStatus SEPMRA_I_PurchaseOrderHeader _InvoicingStatus
_OrderingStatus SEPMRA_I_PurchaseOrderHeader _OrderingStatus
_ConfirmationStatus SEPMRA_I_PurchaseOrderHeader _ConfirmationStatus
_OverallStatus SEPMRA_I_PurchaseOrderHeader _OverallStatus
_CreatedByUser SEPMRA_I_PurchaseOrderHeader _CreatedByUser
_LastChangedByUser SEPMRA_I_PurchaseOrderHeader _LastChangedByUser
_DeliveryAddress SEPMRA_I_PurchaseOrderHeader _DeliveryAddress
_DeliveryDateRange SEPMRA_I_PurchaseOrderHeader _DeliveryDateRange

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 SEPMRA_I_PurchaseOrderWD.
-- 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 SEPMRA_I_PurchaseOrderWD AS
SELECT
  PurchaseOrder.PurchaseOrder AS PurchaseOrder,
  PurchaseOrder.Supplier AS Supplier,
  PurchaseOrder.TransactionCurrency AS TransactionCurrency,
  PurchaseOrder.GrossAmountInTransacCurrency AS GrossAmountInTransacCurrency,
  PurchaseOrder.NetAmountInTransactionCurrency AS NetAmountInTransactionCurrency,
  PurchaseOrder.TaxAmountInTransactionCurrency AS TaxAmountInTransactionCurrency,
  PurchaseOrder.PurchaseOrderLifeCycleStatus AS PurchaseOrderLifeCycleStatus,
  PurchaseOrder.PurchaseOrderApprovalStatus AS PurchaseOrderApprovalStatus,
  PurchaseOrder.PurchaseOrderConfStatus AS PurchaseOrderConfStatus,
  PurchaseOrder.PurchaseOrderOrderingStatus AS PurchaseOrderOrderingStatus,
  PurchaseOrder.PurchaseOrderInvoicingStatus AS PurchaseOrderInvoicingStatus,
  PurchaseOrder.PurchaseOrderOverallStatus AS PurchaseOrderOverallStatus,
  PurchaseOrder.CreatedByUser AS CreatedByUser,
  PurchaseOrder.CreationDateTime AS CreationDateTime,
  PurchaseOrder.LastChangedByUser AS LastChangedByUser,
  PurchaseOrder.LastChangedDateTime AS LastChangedDateTime,
  PurchaseOrder._TransactionCurrency AS _TransactionCurrency,
  PurchaseOrder._Supplier AS _Supplier,
  PurchaseOrder._LifeCycleStatus AS _LifeCycleStatus,
  PurchaseOrder._ApprovalStatus AS _ApprovalStatus,
  PurchaseOrder._InvoicingStatus AS _InvoicingStatus,
  PurchaseOrder._OrderingStatus AS _OrderingStatus,
  PurchaseOrder._ConfirmationStatus AS _ConfirmationStatus,
  PurchaseOrder._OverallStatus AS _OverallStatus,
  PurchaseOrder._CreatedByUser AS _CreatedByUser,
  PurchaseOrder._LastChangedByUser AS _LastChangedByUser,
  PurchaseOrder._DeliveryAddress AS _DeliveryAddress,
  PurchaseOrder._DeliveryDateRange AS _DeliveryDateRange
FROM SEPMRA_I_PurchaseOrderHeader AS PurchaseOrder
LEFT OUTER JOIN SEPMRA_I_PurchaseOrderItemWD AS _Items ON _Items.PurchaseOrder = PurchaseOrder  -- association [0..*]
;

Learn More