I_SAFTBillingHeader

DDL: I_SAFTBILLINGHEADER SQL: ISAFTBILLHEADER Type: view BASIC Package: GLO_FIN_IS_SAFT_GEN

SAF-T Billing Header

I_SAFTBillingHeader is a Basic CDS View that provides data about "SAF-T Billing Header" in SAP S/4HANA. It reads from 1 data source (I_BillingDocument) and exposes 37 fields with key field BillingDocument. Part of development package GLO_FIN_IS_SAFT_GEN.

Data Sources (1)

SourceAliasJoin Type
I_BillingDocument a from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISAFTBILLHEADER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label SAF-T Billing Header view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument I_BillingDocument BillingDocument SD Document
BillingDocumentIsCancelled I_BillingDocument BillingDocumentIsCancelled Canceled
CancelledBillingDocument I_BillingDocument CancelledBillingDocument Canceld Bill.Dc
AccountingTransferStatus I_BillingDocument AccountingTransferStatus
BillingDocumentDate I_BillingDocument BillingDocumentDate Billing Date
CreationDate I_BillingDocument CreationDate Time Stamp
CreationTime I_BillingDocument CreationTime Time of Change
SDDocumentCategory I_BillingDocument SDDocumentCategory Document Cat.
BillingDocumentCategory I_BillingDocument BillingDocumentCategory BillingCategory
CreatedByUser I_BillingDocument CreatedByUser User Name
ExchangeRateDate I_BillingDocument ExchangeRateDate Translatn Date
TotalNetAmount I_BillingDocument TotalNetAmount Total Net Amount
TotalTaxAmount I_BillingDocument TotalTaxAmount Tax Amount
TransactionCurrency I_BillingDocument TransactionCurrency Transaction Currency
CustomerPaymentTerms I_BillingDocument CustomerPaymentTerms Pyt Terms
CompanyCode I_BillingDocument CompanyCode Receiver Company Code
CompanyCodeCurrency
PayerParty I_BillingDocument PayerParty Payer
AccountingDocument I_BillingDocument AccountingDocument Journal Entry
FiscalYear I_BillingDocument FiscalYear G/L Fiscal Year
AccountingExchangeRate I_BillingDocument AccountingExchangeRate Exch.Rate Acct.
VATRegistration I_BillingDocument VATRegistration VAT Registration No.
VATRegistrationCountry I_BillingDocument VATRegistrationCountry CtryRgnSlsTxNo.
DocumentReferenceID I_BillingDocument DocumentReferenceID Reference
_CompanyCode _CompanyCode
_AccountingDocument _AccountingDocument
_Tax _Tax
_Settlement _Settlement
_PayerParty _PayerParty
_CancelBillingDocument _CancelBillingDocument
_CancelledBillingDocument _CancelledBillingDocument
_SDDocumentCategory _SDDocumentCategory
_AccountingTransferStatus _AccountingTransferStatus
_TransactionCurrency _TransactionCurrency
_CustomerPaymentTerms _CustomerPaymentTerms
_FiscalYear _FiscalYear
_Partner _Partner

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_SAFTBillingHeader.
-- 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: ISAFTBILLHEADER

CREATE VIEW I_SAFTBillingHeader AS
SELECT
  a.BillingDocument 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 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,
  a.DocumentReferenceID AS DocumentReferenceID
FROM I_BillingDocument AS a
;