T685A

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: Additional Price Element Data
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T685A (
    MANDT,                       -- Client [mandt]
    KAPPL,                       -- Application [kappl]
    KSCHL,                       -- Condition Type [kscha]
    KRECH,                       -- Calculat.Type [krech]
    KZBZG,                       -- Scale Base Type [kzbzg]
    KNTYP,                       -- Condit.Category [kntyp]
    KONAU,                       -- Required [konau]
    KMANU,                       -- Manual Entries [kmanu]
    GRZGF,                       -- GrKeyAccessSeq. [grzgf]
    GRLNR,                       -- GrpCond.Routine [grlnr]
    GRMEN,                       -- Unit of Measure [grmen]
    GANZZ,                       -- Currency Conv. [ganzz]
    KGRPE,                       -- Group Condition [kgrpe]
    KRELI,                       -- Inv.List Cond. [kreli]
    KDUPL,                       -- Structure Cond. [kdupl]
    KRUEK,                       -- Accruals [kruek]
    KOUPD,                       -- Condit. Update [koupd]
    SOSTA,                       -- Special form [sosta]
    KOFRS,                       -- Scale Routine [kofrs]
    KALSM,                       -- Pric. Procedure [kalsmasd]
    KZNEP,                       -- Exclusion [kznep]
    KOAID,                       -- Condition Class [koaid]
    KKOPF,                       -- Header Condit. [kkopf]
    KPOSI,                       -- Item Condition [kposi]
    KNEGA,                       -- Plus/Minus [knega]
    TXPRF,                       -- Rounding Rule [txprf]
    KSTPR,                       -- Check Scale [kstpr]
    KAEND_BTR,                   -- Amount/Percent [kaend_btr]
    KAEND_WRT,                   -- Value [kaend_wrt]
    KAEND_UFK,                   -- Qty. Relation [kaend_ufk]
    KAEND_RCH,                   -- Calculat.Type [kaend_rch]
    KAEND_LOE,                   -- Delete [kaend_loe]
    KAEND_MEH,                   -- Unit of Measure [kaend_meh]
    IDXUP,                       -- Condition Index [idxup]
    RUKOR,                       -- Accruals corr. [rukor]
    BOVER,                       -- Rebate Proc. [bover]
    KPRDT,                       -- Pricing Date [kprdt]
    STFKZ,                       -- Scale Type [stfkz]
    PRECH,                       -- Per. Calc. Rule [prech]
    BNKWE,                       -- Supplier in GR [bnkwe]
    AKTKO,                       -- Promotion Cond. [aktko]
    VKKAL,                       -- Rel. to Pricing [vkkal]
    VKOBL,                       -- Pricing on/off [vkobl]
    RKAPPL,                      -- Ref. Applic. [rkappl]
    RKSCHL,                      -- Ref.Condit.Type [rkschl]
    BERGL,                       -- Calc. Base [bergl]
    VHART,                       -- Packag.Mat.Type [vhiart]
    RDIFA,                       -- RoundDiffAdj. [rdifa]
    KFKIV,                       -- IntcoBillCond [kfkiv]
    KVARC,                       -- UsedfVarConfig [kvarc]
    KMENG,                       -- Qty Conversion [kmeng]
    MDFLG,                       -- Matrix Maint. [mdflg]
    KTREL,                       -- Rel.Acc.Assig. [ktrel]
    BNKTK,                       -- Copy Shp. Costs [vf_bnktk]
    KFRST,                       -- Release Status [kfrst]
    TXTGR,                       -- TextDetermProc. [txtgr]
    TDID,                        -- Text ID [tdid_tec]
    KDELE,                       -- Delete from DB [kdele]
    KBFLAG,                      -- BitFlags [kbflag]
    PURP,                        -- ConditionFunctn [crm_cond_purpose]
    DTASRC,                      -- Dat.Rec.Source [crm_cond_data_source1]
    IS_CPF_ENABLED,              -- Enabled for CPF [cond_is_cpf_enabled]
    IS_QTYCNVFCT_ENABLED,        -- Conv. Factors [vfprc_cnd_is_qtycnvfct_enabled]
    CCS_USAGE,                   -- Usage [wb2_kschl_ccs_usage]
    VAL_ZERO,                    -- Zero Value Proc. [val_zero]
    IS_CPE_ENABLED,              -- Enabled for CPE [cond_is_cpe_enabled]
    PRCGSUBPROCEDDETNFORMULA,    -- Subproced Detn [vfprcc_subproceddetn_fmla_id]
    ISINCLUSIONPOINT,            -- Inclusion Point [vfprcc_is_inclusion_point]
    PRICINGSUBPROCEDUREMAXSTEP,  -- Maximum Step [vfprcc_subprocedure_max_step]
    SERVICE,                     -- External Service ID [vfprc_ext_service_id]
    PRIMARY KEY (MANDT, KAPPL, KSCHL)
);