ESH_N_BILLINGDOCUMENT

DDL: ESH_N_BILLINGDOCUMENT SQL: ESH_L_BILLGDOC Type: view

ESH_N_BILLINGDOCUMENT is a CDS View in SAP S/4HANA. It reads from 1 data source (I_BILLINGDOCUMENT) and exposes 28 fields with key field BILLINGDOCUMENT. It has 2 associations to related views.

1 data source(s) 28 fields

Data Sources (1)

SourceAliasJoin Type
I_BILLINGDOCUMENT I_BILLINGDOCUMENT from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (2)

CardinalityTargetAliasCondition
[0..*] dd07t _BILLINGISSUETYPE $projection.BillingIssueType=_BILLINGISSUETYPE.domvalue_l and _BILLINGISSUETYPE.domname='VF_TODO' and _BILLINGISSUETYPE.as4local='A'
[0..*] dd07t _OVERALLBILLINGSTATUS ( $projection.OverallBillingStatus=_OVERALLBILLINGSTATUS.domvalue_l AND _OVERALLBILLINGSTATUS.domname='VF_STATUS' AND _OVERALLBILLINGSTATUS.as4local='A' )

Annotations (7)

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

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY BILLINGDOCUMENT BILLINGDOCUMENT
BILLINGDOCUMENTDATE BILLINGDOCUMENTDATE
BILLINGDOCUMENTISTEMPORARY BILLINGDOCUMENTISTEMPORARY
BILLINGDOCUMENTITEMTEXT _ITEM BILLINGDOCUMENTITEMTEXT
BILLINGDOCUMENTTYPE BILLINGDOCUMENTTYPE
BILLINGDOCUMENTTYPENAME
BILLINGISSUETYPE BILLINGISSUETYPE
BILLINGISSUETYPENAME
BILLTOPARTY _ENHANCEDFIELDS BILLTOPARTY
SOLDTOPARTYNAME
PAYERPARTYNAME
BILLTOPARTYNAME
COMPANYCODE COMPANYCODE
COMPANYCODENAME _COMPANYCODE COMPANYCODENAME
CUSTOMERPAYMENTTERMS CUSTOMERPAYMENTTERMS
CUSTOMERPAYMENTTERMSNAME
DOCUMENTREFERENCEID DOCUMENTREFERENCEID
MATERIAL _ITEM MATERIAL
MATERIALNAME
OVERALLBILLINGSTATUS OVERALLBILLINGSTATUS
OVERALLBILLINGSTATUSDESC
PAYERPARTY PAYERPARTY
SALESORGANIZATION SALESORGANIZATION
SALESORGANIZATIONNAME
SOLDTOPARTY SOLDTOPARTY
TOTALNETAMOUNT TOTALNETAMOUNT
TOTALTAXAMOUNT TOTALTAXAMOUNT
TRANSACTIONCURRENCY TRANSACTIONCURRENCY 
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #P
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'ESH_L_BILLGDOC'
define view ESH_N_BILLINGDOCUMENT
 with parameters
 @Consumption.hidden: true
 @Environment.systemField: #SYSTEM_LANGUAGE
 P_Language: abap.lang
as select from I_BILLINGDOCUMENT
association [0..*] to dd07t as _BILLINGISSUETYPE on  $projection.BillingIssueType=_BILLINGISSUETYPE.domvalue_l and  _BILLINGISSUETYPE.domname='VF_TODO' and  _BILLINGISSUETYPE.as4local='A' association [0..*] to dd07t as _OVERALLBILLINGSTATUS on ( $projection.OverallBillingStatus=_OVERALLBILLINGSTATUS.domvalue_l AND  _OVERALLBILLINGSTATUS.domname='VF_STATUS' AND  _OVERALLBILLINGSTATUS.as4local='A' ) {

key BILLINGDOCUMENT,

BILLINGDOCUMENTDATE,

BILLINGDOCUMENTISTEMPORARY,

_ITEM.BILLINGDOCUMENTITEMTEXT,

BILLINGDOCUMENTTYPE,

_BILLINGDOCUMENTTYPE._TEXT[1: Language = $parameters. P_Language].BILLINGDOCUMENTTYPENAME,

BILLINGISSUETYPE,

_BILLINGISSUETYPE[1: ddlanguage = $parameters. P_Language].ddtext as BILLINGISSUETYPENAME,

_ENHANCEDFIELDS.BILLTOPARTY,

_SOLDTOPARTY._STANDARDADDRESS.BUSINESSPARTNERNAME1 as SOLDTOPARTYNAME,

_PAYERPARTY._STANDARDADDRESS.BUSINESSPARTNERNAME1 as PAYERPARTYNAME,

_ENHANCEDFIELDS._BILLTOPARTY._STANDARDADDRESS.BUSINESSPARTNERNAME1 as BILLTOPARTYNAME,

COMPANYCODE,

_COMPANYCODE.COMPANYCODENAME,

CUSTOMERPAYMENTTERMS,

_CUSTOMERPAYMENTTERMS._TEXT[1: Language = $parameters. P_Language].CUSTOMERPAYMENTTERMSNAME,

DOCUMENTREFERENCEID,

_ITEM.MATERIAL,

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

OVERALLBILLINGSTATUS,

_OVERALLBILLINGSTATUS[1: ddlanguage = $parameters. P_Language].ddtext as OVERALLBILLINGSTATUSDESC,

PAYERPARTY,

SALESORGANIZATION,

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

SOLDTOPARTY,

TOTALNETAMOUNT,

TOTALTAXAMOUNT,

TRANSACTIONCURRENCY
}where BillingDocumentIsTemporary = ' '
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS",
"I_BILLINGDOCENHANCEDFIELDS",
"I_BILLINGDOCUMENT",
"I_BILLINGDOCUMENTITEM",
"I_BILLINGDOCUMENTTYPE",
"I_BILLINGDOCUMENTTYPETEXT",
"I_COMPANYCODE",
"I_CUSTOMER",
"I_CUSTOMERPAYMENTTERMS",
"I_CUSTOMERPAYMENTTERMSTEXT",
"I_MATERIAL",
"I_MATERIALTEXT",
"I_SALESORGANIZATION",
"I_SALESORGANIZATIONTEXT",
"DD07T"
],
"ASSOCIATED":
[
"DD07T"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More