ESH_N_BILLINGDOCUMENTREQUEST

DDL: ESH_N_BILLINGDOCUMENTREQUEST SQL: ESH_L_BILDOCREQS Type: view

ESH_N_BILLINGDOCUMENTREQUEST is a CDS View in SAP S/4HANA. It reads from 1 data source (I_BILLINGDOCUMENTREQUEST) and exposes 24 fields with key field BILLINGDOCUMENTREQUEST. It has 2 associations to related views.

1 data source(s) 24 fields

Data Sources (1)

SourceAliasJoin Type
I_BILLINGDOCUMENTREQUEST I_BILLINGDOCUMENTREQUEST 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 _OVRLBILLINGDOCREQSTATUS ( $projection.OverallBillingDocReqStatus=_OVRLBILLINGDOCREQSTATUS.domvalue_l AND _OVRLBILLINGDOCREQSTATUS.domname='BDR_STATUS' AND _OVRLBILLINGDOCREQSTATUS.as4local='A' )

Annotations (8)

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
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ESH_L_BILDOCREQS view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY BILLINGDOCUMENTREQUEST BILLINGDOCUMENTREQUEST
BILLINGDOCUMENTDATE BILLINGDOCUMENTDATE
BILLINGDOCUMENTREQUESTITEMTEXT _ITEM BILLINGDOCUMENTREQUESTITEMTEXT
BILLINGDOCUMENTREQUESTTYPE BILLINGDOCUMENTREQUESTTYPE
PROPOSEDBILLINGDOCUMENTTYPE _PROPOSEDBILLINGDOCUMENTTYPE BILLINGDOCUMENTTYPE
BILDOCTYPENAME
PROPOSEDBILDOCTYPENAME
BILLINGISSUETYPE BILLINGISSUETYPE
BILLINGISSUETYPENAME
SOLDTOPARTYNAME
COMPANYCODE COMPANYCODE
COMPANYCODENAME _COMPANYCODE COMPANYCODENAME
MATERIAL _ITEM MATERIAL
MATERIALNAME
OVERALLBILLINGDOCREQSTATUS OVERALLBILLINGDOCREQSTATUS
OVERALLBILLINGSTATUSDESC
REFERENCEDOCUMENT REFERENCEDOCUMENT
REFERENCEDOCUMENTLOGICALSYSTEM REFERENCEDOCUMENTLOGICALSYSTEM
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: #REQUIRED
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'ESH_L_BILDOCREQS'
define view ESH_N_BILLINGDOCUMENTREQUEST
 with parameters
 @Consumption.hidden: true
 @Environment.systemField: #SYSTEM_LANGUAGE
 P_Language: abap.lang
as select from I_BILLINGDOCUMENTREQUEST
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 _OVRLBILLINGDOCREQSTATUS on ( $projection.OverallBillingDocReqStatus=_OVRLBILLINGDOCREQSTATUS.domvalue_l AND  _OVRLBILLINGDOCREQSTATUS.domname='BDR_STATUS' AND  _OVRLBILLINGDOCREQSTATUS.as4local='A' ) {

key BILLINGDOCUMENTREQUEST,

BILLINGDOCUMENTDATE,

_ITEM.BILLINGDOCUMENTREQUESTITEMTEXT,

BILLINGDOCUMENTREQUESTTYPE,

_PROPOSEDBILLINGDOCUMENTTYPE.BILLINGDOCUMENTTYPE as PROPOSEDBILLINGDOCUMENTTYPE,

_BILLINGDOCUMENTREQUESTTYPE._TEXT[1: LANGUAGE = $parameters. P_Language].BILLINGDOCUMENTTYPENAME as BILDOCTYPENAME,

_PROPOSEDBILLINGDOCUMENTTYPE._TEXT[1: LANGUAGE = $parameters. P_Language].BILLINGDOCUMENTTYPENAME as PROPOSEDBILDOCTYPENAME,

BILLINGISSUETYPE,

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

_SOLDTOPARTY._STANDARDADDRESS.BUSINESSPARTNERNAME1 as SOLDTOPARTYNAME,

COMPANYCODE,

_COMPANYCODE.COMPANYCODENAME,

_ITEM.MATERIAL,

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

OVERALLBILLINGDOCREQSTATUS,

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

REFERENCEDOCUMENT,

REFERENCEDOCUMENTLOGICALSYSTEM,

SALESORGANIZATION,

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

SOLDTOPARTY,

TOTALNETAMOUNT,

TOTALTAXAMOUNT,

TRANSACTIONCURRENCY
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS",
"I_BILLINGDOCUMENTREQUEST",
"I_BILLINGDOCUMENTREQUESTITEM",
"I_BILLINGDOCUMENTTYPE",
"I_BILLINGDOCUMENTTYPETEXT",
"I_COMPANYCODE",
"I_CUSTOMER",
"I_MATERIAL",
"I_MATERIALTEXT",
"I_SALESORGANIZATION",
"I_SALESORGANIZATIONTEXT",
"DD07T"
],
"ASSOCIATED":
[
"DD07T"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More