C_GB_STRPTAXITEMBOXCUBE

CDS View
28 Fields 2 CDS Views

VAT Tax Item box level reporting

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_GB_StRpNotRptdTaxItem view from CONSUMPTION GB: Non Reported document for Statutory Reporting
C_GB_StRpTaxItemQuery view from CONSUMPTION Items from the current period

Fields (28)

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 TaxBox TaxBox 2
KEY TaxBoxStructureType TaxBoxStructureType 1
KEY TaxCode TaxCode 2
KEY TaxDeclnAmountType TaxDeclnAmountType 2
KEY TaxGroup TaxGroup 1
KEY TaxItemGroupingVersion TaxItemGroupingVersion 2
KEY TransactionTypeDetermination TransactionTypeDetermination 2
KEY ValidFrom TaxCodeValidFromDate 1
AccountingDocumentType AccountingDocumentType 2
AdditionalCurrency1 AdditionalCurrency1 1
AdditionalCurrency2 AdditionalCurrency2 1
AmountInAdditionalCurrency1 AmountInAdditionalCurrency1 1
AmountInAdditionalCurrency2 AmountInAdditionalCurrency2 1
AmountInTransactionCurrency AmountInTransactionCurrency 1
BusinessPlace BusinessPlace 1
DocumentDate DocumentDate 1
FiscalPeriod FiscalPeriod 1
GLAccount GLAccount 1
PostingDate PostingDate 1
TaxJurisdiction TaxJurisdiction 1
TaxReportingDate TaxReportingDate 1
TaxType TaxType 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.

-- VAT Tax Item box level reporting
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE C_GB_STRPTAXITEMBOXCUBE (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    TAXBOX,
    TAXBOXSTRUCTURETYPE,
    TAXCODE,
    TAXDECLNAMOUNTTYPE,
    TAXGROUP,
    TAXITEMGROUPINGVERSION,
    TRANSACTIONTYPEDETERMINATION,
    VALIDFROM,
    ACCOUNTINGDOCUMENTTYPE,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    AMOUNTINADDITIONALCURRENCY1,
    AMOUNTINADDITIONALCURRENCY2,
    AMOUNTINTRANSACTIONCURRENCY,
    BUSINESSPLACE,
    DOCUMENTDATE,
    FISCALPERIOD,
    GLACCOUNT,
    POSTINGDATE,
    TAXJURISDICTION,
    TAXREPORTINGDATE,
    TAXTYPE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, TAXBOX, TAXBOXSTRUCTURETYPE, TAXCODE, TAXDECLNAMOUNTTYPE, TAXGROUP, TAXITEMGROUPINGVERSION, TRANSACTIONTYPEDETERMINATION, VALIDFROM)
);

Learn More