ESH_N_PURCHASE_ORDER
ESH_N_PURCHASE_ORDER is a CDS View in SAP S/4HANA. It reads from 1 data source (R_PURCHASEORDER) and exposes 55 fields with key field PURCHASEORDER. It has 2 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_PURCHASEORDER | R_PURCHASEORDER | from |
Parameters (1)
| Name | Type | Default |
|---|---|---|
| P_Language | abap.lang |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | N_PAYMENTTERMS | _PAYMENTTERMS | $projection.PaymentTerms=_PAYMENTTERMS.PaymentTerms |
| [0..*] | dd07t | _PURCHASEORDERDELETIONCODE | $projection.PurchaseOrderDeletionCode=_PURCHASEORDERDELETIONCODE.domvalue_l and _PURCHASEORDERDELETIONCODE.domname='MMPUR_PO_DEL_CODE' and _PURCHASEORDERDELETIONCODE.as4local='A' |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| ObjectModel.usageType.serviceQuality | #P | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view | |
| AbapCatalog.preserveKey | true | view | |
| AbapCatalog.sqlViewName | ESH_L_PURORDER | view |
Fields (55)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PURCHASEORDER | PURCHASEORDER | Purchasing Document | |
| BUSINESSAREA | ||||
| BUSINESSAREANAME | ||||
| COMPANYCODE | COMPANYCODE | Receiver Company Code | ||
| COMPANYCODENAME | _COMPANYCODE | COMPANYCODENAME | Company Name | |
| CONTROLLINGAREA | ||||
| CONTROLLINGAREANAME | ||||
| CREATEDBYUSER | CREATEDBYUSER | User Name | ||
| CREATIONDATE | CREATIONDATE | Time Stamp | ||
| DOCUMENTCURRENCY | DOCUMENTCURRENCY | Document Currency | ||
| PURCHASEORDERCURRENCY | _PURCHASEORDERITEM | DOCUMENTCURRENCY | Document Currency | |
| INCOTERMSCLASSIFICATION | INCOTERMSCLASSIFICATION | Incoterms | ||
| INCOTERMSCLASSIFICATIONNAME | ||||
| INCOTERMSLOCATION1 | INCOTERMSLOCATION1 | Inco. Location1 | ||
| INCOTERMSLOCATION2 | INCOTERMSLOCATION2 | Inco. Location2 | ||
| INCOTERMSTRANSFERLOCATION | INCOTERMSTRANSFERLOCATION | Incoterms 2 | ||
| LASTCHANGEDATETIME | LASTCHANGEDATETIME | Timestamp | ||
| MANUFACTURERMATERIAL | _PURCHASEORDERITEM | MANUFACTURERMATERIAL | MPN: Material | |
| MATERIAL | _PURCHASEORDERITEM | MATERIAL | Vehicle Model | |
| MATERIALGROUP | _PURCHASEORDERITEM | MATERIALGROUP | Product Group | |
| MATERIALGROUPNAME | ||||
| NETAMOUNT | _PURCHASEORDERITEM | NETAMOUNT | Stated Amount | |
| NETPRICEAMOUNT | _PURCHASEORDERITEM | NETPRICEAMOUNT | Net Price | |
| NETPRICEQUANTITY | _PURCHASEORDERITEM | NETPRICEQUANTITY | Price Unit | |
| ORDERPRICEUNIT | _PURCHASEORDERITEM | ORDERPRICEUNIT | Order Price Un. | |
| ORDERQUANTITY | _PURCHASEORDERITEM | ORDERQUANTITY | Quantity | |
| ORGANIZATIONBPNAME1 | _SUPPLIER | ORGANIZATIONBPNAME1 | Name 1 | |
| PAYMENTTERMS | PAYMENTTERMS | Pyt Terms | ||
| PAYMENTTERMSNAME | _PAYMENTTERMS | PAYMENTTERMSNAME | Description | |
| PLANT | _PURCHASEORDERITEM | PLANT | Valuation Area | |
| PLANTNAME | _SUPPLYINGPLANT | PLANTNAME | Plant Name | |
| PURORDERITEMPLANT | ||||
| PROFITCENTER | ||||
| PROFITCENTERNAME | ||||
| PURCHASECONTRACT | PURCHASECONTRACT | Purchasing Doc. | ||
| PURCHASEORDERDATE | PURCHASEORDERDATE | PO Date | ||
| PURCHASEORDERDELETIONCODE | PURCHASEORDERDELETIONCODE | Deletion Code | ||
| PURCHASEORDERDELETIONCODENAME | ||||
| PURCHASEORDERITEM | _PURCHASEORDERITEM | PURCHASEORDERITEM | Purchasing Document Item | |
| PURCHASEORDERITEMTEXT | _PURCHASEORDERITEM | PURCHASEORDERITEMTEXT | Short Text | |
| PURCHASEORDERQUANTITYUNIT | _PURCHASEORDERITEM | PURCHASEORDERQUANTITYUNIT | Order Unit | |
| PURCHASEORDERTYPE | PURCHASEORDERTYPE | PO Type | ||
| PURCHASEREQUISITION | _PURCHASEORDERITEM | PURCHASEREQUISITION | Requisition | |
| ISDELETED | _PURCHASEORDERITEM | PURCHASINGDOCUMENTDELETIONCODE | Del. Indicator | |
| PURCHASINGDOCUMENTTYPENAME | ||||
| PURCHASINGGROUP | PURCHASINGGROUP | Purchasing Group | ||
| PURCHASINGGROUPNAME | _PURCHASINGGROUP | PURCHASINGGROUPNAME | Purchasing Grp. Name | |
| PURCHASINGORGANIZATION | PURCHASINGORGANIZATION | Purchasing Organization | ||
| PURCHASINGORGANIZATIONNAME | _PURCHASINGORGANIZATION | PURCHASINGORGANIZATIONNAME | Purch. Org. Name | |
| SUPPLIER | SUPPLIER | Supplier | ||
| SUPPLYINGPLANT | SUPPLYINGPLANT | Supplying Plant | ||
| USERDESCRIPTION | _CREATEDBYUSER | USERDESCRIPTION | Full Name | |
| WBSDESCRIPTION | ||||
| WBSELEMENTEXTERNALID | ||||
| WBSELEMENTINTERNALID |
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 ESH_N_PURCHASE_ORDER.
-- 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: ESH_L_PURORDER
-- Parameters: P_Language : abap.lang
CREATE VIEW ESH_N_PURCHASE_ORDER AS
SELECT
PURCHASEORDER,
_PURCHASEORDERITEM._PURORDACCOUNTASSIGNMENT.BUSINESSAREA AS BUSINESSAREA,
_PURCHASEORDERITEM._PURORDACCOUNTASSIGNMENT._BUSINESSAREA._TEXT[1: LANGUAGE = $parameters. P_Language].BUSINESSAREANAME AS BUSINESSAREANAME,
COMPANYCODE,
_COMPANYCODE.COMPANYCODENAME AS COMPANYCODENAME,
_PURCHASEORDERITEM._PURORDACCOUNTASSIGNMENT.CONTROLLINGAREA AS CONTROLLINGAREA,
_PURCHASEORDERITEM._PURORDACCOUNTASSIGNMENT._CONTROLLINGAREA.CONTROLLINGAREANAME AS CONTROLLINGAREANAME,
CREATEDBYUSER,
CREATIONDATE,
DOCUMENTCURRENCY,
_PURCHASEORDERITEM.DOCUMENTCURRENCY AS PURCHASEORDERCURRENCY,
INCOTERMSCLASSIFICATION,
_INCOTERMSCLASSIFICATION._TEXT[1: LANGUAGE = $parameters. P_Language].INCOTERMSCLASSIFICATIONNAME AS INCOTERMSCLASSIFICATIONNAME,
INCOTERMSLOCATION1,
INCOTERMSLOCATION2,
INCOTERMSTRANSFERLOCATION,
LASTCHANGEDATETIME,
_PURCHASEORDERITEM.MANUFACTURERMATERIAL AS MANUFACTURERMATERIAL,
_PURCHASEORDERITEM.MATERIAL AS MATERIAL,
_PURCHASEORDERITEM.MATERIALGROUP AS MATERIALGROUP,
_PURCHASEORDERITEM._MATERIALGROUP._TEXT[1: LANGUAGE = $parameters. P_Language].MATERIALGROUPNAME AS MATERIALGROUPNAME,
_PURCHASEORDERITEM.NETAMOUNT AS NETAMOUNT,
_PURCHASEORDERITEM.NETPRICEAMOUNT AS NETPRICEAMOUNT,
_PURCHASEORDERITEM.NETPRICEQUANTITY AS NETPRICEQUANTITY,
_PURCHASEORDERITEM.ORDERPRICEUNIT AS ORDERPRICEUNIT,
_PURCHASEORDERITEM.ORDERQUANTITY AS ORDERQUANTITY,
_SUPPLIER.ORGANIZATIONBPNAME1 AS ORGANIZATIONBPNAME1,
PAYMENTTERMS,
_PAYMENTTERMS.PAYMENTTERMSNAME AS PAYMENTTERMSNAME,
_PURCHASEORDERITEM.PLANT AS PLANT,
_SUPPLYINGPLANT.PLANTNAME AS PLANTNAME,
_PURCHASEORDERITEM._PLANT.PLANTNAME AS PURORDERITEMPLANT,
_PURCHASEORDERITEM._PURORDACCOUNTASSIGNMENT.PROFITCENTER AS PROFITCENTER,
_PURCHASEORDERITEM._PURORDACCOUNTASSIGNMENT._PROFITCENTERTEXT[1: LANGUAGE = $parameters. P_Language].PROFITCENTERNAME AS PROFITCENTERNAME,
PURCHASECONTRACT,
PURCHASEORDERDATE,
PURCHASEORDERDELETIONCODE,
_PURCHASEORDERDELETIONCODE[1: ddlanguage = $parameters. P_Language].ddtext AS PURCHASEORDERDELETIONCODENAME,
_PURCHASEORDERITEM.PURCHASEORDERITEM AS PURCHASEORDERITEM,
_PURCHASEORDERITEM.PURCHASEORDERITEMTEXT AS PURCHASEORDERITEMTEXT,
_PURCHASEORDERITEM.PURCHASEORDERQUANTITYUNIT AS PURCHASEORDERQUANTITYUNIT,
PURCHASEORDERTYPE,
_PURCHASEORDERITEM.PURCHASEREQUISITION AS PURCHASEREQUISITION,
_PURCHASEORDERITEM.PURCHASINGDOCUMENTDELETIONCODE AS ISDELETED,
_PURCHASEORDERTYPE._TEXT[1: LANGUAGE = $parameters. P_Language].PURCHASINGDOCUMENTTYPENAME AS PURCHASINGDOCUMENTTYPENAME,
PURCHASINGGROUP,
_PURCHASINGGROUP.PURCHASINGGROUPNAME AS PURCHASINGGROUPNAME,
PURCHASINGORGANIZATION,
_PURCHASINGORGANIZATION.PURCHASINGORGANIZATIONNAME AS PURCHASINGORGANIZATIONNAME,
SUPPLIER,
SUPPLYINGPLANT,
_CREATEDBYUSER.USERDESCRIPTION AS USERDESCRIPTION,
_PURCHASEORDERITEM._PURORDACCOUNTASSIGNMENT._WBSELEMENTBYINTERNALKEY.WBSDESCRIPTION AS WBSDESCRIPTION,
_PURCHASEORDERITEM._PURORDACCOUNTASSIGNMENT.WBSELEMENTEXTERNALID AS WBSELEMENTEXTERNALID,
_PURCHASEORDERITEM._PURORDACCOUNTASSIGNMENT.WBSELEMENTINTERNALID AS WBSELEMENTINTERNALID
FROM R_PURCHASEORDER
LEFT OUTER JOIN N_PAYMENTTERMS AS _PAYMENTTERMS ON PaymentTerms=_PAYMENTTERMS.PaymentTerms -- association [0..1]
LEFT OUTER JOIN dd07t AS _PURCHASEORDERDELETIONCODE ON PurchaseOrderDeletionCode=_PURCHASEORDERDELETIONCODE.domvalue_l AND _PURCHASEORDERDELETIONCODE.domname='MMPUR_PO_DEL_CODE' AND _PURCHASEORDERDELETIONCODE.as4local='A' -- association [0..*]
;Learn More
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA