T685A

Transparent Table Customizing Table
81 Fields 15 CDS Views

Conditions: Types: Additional Price Element Data

T685A is an SAP database table in S/4HANA. Conditions: Types: Additional Price Element Data. It contains 81 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
/dmbe/i_Condition_Type_AddData view from Condition Types: Additional Price Data
C_TaxCatVHTemp view from CONSUMPTION Value Help for Tax Category
FAC_DART_Z3_TAX_LINEITEM_TX view left_outer Tax Line Item with t685A-kappl = TX
I_ACMTrdgContPrcConditionType view_entity inner BASIC Fetch Condition Type for price fixation
I_CmmdtyPricingConditionTypeVH view_entity from BASIC Condition Type Values
I_ES_SIITaxRateDetail view from COMPOSITE Spain SII Tax Rate Details
I_ES_SIITaxRateDetail view union COMPOSITE Spain SII Tax Rate Details
I_ES_SIITaxRateDetailTaxType view from BASIC Spain SII Tax Rate Details for Tax Type
I_PricingConditionType view inner BASIC Pricing Condition Type
I_PurgPrcgCndnType view inner BASIC Condition Type for Pricing in Purchasing
I_SOM_CnvChrgPrcgCndnType view inner BASIC Pricing Condition Type for Convergent Charging
I_Taxclassificationcategory view from BASIC Conditions Types Additional Price Element Data
I_TripPrcgConditionTypeVH view inner BASIC Pricing Condition type value help
P_KSCHL_SETTLEMENT_VALUEHELP view inner BASIC
P_SrcgProjQtnItmCndnAmount view_entity inner BASIC

Fields (81)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kappl KAPPL Application
KEY kschl KSCHA Condition Type
krech KRECH Calculat.Type
kzbzg KZBZG Scale Base Type
kntyp KNTYP Condit.Category
konau KONAU Required
kmanu KMANU Manual Entries
grzgf GRZGF GrKeyAccessSeq.
grlnr GRLNR GrpCond.Routine
grmen GRMEN Unit of Measure
ganzz GANZZ Currency Conv.
kgrpe KGRPE Group Condition
kreli KRELI Inv.List Cond.
kdupl KDUPL Structure Cond.
kruek KRUEK Accruals
koupd KOUPD Condit. Update
sosta SOSTA Special form
kofrs KOFRS Scale Routine
kalsm KALSMASD Pric. Procedure
kznep KZNEP Exclusion
koaid KOAID Condition Class
kkopf KKOPF Header Condit.
kposi KPOSI Item Condition
knega KNEGA Plus/Minus
txprf TXPRF Rounding Rule
kstpr KSTPR Check Scale
kaend_btr KAEND_BTR Amount/Percent
kaend_wrt KAEND_WRT Value
kaend_ufk KAEND_UFK Qty. Relation
kaend_rch KAEND_RCH Calculat.Type
kaend_loe KAEND_LOE Delete
kaend_meh KAEND_MEH Unit of Measure
idxup IDXUP Condition Index
rukor RUKOR Accruals corr.
bover BOVER Rebate Proc.
kprdt KPRDT Pricing Date
stfkz STFKZ Scale Type
prech PRECH Per. Calc. Rule
bnkwe BNKWE Supplier in GR
aktko AKTKO Promotion Cond.
vkkal VKKAL Rel. to Pricing
vkobl VKOBL Pricing on/off
rkappl RKAPPL Ref. Applic.
rkschl RKSCHL Ref.Condit.Type
bergl BERGL Calc. Base
vhart VHIART Packag.Mat.Type
rdifa RDIFA RoundDiffAdj.
kfkiv KFKIV IntcoBillCond
kvarc KVARC UsedfVarConfig
kmeng KMENG Qty Conversion
mdflg MDFLG Matrix Maint.
ktrel KTREL Rel.Acc.Assig.
bnktk VF_BNKTK Copy Shp. Costs
kfrst KFRST Release Status
txtgr TXTGR TextDetermProc.
tdid TDID_TEC Text ID
kdele KDELE Delete from DB
kbflag KBFLAG BitFlags
purp CRM_COND_PURPOSE ConditionFunctn
dtasrc CRM_COND_DATA_SOURCE1 Dat.Rec.Source
is_cpf_enabled COND_IS_CPF_ENABLED Enabled for CPF
is_qtycnvfct_enabled VFPRC_CND_IS_QTYCNVFCT_ENABLED Conv. Factors
ccs_usage WB2_KSCHL_CCS_USAGE Usage
val_zero VAL_ZERO Zero Value Proc.
is_cpe_enabled COND_IS_CPE_ENABLED Enabled for CPE
prcgsubproceddetnformula VFPRCC_SUBPROCEDDETN_FMLA_ID Subproced Detn
isinclusionpoint VFPRCC_IS_INCLUSION_POINT Inclusion Point
pricingsubproceduremaxstep VFPRCC_SUBPROCEDURE_MAX_STEP Maximum Step
oigrnet OIC_GRNET Gr/net ind.
oiinvcyc OIA_INVCYC Invoice cycle
oireport OIC_REPORT Report number
oihead OIC_HEAD Header format
oiitem OIC_ITEM Item format
oierrhan OIC_SECERR Error handling
oidata OIC_DATA Data capture
oia_spltiv OIA_SPLTIV Split IV
oircondcl OIRE_CONDCLA Cond. classif.
oiu_ep OIU_EP Condition PRA
wty_kondm KONDM Mat. Price Grp
wty_kateg WTY_KATEG Category

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]
    OIGRNET,                     -- Gr/net ind. [OIC_GRNET]
    OIINVCYC,                    -- Invoice cycle [OIA_INVCYC]
    OIREPORT,                    -- Report number [OIC_REPORT]
    OIHEAD,                      -- Header format [OIC_HEAD]
    OIITEM,                      -- Item format [OIC_ITEM]
    OIERRHAN,                    -- Error handling [OIC_SECERR]
    OIDATA,                      -- Data capture [OIC_DATA]
    OIA_SPLTIV,                  -- Split IV [OIA_SPLTIV]
    OIRCONDCL,                   -- Cond. classif. [OIRE_CONDCLA]
    OIU_EP,                      -- Condition PRA [OIU_EP]
    WTY_KONDM,                   -- Mat. Price Grp [KONDM]
    WTY_KATEG,                   -- Category [WTY_KATEG]
    PRIMARY KEY (MANDT, KAPPL, KSCHL)
);

Learn More