I_SAFTBillingHeader

DDL: I_SAFTBILLINGHEADER SQL: ISAFTBILLHEADER Type: view BASIC

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 36 fields with key field BillingDocument.

1 data source(s) 36 fields

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 (36)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument I_BillingDocument BillingDocument
BillingDocumentIsCancelled I_BillingDocument BillingDocumentIsCancelled
CancelledBillingDocument I_BillingDocument CancelledBillingDocument
AccountingTransferStatus I_BillingDocument AccountingTransferStatus
BillingDocumentDate I_BillingDocument BillingDocumentDate
CreationDate I_BillingDocument CreationDate
CreationTime I_BillingDocument CreationTime
SDDocumentCategory I_BillingDocument SDDocumentCategory
BillingDocumentCategory I_BillingDocument BillingDocumentCategory
CreatedByUser I_BillingDocument CreatedByUser
ExchangeRateDate I_BillingDocument ExchangeRateDate
TotalNetAmount I_BillingDocument TotalNetAmount
TotalTaxAmount I_BillingDocument TotalTaxAmount
TransactionCurrency I_BillingDocument TransactionCurrency
CustomerPaymentTerms I_BillingDocument CustomerPaymentTerms
CompanyCode I_BillingDocument CompanyCode
CompanyCodeCurrency
PayerParty I_BillingDocument PayerParty
AccountingDocument I_BillingDocument AccountingDocument
FiscalYear I_BillingDocument FiscalYear
AccountingExchangeRate I_BillingDocument AccountingExchangeRate
VATRegistration I_BillingDocument VATRegistration
VATRegistrationCountry I_BillingDocument VATRegistrationCountry
_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 
@AbapCatalog.sqlViewName: 'ISAFTBILLHEADER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_INCLUDED
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'SAF-T Billing Header'
define view I_SAFTBillingHeader
  as select from I_BillingDocument as a
  association[0..1] to I_SAFTBillingHeaderTaxCheck as _Tax on $projection.BillingDocument = _Tax.BillingDocument
  association[0..1] to I_BillingDocument           as _CancelBillingDocument      on  _CancelBillingDocument.CancelledBillingDocument = a.BillingDocument  
  association[0..1] to I_SAFTBillingPaymentTerms   as _Settlement on $projection.BillingDocument = _Settlement.BillingDocument and
                                                             $projection.CustomerPaymentTerms = _Settlement.PaymentTerms
  

{

  key a.BillingDocument                                                                                                                                                            as BillingDocument,

      a.BillingDocumentIsCancelled                                                                                                                                                 as BillingDocumentIsCancelled,
      a.CancelledBillingDocument                                                                                                                                                   as CancelledBillingDocument,
      //Required for Cancelled Proforma Invoices

      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,
      _AccountingDocument,
      _Tax,
      _Settlement,
      _PayerParty,
      _CancelBillingDocument,
      _CancelledBillingDocument,
      _SDDocumentCategory,
      _AccountingTransferStatus,
      _TransactionCurrency,
      _CustomerPaymentTerms,
      _FiscalYear,
      _Partner
      }
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLINGDOCUMENT",
"I_COMPANYCODE"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENT",
"I_ACCOUNTINGTRANSFERSTATUS",
"I_BILLINGDOCUMENT",
"I_BILLINGDOCUMENTPARTNER",
"I_COMPANYCODE",
"I_CURRENCY",
"I_CUSTOMER",
"I_CUSTOMERPAYMENTTERMS",
"I_FISCALYEARFORCOMPANYCODE",
"I_SAFTBILLINGHEADERTAXCHECK",
"I_SAFTBILLINGPAYMENTTERMS",
"I_SDDOCUMENTCATEGORY"
],
"BASE":
[
"I_BILLINGDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More