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 13 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 13 fields

CDS Views using this table (1)

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

Fields (13)

KeyField CDS FieldsUsed in Views
_CompanyCode _CompanyCode 1
_PayerParty _PayerParty 1
BillingDocument BillingDocument 1
BillingDocumentCategory BillingDocumentCategory 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
@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