I_SAFTInvoiceListHeader

DDL: I_SAFTINVOICELISTHEADER SQL: ISAFTINVLISTH Type: view BASIC
35 Fields 1 Data Sources 2 Associations

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

Data Sources (1)

SourceAliasJoin Type
I_InvoiceList a from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_SAFTBillingHeaderTaxCheck _TaxCheck $projection.BillingDocument = _TaxCheck.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 (35)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument
BillingDocumentIsCancelled I_InvoiceList InvoiceListIsCancelled
CancelledBillingDocument I_InvoiceList CancelledInvoiceList
AccountingTransferStatus I_InvoiceList AccountingTransferStatus
BillingDocumentDate I_InvoiceList InvoiceListBillingDate Billing Date
CreationDate I_InvoiceList CreationDate Time Stamp
CreationTime I_InvoiceList CreationTime Time of Change
SDDocumentCategory I_InvoiceList SDDocumentCategory Document Cat.
CreatedByUser I_InvoiceList CreatedByUser User Name
ExchangeRateDate I_InvoiceList ExchangeRateDate Translatn Date
TotalNetAmount I_InvoiceList TotalNetAmount Total Net Amount
TotalTaxAmount I_InvoiceList TotalTaxAmount Tax Amount
TransactionCurrency I_InvoiceList TransactionCurrency Transaction Currency
CustomerPaymentTerms I_InvoiceList CustomerPaymentTerms Pyt Terms
CompanyCode I_InvoiceList CompanyCode Receiver Company Code
CompanyCodeCurrency
PayerParty I_InvoiceList PayerParty Payer
AccountingDocument I_InvoiceList AccountingDocument Journal Entry
FiscalYear I_InvoiceList FiscalYear G/L Fiscal Year
AccountingExchangeRate I_InvoiceList AccountingExchangeRate Exch.Rate Acct.
VATRegistration I_InvoiceList VATRegistration VAT Registration No.
VATRegistrationCountry I_InvoiceList VATRegistrationCountry CtryRgnSlsTxNo.
_CompanyCode _CompanyCode
_Currency _CompanyCode _Currency
_AccountingDocument _AccountingDocument
_TaxCheck _TaxCheck
_Settlement _Settlement
_PayerParty _PayerParty
_VATRegistrationCountry _VATRegistrationCountry
Currency _CompanyCode Currency Valuation Crcy
_SDDocumentCategory _SDDocumentCategory
_AccountingTransferStatus _AccountingTransferStatus
_TransactionCurrency _TransactionCurrency
_CustomerPaymentTerms _CustomerPaymentTerms
_FiscalYear _FiscalYear

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_SAFTInvoiceListHeader.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ISAFTINVLISTH

CREATE VIEW I_SAFTInvoiceListHeader AS
SELECT
  cast (a.InvoiceList as vbeln_vf) AS BillingDocument,
  a.InvoiceListIsCancelled AS BillingDocumentIsCancelled,
  a.CancelledInvoiceList AS CancelledBillingDocument,
  a.AccountingTransferStatus AS AccountingTransferStatus,
  a.InvoiceListBillingDate AS BillingDocumentDate,
  a.CreationDate AS CreationDate,
  a.CreationTime AS CreationTime,
  a.SDDocumentCategory AS SDDocumentCategory,
  a.CreatedByUser AS CreatedByUser,
  a.ExchangeRateDate AS ExchangeRateDate,
  a.TotalNetAmount AS TotalNetAmount,
  a.TotalTaxAmount AS TotalTaxAmount,
  a.TransactionCurrency AS TransactionCurrency,
  a.CustomerPaymentTerms AS CustomerPaymentTerms,
  a.CompanyCode AS CompanyCode,
  a._CompanyCode.Currency AS CompanyCodeCurrency,
  a.PayerParty AS PayerParty,
  a.AccountingDocument AS AccountingDocument,
  a.FiscalYear AS FiscalYear,
  a.AccountingExchangeRate AS AccountingExchangeRate,
  a.VATRegistration AS VATRegistration,
  a.VATRegistrationCountry AS VATRegistrationCountry,
  _CompanyCode._Currency AS _Currency,
  _CompanyCode.Currency AS Currency
FROM I_InvoiceList AS a
LEFT OUTER JOIN I_SAFTBillingHeaderTaxCheck AS _TaxCheck ON BillingDocument = _TaxCheck.BillingDocument  -- association [0..1]
LEFT OUTER JOIN I_SAFTBillingPaymentTerms AS _Settlement ON BillingDocument = _Settlement.BillingDocument AND CustomerPaymentTerms = _Settlement.PaymentTerms  -- association [0..1]
;

Learn More