ESH_N_CONTRACTACCOUNT

DDL: ESH_N_CONTRACTACCOUNT SQL: ESH_L_CONTRACTAC Type: view

ESH_N_CONTRACTACCOUNT is a CDS View in SAP S/4HANA. It reads from 1 data source (I_CONTRACTACCOUNTPARTNER) and exposes 15 fields with key fields BUSINESSPARTNER, CONTRACTACCOUNT.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_CONTRACTACCOUNTPARTNER I_CONTRACTACCOUNTPARTNER from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ESH_L_CONTRACTAC view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY BUSINESSPARTNER BUSINESSPARTNER
KEY CONTRACTACCOUNT CONTRACTACCOUNT
CAAUTHORIZATIONGROUP CAAUTHORIZATIONGROUP
CABUSINESSPARTNERFORPAYMENT CABUSINESSPARTNERFORPAYMENT
CACOMPANYCODEGROUP CACOMPANYCODEGROUP
CACOMPANYCODEGROUPNAME
CACORRESPONDENCEVARIANTNAME
CADUNNINGPROCEDURENAME
CAINVCGCATEGORYTEXT
CARELATIONSHIPOFBPTOCONTRACCT CARELATIONSHIPOFBPTOCONTRACCT
CARELSHPOFBPTOCONTRACCTNAME
CONTRACTACCOUNTCATEGORY
CONTRACTACCOUNTCATEGORYNAME
CONTRACTACCOUNTNAME CONTRACTACCOUNTNAME
PAYMENTCONDITIONNAME 
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #P
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.sqlViewName: 'ESH_L_CONTRACTAC'
define view ESH_N_CONTRACTACCOUNT
 with parameters
 @Consumption.hidden: true
 @Environment.systemField: #SYSTEM_LANGUAGE
 P_Language: abap.lang
as select from I_CONTRACTACCOUNTPARTNER {

key BUSINESSPARTNER,

key CONTRACTACCOUNT,

CAAUTHORIZATIONGROUP,

CABUSINESSPARTNERFORPAYMENT,

CACOMPANYCODEGROUP,

_COMPCODEGROUP._TEXT[1: LANGUAGE = $parameters. P_Language].CACOMPANYCODEGROUPNAME,

_CORRVARIANT._TEXT[1: LANGUAGE = $parameters. P_Language].CACORRESPONDENCEVARIANTNAME,

_DUNNINGPROCEDURE._TEXT[1: LANGUAGE = $parameters. P_Language].CADUNNINGPROCEDURENAME,

_INVCGCATEGORY._CAINVCGCATEGORYTEXT[1: LANGUAGE = $parameters. P_Language].CAINVCGCATEGORYTEXT,

CARELATIONSHIPOFBPTOCONTRACCT,

_RELSHPOFBP._TEXT[1: LANGUAGE = $parameters. P_Language].CARELSHPOFBPTOCONTRACCTNAME,

CASTANDARDCOMPANYCODE,

_CONTRACC._CATEGORY.CONTRACTACCOUNTCATEGORY,

_CONTRACC._CATEGORY._TEXT[1: LANGUAGE = $parameters. P_Language].CONTRACTACCOUNTCATEGORYNAME,

CONTRACTACCOUNTNAME,

_PAYMENTCONDITION._TEXT[1: LANGUAGE = $parameters. P_Language].PAYMENTCONDITIONNAME
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CACOMPANYCODEGROUP",
"I_CACOMPANYCODEGROUPTEXT",
"I_CACORRESPONDENCEVARIANT",
"I_CACORRESPONDENCEVARIANTTEXT",
"I_CADUNNINGPROCEDURE",
"I_CADUNNINGPROCEDURETEXT",
"I_CAINVCGCATEGORY",
"I_CAINVCGCATEGORYTEXT",
"I_CONTRACCTPRTNRELSHPTYPE",
"I_CONTRACCTPRTNRELSHPTYPETXT",
"I_CONTRACTACCOUNTCATEGORY",
"I_CONTRACTACCOUNTCATEGORYTEXT",
"I_CONTRACTACCOUNTHEADER",
"I_CONTRACTACCOUNTPARTNER",
"I_PAYMENTCONDITION",
"I_PAYMENTCONDITIONTEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More