I_TAXREPORTINGDATESTRPACTIVITY

CDS View

Tax Reporting Date Log

I_TAXREPORTINGDATESTRPACTIVITY is a CDS View in S/4HANA. Tax Reporting Date Log. It contains 3 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 3 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_LtstTaxReportingDateStRpActy view from BASIC Latest Tax Reporting Date Statutory Reporting Act
P_TxDocStRpActy0 view union COMPOSITE

Fields (3)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1 
@AbapCatalog.sqlViewName: 'ISTRPTAXREPDTLOG'
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Tax Reporting Date Log'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.representativeKey: 'ChangedOnDateTime'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

define view I_TaxReportingDateStRpActivity as select from figld_taxdoc_log as taxdoclog
   
    association [1..1] to I_AccountingDocument    as _AccountingDocument on $projection.CompanyCode        = _AccountingDocument.CompanyCode and
                                                                            $projection.AccountingDocument = _AccountingDocument.AccountingDocument and
                                                                            $projection.FiscalYear         = _AccountingDocument.FiscalYear 
    association [1..1] to I_CompanyCode           as _CompanyCode        on $projection.CompanyCode        = _CompanyCode.CompanyCode     
    association [0..1] to I_FiscalYearForCompanyCode   as _FiscalYear    on $projection.FiscalYear  = _FiscalYear.FiscalYear and
                                                                            $projection.CompanyCode = _FiscalYear.CompanyCode                                                                   
    
  {
 
    @ObjectModel.foreignKey.association: '_CompanyCode'
  key bukrs as CompanyCode, 
    @ObjectModel.foreignKey.association: '_AccountingDocument'
  key belnr as AccountingDocument,
    @ObjectModel.foreignKey.association: '_FiscalYear'
  key gjahr as FiscalYear, 
  key changed_on as ChangedOnDateTime,
  taxdoclog.changed_by          as LastChangedByUser,
  taxdoclog.old_vatdate         as OldTaxReportingDate,  
  taxdoclog.new_vatdate         as NewTaxReportingDate,  
  taxdoclog.original_vatdate    as OriginalTaxReportingDate, 
  taxdoclog.status_incl_excl    as TaxItemIsIncluded,
  taxdoclog.comments            as Comments,
  _AccountingDocument as _AccountingDocument,
  _CompanyCode        as _CompanyCode,
  _FiscalYear         as _FiscalYear
}


/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FIGLD_TAXDOC_LOG"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENT",
"I_COMPANYCODE",
"I_FISCALYEARFORCOMPANYCODE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More