C_STRPDOCITEMGRPGWTHVNDRACCT

CDS View

Tax Item Grouping Based on Vendor Account Group

C_STRPDOCITEMGRPGWTHVNDRACCT is a CDS View in S/4HANA. Tax Item Grouping Based on Vendor Account Group. It contains 23 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_StRpDocItemWithTaxGrouping view from CONSUMPTION Document Item Tax Grouping
C_StRpDocItmGrpgWithDocType view from CONSUMPTION Tax Item Grouping Based on Accounting Document Type

Fields (23)

KeyField CDS FieldsUsed in Views
KEY TaxBox TaxBox 1
KEY TaxCode TaxCode 1
KEY TaxItemGroupingVersion TaxItemGroupingVersion 1
KEY TransactionTypeDetermination TransactionTypeDetermination 1
AccountingDocumentType AccountingDocumentType 1
BusinessPartner BusinessPartner 2
BusinessPartnerCountry BusinessPartnerCountry 2
CashDiscountAmount CashDiscountAmount 1
CashDiscountBaseAmount CashDiscountBaseAmount 1
DebitCreditCode DebitCreditCode 1
DocumentReferenceID DocumentReferenceID 1
IsNaturalPerson IsNaturalPerson 2
IsPrivate IsPrivate 2
IsTimeDependent IsTimeDependent 2
LegalEntityOfOrganization LegalEntityOfOrganization 1
SupplierAccountGroup SupplierAccountGroup 1
TaxBoxConfiguration TaxBoxConfiguration 2
TaxBoxStrucValidityEndDate TaxBoxStrucValidityEndDate 1
TaxBoxStrucValidityStartDate TaxBoxStrucValidityStartDate 1
TaxDeclnAmountType TaxDeclnAmountType 1
TaxGroupFreeClassification TaxGroupFreeClassification 2
TaxRateValidityStartDate TaxRateValidityStartDate 1
TaxType TaxType 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.

-- Tax Item Grouping Based on Vendor Account Group
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE C_STRPDOCITEMGRPGWTHVNDRACCT (
    TAXBOX,
    TAXCODE,
    TAXITEMGROUPINGVERSION,
    TRANSACTIONTYPEDETERMINATION,
    ACCOUNTINGDOCUMENTTYPE,
    BUSINESSPARTNER,
    BUSINESSPARTNERCOUNTRY,
    CASHDISCOUNTAMOUNT,
    CASHDISCOUNTBASEAMOUNT,
    DEBITCREDITCODE,
    DOCUMENTREFERENCEID,
    ISNATURALPERSON,
    ISPRIVATE,
    ISTIMEDEPENDENT,
    LEGALENTITYOFORGANIZATION,
    SUPPLIERACCOUNTGROUP,
    TAXBOXCONFIGURATION,
    TAXBOXSTRUCVALIDITYENDDATE,
    TAXBOXSTRUCVALIDITYSTARTDATE,
    TAXDECLNAMOUNTTYPE,
    TAXGROUPFREECLASSIFICATION,
    TAXRATEVALIDITYSTARTDATE,
    TAXTYPE,
    PRIMARY KEY (TAXBOX, TAXCODE, TAXITEMGROUPINGVERSION, TRANSACTIONTYPEDETERMINATION)
);