ESH_N_INVOICELIST

DDL: ESH_N_INVOICELIST SQL: ESH_L_INVLIST Type: view Package: BSESH_SD_BIL

Anchor view -INVOICELIST

ESH_N_INVOICELIST is a CDS View that provides data about "Anchor view -INVOICELIST" in SAP S/4HANA. It reads from 1 data source (I_INVOICELIST) and exposes 14 fields with key field INVOICELIST. It has 1 association to related views. Part of development package BSESH_SD_BIL.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_INVOICELIST I_INVOICELIST from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..*] dd07t _ACCOUNTINGTRANSFERSTATUS $projection.AccountingTransferStatus=_ACCOUNTINGTRANSFERSTATUS.domvalue_l and _ACCOUNTINGTRANSFERSTATUS.domname='RFBSK' and _ACCOUNTINGTRANSFERSTATUS.as4local='A'

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ESH_L_INVLIST view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY INVOICELIST INVOICELIST
ACCOUNTINGTRANSFERSTATUS ACCOUNTINGTRANSFERSTATUS
ACCOUNTINGTRANSFERSTATUSDESC
BILLINGDOCUMENT _ITEM BILLINGDOCUMENT
PAYERPARTYNAME
BILLINGDOCUMENTDATE INVOICELISTBILLINGDATE
BILLINGDOCUMENTTYPE INVOICELISTTYPE
BILLINGDOCUMENTTYPENAME
PAYERPARTY PAYERPARTY
SALESORGANIZATION SALESORGANIZATION
SALESORGANIZATIONNAME
TOTALNETAMOUNT TOTALNETAMOUNT
TOTALTAXAMOUNT TOTALTAXAMOUNT
TRANSACTIONCURRENCY TRANSACTIONCURRENCY 
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.sqlViewName: 'ESH_L_INVLIST'
define view ESH_N_INVOICELIST
 with parameters
 @Consumption.hidden: true
 @Environment.systemField: #SYSTEM_LANGUAGE
 P_Language: abap.lang
as select from I_INVOICELIST
association [0..*] to dd07t as _ACCOUNTINGTRANSFERSTATUS on  $projection.AccountingTransferStatus=_ACCOUNTINGTRANSFERSTATUS.domvalue_l and  _ACCOUNTINGTRANSFERSTATUS.domname='RFBSK' and  _ACCOUNTINGTRANSFERSTATUS.as4local='A'  {

key INVOICELIST,

ACCOUNTINGTRANSFERSTATUS,

_ACCOUNTINGTRANSFERSTATUS[1: ddlanguage = $parameters. P_Language].ddtext as ACCOUNTINGTRANSFERSTATUSDESC,

_ITEM.BILLINGDOCUMENT,

_PAYERPARTY._STANDARDADDRESS.BUSINESSPARTNERNAME1 as PAYERPARTYNAME,

INVOICELISTBILLINGDATE as BILLINGDOCUMENTDATE,

INVOICELISTTYPE as BILLINGDOCUMENTTYPE,

_INVOICELISTTYPE._TEXT[1: LANGUAGE = $parameters. P_Language].INVOICELISTTYPENAME as BILLINGDOCUMENTTYPENAME,

PAYERPARTY,

SALESORGANIZATION,

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

TOTALNETAMOUNT,

TOTALTAXAMOUNT,

TRANSACTIONCURRENCY
}

Learn More