ESH_S_CENTRL_PURCHASE_CONTRACT

DDL: ESH_S_CENTRL_PURCHASE_CONTRACT SQL: ESH_U_CPCTR Type: view
31 Fields 1 Data Sources

ESH_S_CENTRL_PURCHASE_CONTRACT is a CDS View in SAP S/4HANA. It reads from 1 data source (ESH_N_CENTRL_PURCHASE_CONTRACT) and exposes 31 fields with key field CENTRALPURCHASECONTRACT.

Data Sources (1)

SourceAliasJoin Type
ESH_N_CENTRL_PURCHASE_CONTRACT ESH_N_CENTRL_PURCHASE_CONTRACT from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (18)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.modelingPattern #ENTERPRISE_SEARCH_PROVIDER view
Metadata.allowExtensions true view
Search.searchable true view
EnterpriseSearch.enabled true view
ObjectModel.sapObjectNodeType.name CentralPurchaseContract view
UI.headerInfo.typeName Central Purchase Contract view
UI.headerInfo.typeNamePlural Central Purchase Contracts view
Consumption.semanticObject CentralPurchaseContract view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value PURCHASINGDOCUMENTNAME view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_CPCTR view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY CENTRALPURCHASECONTRACT CENTRALPURCHASECONTRACT Central Contract Number
COMPANYCODE COMPANYCODE Central Company Code
COMPANYCODENAME COMPANYCODENAME Central Company Code Name
CREATEDBYUSER CREATEDBYUSER User Name
CREATIONDATE CREATIONDATE Time Stamp
CURRENCY CURRENCY Valuation Crcy
DOCUMENTSTATUSNAME DOCUMENTSTATUSNAME Status Text
MATERIALGROUP MATERIALGROUP Product Group
ORGANIZATIONBPNAME1 ORGANIZATIONBPNAME1 Supplier Name
PAYMENTTERMS PAYMENTTERMS Terms of Payment
PAYMENTTERMSNAME PAYMENTTERMSNAME Description
PRODUCTGROUPNAME PRODUCTGROUPNAME Material Group Name
PURCHASECONTRACTITEMTEXT PURCHASECONTRACTITEMTEXT Material Name
PURCHASECONTRACTTARGETAMOUNT PURCHASECONTRACTTARGETAMOUNT Target Value
PURCHASECONTRACTTYPE PURCHASECONTRACTTYPE Central Document Type
PURCHASINGCENTRALMATERIAL PURCHASINGCENTRALMATERIAL Material
PURCHASINGDOCUMENTNAME PURCHASINGDOCUMENTNAME Purch. Doc. Name
PURCHASINGDOCUMENTSTATUS PURCHASINGDOCUMENTSTATUS Short Description
PURCHASINGDOCUMENTSUBTYPE PURCHASINGDOCUMENTSUBTYPE Control
PURCHASINGDOCUMENTTYPENAME PURCHASINGDOCUMENTTYPENAME Central Document Type Name
PURCHASINGGROUP PURCHASINGGROUP Purchasing Group
PURCHASINGGROUPNAME PURCHASINGGROUPNAME Central Purchasing Group
PURCHASINGORGANIZATION PURCHASINGORGANIZATION Purchasing Organization
PURCHASINGORGANIZATIONNAME PURCHASINGORGANIZATIONNAME Central Purchasing Org
PURCHASINGPARENTDOCUMENT PURCHASINGPARENTDOCUMENT Parent Document ID
PURCHASINGPROCESSINGSTATUS PURCHASINGPROCESSINGSTATUS Status
PURGDOCCHANGEREQUESTSTATUS PURGDOCCHANGEREQUESTSTATUS Change Request Stat.
SUPPLIER SUPPLIER Supplier
USERDESCRIPTION USERDESCRIPTION Full Name
VALIDITYENDDATE VALIDITYENDDATE ValidTo
VALIDITYSTARTDATE VALIDITYSTARTDATE Validity Period (From/To)

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_S_CENTRL_PURCHASE_CONTRACT.
-- 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_U_CPCTR
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_CENTRL_PURCHASE_CONTRACT AS
SELECT
  CENTRALPURCHASECONTRACT,
  COMPANYCODE,
  COMPANYCODENAME,
  CREATEDBYUSER,
  CREATIONDATE,
  CURRENCY,
  DOCUMENTSTATUSNAME,
  MATERIALGROUP,
  ORGANIZATIONBPNAME1,
  PAYMENTTERMS,
  PAYMENTTERMSNAME,
  PRODUCTGROUPNAME,
  PURCHASECONTRACTITEMTEXT,
  PURCHASECONTRACTTARGETAMOUNT,
  PURCHASECONTRACTTYPE,
  PURCHASINGCENTRALMATERIAL,
  PURCHASINGDOCUMENTNAME,
  PURCHASINGDOCUMENTSTATUS,
  PURCHASINGDOCUMENTSUBTYPE,
  PURCHASINGDOCUMENTTYPENAME,
  PURCHASINGGROUP,
  PURCHASINGGROUPNAME,
  PURCHASINGORGANIZATION,
  PURCHASINGORGANIZATIONNAME,
  PURCHASINGPARENTDOCUMENT,
  PURCHASINGPROCESSINGSTATUS,
  PURGDOCCHANGEREQUESTSTATUS,
  SUPPLIER,
  USERDESCRIPTION,
  VALIDITYENDDATE,
  VALIDITYSTARTDATE
FROM ESH_N_CENTRL_PURCHASE_CONTRACT
;

Learn More