ESH_N_PURCHASECONTRACT

DDL: ESH_N_PURCHASECONTRACT SQL: ESH_L_PURCTR Type: view
45 Fields 1 Data Sources 1 Associations

ESH_N_PURCHASECONTRACT is a CDS View in SAP S/4HANA. It reads from 1 data source (I_PURCHASECONTRACT) and exposes 45 fields with key field PURCHASECONTRACT. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PURCHASECONTRACT I_PURCHASECONTRACT from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..1] N_PAYMENTTERMS _PAYMENTTERMS $projection.PaymentTerms=_PAYMENTTERMS.PaymentTerms

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
AbapCatalog.sqlViewName ESH_L_PURCTR view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY PURCHASECONTRACT PURCHASECONTRACT Purchasing Doc.
VENDAUTHGRP
MATLTYPAUTHGRP
MATAUTHGRP
COMPANYCODE COMPANYCODE Receiver Company Code
COMPANYCODENAME
CONTRACTNETPRICEAMOUNT _PURCHASECONTRACTITEM CONTRACTNETPRICEAMOUNT Net Price
CREATEDBYUSER CREATEDBYUSER User Name
CREATIONDATE CREATIONDATE Time Stamp
CURRENCY _PURCHASECONTRACTITEM DOCUMENTCURRENCY Document Currency
DOCUMENTCURRENCY DOCUMENTCURRENCY Document Currency
INCOTERMSCLASSIFICATIONNAME
INCOTERMSTRANSFERLOCATION INCOTERMSTRANSFERLOCATION Incoterms 2
MATERIAL _PURCHASECONTRACTITEM MATERIAL Vehicle Model
MATGRPAUTHGRP
MATERIALGROUP _PURCHASECONTRACTITEM MATERIALGROUP Product Group
MATERIALGROUPNAME
MATERIALNAME
NETPRICEQUANTITY _PURCHASECONTRACTITEM NETPRICEQUANTITY Price Unit
ORDERPRICEUNIT _PURCHASECONTRACTITEM ORDERPRICEUNIT Order Price Un.
ORDERQUANTITYUNIT _PURCHASECONTRACTITEM ORDERQUANTITYUNIT Sales Unit
SUPPLIERNAME
PAYMENTTERMS PAYMENTTERMS Pyt Terms
PAYMENTTERMSNAME _PAYMENTTERMS PAYMENTTERMSNAME Description
PLANT _PURCHASECONTRACTITEM PLANT Valuation Area
PLANTNAME
PURCHASECONTRACTITEM _PURCHASECONTRACTITEM PURCHASECONTRACTITEM Item
PURCHASECONTRACTITEMTEXT _PURCHASECONTRACTITEM PURCHASECONTRACTITEMTEXT Short Text
PURCHASECONTRACTTARGETAMOUNT PURCHASECONTRACTTARGETAMOUNT Target Value
PURCHASECONTRACTTYPE PURCHASECONTRACTTYPE Order Type
DELETIONCODEHDR _PURCHASECONTRACTITEM PURCHASINGCONTRACTDELETIONCODE Del. Indicator
PURCHASINGDOCUMENTDELETIONCODE 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
VENDACCTGRP
SUPPLIERPHONENUMBER SUPPLIERPHONENUMBER Telephone
TARGETAMOUNT _PURCHASECONTRACTITEM TARGETAMOUNT Target Value
TARGETQUANTITY _PURCHASECONTRACTITEM TARGETQUANTITY Target Quantity
USERNAME _CREATEDBYUSER USERDESCRIPTION Full Name
VALIDITYENDDATE VALIDITYENDDATE ValidTo
VALIDITYSTARTDATE VALIDITYSTARTDATE Validity Start Date

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_PURCHASECONTRACT.
-- 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_PURCTR
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_PURCHASECONTRACT AS
SELECT
  PURCHASECONTRACT,
  _SUPPLIER[1: SUPPLIERLANGUAGE = $parameters. P_Language].AUTHORIZATIONGROUP AS VENDAUTHGRP,
  _PURCHASECONTRACTITEM._MATERIAL._MATERIALTYPE.AUTHORIZATIONGROUP AS MATLTYPAUTHGRP,
  _PURCHASECONTRACTITEM._MATERIAL.AUTHORIZATIONGROUP AS MATAUTHGRP,
  COMPANYCODE,
  _COMPANYCODE[1: LANGUAGE = $parameters. P_Language].COMPANYCODENAME AS COMPANYCODENAME,
  _PURCHASECONTRACTITEM.CONTRACTNETPRICEAMOUNT AS CONTRACTNETPRICEAMOUNT,
  CREATEDBYUSER,
  CREATIONDATE,
  _PURCHASECONTRACTITEM.DOCUMENTCURRENCY AS CURRENCY,
  DOCUMENTCURRENCY,
  _INCOTERMSCLASSIFICATION._TEXT[1: LANGUAGE = $parameters. P_Language].INCOTERMSCLASSIFICATIONNAME AS INCOTERMSCLASSIFICATIONNAME,
  INCOTERMSTRANSFERLOCATION,
  _PURCHASECONTRACTITEM.MATERIAL AS MATERIAL,
  _PURCHASECONTRACTITEM._MATERIALGROUP.MATERIALAUTHORIZATIONGROUP AS MATGRPAUTHGRP,
  _PURCHASECONTRACTITEM.MATERIALGROUP AS MATERIALGROUP,
  _PURCHASECONTRACTITEM._MATERIALGROUP._TEXT[1: LANGUAGE = $parameters. P_Language].MATERIALGROUPNAME AS MATERIALGROUPNAME,
  _PURCHASECONTRACTITEM._MATERIAL._TEXT[1: LANGUAGE = $parameters. P_Language].MATERIALNAME AS MATERIALNAME,
  _PURCHASECONTRACTITEM.NETPRICEQUANTITY AS NETPRICEQUANTITY,
  _PURCHASECONTRACTITEM.ORDERPRICEUNIT AS ORDERPRICEUNIT,
  _PURCHASECONTRACTITEM.ORDERQUANTITYUNIT AS ORDERQUANTITYUNIT,
  _SUPPLIER[1: SUPPLIERLANGUAGE = $parameters. P_Language].ORGANIZATIONBPNAME1 AS SUPPLIERNAME,
  PAYMENTTERMS,
  _PAYMENTTERMS.PAYMENTTERMSNAME AS PAYMENTTERMSNAME,
  _PURCHASECONTRACTITEM.PLANT AS PLANT,
  _PURCHASECONTRACTITEM._PLANT.PLANTNAME AS PLANTNAME,
  _PURCHASECONTRACTITEM.PURCHASECONTRACTITEM AS PURCHASECONTRACTITEM,
  _PURCHASECONTRACTITEM.PURCHASECONTRACTITEMTEXT AS PURCHASECONTRACTITEMTEXT,
  PURCHASECONTRACTTARGETAMOUNT,
  PURCHASECONTRACTTYPE,
  _PURCHASECONTRACTITEM.PURCHASINGCONTRACTDELETIONCODE AS DELETIONCODEHDR,
  PURCHASINGDOCUMENTDELETIONCODE,
  _PURCHASINGDOCUMENTTYPE._TEXT[1: LANGUAGE = $parameters. P_Language].PURCHASINGDOCUMENTTYPENAME AS PURCHASINGDOCUMENTTYPENAME,
  PURCHASINGGROUP,
  _PURCHASINGGROUP.PURCHASINGGROUPNAME AS PURCHASINGGROUPNAME,
  PURCHASINGORGANIZATION,
  _PURCHASINGORGANIZATION.PURCHASINGORGANIZATIONNAME AS PURCHASINGORGANIZATIONNAME,
  SUPPLIER,
  _SUPPLIER[1: SUPPLIERLANGUAGE = $parameters. P_Language].SUPPLIERACCOUNTGROUP AS VENDACCTGRP,
  SUPPLIERPHONENUMBER,
  _PURCHASECONTRACTITEM.TARGETAMOUNT AS TARGETAMOUNT,
  _PURCHASECONTRACTITEM.TARGETQUANTITY AS TARGETQUANTITY,
  _CREATEDBYUSER.USERDESCRIPTION AS USERNAME,
  VALIDITYENDDATE,
  VALIDITYSTARTDATE
FROM I_PURCHASECONTRACT
LEFT OUTER JOIN N_PAYMENTTERMS AS _PAYMENTTERMS ON PaymentTerms=_PAYMENTTERMS.PaymentTerms  -- association [0..1]
;

Learn More