I_InvoiceList

DDL: I_INVOICELIST Type: view BASIC

Invoice List

I_InvoiceList is a Basic CDS View (Dimension) that provides data about "Invoice List" in SAP S/4HANA. It reads from 1 data source (I_BillingDocumentBasic) and exposes 136 fields with key field InvoiceList. It has 3 associations to related views.

1 data source(s) 136 fields

Data Sources (1)

SourceAliasJoin Type
I_BillingDocumentBasic I_BillingDocumentBasic from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_InvoiceListItem _Item $projection.InvoiceList = _Item.InvoiceList
[1..*] I_InvoiceListPartner _Partner $projection.InvoiceList = _Partner.InvoiceList
[1..1] I_InvoiceListEnhancedFields _EnhancedFields $projection.InvoiceList = _EnhancedFields.InvoiceList

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.compositionRoot true view
ObjectModel.representativeKey InvoiceList view
VDM.viewType #BASIC view
Analytics.dataCategory #DIMENSION view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISDINVOICELIST view
AbapCatalog.preserveKey true view
EndUserText.label Invoice List view
Metadata.allowExtensions true view

Fields (136)

KeyFieldSource TableSource FieldDescription
KEY InvoiceList
SDDocumentCategory SDDocumentCategory
BillingDocumentCategory BillingDocumentCategory
BillingDocumentType BillingDocumentType
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationTime CreationTime
LastChangeDate LastChangeDate
LastChangeDateTime LastChangeDateTime
LogicalSystem LogicalSystem
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
Division Division
BillingDocumentDate BillingDocumentDate
BillingDocumentIsCancelled BillingDocumentIsCancelled
CancelledBillingDocument CancelledBillingDocument
BillingDocCombinationCriteria BillingDocCombinationCriteria
ManualInvoiceMaintIsRelevant ManualInvoiceMaintIsRelevant
NmbrOfPages NmbrOfPages
IsIntrastatReportingRelevant IsIntrastatReportingRelevant
IsIntrastatReportingExcluded IsIntrastatReportingExcluded
TotalNetAmount TotalNetAmount
TransactionCurrency TransactionCurrency
StatisticsCurrency StatisticsCurrency
TotalTaxAmount TotalTaxAmount
CustomerPriceGroup CustomerPriceGroup
PriceListType PriceListType
TaxDepartureCountry TaxDepartureCountry
VATRegistration VATRegistration
VATRegistrationOrigin VATRegistrationOrigin
VATRegistrationCountry VATRegistrationCountry
CustomerTaxClassification1 CustomerTaxClassification1
CustomerTaxClassification2 CustomerTaxClassification2
CustomerTaxClassification3 CustomerTaxClassification3
CustomerTaxClassification4 CustomerTaxClassification4
CustomerTaxClassification5 CustomerTaxClassification5
CustomerTaxClassification6 CustomerTaxClassification6
CustomerTaxClassification7 CustomerTaxClassification7
CustomerTaxClassification8 CustomerTaxClassification8
CustomerTaxClassification9 CustomerTaxClassification9
IsEUTriangularDeal IsEUTriangularDeal
SDPricingProcedure SDPricingProcedure
ShippingCondition ShippingCondition
IncotermsVersion IncotermsVersion
IncotermsClassification IncotermsClassification
IncotermsTransferLocation IncotermsTransferLocation
IncotermsLocation1 IncotermsLocation1
IncotermsLocation2 IncotermsLocation2
PayerParty PayerParty
ContractAccount ContractAccount
CustomerPaymentTerms CustomerPaymentTerms
PaymentMethod PaymentMethod
PaymentReference PaymentReference
FixedValueDate FixedValueDate
AdditionalValueDays AdditionalValueDays
SEPAMandate SEPAMandate
CompanyCode CompanyCode
FiscalYear FiscalYear
AccountingDocument AccountingDocument
FiscalPeriod FiscalPeriod
CustomerAccountAssignmentGroup CustomerAccountAssignmentGroup
AccountingExchangeRateIsSet AccountingExchangeRateIsSet
AccountingExchangeRate AccountingExchangeRate
ExchangeRateDate ExchangeRateDate
ExchangeRateType ExchangeRateType
DocumentReferenceID DocumentReferenceID
AssignmentReference AssignmentReference
DunningArea DunningArea
DunningBlockingReason DunningBlockingReason
DunningKey DunningKey
InternalFinancialDocument InternalFinancialDocument
SoldToParty SoldToParty
PartnerCompany PartnerCompany
PurchaseOrderByCustomer PurchaseOrderByCustomer
CustomerGroup CustomerGroup
Country Country
CityCode CityCode
SalesDistrict SalesDistrict
Region Region
County County
CreditControlArea CreditControlArea
OverallSDProcessStatus OverallSDProcessStatus
OverallBillingStatus OverallBillingStatus
AccountingPostingStatus AccountingPostingStatus
AccountingTransferStatus AccountingTransferStatus
BillingIssueType BillingIssueType
OvrlItmGeneralIncompletionSts OvrlItmGeneralIncompletionSts
OverallPricingIncompletionSts OverallPricingIncompletionSts
_EnhancedFields _EnhancedFields
_Item _Item
_Partner _Partner
_SDDocumentCategory _SDDocumentCategory
_BillingDocumentCategory _BillingDocumentCategory
_BillingDocumentType _BillingDocumentType
_CreatedByUser _CreatedByUser
_LogicalSystem _LogicalSystem
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_TransactionCurrency _TransactionCurrency
_StatisticsCurrency _StatisticsCurrency
_CustomerPriceGroup _CustomerPriceGroup
_PriceListType _PriceListType
_TaxDepartureCountry _TaxDepartureCountry
_VATRegistrationOrigin _VATRegistrationOrigin
_VATRegistrationCountry _VATRegistrationCountry
_SDPricingProcedure _SDPricingProcedure
_ShippingCondition _ShippingCondition
_IncotermsClassification _IncotermsClassification
_IncotermsVersion _IncotermsVersion
_PayerParty _PayerParty
_CustomerPaymentTerms _CustomerPaymentTerms
_PaymentMethod _PaymentMethod
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_AccountingDocument _AccountingDocument
_CustomerAccountAssgmtGroup _CustomerAccountAssgmtGroup
_ExchangeRateType _ExchangeRateType
_DunningArea _DunningArea
_DunningBlockingReason _DunningBlockingReason
_DunningKey _DunningKey
_SoldToParty _SoldToParty
_CustomerGroup _CustomerGroup
_Country _Country
_CityCode _CityCode
_SalesDistrict _SalesDistrict
_Region _Region
_CreditControlArea _CreditControlArea
_OverallSDProcessStatus _OverallSDProcessStatus
_OverallBillingStatus _OverallBillingStatus
_AccountingPostingStatus _AccountingPostingStatus
_AccountingTransferStatus _AccountingTransferStatus
_BillingIssueType _BillingIssueType
_OvrlItmGeneralIncompletionSts _OvrlItmGeneralIncompletionSts
_OverallPricingIncompletionSts _OverallPricingIncompletionSts
_CancelledBillingDocumentBasic _CancelledBillingDocumentBasic 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.compositionRoot: true
@ObjectModel.representativeKey: 'InvoiceList'
@VDM.viewType: #BASIC
@Analytics.dataCategory: #DIMENSION
@AccessControl.authorizationCheck:#CHECK
@AbapCatalog: {
  sqlViewName: 'ISDINVOICELIST',
  preserveKey: true
}
@EndUserText.label: 'Invoice List'
@Metadata.allowExtensions: true
define view I_InvoiceList
    as select from I_BillingDocumentBasic
   
 //Association

  association [0..*] to I_InvoiceListItem    as _Item                          on  $projection.InvoiceList = _Item.InvoiceList
  association [1..*] to I_InvoiceListPartner as _Partner                       on  $projection.InvoiceList = _Partner.InvoiceList    
  
  association [1..1] to I_InvoiceListEnhancedFields      as _EnhancedFields       on  $projection.InvoiceList = _EnhancedFields.InvoiceList
{
      //key

  key cast(BillingDocument as vbeln_rl ) as InvoiceList,       
  

      //category

      SDDocumentCategory,
      BillingDocumentCategory,
      BillingDocumentType,

      //admin

      CreatedByUser,

      CreationDate,
      CreationTime,

      LastChangeDate,
      LastChangeDateTime,

      LogicalSystem,

      //org

      SalesOrganization,
      DistributionChannel,
      Division,

      //billing

      BillingDocumentDate,
      BillingDocumentIsCancelled,
      CancelledBillingDocument,
      BillingDocCombinationCriteria,
      ManualInvoiceMaintIsRelevant,
      NmbrOfPages,
      IsIntrastatReportingRelevant,
      IsIntrastatReportingExcluded,

      //pricing

      TotalNetAmount,
      TransactionCurrency,
      StatisticsCurrency,
      TotalTaxAmount,     
      CustomerPriceGroup,
      PriceListType,
      TaxDepartureCountry,
      VATRegistration,
      VATRegistrationOrigin,
      VATRegistrationCountry,

      CustomerTaxClassification1,
      CustomerTaxClassification2,
      CustomerTaxClassification3,
      CustomerTaxClassification4,
      CustomerTaxClassification5,
      CustomerTaxClassification6,
      CustomerTaxClassification7,
      CustomerTaxClassification8,
      CustomerTaxClassification9,
      IsEUTriangularDeal,

      SDPricingProcedure,

      //shipping

      ShippingCondition,

      IncotermsVersion,


      IncotermsClassification,
      IncotermsTransferLocation,
      IncotermsLocation1,
      IncotermsLocation2,

      //payment      

      PayerParty,
      ContractAccount,
      CustomerPaymentTerms,
      PaymentMethod,
      PaymentReference,
      FixedValueDate,
      AdditionalValueDays,
      SEPAMandate,

      //accounting

      CompanyCode,
      FiscalYear,
      AccountingDocument,
      FiscalPeriod,
      CustomerAccountAssignmentGroup,
      AccountingExchangeRateIsSet,
      AccountingExchangeRate,
      ExchangeRateDate,
      ExchangeRateType,
      DocumentReferenceID,
      AssignmentReference,
      
      DunningArea,      
      
      DunningBlockingReason,
      DunningKey,
      InternalFinancialDocument,
          
      //sales      

      SoldToParty,
      PartnerCompany,
      PurchaseOrderByCustomer,
      CustomerGroup,
      Country,
      CityCode,
      SalesDistrict,
      Region,
      County,
      
      CreditControlArea,
      //SalesDocumentCondition,    TEMP will be renamed to PriceDocument


      //status

      OverallSDProcessStatus,
      OverallBillingStatus,
      AccountingPostingStatus,
      AccountingTransferStatus,
      BillingIssueType,
      OvrlItmGeneralIncompletionSts,
      OverallPricingIncompletionSts,

      //association

      _EnhancedFields,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _Item,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _Partner,
      _SDDocumentCategory,
      _BillingDocumentCategory,
      _BillingDocumentType,
      _CreatedByUser,
      _LogicalSystem,
      _SalesOrganization,
      _DistributionChannel,
      _Division,
      _TransactionCurrency,
      _StatisticsCurrency,
      _CustomerPriceGroup,
      _PriceListType,
      _TaxDepartureCountry,
      _VATRegistrationOrigin,
      _VATRegistrationCountry,
      _SDPricingProcedure,
      _ShippingCondition,
      _IncotermsClassification,
      _IncotermsVersion,
      _PayerParty,
      _CustomerPaymentTerms,
      _PaymentMethod,
      _CompanyCode,
      _FiscalYear,
      _AccountingDocument,
      _CustomerAccountAssgmtGroup,
      _ExchangeRateType,
      _DunningArea,
      _DunningBlockingReason,
      _DunningKey,
      _SoldToParty,
      _CustomerGroup,
      _Country,
      _CityCode,
      _SalesDistrict,
      _Region,
      _CreditControlArea,
      _OverallSDProcessStatus,
      _OverallBillingStatus,
      _AccountingPostingStatus,
      _AccountingTransferStatus,
      _BillingIssueType,
      _OvrlItmGeneralIncompletionSts,
      _OverallPricingIncompletionSts,
      _CancelledBillingDocumentBasic
      
}
where
  SDDocumentCategory = '3' or SDDocumentCategory = '4'
 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLINGDOCUMENTBASIC"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENT",
"I_ACCOUNTINGPOSTINGSTATUS",
"I_ACCOUNTINGTRANSFERSTATUS",
"I_BILLINGDOCUMENTBASIC",
"I_BILLINGDOCUMENTCATEGORY",
"I_BILLINGDOCUMENTTYPE",
"I_BILLINGISSUETYPE",
"I_CITYCODE",
"I_COMPANYCODE",
"I_COUNTRY",
"I_CREDITCONTROLAREA",
"I_CURRENCY",
"I_CUSTOMER",
"I_CUSTOMERACCOUNTASSGMTGROUP",
"I_CUSTOMERGROUP",
"I_CUSTOMERPAYMENTTERMS",
"I_CUSTOMERPRICEGROUP",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_DUNNINGAREA",
"I_DUNNINGBLOCKINGREASONCODE",
"I_DUNNINGKEY",
"I_EXCHANGERATETYPE",
"I_FISCALYEARFORCOMPANYCODE",
"I_INCOTERMSCLASSIFICATION",
"I_INCOTERMSVERSION",
"I_INVOICELISTENHANCEDFIELDS",
"I_INVOICELISTITEM",
"I_INVOICELISTPARTNER",
"I_LOGICALSYSTEM",
"I_OVERALLBILLINGSTATUS",
"I_OVERALLPRCINCOMPLETIONSTS",
"I_OVERALLSDPROCESSSTATUS",
"I_OVRLITMGENINCOMPLETIONSTS",
"I_PAYMENTMETHOD",
"I_PRICELISTTYPE",
"I_REGION",
"I_SALESDISTRICT",
"I_SALESORGANIZATION",
"I_SDDOCUMENTCATEGORY",
"I_SHIPPINGCONDITION",
"I_SLSPRICINGPROCEDURE",
"I_USER",
"I_VATREGISTRATIONORIGIN"
],
"BASE":
[
"I_BILLINGDOCUMENTBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More