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

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