I_STRPTAXITEMGRPG

CDS View
21 Fields 4 CDS Views

Tax Item Grouping For Statutory Reporting

I_STRPTAXITEMGRPG is a CDS View in S/4HANA. Tax Item Grouping For Statutory Reporting. It contains 21 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_StRpTaxItemBoxCube view left_outer COMPOSITE VAT Tax Item box level reporting
P_KR_StRpNotRptdItem view left_outer COMPOSITE
P_StRpTaxItemBoxPA view left_outer COMPOSITE
P_TW_StRpNotRptdItem view left_outer COMPOSITE

Fields (21)

KeyField CDS FieldsUsed in Views
KEY AccountingDocumentType TaxItemGrpgAcctgDocumentType 2
KEY DebitCreditCode TaxItemGrpgDebitCreditCode 2
KEY SpecialGLCode TaxItemGrpgSpecialGLCode 2
KEY SupplierAccountGroup SupplierAccountGroup,TaxItemGrpgSupplierAcctGroup 3
KEY TaxBox TaxBox 5
KEY TaxBoxStructureType TaxBoxStructureType 3
KEY TaxBoxStrucValidityStartDate TaxBoxStrucValidityStartDate 1
KEY TaxDeclnAmountType TaxDeclnAmountType 4
KEY TaxGroup TaxGroup 3
KEY TaxItemGroupingVersion TaxItemGroupingVersion 5
KEY UnifiedTaxBoxStructureType UnifiedTaxBoxStructureType 1
KEY ValidFrom ValidFrom 4
Country Country,ReportingCountry 2
TaxBoxAggregationOperation TaxBoxAggregationOperation 2
TaxBoxStrucValidityEndDate TaxBoxStrucValidityEndDate 1
TaxCountry TaxGrpgTaxCountry 1
TaxGroupOperation TaxGroupOperation 2
TaxItemGroupingAccountNumber TaxItemGroupingAccountNumber 1
TaxRate TaxCodeRatePointer 1
TaxRateValidityStartDate TaxRateValidityStartDate 1
ValidTo ValidTo 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.

-- Tax Item Grouping For Statutory Reporting
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_STRPTAXITEMGRPG (
    ACCOUNTINGDOCUMENTTYPE,
    DEBITCREDITCODE,
    SPECIALGLCODE,
    SUPPLIERACCOUNTGROUP,
    TAXBOX,
    TAXBOXSTRUCTURETYPE,
    TAXBOXSTRUCVALIDITYSTARTDATE,
    TAXDECLNAMOUNTTYPE,
    TAXGROUP,
    TAXITEMGROUPINGVERSION,
    UNIFIEDTAXBOXSTRUCTURETYPE,
    VALIDFROM,
    COUNTRY,
    TAXBOXAGGREGATIONOPERATION,
    TAXBOXSTRUCVALIDITYENDDATE,
    TAXCOUNTRY,
    TAXGROUPOPERATION,
    TAXITEMGROUPINGACCOUNTNUMBER,
    TAXRATE,
    TAXRATEVALIDITYSTARTDATE,
    VALIDTO,
    PRIMARY KEY (ACCOUNTINGDOCUMENTTYPE, DEBITCREDITCODE, SPECIALGLCODE, SUPPLIERACCOUNTGROUP, TAXBOX, TAXBOXSTRUCTURETYPE, TAXBOXSTRUCVALIDITYSTARTDATE, TAXDECLNAMOUNTTYPE, TAXGROUP, TAXITEMGROUPINGVERSION, UNIFIEDTAXBOXSTRUCTURETYPE, VALIDFROM)
);

Learn More