I_STRPTAXITEMBOXCUBE

CDS View
77 Fields 18 CDS Views

VAT Tax Item box level reporting

I_STRPTAXITEMBOXCUBE is a CDS View in S/4HANA. VAT Tax Item box level reporting. It contains 77 fields. 18 CDS views read from this table.

CDS Views using this table (18)

ViewTypeJoinVDMDescription
C_CA_StRpGSTItemCube view from CONSUMPTION Canada GST Tax Item Details
C_CH_VATTaxItemCube view from CONSUMPTION Tax Items log for Statutory Reporting for Switzerland
C_CO_DIANVatTaxReturnBoxLog view_entity from CONSUMPTION Colombia DIAN VAT Tax Box Item Log
C_NL_StRpAcceptedTaxItemCube view inner CONSUMPTION [Obsolete] NL VAT - Reported Tax Items
C_StRpTaxItemBoxQuery view from CONSUMPTION Analytical Query for Box Reporting
I_FR_DueDeferredTaxItemCube view from COMPOSITE Deferred Tax Item Cube
I_SG_StRpTaxItemCube view from COMPOSITE Tax Items for Singapore Statutory Reporting
I_StRpTaxItemLog view from COMPOSITE Tax Items log for Statutory Reporting
I_ZA_StRpRevenueExpenseLineC view from COMPOSITE South Africa Revenue Expense Lines
P_AU_StRpBASItem view union_all COMPOSITE
P_ID_STRPTAXITEMGROUP view from COMPOSITE
P_MY_STRPTaxItem view from CONSUMPTION Tax Items for Malaysia Statutory Reporting
P_PH_CapitalGoodsItem view from COMPOSITE
P_PH_STRPTaxItems view from COMPOSITE
P_RO_StRpSalesPurchaseBox view from CONSUMPTION Data selection for the RO SPJ
P_StRpAdvncRetForSlsAndPurTx view from COMPOSITE
P_StRpTaxItemCount view from CONSUMPTION
P_TH_StRpTaxPaymentItem view from COMPOSITE

Fields (77)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 16
KEY CompanyCode CompanyCode,CompanyCode2 16
KEY DebitCreditCode DebitCreditCode 1
KEY FiscalYear FiscalYear 15
KEY PostingDate PostingDate 8
KEY TaxBox TaxBox 6
KEY TaxBoxStructureType TaxBoxStructureType 4
KEY TaxCode TaxCode 14
KEY TaxDeclnAmountType TaxDeclnAmountType 6
KEY TaxGroup TaxGroup 3
KEY TaxItem TaxItem 10
KEY TaxItemGroupingVersion TaxItemGroupingVersion 9
KEY TransactionTypeDetermination TransactionTypeDetermination 11
KEY ValidFrom ValidFrom 4
_AccountingDocument _AccountingDocument 3
_DebtorCreditorRblsPyblsItem _DebtorCreditorRblsPyblsItem 1
_GLAccount _GLAccount 3
_ReceivablesPayablesItem _ReceivablesPayablesItem 1
_ReportedItemsLog _ReportedItemsLog 1
_ReportingCurrency _ReportingCurrency 1
_TaxCalculationProcedure _TaxCalculationProcedure 1
_TaxJurisdiction _TaxJurisdiction 1
_TaxReceivablesPayablesItem _TaxReceivablesPayablesItem 1
AccountingDocumentHeaderText AccountingDocumentHeaderText 1
AccountingDocumentType AccountingDocumentType 7
AdditionalCurrency1 AdditionalCurrency1 3
AdditionalCurrency2 AdditionalCurrency2 3
AmountInAdditionalCurrency1 AmountInAdditionalCurrency1 2
AmountInAdditionalCurrency2 AmountInAdditionalCurrency2 2
AmountInReportingCurrency AmountInReportingCurrency 1
AmountInTransactionCurrency AmountInTransactionCurrency 2
BusinessPartner BusinessPartner 2
BusinessPartnerCountry BusinessPartnerCountry 1
BusinessPartnerName BusinessPartnerName 1
BusinessPlace BusinessPlace 6
CAReconciliationKey CAReconciliationKey 1
CompanyCodeCountry CompanyCodeCountry 1
CompanyCodeCurrency CompanyCodeCurrency 9
ConditionType ConditionType 1
CountryCurrency CountryCurrency 3
DocumentCurrency DocumentCurrency 7
DocumentDate DocumentDate 7
DocumentReferenceID DocumentReferenceID 1
EUTaxClassification EUTaxClassification 1
ExchangeRate ExchangeRate 1
FiscalPeriod FiscalPeriod 4
GLAccount GLAccount 6
IsReversal IsReversal 1
IsReversed IsReversed 1
LowestLevelTaxJurisdiction LowestLevelTaxJurisdiction 2
ReferenceDocumentType ReferenceDocumentType 2
ReportingCountry ReportingCountry 1
ReportingCurrency ReportingCurrency 4
ReportingDate ReportingDate 6
SenderAccountingDocument SenderAccountingDocument 1
SenderCompanyCode SenderCompanyCode 1
SenderFiscalYear SenderFiscalYear 1
StatryRptRun StatryRptRun 1
TargetTaxCode TargetTaxCode 2
TaxAmount TaxAmount 6
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 7
TaxAmountInRptgCrcy TaxAmountInRptgCrcy 3
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 7
TaxBaseAmountInRptgCrcy TaxBaseAmountInRptgCrcy 3
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy 5
TaxCalculationProcedure TaxCalculationProcedure 8
TaxCountry TaxCountry 2
TaxItemGroup TaxItemGroup 4
TaxJurisdiction TaxJurisdiction 6
TaxNumber1 TaxNumber1 1
TaxNumber2 TaxNumber2 1
TaxNumber3 TaxNumber3 1
TaxRate TaxRate 2
TaxReportingDate TaxReportingDate 4
TaxReportingDocumentDate TaxReportingDocumentDate 1
TaxReturnCountry TaxReturnCountry 2
TaxType TaxType 13

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.

-- VAT Tax Item box level reporting
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_STRPTAXITEMBOXCUBE (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    DEBITCREDITCODE,
    FISCALYEAR,
    POSTINGDATE,
    TAXBOX,
    TAXBOXSTRUCTURETYPE,
    TAXCODE,
    TAXDECLNAMOUNTTYPE,
    TAXGROUP,
    TAXITEM,
    TAXITEMGROUPINGVERSION,
    TRANSACTIONTYPEDETERMINATION,
    VALIDFROM,
    _ACCOUNTINGDOCUMENT,
    _DEBTORCREDITORRBLSPYBLSITEM,
    _GLACCOUNT,
    _RECEIVABLESPAYABLESITEM,
    _REPORTEDITEMSLOG,
    _REPORTINGCURRENCY,
    _TAXCALCULATIONPROCEDURE,
    _TAXJURISDICTION,
    _TAXRECEIVABLESPAYABLESITEM,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTTYPE,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    AMOUNTINADDITIONALCURRENCY1,
    AMOUNTINADDITIONALCURRENCY2,
    AMOUNTINREPORTINGCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BUSINESSPARTNER,
    BUSINESSPARTNERCOUNTRY,
    BUSINESSPARTNERNAME,
    BUSINESSPLACE,
    CARECONCILIATIONKEY,
    COMPANYCODECOUNTRY,
    COMPANYCODECURRENCY,
    CONDITIONTYPE,
    COUNTRYCURRENCY,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    EUTAXCLASSIFICATION,
    EXCHANGERATE,
    FISCALPERIOD,
    GLACCOUNT,
    ISREVERSAL,
    ISREVERSED,
    LOWESTLEVELTAXJURISDICTION,
    REFERENCEDOCUMENTTYPE,
    REPORTINGCOUNTRY,
    REPORTINGCURRENCY,
    REPORTINGDATE,
    SENDERACCOUNTINGDOCUMENT,
    SENDERCOMPANYCODE,
    SENDERFISCALYEAR,
    STATRYRPTRUN,
    TARGETTAXCODE,
    TAXAMOUNT,
    TAXAMOUNTINCOCODECRCY,
    TAXAMOUNTINRPTGCRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINRPTGCRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXCALCULATIONPROCEDURE,
    TAXCOUNTRY,
    TAXITEMGROUP,
    TAXJURISDICTION,
    TAXNUMBER1,
    TAXNUMBER2,
    TAXNUMBER3,
    TAXRATE,
    TAXREPORTINGDATE,
    TAXREPORTINGDOCUMENTDATE,
    TAXRETURNCOUNTRY,
    TAXTYPE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, DEBITCREDITCODE, FISCALYEAR, POSTINGDATE, TAXBOX, TAXBOXSTRUCTURETYPE, TAXCODE, TAXDECLNAMOUNTTYPE, TAXGROUP, TAXITEM, TAXITEMGROUPINGVERSION, TRANSACTIONTYPEDETERMINATION, VALIDFROM)
);

Learn More