I_STRPTAXITEMLOG

CDS View
33 Fields 11 CDS Views

Tax Items log for Statutory Reporting

I_STRPTAXITEMLOG is a CDS View in S/4HANA. Tax Items log for Statutory Reporting. It contains 33 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
C_AT_StRpTaxItemQuery view from CONSUMPTION VAT Tax Item Query for Austria
C_GB_StRpTaxItemBoxCube view from CONSUMPTION VAT Tax Item box level reporting
C_HU_StRpTaxItemBoxCube view from CONSUMPTION Hungary VAT: Tax Items
C_IE_StRpTaxItemCube view from CONSUMPTION IE VAT Return items
C_PT_StRpTaxItemQuery view from CONSUMPTION VAT Tax Item Query for Portugal
C_StRpTaxItemQ view from CONSUMPTION Tax Items for Statutory Reporting
I_PH_StRpTxItmGrpByIndstryCube view from COMPOSITE Tax Item for Philippline
P_GB_StRpRCTaxItemBoxCube view from CONSUMPTION VAT Tax Item box level reporting for Reverse Charge
P_NL_StRpTaxItemCube_Lang view from CONSUMPTION Session Lang. for NL VAT Tax Line Items
P_PH_SalesPurchasesSummaryItem view from COMPOSITE PH Sales Purchase Summary
P_PH_StRpNotRptdTaxItem view from CONSUMPTION Non Reported document for Statutory Reporting of Philippines

Fields (33)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 9
KEY CompanyCode CompanyCode 10
KEY FiscalYear FiscalYear 9
KEY StatryRptCategory StatryRptCategory 4
KEY StatryRptgEntity StatryRptgEntity 4
KEY StatryRptRunID StatryRptRunID 4
KEY TaxBox TaxBox 4
KEY TaxBoxStructureType TaxBoxStructureType 1
KEY TaxCode TaxCode 5
KEY TaxDeclnAmountType TaxDeclnAmountType 3
KEY TaxGroup TaxGroup 2
KEY TaxItem TaxItem 2
KEY TaxItemGroupingVersion TaxItemGroupingVersion 5
KEY TransactionTypeDetermination TransactionTypeDetermination 4
KEY ValidFrom ValidFrom 1
AccountingDocumentType AccountingDocumentType 5
AdditionalCurrency1 AdditionalCurrency1 3
AdditionalCurrency2 AdditionalCurrency2 3
AmountInAdditionalCurrency1 AmountInAdditionalCurrency1 3
AmountInAdditionalCurrency2 AmountInAdditionalCurrency2 3
AmountInTransactionCurrency AmountInTransactionCurrency 3
BusinessPlace BusinessPlace 4
DocumentDate DocumentDate 4
FiscalPeriod FiscalPeriod 4
GLAccount GLAccount 4
PostingDate PostingDate 4
ReportingCurrency currency 1
ReportingDate ReportingDate 3
TaxAmountInRptgCrcy TaxAmountInCoCodeCrcy 1
TaxJurisdiction TaxJurisdiction 3
TaxRate TaxRate 1
TaxReportingDate TaxReportingDate 3
TaxType TaxType 4

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Tax Items log for Statutory Reporting
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_STRPTAXITEMLOG (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    TAXBOX,
    TAXBOXSTRUCTURETYPE,
    TAXCODE,
    TAXDECLNAMOUNTTYPE,
    TAXGROUP,
    TAXITEM,
    TAXITEMGROUPINGVERSION,
    TRANSACTIONTYPEDETERMINATION,
    VALIDFROM,
    ACCOUNTINGDOCUMENTTYPE,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    AMOUNTINADDITIONALCURRENCY1,
    AMOUNTINADDITIONALCURRENCY2,
    AMOUNTINTRANSACTIONCURRENCY,
    BUSINESSPLACE,
    DOCUMENTDATE,
    FISCALPERIOD,
    GLACCOUNT,
    POSTINGDATE,
    REPORTINGCURRENCY,
    REPORTINGDATE,
    TAXAMOUNTINRPTGCRCY,
    TAXJURISDICTION,
    TAXRATE,
    TAXREPORTINGDATE,
    TAXTYPE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, TAXBOX, TAXBOXSTRUCTURETYPE, TAXCODE, TAXDECLNAMOUNTTYPE, TAXGROUP, TAXITEM, TAXITEMGROUPINGVERSION, TRANSACTIONTYPEDETERMINATION, VALIDFROM)
);

Learn More