SEPMRA_I_PURCHASEORDERHEADER

CDS View
29 Fields 3 CDS Views

Purchase Order

SEPMRA_I_PURCHASEORDERHEADER is a CDS View in S/4HANA. Purchase Order. It contains 29 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
SEPMRA_I_PD_PoItmCube view from Purchase Order Item Cube
SEPMRA_I_PurchaseOrderWD view from Purchase Order
SEPMRA_P_LEG_POAPV_BUDGET view from Fiori Ref Apps: {LEGACY] open POs and their gross amount

Fields (29)

KeyField CDS FieldsUsed in Views
KEY PurchaseOrder PurchaseOrder 3
_ApprovalStatus _ApprovalStatus 2
_ConfirmationStatus _ConfirmationStatus 2
_CreatedByUser _CreatedByUser 2
_DeliveryAddress _DeliveryAddress 1
_DeliveryDateRange _DeliveryDateRange 1
_InvoicingStatus _InvoicingStatus 2
_Items _Items 1
_LastChangedByUser _LastChangedByUser 1
_LifeCycleStatus _LifeCycleStatus 2
_OrderingStatus _OrderingStatus 2
_OverallStatus _OverallStatus 2
_Supplier _Supplier 2
_TransactionCurrency _TransactionCurrency 2
CreatedByUser CreatedByUser 2
CreationDateTime CreationDateTime 2
GrossAmountInTransacCurrency GrossAmountInTransacCurrency,TotalGrossAmount 2
LastChangedByUser LastChangedByUser 1
LastChangedDateTime LastChangedDateTime 2
NetAmountInTransactionCurrency NetAmountInTransactionCurrency,TotalNetAmount 2
PurchaseOrderApprovalStatus PurchaseOrderApprovalStatus 2
PurchaseOrderConfStatus PurchaseOrderConfStatus 2
PurchaseOrderInvoicingStatus PurchaseOrderInvoicingStatus 2
PurchaseOrderLifeCycleStatus PurchaseOrderLifeCycleStatus 2
PurchaseOrderOrderingStatus PurchaseOrderOrderingStatus 2
PurchaseOrderOverallStatus PurchaseOrderOverallStatus 2
Supplier Supplier 2
TaxAmountInTransactionCurrency TaxAmountInTransactionCurrency,TotalTaxAmount 2
TransactionCurrency TransactionCurrency 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Purchase Order
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SEPMRA_I_PURCHASEORDERHEADER (
    PURCHASEORDER,
    _APPROVALSTATUS,
    _CONFIRMATIONSTATUS,
    _CREATEDBYUSER,
    _DELIVERYADDRESS,
    _DELIVERYDATERANGE,
    _INVOICINGSTATUS,
    _ITEMS,
    _LASTCHANGEDBYUSER,
    _LIFECYCLESTATUS,
    _ORDERINGSTATUS,
    _OVERALLSTATUS,
    _SUPPLIER,
    _TRANSACTIONCURRENCY,
    CREATEDBYUSER,
    CREATIONDATETIME,
    GROSSAMOUNTINTRANSACCURRENCY,
    LASTCHANGEDBYUSER,
    LASTCHANGEDDATETIME,
    NETAMOUNTINTRANSACTIONCURRENCY,
    PURCHASEORDERAPPROVALSTATUS,
    PURCHASEORDERCONFSTATUS,
    PURCHASEORDERINVOICINGSTATUS,
    PURCHASEORDERLIFECYCLESTATUS,
    PURCHASEORDERORDERINGSTATUS,
    PURCHASEORDEROVERALLSTATUS,
    SUPPLIER,
    TAXAMOUNTINTRANSACTIONCURRENCY,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (PURCHASEORDER)
);

Learn More