STRPTAXRETURNBOXCUBE

72 Fields

STRPTAXRETURNBOXCUBE is an SAP database table in S/4HANA. It contains 72 fields.

Fields (72)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY AccountingDocumentType AccountingDocumentType 2
KEY CompanyCode CompanyCode 2
KEY DebitCreditCode DebitCreditCode 2
KEY FiscalYear FiscalYear 2
KEY StatryRptCategory StatryRptCategory 2
KEY StatryRptgEntity StatryRptgEntity 2
KEY StatryRptRunID StatryRptRunID 2
KEY SupplierAccountGroup SupplierAccountGroup 2
KEY TaxBox TaxBox 2
KEY TaxBoxStrucValidityStartDate TaxBoxStrucValidityStartDate 2
KEY TaxDeclnAmountType TaxDeclnAmountType 2
KEY TaxGroup TaxGroup 2
KEY TaxItem TaxItem 2
KEY TaxItemGrpgAcctgDocumentType TaxItemGrpgAcctgDocumentType 2
KEY TaxItemGrpgDebitCreditCode TaxItemGrpgDebitCreditCode 2
KEY TaxItemGrpgSpecialGLCode TaxItemGrpgSpecialGLCode 2
KEY TaxItemGrpgSupplierAcctGroup TaxItemGrpgSupplierAcctGroup 2
KEY TransactionTypeDetermination TransactionTypeDetermination 2
KEY UnifiedTaxBoxStructureType UnifiedTaxBoxStructureType 2
_DebtorCreditorRblsPyblsItem _DebtorCreditorRblsPyblsItem 1
_JournalEntry _JournalEntry 1
AccountingDocumentHeaderText AccountingDocumentHeaderText 2
AccountingDocumentItem AccountingDocumentItem 1
ActiveTaxType ActiveTaxType 2
AlternativeReferenceDocument AlternativeReferenceDocument 2
AmountInReportingCurrency AmountInReportingCurrency 2
BusinessPartner BusinessPartner 1
BusinessPartnerCountry BusinessPartnerCountry 1
BusinessPartnerName BusinessPartnerName 1
CompanyCodeCountry CompanyCodeCountry 2
CompanyCodeCurrency CompanyCodeCurrency 2
Country Country 2
CountryCurrency CountryCurrency 2
Customer Customer 1
CustomerSupplierAddress CustomerSupplierAddress 1
DocumentCurrency DocumentCurrency 2
DocumentDate DocumentDate 2
DocumentReferenceID DocumentReferenceID 2
FiscalPeriod FiscalPeriod 2
InvoiceReceiptDate InvoiceReceiptDate 1
IsReversal IsReversal 1
Ledger Ledger 2
OriginalReferenceDocument OriginalReferenceDocument 1
PostingDate PostingDate 2
ReferenceDocumentType ReferenceDocumentType 2
ReportingCountry ReportingCountry 2
ReportingCurrency ReportingCurrency 2
ReportingDate ReportingDate 2
ReportingVATRegistration ReportingVATRegistration 1
StatryRptRun StatryRptRun 2
Supplier Supplier 1
SupplyingCountry SupplyingCountry 1
TaxAmountInRptgCrcy TaxAmountInRptgCrcy 2
TaxBaseAmountInRptgCrcy TaxBaseAmountInRptgCrcy 2
TaxBoxStructureType TaxBoxStructureType 2
TaxBoxStrucValidityEndDate TaxBoxStrucValidityEndDate 2
TaxCalculationProcedure TaxCalculationProcedure 2
TaxCode TaxCode 2
TaxCountry TaxCountry 2
TaxFulfillmentDate TaxFulfillmentDate 2
TaxGroupFreeClassification TaxGroupFreeClassification 2
TaxGroupOperation TaxGroupOperation 2
TaxIsNotDeductible TaxIsNotDeductible 2
TaxJurisdiction TaxJurisdiction 2
TaxRate TaxRate 2
TaxReportingDate TaxReportingDate 2
TaxReportingDocumentDate TaxReportingDocumentDate 2
TaxReturnCountry TaxReturnCountry 2
TaxType TaxType 2
ValidFrom ValidFrom 2
ValidTo ValidTo 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE STRPTAXRETURNBOXCUBE (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTTYPE,
    COMPANYCODE,
    DEBITCREDITCODE,
    FISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    SUPPLIERACCOUNTGROUP,
    TAXBOX,
    TAXBOXSTRUCVALIDITYSTARTDATE,
    TAXDECLNAMOUNTTYPE,
    TAXGROUP,
    TAXITEM,
    TAXITEMGRPGACCTGDOCUMENTTYPE,
    TAXITEMGRPGDEBITCREDITCODE,
    TAXITEMGRPGSPECIALGLCODE,
    TAXITEMGRPGSUPPLIERACCTGROUP,
    TRANSACTIONTYPEDETERMINATION,
    UNIFIEDTAXBOXSTRUCTURETYPE,
    _DEBTORCREDITORRBLSPYBLSITEM,
    _JOURNALENTRY,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTITEM,
    ACTIVETAXTYPE,
    ALTERNATIVEREFERENCEDOCUMENT,
    AMOUNTINREPORTINGCURRENCY,
    BUSINESSPARTNER,
    BUSINESSPARTNERCOUNTRY,
    BUSINESSPARTNERNAME,
    COMPANYCODECOUNTRY,
    COMPANYCODECURRENCY,
    COUNTRY,
    COUNTRYCURRENCY,
    CUSTOMER,
    CUSTOMERSUPPLIERADDRESS,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    FISCALPERIOD,
    INVOICERECEIPTDATE,
    ISREVERSAL,
    LEDGER,
    ORIGINALREFERENCEDOCUMENT,
    POSTINGDATE,
    REFERENCEDOCUMENTTYPE,
    REPORTINGCOUNTRY,
    REPORTINGCURRENCY,
    REPORTINGDATE,
    REPORTINGVATREGISTRATION,
    STATRYRPTRUN,
    SUPPLIER,
    SUPPLYINGCOUNTRY,
    TAXAMOUNTINRPTGCRCY,
    TAXBASEAMOUNTINRPTGCRCY,
    TAXBOXSTRUCTURETYPE,
    TAXBOXSTRUCVALIDITYENDDATE,
    TAXCALCULATIONPROCEDURE,
    TAXCODE,
    TAXCOUNTRY,
    TAXFULFILLMENTDATE,
    TAXGROUPFREECLASSIFICATION,
    TAXGROUPOPERATION,
    TAXISNOTDEDUCTIBLE,
    TAXJURISDICTION,
    TAXRATE,
    TAXREPORTINGDATE,
    TAXREPORTINGDOCUMENTDATE,
    TAXRETURNCOUNTRY,
    TAXTYPE,
    VALIDFROM,
    VALIDTO,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTTYPE, COMPANYCODE, DEBITCREDITCODE, FISCALYEAR, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, SUPPLIERACCOUNTGROUP, TAXBOX, TAXBOXSTRUCVALIDITYSTARTDATE, TAXDECLNAMOUNTTYPE, TAXGROUP, TAXITEM, TAXITEMGRPGACCTGDOCUMENTTYPE, TAXITEMGRPGDEBITCREDITCODE, TAXITEMGRPGSPECIALGLCODE, TAXITEMGRPGSUPPLIERACCTGROUP, TRANSACTIONTYPEDETERMINATION, UNIFIEDTAXBOXSTRUCTURETYPE)
);

Learn More