I_SAFTInvoiceListHeader

DDL: I_SAFTINVOICELISTHEADER SQL: ISAFTINVLISTH Type: view BASIC

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 39 fields with key field BillingDocument. It has 3 associations to related views.

1 data source(s) 39 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.CancelledBillingDocument = a.InvoiceList
[0..1] I_SAFTBillingPaymentTerms _Settlement $projection.BillingDocument = _Settlement.BillingDocument and $projection.CustomerPaymentTerms = _Settlement.PaymentTerms

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISAFTINVLISTH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK 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 (39)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument I_InvoiceList InvoiceList
BillingDocumentIsCancelled I_InvoiceList BillingDocumentIsCancelled
CancelledBillingDocument I_InvoiceList CancelledBillingDocument
AccountingTransferStatus I_InvoiceList AccountingTransferStatus
BillingDocumentDate I_InvoiceList BillingDocumentDate
CreationDate I_InvoiceList CreationDate
CreationTime I_InvoiceList CreationTime
SDDocumentCategory I_InvoiceList SDDocumentCategory
BillingDocumentCategory I_InvoiceList BillingDocumentCategory
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
_CancelledBillingDocumentBasic _CancelledBillingDocumentBasic
_Currency _CompanyCode _Currency
_BillingDocumentCategory _BillingDocumentCategory
_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
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck:#CHECK 
@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.CancelledBillingDocument = a.InvoiceList
  association [0..1] to I_SAFTBillingPaymentTerms   as _Settlement            on  $projection.BillingDocument      = _Settlement.BillingDocument
                                                                              and $projection.CustomerPaymentTerms = _Settlement.PaymentTerms


{

  key a.InvoiceList                as BillingDocument,

      a.BillingDocumentIsCancelled as BillingDocumentIsCancelled,
      a.CancelledBillingDocument   as CancelledBillingDocument,
      a.AccountingTransferStatus   as AccountingTransferStatus,

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

      a.SDDocumentCategory         as SDDocumentCategory,
      a.BillingDocumentCategory    as BillingDocumentCategory,

      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,
      _AccountingDocument,
      _TaxCheck,
      _Settlement,
      _PayerParty,
      _CancelBillingDocument,
      _VATRegistrationCountry,
      _CompanyCode.Currency,
      _SDDocumentCategory,
      _AccountingTransferStatus,
      _TransactionCurrency,
      _CustomerPaymentTerms,
      _FiscalYear
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_INVOICELIST"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENT",
"I_ACCOUNTINGTRANSFERSTATUS",
"I_BILLINGDOCUMENTBASIC",
"I_BILLINGDOCUMENTCATEGORY",
"I_COMPANYCODE",
"I_COUNTRY",
"I_CURRENCY",
"I_CUSTOMER",
"I_CUSTOMERPAYMENTTERMS",
"I_FISCALYEARFORCOMPANYCODE",
"I_INVOICELIST",
"I_SAFTBILLINGHEADERTAXCHECK",
"I_SAFTBILLINGPAYMENTTERMS",
"I_SDDOCUMENTCATEGORY"
],
"BASE":
[
"I_COMPANYCODE",
"I_INVOICELIST"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More