VCH_APRIORI_RES

Transparent Table Temporary Data
11 Fields 1 CDS Views

Dummy table for field definitions used in Apriori VC queries

VCH_APRIORI_RES is an SAP database table in S/4HANA. Dummy table for field definitions used in Apriori VC queries. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_VarConfignSalesByNetValQry view from BASIC Base Query for VC Related Sales Anlyts

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY entry_no int4 INT4
charcvaluecombnset vch_charc_value_combn_set Value Comb. Set
charcvaluecombnsetsupport vch_charc_value_combn_set_supp Value Set Support
creationdate erdat Created On
soldtoparty kunag Sold-to Party
salesorganization vkorg Sales Org.
distributionchannel vtweg Distr. Channel
salesoffice vkbur Sales Office
product matnr Material
productgroup matkl Material Group
netamount vch_anlyts_net_amount_cond Cond.amnt indep.curr

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.

-- Dummy table for field definitions used in Apriori VC queries
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VCH_APRIORI_RES (
    ENTRY_NO,                   -- INT4 [int4]
    CHARCVALUECOMBNSET,         -- Value Comb. Set [vch_charc_value_combn_set]
    CHARCVALUECOMBNSETSUPPORT,  -- Value Set Support [vch_charc_value_combn_set_supp]
    CREATIONDATE,               -- Created On [erdat]
    SOLDTOPARTY,                -- Sold-to Party [kunag]
    SALESORGANIZATION,          -- Sales Org. [vkorg]
    DISTRIBUTIONCHANNEL,        -- Distr. Channel [vtweg]
    SALESOFFICE,                -- Sales Office [vkbur]
    PRODUCT,                    -- Material [matnr]
    PRODUCTGROUP,               -- Material Group [matkl]
    NETAMOUNT,                  -- Cond.amnt indep.curr [vch_anlyts_net_amount_cond]
    PRIMARY KEY (ENTRY_NO)
);

Learn More