T685

Transparent Table Customizing Table
11 Fields 7 CDS Views

Conditions: Types

T685 is an SAP database table in S/4HANA. Conditions: Types. It contains 11 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_ConditionType view from BASIC Condition Type
I_PricingConditionType view from BASIC Pricing Condition Type
I_PurgPrcgCndnType view from BASIC Condition Type for Pricing in Purchasing
I_SlsPrcgKeyCombination view inner BASIC Key Combination for Pricing in Sales
I_SlsPrcgKeyCombinationField view inner BASIC Field from Condition Table for Pricing in Sales
I_SlsPrcgKeyCombinationText view inner BASIC Text of Key Combination for Pricing in Sales
SBN_DRF_COND_REC view from Existent Condition tables

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kvewe KVEWE Usage
KEY kappl KAPPL Application
KEY kschl KSCHL Condition Type
kozgf KOZGF Access Sequence
datvo DATVO Prop. Valid To
dtvob DTVOB Prop.Valid From
obsolete K_OBSOLETE Obsolete
j_3gpraend J_3GPRAEND Price change
j_3gbuartl J_3GBUARTL PostType-prov.
j_3gbuartb J_3GBUARTB PostType - dbtd

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.

-- Conditions: Types
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T685 (
    MANDT,       -- Client [MANDT]
    KVEWE,       -- Usage [KVEWE]
    KAPPL,       -- Application [KAPPL]
    KSCHL,       -- Condition Type [KSCHL]
    KOZGF,       -- Access Sequence [KOZGF]
    DATVO,       -- Prop. Valid To [DATVO]
    DTVOB,       -- Prop.Valid From [DTVOB]
    OBSOLETE,    -- Obsolete [K_OBSOLETE]
    J_3GPRAEND,  -- Price change [J_3GPRAEND]
    J_3GBUARTL,  -- PostType-prov. [J_3GBUARTL]
    J_3GBUARTB,  -- PostType - dbtd [J_3GBUARTB]
    PRIMARY KEY (MANDT, KVEWE, KAPPL, KSCHL)
);

Learn More