ESH_N_SALESCONTRACT

DDL: ESH_N_SALESCONTRACT SQL: ESH_L_SLSCONTRCT Type: view

ESH_N_SALESCONTRACT is a CDS View in SAP S/4HANA. It reads from 1 data source (I_SALESCONTRACT) and exposes 34 fields with key field SALESCONTRACT. It has 3 associations to related views.

1 data source(s) 34 fields

Data Sources (1)

SourceAliasJoin Type
I_SALESCONTRACT I_SALESCONTRACT from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (3)

CardinalityTargetAliasCondition
[0..1] N_OVERALLSDDOCREFERENCESTATUS _OVERALLSDDOCREFERENCESTATUS $projection.OverallSDDocReferenceStatus=_OVERALLSDDOCREFERENCESTATUS.OverallSDDocReferenceStatus
[0..1] N_OVERALLSDPROCESSSTATUS _OVERALLSDPROCESSSTATUS $projection.OverallSDProcessStatus=_OVERALLSDPROCESSSTATUS.OverallSDProcessStatus
[0..1] N_OVERALLSDDOCUMENTRJCNSTATUS _OVERALLSDDOCUMENTREJECTIONSTS $projection.OverallSDDocumentRejectionSts=_OVERALLSDDOCUMENTREJECTIONSTS.OverallSDDocumentRejectionSts

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ESH_L_SLSCONTRCT view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY SALESCONTRACT SALESCONTRACT
BUSINESSPARTNERNAME1
SHIPTOPARTYNAME1
BUSINESSPARTNERNAME2
SHIPTOPARTYNAME2
CREATEDBYUSER CREATEDBYUSER
DISTRIBUTIONCHANNEL DISTRIBUTIONCHANNEL
DISTRIBUTIONCHANNELNAME
DIVISIONNAME
MASTERSALESCONTRACT MASTERSALESCONTRACT
MATERIAL _ITEM MATERIAL
MATERIALBYCUSTOMER _ITEM MATERIALBYCUSTOMER
MATERIALNAME
ORGANIZATIONDIVISION ORGANIZATIONDIVISION
OVERALLSDDOCREFERENCESTATUS OVERALLSDDOCREFERENCESTATUS
OVERALLSDDOCREFSTATUSDESC
OVERALLSDDOCUMENTREJECTIONSTS OVERALLSDDOCUMENTREJECTIONSTS
OVERALLSDPROCESSSTATUS OVERALLSDPROCESSSTATUS
OVERALLSDPROCESSSTATUSDESC
OVRLSDDOCUMENTREJECTIONSTSDESC
PURCHASEORDERBYCUSTOMER PURCHASEORDERBYCUSTOMER
SALESCONTRACTDATE SALESCONTRACTDATE
SALESCONTRACTITEMTEXT _ITEM SALESCONTRACTITEMTEXT
SALESCONTRACTTYPE SALESCONTRACTTYPE
SALESCONTRACTVALIDITYENDDATE SALESCONTRACTVALIDITYENDDATE
SALESCONTRACTVALIDITYSTARTDATE SALESCONTRACTVALIDITYSTARTDATE
SALESDOCUMENTTYPENAME
SALESORGANIZATION SALESORGANIZATION
SALESORGANIZATIONNAME
SHIPTOPARTY _STANDARDPARTNER SHIPTOPARTY
SOLDTOPARTY SOLDTOPARTY
TOTALNETAMOUNT TOTALNETAMOUNT
TRANSACTIONCURRENCY TRANSACTIONCURRENCY
USERDESCRIPTION _CREATEDBYUSER USERDESCRIPTION 
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #P
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'ESH_L_SLSCONTRCT'
define view ESH_N_SALESCONTRACT
 with parameters
 @Consumption.hidden: true
 @Environment.systemField: #SYSTEM_LANGUAGE
 P_Language: abap.lang
as select from I_SALESCONTRACT
association [0..1] to N_OVERALLSDDOCREFERENCESTATUS as _OVERALLSDDOCREFERENCESTATUS on  $projection.OverallSDDocReferenceStatus=_OVERALLSDDOCREFERENCESTATUS.OverallSDDocReferenceStatus 
association [0..1] to N_OVERALLSDPROCESSSTATUS as _OVERALLSDPROCESSSTATUS on  $projection.OverallSDProcessStatus=_OVERALLSDPROCESSSTATUS.OverallSDProcessStatus 
association [0..1] to N_OVERALLSDDOCUMENTRJCNSTATUS as _OVERALLSDDOCUMENTREJECTIONSTS on  $projection.OverallSDDocumentRejectionSts=_OVERALLSDDOCUMENTREJECTIONSTS.OverallSDDocumentRejectionSts 
 {

key SALESCONTRACT,

_SOLDTOPARTY._STANDARDADDRESS.BUSINESSPARTNERNAME1,

_STANDARDPARTNER._SHIPTOPARTY._STANDARDADDRESS.BUSINESSPARTNERNAME1 as SHIPTOPARTYNAME1,

_SOLDTOPARTY._STANDARDADDRESS.BUSINESSPARTNERNAME2,

_STANDARDPARTNER._SHIPTOPARTY._STANDARDADDRESS.BUSINESSPARTNERNAME2 as SHIPTOPARTYNAME2,

CREATEDBYUSER,

DISTRIBUTIONCHANNEL,

_DISTRIBUTIONCHANNEL._TEXT[1: Language = $parameters. P_Language].DISTRIBUTIONCHANNELNAME,

_ORGANIZATIONDIVISION._TEXT[1: Language = $parameters. P_Language].DIVISIONNAME,

MASTERSALESCONTRACT,

_ITEM.MATERIAL,

_ITEM.MATERIALBYCUSTOMER,

_ITEM._MATERIAL._TEXT[1: Language = $parameters. P_Language].MATERIALNAME,

ORGANIZATIONDIVISION,

OVERALLSDDOCREFERENCESTATUS as OVERALLSDDOCREFERENCESTATUS,

_OVERALLSDDOCREFERENCESTATUS[1: Language = $parameters. P_Language].OVERALLSDDOCREFSTATUSDESC,

OVERALLSDDOCUMENTREJECTIONSTS as OVERALLSDDOCUMENTREJECTIONSTS,

OVERALLSDPROCESSSTATUS as OVERALLSDPROCESSSTATUS,

_OVERALLSDPROCESSSTATUS[1: Language = $parameters. P_Language].OVERALLSDPROCESSSTATUSDESC,

_OVERALLSDDOCUMENTREJECTIONSTS[1: Language = $parameters. P_Language].OVRLSDDOCUMENTREJECTIONSTSDESC,

PURCHASEORDERBYCUSTOMER,

SALESCONTRACTDATE,

_ITEM.SALESCONTRACTITEMTEXT,

SALESCONTRACTTYPE,

SALESCONTRACTVALIDITYENDDATE,

SALESCONTRACTVALIDITYSTARTDATE,

_SALESCONTRACTTYPE._TEXT[1: Language = $parameters. P_Language].SALESDOCUMENTTYPENAME,

SALESORGANIZATION,

_SALESORGANIZATION._TEXT[1: Language = $parameters. P_Language].SALESORGANIZATIONNAME,

_STANDARDPARTNER.SHIPTOPARTY,

SOLDTOPARTY,

TOTALNETAMOUNT,

TRANSACTIONCURRENCY,

_CREATEDBYUSER.USERDESCRIPTION
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS",
"I_CUSTOMER",
"I_DISTRIBUTIONCHANNEL",
"I_DISTRIBUTIONCHANNELTEXT",
"I_DIVISION",
"I_DIVISIONTEXT",
"I_MATERIAL",
"I_MATERIALTEXT",
"I_SALESCONTRACT",
"I_SALESCONTRACTITEM",
"I_SALESCONTRACTTYPE",
"I_SALESDOCUMENTSTANDARDPARTNER",
"I_SALESDOCUMENTTYPETEXT",
"I_SALESORGANIZATION",
"I_SALESORGANIZATIONTEXT",
"I_USER",
"N_OVERALLSDDOCREFERENCESTATUS",
"N_OVERALLSDDOCUMENTRJCNSTATUS",
"N_OVERALLSDPROCESSSTATUS"
],
"ASSOCIATED":
[
"N_OVERALLSDDOCREFERENCESTATUS",
"N_OVERALLSDDOCUMENTRJCNSTATUS",
"N_OVERALLSDPROCESSSTATUS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More