ESH_S_CENTRL_PURCHASE_CONTRACT

DDL: ESH_S_CENTRL_PURCHASE_CONTRACT SQL: ESH_U_CPCTR Type: view Package: APPL_MM_PUR_OA_CCTR
33 Fields 1 Data Sources

Search view -CENTRL_PURCHASE_CONTRACT

ESH_S_CENTRL_PURCHASE_CONTRACT is a CDS View that provides data about "Search view -CENTRL_PURCHASE_CONTRACT" in SAP S/4HANA. It reads from 1 data source (ESH_N_CENTRL_PURCHASE_CONTRACT) and exposes 33 fields with key field CENTRALPURCHASECONTRACT. Part of development package APPL_MM_PUR_OA_CCTR.

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 (33)

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
EXTCONTRACTFORPURG EXTCONTRACTFORPURG Outline Agreement
ITEMDISTRIBUTIONSTATUSNAME ITEMDISTRIBUTIONSTATUSNAME Outline Agreement Distribution Status
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,
  EXTCONTRACTFORPURG,
  ITEMDISTRIBUTIONSTATUSNAME,
  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