I_STRPTAXRETURNBOXCUBE

CDS View
89 Fields 45 CDS Views

Cube View to Return Tax Details with TaxBox configuration

I_STRPTAXRETURNBOXCUBE is a CDS View in S/4HANA. Cube View to Return Tax Details with TaxBox configuration. It contains 89 fields. 45 CDS views read from this table.

CDS Views using this table (45)

ViewTypeJoinVDMDescription
C_AT_TaxReturnBoxQuery view from CONSUMPTION Tax Items for Austria
C_AU_StRpTaxItemCube view from CONSUMPTION Consumtion View for Australia VAT Tax Line Item
C_BE_TaxReturnBoxCube view from CONSUMPTION ATR enabled tax Items for BE VAT Return
C_CH_TaxReturnBoxCube view from CONSUMPTION ATR enabled Tax Items for Swiss Cube
C_DE_TaxReturnBoxQuery view from CONSUMPTION Query Tax Items for Germany
C_DK_TaxReturnBoxQuery view from CONSUMPTION Tax Items for Denmark
C_FI_TaxReturnBoxQuery view from CONSUMPTION Tax Items for Finnland
C_FR_TaxReturnBoxCube view from CONSUMPTION ATR enabled Tax Items for France Cube
C_IT_TaxReturnBoxCube view from CONSUMPTION Tax Items for Italy
C_LU_TaxReturnBoxCube view from CONSUMPTION Tax Items for Luxembourg Cube
C_NO_TaxReturnBoxCube view from CONSUMPTION ATR enabled Tax Items for Norway - Cube
C_PT_TaxReturnBoxQuery view from CONSUMPTION Tax Items for Portugal - Query
C_PT_TaxReturnBoxQuery_2 view from CONSUMPTION ATR enabled tax Items for Portugal - Query
C_SE_TaxReturnBoxQuery view from CONSUMPTION Query Tax Items for Sweden
C_StRpTaxItemBoxLogQuery view from CONSUMPTION Analytical Query for Box Reporting With Rptd Item Log Data
C_StRpTaxReturnBoxQuery view from CONSUMPTION Analytical Query Tax Return info with TaxBox configuration
I_BG_StRpVATDeclaration view from COMPOSITE VAT Declaration for BG
I_DueDeferredTaxItemCube view from COMPOSITE View to display Due Deferred Tax Items
I_MY_STRPTaxItem view from COMPOSITE Tax Items for Malaysia Statutory Reporting
I_PH_TaxReturnItemGroupCube view from COMPOSITE Tax Item for Philippline
I_PT_TaxReturnAnnex view_entity from COMPOSITE FI and FICA tax items for PT Annexes
I_SG_StRpTaxReturnCube view from COMPOSITE Tax Return Items for Singapore Statutory Reporting
I_ZA_StRpTaxReturnBoxCube view from COMPOSITE South Africa VAT Report
P_CO_DIANVatTaxReturnBox view_entity inner COMPOSITE
P_ES_TaxReturnBoxATR view from CONSUMPTION
P_HR_StRpCalTaxReturnBox view_entity from COMPOSITE
P_HR_StRpTaxReturnBox view_entity from COMPOSITE
P_HR_StRpTaxReturnPeriodDetail view_entity from COMPOSITE Croatia Tax return period detail
P_ID_StRpTaxReturnItemGroup view from COMPOSITE
P_ID_StRpTxReturnBoxItm view_entity from COMPOSITE
P_MY_StRpTxItmWithOriglDoc view from COMPOSITE
P_MY_TDTTAXRATE view from COMPOSITE
P_NZ_StRpTaxReturnBox view from COMPOSITE New Zealand specific base view for TaxBox Reporting
P_PH_CapitalGoodsItemTDT view from COMPOSITE
P_PH_ImportationSummaryItem view_entity from COMPOSITE
P_PH_SmmryStRpTaxReturnBox view from COMPOSITE
P_PH_STRPTaxItems_TDT view from COMPOSITE
P_PT_TaxReturnBoxItem view_entity from COMPOSITE
P_RO_StRpTaxItemLog view from CONSUMPTION Tax Items log for Statutory Reporting
P_SI_STRPTAXRETURNBOXCUBE1 view_entity from COMPOSITE
P_StRpTaxReturnBoxCube view_entity from COMPOSITE Private View to Return Tax Details
P_TH_StRpDeferTaxPayment view_entity from COMPOSITE
P_TH_STRPTAXCURRADAPT view_entity from COMPOSITE
P_TH_StRpTaxPaymentReturn view from COMPOSITE
P_ZA_StRpTaxReturnBox view from COMPOSITE

Fields (89)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 6
KEY AccountingDocumentType AccountingDocumentType 6
KEY CompanyCode CompanyCode 8
KEY Country Country 8
KEY DebitCreditCode DebitCreditCode 3
KEY FiscalYear FiscalYear 6
KEY StatryRptCategory StatryRptCategory 3
KEY StatryRptgEntity StatryRptgEntity 3
KEY StatryRptRunID StatryRptRunID 3
KEY SupplierAccountGroup SupplierAccountGroup 2
KEY TaxBox TaxBox 4
KEY TaxBoxStructureType TaxBoxStructureType 4
KEY TaxBoxStrucValidityStartDate TaxBoxStrucValidityStartDate,ValidityStartDate 4
KEY TaxCalculationProcedure TaxCalculationProcedure 7
KEY TaxCode TaxCode 9
KEY TaxDeclnAmountType TaxDeclnAmountType 5
KEY TaxGroup TaxGroup 4
KEY TaxItem TaxItem 6
KEY TaxItemGroupingVersion TaxItemGroupingVersion 8
KEY TaxItemGrpgAcctgDocumentType TaxItemGrpgAcctgDocumentType 2
KEY TaxItemGrpgDebitCreditCode TaxItemGrpgDebitCreditCode 2
KEY TaxItemGrpgSpecialGLCode TaxItemGrpgSpecialGLCode 2
KEY TaxItemGrpgSupplierAcctGroup TaxItemGrpgSupplierAcctGroup 2
KEY TransactionTypeDetermination TransactionTypeDetermination 8
KEY UnifiedTaxBoxStructureType UnifiedTaxBoxStructureType 3
_GLAccount _GLAccount 2
_TaxTypeText _TaxTypeText 1
AccountingDocumentHeaderText AccountingDocumentHeaderText 2
AdditionalCurrency1 AdditionalCurrency1 3
AdditionalCurrency2 AdditionalCurrency2 3
AlternativeReferenceDocument AlternativeReferenceDocument 2
AmountInAdditionalCurrency1 AmountInAdditionalCurrency1 3
AmountInAdditionalCurrency2 AmountInAdditionalCurrency2 3
AmountInReportingCurrency AmountInReportingCurrency 3
BusinessPartner BusinessPartner 3
BusinessPartnerCountry BusinessPartnerCountry 2
BusinessPartnerName BusinessPartnerName 2
BusinessPlace BusinessPlace 3
CAReconciliationKey CAReconciliationKey 3
CompanyCodeCountry CompanyCodeCountry 3
CompanyCodeCurrency CompanyCodeCurrency 5
CountryCurrency CountryCurrency 2
CustomerSupplierAddress CustomerSupplierAddress 1
DocumentCurrency DocumentCurrency 3
DocumentDate DocumentDate 5
DocumentReferenceID DocumentReferenceID 4
ExchangeRate ExchangeRate 1
FiscalPeriod FiscalPeriod 5
GLAccount GLAccount 5
IsReversal IsReversal 1
IsReversed IsReversed 1
LowestLevelTaxJurisdiction LowestLevelTaxJurisdiction 1
NonDeductibleInputTaxAmount NonDeductibleInputTaxAmount 4
PostingDate PostingDate 5
ReferenceDocumentType ReferenceDocumentType 2
ReportingCountry ReportingCountry 3
ReportingCurrency ReportingCurrency 3
ReportingDate ReportingDate 3
StatryRptRun StatryRptRun 4
TargetTaxCode TargetTaxCode 2
TaxAmount TaxAmount 3
TaxAmountInAdditionalCurrency1 TaxAmountInAdditionalCurrency1 1
TaxAmountInAdditionalCurrency2 TaxAmountInAdditionalCurrency2 1
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 2
TaxAmountInRptgCrcy TaxAmountInRptgCrcy 3
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 2
TaxBaseAmountInRptgCrcy TaxBaseAmountInRptgCrcy 3
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy 2
TaxBaseAmtInAdditionalCrcy1 TaxBaseAmtInAdditionalCrcy1 1
TaxBaseAmtInAdditionalCrcy2 TaxBaseAmtInAdditionalCrcy2 1
TaxBoxCondition TaxBoxCondition 2
TaxBoxName TaxBoxName 2
TaxBoxStructure TaxBoxStructure 3
TaxBoxStructureName TaxBoxStructureName 2
TaxBoxStrucValidityEndDate TaxBoxStrucValidityEndDate,ValidityEndDate 3
TaxCountry TaxCountry 2
TaxGroupOperation TaxGroupOperation 1
TaxIsNotDeductible TaxIsNotDeductible 3
TaxItemGroup TaxItemGroup 5
TaxJurisdiction TaxJurisdiction 3
TaxNumber1 TaxNumber1 1
TaxNumber2 TaxNumber2 1
TaxNumber3 TaxNumber3 1
TaxRate TaxRate 2
TaxRateValidityStartDate TaxRateValidityStartDate 6
TaxReportingDate TaxReportingDate 5
TaxReturnCountry TaxReturnCountry 2
TaxType TaxType 5
TaxTypeName TaxTypeName 2

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.

-- Cube View to Return Tax Details with TaxBox configuration
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_STRPTAXRETURNBOXCUBE (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTTYPE,
    COMPANYCODE,
    COUNTRY,
    DEBITCREDITCODE,
    FISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    SUPPLIERACCOUNTGROUP,
    TAXBOX,
    TAXBOXSTRUCTURETYPE,
    TAXBOXSTRUCVALIDITYSTARTDATE,
    TAXCALCULATIONPROCEDURE,
    TAXCODE,
    TAXDECLNAMOUNTTYPE,
    TAXGROUP,
    TAXITEM,
    TAXITEMGROUPINGVERSION,
    TAXITEMGRPGACCTGDOCUMENTTYPE,
    TAXITEMGRPGDEBITCREDITCODE,
    TAXITEMGRPGSPECIALGLCODE,
    TAXITEMGRPGSUPPLIERACCTGROUP,
    TRANSACTIONTYPEDETERMINATION,
    UNIFIEDTAXBOXSTRUCTURETYPE,
    _GLACCOUNT,
    _TAXTYPETEXT,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    ALTERNATIVEREFERENCEDOCUMENT,
    AMOUNTINADDITIONALCURRENCY1,
    AMOUNTINADDITIONALCURRENCY2,
    AMOUNTINREPORTINGCURRENCY,
    BUSINESSPARTNER,
    BUSINESSPARTNERCOUNTRY,
    BUSINESSPARTNERNAME,
    BUSINESSPLACE,
    CARECONCILIATIONKEY,
    COMPANYCODECOUNTRY,
    COMPANYCODECURRENCY,
    COUNTRYCURRENCY,
    CUSTOMERSUPPLIERADDRESS,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    EXCHANGERATE,
    FISCALPERIOD,
    GLACCOUNT,
    ISREVERSAL,
    ISREVERSED,
    LOWESTLEVELTAXJURISDICTION,
    NONDEDUCTIBLEINPUTTAXAMOUNT,
    POSTINGDATE,
    REFERENCEDOCUMENTTYPE,
    REPORTINGCOUNTRY,
    REPORTINGCURRENCY,
    REPORTINGDATE,
    STATRYRPTRUN,
    TARGETTAXCODE,
    TAXAMOUNT,
    TAXAMOUNTINADDITIONALCURRENCY1,
    TAXAMOUNTINADDITIONALCURRENCY2,
    TAXAMOUNTINCOCODECRCY,
    TAXAMOUNTINRPTGCRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINRPTGCRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXBASEAMTINADDITIONALCRCY1,
    TAXBASEAMTINADDITIONALCRCY2,
    TAXBOXCONDITION,
    TAXBOXNAME,
    TAXBOXSTRUCTURE,
    TAXBOXSTRUCTURENAME,
    TAXBOXSTRUCVALIDITYENDDATE,
    TAXCOUNTRY,
    TAXGROUPOPERATION,
    TAXISNOTDEDUCTIBLE,
    TAXITEMGROUP,
    TAXJURISDICTION,
    TAXNUMBER1,
    TAXNUMBER2,
    TAXNUMBER3,
    TAXRATE,
    TAXRATEVALIDITYSTARTDATE,
    TAXREPORTINGDATE,
    TAXRETURNCOUNTRY,
    TAXTYPE,
    TAXTYPENAME,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTTYPE, COMPANYCODE, COUNTRY, DEBITCREDITCODE, FISCALYEAR, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, SUPPLIERACCOUNTGROUP, TAXBOX, TAXBOXSTRUCTURETYPE, TAXBOXSTRUCVALIDITYSTARTDATE, TAXCALCULATIONPROCEDURE, TAXCODE, TAXDECLNAMOUNTTYPE, TAXGROUP, TAXITEM, TAXITEMGROUPINGVERSION, TAXITEMGRPGACCTGDOCUMENTTYPE, TAXITEMGRPGDEBITCREDITCODE, TAXITEMGRPGSPECIALGLCODE, TAXITEMGRPGSUPPLIERACCTGROUP, TRANSACTIONTYPEDETERMINATION, UNIFIEDTAXBOXSTRUCTURETYPE)
);

Learn More