I_SAFTInvoiceListHeader

DDL: I_SAFTINVOICELISTHEADER SQL: ISAFTINVLISTH Type: view BASIC Package: GLO_FIN_IS_SAFT_GEN

SAF-T Invoice List Header

I_SAFTInvoiceListHeader is a Basic CDS View that provides data about "SAF-T Invoice List Header" in SAP S/4HANA. It reads from 1 data source (I_InvoiceList) and exposes 36 fields with key field BillingDocument. It has 3 associations to related views. Part of development package GLO_FIN_IS_SAFT_GEN.

1 data source(s) 36 fields

Data Sources (1)

SourceAliasJoin Type
I_InvoiceList a from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_SAFTBillingHeaderTaxCheck _TaxCheck $projection.BillingDocument = _TaxCheck.BillingDocument
[0..1] I_InvoiceList _CancelBillingDocument _CancelBillingDocument.CancelledInvoiceList = $projection.BillingDocument
[0..1] I_SAFTBillingPaymentTerms _Settlement $projection.BillingDocument = _Settlement.BillingDocument and $projection.CustomerPaymentTerms = _Settlement.PaymentTerms

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISAFTINVLISTH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label SAF-T Invoice List Header view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument
BillingDocumentIsCancelled I_InvoiceList InvoiceListIsCancelled
CancelledBillingDocument I_InvoiceList CancelledInvoiceList
AccountingTransferStatus I_InvoiceList AccountingTransferStatus
BillingDocumentDate I_InvoiceList InvoiceListBillingDate
CreationDate I_InvoiceList CreationDate
CreationTime I_InvoiceList CreationTime
SDDocumentCategory I_InvoiceList SDDocumentCategory
CreatedByUser I_InvoiceList CreatedByUser
ExchangeRateDate I_InvoiceList ExchangeRateDate
TotalNetAmount I_InvoiceList TotalNetAmount
TotalTaxAmount I_InvoiceList TotalTaxAmount
TransactionCurrency I_InvoiceList TransactionCurrency
CustomerPaymentTerms I_InvoiceList CustomerPaymentTerms
CompanyCode I_InvoiceList CompanyCode
CompanyCodeCurrency
PayerParty I_InvoiceList PayerParty
AccountingDocument I_InvoiceList AccountingDocument
FiscalYear I_InvoiceList FiscalYear
AccountingExchangeRate I_InvoiceList AccountingExchangeRate
VATRegistration I_InvoiceList VATRegistration
VATRegistrationCountry I_InvoiceList VATRegistrationCountry
_CompanyCode _CompanyCode
_Currency _CompanyCode _Currency
_AccountingDocument _AccountingDocument
_TaxCheck _TaxCheck
_Settlement _Settlement
_PayerParty _PayerParty
_CancelBillingDocument _CancelBillingDocument
_VATRegistrationCountry _VATRegistrationCountry
Currency _CompanyCode Currency
_SDDocumentCategory _SDDocumentCategory
_AccountingTransferStatus _AccountingTransferStatus
_TransactionCurrency _TransactionCurrency
_CustomerPaymentTerms _CustomerPaymentTerms
_FiscalYear _FiscalYear 
@AbapCatalog.sqlViewName: 'ISAFTINVLISTH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck:#MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_INCLUDED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'SAF-T Invoice List Header'
define view I_SAFTInvoiceListHeader
  as select from I_InvoiceList as a
  association [0..1] to I_SAFTBillingHeaderTaxCheck as _TaxCheck              on  $projection.BillingDocument = _TaxCheck.BillingDocument
  association [0..1] to I_InvoiceList               as _CancelBillingDocument on  _CancelBillingDocument.CancelledInvoiceList = $projection.BillingDocument //a.InvoiceList   //VDM

  association [0..1] to I_SAFTBillingPaymentTerms   as _Settlement            on  $projection.BillingDocument      = _Settlement.BillingDocument
                                                                              and $projection.CustomerPaymentTerms = _Settlement.PaymentTerms


{

  key cast (a.InvoiceList  as vbeln_vf) as BillingDocument,

      a.InvoiceListIsCancelled          as BillingDocumentIsCancelled, //VDM

      a.CancelledInvoiceList            as CancelledBillingDocument, //VDM

      a.AccountingTransferStatus        as AccountingTransferStatus,

      a.InvoiceListBillingDate          as BillingDocumentDate, //VDM

      a.CreationDate                    as CreationDate,
      a.CreationTime                    as CreationTime,

      a.SDDocumentCategory              as SDDocumentCategory,
      //      a.BillingDocumentCategory    as BillingDocumentCategory,  //VDM


      a.CreatedByUser                   as CreatedByUser,

      a.ExchangeRateDate,
      a.TotalNetAmount,
      a.TotalTaxAmount,
      a.TransactionCurrency,

      a.CustomerPaymentTerms            as CustomerPaymentTerms,

      a.CompanyCode                     as CompanyCode,
      a._CompanyCode.Currency           as CompanyCodeCurrency,
      a.PayerParty,
      a.AccountingDocument,
      a.FiscalYear,

      a.AccountingExchangeRate,

      a.VATRegistration,
      a.VATRegistrationCountry,

      //Associations

      _CompanyCode,
      //      _CancelledBillingDocumentBasic,

      _CompanyCode._Currency,
      //      _BillingDocumentCategory,  VDM

      _AccountingDocument,
      _TaxCheck,
      _Settlement,
      _PayerParty,
      _CancelBillingDocument,
      _VATRegistrationCountry,
      _CompanyCode.Currency,
      _SDDocumentCategory,
      _AccountingTransferStatus,
      _TransactionCurrency,
      _CustomerPaymentTerms,
      _FiscalYear
}

Learn More