I_INVOICELIST

CDS View

Invoice List

I_INVOICELIST is a CDS View in S/4HANA. Invoice List. It contains 34 fields. 10 CDS views read from this table.

Used by 10 CDS view(s) 34 fields

CDS Views using this table (10)

ViewTypeJoinVDMDescription
C_InvoiceListObjPg view from CONSUMPTION
C_InvoiceListWorklist view from CONSUMPTION Invoice List
ESH_N_INVOICELIST view from
I_InvoiceListEnhancedFields view from COMPOSITE Invoice List Enhanced Fields
I_InvoiceListStdVH view from COMPOSITE Invoice List
I_PT_BillgDocCustAddrVers view inner COMPOSITE PT BillingDoc CustAddr Version
I_SAFTBillingCustomer view union COMPOSITE SAF-T Regular Billing Customers
I_SAFTBillingOneTimeCustomer view union COMPOSITE SAF-T Billing OneTimeCustomers
I_SAFTInvoiceListHeader view from BASIC SAF-T Invoice List Header
P_SAFT_BillDocOnInvoiceList view inner COMPOSITE

Fields (34)

KeyField CDS FieldsUsed in Views
KEY BillingDocument BillingDocument 2
KEY CompanyCode CompanyCode 6
KEY FiscalYear FiscalYear 2
KEY InvoiceList BillingDocument,InvoiceList 4
KEY PayerParty Customer,PayerParty 4
_AccountingTransferStatus _AccountingTransferStatus 2
_BillingDocumentType _BillingDocumentType 1
_CancelledBillingDocumentBasic _CancelledBillingDocumentBasic 1
_CompanyCode _CompanyCode 2
_CustomerPaymentTerms _CustomerPaymentTerms 1
_PayerParty _PayerParty 3
_SalesOrganization _SalesOrganization 2
_TransactionCurrency _TransactionCurrency 1
AccountingDocument AccountingDocument 1
AccountingExchangeRate AccountingExchangeRate 1
AccountingTransferStatus AccountingTransferStatus 3
BillingDocumentCategory BillingDocumentCategory 1
BillingDocumentDate BillingDocumentDate,InvoiceDate 4
BillingDocumentIsCancelled BillingDocumentIsCancelled 1
BillingDocumentType BillingDocumentType 1
CancelledBillingDocument CancelledBillingDocument 2
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
CreationTime CreationTime 1
CustomerPaymentTerms CustomerPaymentTerms 2
DocumentReferenceID DocumentReferenceID 2
ExchangeRateDate ExchangeRateDate 1
SalesOrganization SalesOrganization 2
SDDocumentCategory SDDocumentCategory 2
TotalNetAmount TotalNetAmount 3
TotalTaxAmount TotalTaxAmount 3
TransactionCurrency TransactionCurrency 4
VATRegistration VATRegistration 2
VATRegistrationCountry VATRegistrationCountry 1 
@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'

Learn More