ESH_N_RECONTRACT

DDL: ESH_N_RECONTRACT SQL: ESH_L_RECONTRACT Type: view

ESH_N_RECONTRACT is a CDS View in SAP S/4HANA. It reads from 1 data source (I_RECONTRACT) and exposes 25 fields with key field INTERNALREALESTATENUMBER.

1 data source(s) 25 fields

Data Sources (1)

SourceAliasJoin Type
I_RECONTRACT I_RECONTRACT from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ESH_L_RECONTRACT view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY INTERNALREALESTATENUMBER INTERNALREALESTATENUMBER
COMPANYCODE COMPANYCODE
COMPANYCODENAME _COMPANYCODE COMPANYCODENAME
CONTRACTENDDATE CONTRACTENDDATE
CONTRACTSTARTDATE CONTRACTSTARTDATE
FIRSTNAME
GROUPBUSINESSPARTNERNAME1
GROUPBUSINESSPARTNERNAME2
ISBUSINESSPURPOSECOMPLETED
LASTNAME
ORGANIZATIONBPNAME1
ORGANIZATIONBPNAME2
ORGANIZATIONBPNAME3
ORGANIZATIONBPNAME4
PERSONFULLNAME
PLAINLONGTEXT
REALESTATECONTRACT REALESTATECONTRACT
REALESTATECONTRACTOID REALESTATECONTRACTOID
REAUTHORIZATIONGROUP REAUTHORIZATIONGROUP
RECONTRACTNAME RECONTRACTNAME
RECONTRACTSUBJECTDESCRIPTION
RECONTRACTSUBJECTTYPENAME
RECONTRACTTYPE RECONTRACTTYPE
RECONTRACTTYPENAME
USERDESCRIPTION _CREATEDBYUSER USERDESCRIPTION 
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.sqlViewName: 'ESH_L_RECONTRACT'
define view ESH_N_RECONTRACT
 with parameters
 @Consumption.hidden: true
 @Environment.systemField: #SYSTEM_LANGUAGE
 P_Language: abap.lang
as select from I_RECONTRACT {

key INTERNALREALESTATENUMBER,

COMPANYCODE,

_COMPANYCODE.COMPANYCODENAME,

CONTRACTENDDATE,

CONTRACTSTARTDATE,

_REPARTNERASSGMT._BUSINESSPARTNER.FIRSTNAME,

_REPARTNERASSGMT._BUSINESSPARTNER.GROUPBUSINESSPARTNERNAME1,

_REPARTNERASSGMT._BUSINESSPARTNER.GROUPBUSINESSPARTNERNAME2,

_REPARTNERASSGMT._BUSINESSPARTNER.ISBUSINESSPURPOSECOMPLETED,

_REPARTNERASSGMT._BUSINESSPARTNER.LASTNAME,

_REPARTNERASSGMT._BUSINESSPARTNER.ORGANIZATIONBPNAME1,

_REPARTNERASSGMT._BUSINESSPARTNER.ORGANIZATIONBPNAME2,

_REPARTNERASSGMT._BUSINESSPARTNER.ORGANIZATIONBPNAME3,

_REPARTNERASSGMT._BUSINESSPARTNER.ORGANIZATIONBPNAME4,

_REPARTNERASSGMT._BUSINESSPARTNER.PERSONFULLNAME,

_REREMINDERRULE._REREMINDERDATE._REREMINDERLONGTEXT[1: LANGUAGE = $parameters. P_Language].PLAINLONGTEXT,

REALESTATECONTRACT,

REALESTATECONTRACTOID,

REAUTHORIZATIONGROUP,

RECONTRACTNAME,

_REOBJECTASSGMT._RECONTRACTSUBJECT.RECONTRACTSUBJECTDESCRIPTION,

_REOBJECTASSGMT._RECONTRACTSUBJECT._RECONTRACTSUBJECTTYPE._TEXT[1: LANGUAGE = $parameters. P_Language].RECONTRACTSUBJECTTYPENAME,

RECONTRACTTYPE,

_RECONTRACTTYPE._TEXT[1: LANGUAGE = $parameters. P_Language].RECONTRACTTYPENAME,

_CREATEDBYUSER.USERDESCRIPTION
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_COMPANYCODE",
"I_RECONTRACT",
"I_RECONTRACTSUBJECT",
"I_RECONTRACTSUBJECTTYPE",
"I_RECONTRACTSUBJECTTYPETEXT",
"I_RECONTRACTTYPE",
"I_RECONTRACTTYPETEXT",
"I_REOBJECTASSGMT",
"I_REPARTNERASSGMT",
"I_REREMINDERDATE",
"I_REREMINDEROBJRULE",
"I_TEXTOBJECTPLAINLONGTEXT",
"I_USER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More