I_STRPTAXRETURNCUBE

CDS View
63 Fields 2 CDS Views

Cube view to Return all types of Tax Details

I_STRPTAXRETURNCUBE is a CDS View in S/4HANA. Cube view to Return all types of Tax Details. It contains 63 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_IT_TaxReturnCube view_entity from CONSUMPTION IT Tax Return Item - Cube
C_StRpTaxReturnQuery view from CONSUMPTION Analytical Query to Fetch all types of Tax Return details

Fields (63)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY CompanyCode CompanyCode 2
KEY FiscalYear FiscalYear 2
KEY StatryRptCategory StatryRptCategory 1
KEY StatryRptgEntity StatryRptgEntity 1
KEY StatryRptRunID StatryRptRunID 1
KEY TaxCode TaxCode 2
KEY TaxItem TaxItem 2
KEY TransactionTypeDetermination TransactionTypeDetermination 2
_CustomerSupplierLineItem _CustomerSupplierLineItem 1
_JournalEntry _JournalEntry 1
AccountingDocumentHeaderText AccountingDocumentHeaderText 1
AccountingDocumentType AccountingDocumentType 2
ActiveTaxType ActiveTaxType 1
BalanceAmountInTransacCurrency BalanceAmountInTransacCurrency 1
BusinessPartnerCountry BusinessPartnerCountry 1
BusinessPartnerName BusinessPartnerName 1
CAReconciliationKey CAReconciliationKey 1
CompanyCodeCountry CompanyCodeCountry 1
CompanyCodeCurrency CompanyCodeCurrency 1
ConditionType ConditionType 1
Country Country 1
DcblVATIncrdCostInRptgCrcy DcblVATIncrdCostInRptgCrcy 1
DebitCreditCode DebitCreditCode 1
DocumentCurrency DocumentCurrency 1
DocumentDate DocumentDate 1
DocumentReferenceID DocumentReferenceID 1
FiscalPeriod FiscalPeriod 1
GLAccount GLAccount 1
IsNegativePosting IsNegativePosting 1
IsReversal IsReversal 1
IsReversed IsReversed 1
NonDeductibleInputTaxAmount NonDeductibleInputTaxAmount 1
PostingDate PostingDate 1
ReferenceDocumentType ReferenceDocumentType 2
ReportingCountry ReportingCountry 1
ReportingCurrency ReportingCurrency 1
ReportingDate ReportingDate 1
StatryRptRun StatryRptRun 1
TargetTaxCode TargetTaxCode 1
TaxAmount TaxAmount 1
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 1
TaxAmountInRptgCrcy TaxAmountInRptgCrcy 1
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 1
TaxBaseAmountInRptgCrcy TaxBaseAmountInRptgCrcy 1
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy 1
TaxCalculationProcedure TaxCalculationProcedure 1
TaxCountry TaxCountry 1
TaxIsDeferredRelevant TaxIsDeferredRelevant 1
TaxIsMossRelevant TaxIsMossRelevant 1
TaxIsNotDeductible TaxIsNotDeductible 1
TaxItemGroup TaxItemGroup 1
TaxNumber1 TaxNumber1 1
TaxNumber2 TaxNumber2 1
TaxNumber3 TaxNumber3 1
TaxRate TaxRate 2
TaxRateValidityStartDate TaxRateValidityStartDate 2
TaxReportingDate TaxReportingDate 1
TaxType TaxType 1
TaxTypeName TaxTypeName 1
TotalGrossAmount TotalGrossAmount 1
TotalGrossAmountInCoCodeCrcy TotalGrossAmountInCoCodeCrcy 1
TotalGrossAmountInTransCrcy TotalGrossAmountInTransCrcy 1

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 all types of Tax Details
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_STRPTAXRETURNCUBE (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    TAXCODE,
    TAXITEM,
    TRANSACTIONTYPEDETERMINATION,
    _CUSTOMERSUPPLIERLINEITEM,
    _JOURNALENTRY,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTTYPE,
    ACTIVETAXTYPE,
    BALANCEAMOUNTINTRANSACCURRENCY,
    BUSINESSPARTNERCOUNTRY,
    BUSINESSPARTNERNAME,
    CARECONCILIATIONKEY,
    COMPANYCODECOUNTRY,
    COMPANYCODECURRENCY,
    CONDITIONTYPE,
    COUNTRY,
    DCBLVATINCRDCOSTINRPTGCRCY,
    DEBITCREDITCODE,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    FISCALPERIOD,
    GLACCOUNT,
    ISNEGATIVEPOSTING,
    ISREVERSAL,
    ISREVERSED,
    NONDEDUCTIBLEINPUTTAXAMOUNT,
    POSTINGDATE,
    REFERENCEDOCUMENTTYPE,
    REPORTINGCOUNTRY,
    REPORTINGCURRENCY,
    REPORTINGDATE,
    STATRYRPTRUN,
    TARGETTAXCODE,
    TAXAMOUNT,
    TAXAMOUNTINCOCODECRCY,
    TAXAMOUNTINRPTGCRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINRPTGCRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXCALCULATIONPROCEDURE,
    TAXCOUNTRY,
    TAXISDEFERREDRELEVANT,
    TAXISMOSSRELEVANT,
    TAXISNOTDEDUCTIBLE,
    TAXITEMGROUP,
    TAXNUMBER1,
    TAXNUMBER2,
    TAXNUMBER3,
    TAXRATE,
    TAXRATEVALIDITYSTARTDATE,
    TAXREPORTINGDATE,
    TAXTYPE,
    TAXTYPENAME,
    TOTALGROSSAMOUNT,
    TOTALGROSSAMOUNTINCOCODECRCY,
    TOTALGROSSAMOUNTINTRANSCRCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, TAXCODE, TAXITEM, TRANSACTIONTYPEDETERMINATION)
);

Learn More