I_SAFTINVOICELISTHEADER

CDS View

SAF-T Invoice List Header

I_SAFTINVOICELISTHEADER is a CDS View in S/4HANA. SAF-T Invoice List Header. It contains 12 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 12 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PT_SAFTInvoiceListHeader view from COMPOSITE SAF-T PT Invoice List Header

Fields (12)

KeyField CDS FieldsUsed in Views
_CompanyCode _CompanyCode 1
_PayerParty _PayerParty 1
BillingDocument BillingDocument 1
BillingDocumentDate BillingDocumentDate 1
BillingDocumentIsCancelled BillingDocumentIsCancelled 1
CompanyCode CompanyCode 1
CreatedByUser CreatedByUser 1
CustomerPaymentTerms CustomerPaymentTerms 1
ExchangeRateDate ExchangeRateDate 1
FiscalYear FiscalYear 1
PayerParty PayerParty 1
SDDocumentCategory SDDocumentCategory 1 
@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