KONA

Transparent Table Application Table
56 Fields 4 CDS Views

Agreements

KONA is an SAP database table in S/4HANA. Agreements. It contains 56 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_SalesDeal view from BASIC Sales Deal
SHSM_KONA view from CDS View replacing KONA check table
SHSM_VMBOA view from CDS View replacing V_VMBOA in search help VMBOA
SHSM_VMBOC view from CDS View replacing V_VMBOC in search help VMBOC

Fields (56)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY knuma knuma Agreement
vkorg vkorg Sales Org.
vtweg vtweg Distr. Channel
spart spart Division
vkbur vkbur Sales Office
vkgrp vkgrp Sales Group
boart boart Agreement type
abtyp boabtyp Agreemt categ.
kappl kappl Application
ernam ernam Created By
erdat erdat Created On
erzet erzet Time
aenam aenam Changed By
aedat aedat Changed On
aezet aezet Time of change
bonem bonem Rebate recip.
waers waers Currency
maxbo maxbo Max.rebate
abrex abrex Ext.description
ekorg ekorg Purchasing Org.
bolif bogew Condit. granter
abspz abspz Verific.level
bosta bosta Agmt status
datab abdatab Validity period
datbi abdatbi Validity period
kobog kobog Cond.Type Group
botext botext Description
zlsch dzlsch Pymt Meth.
valtg valtg Add. Value Days
valdt valdt Fixed Val. Date
zterm dzterm Pyt Terms
uknuma knuma_ueb High.LevelAgree
ident1 wfcid1 Settlement cal.
ident2 wfcid2 Arrangemnt.cal.
umnam umnam Person resp.
umsda umsda Carried out on
umsae umsaef BVComp FinSettl
ekgrp ekgrp Purch. Group
aktnr waktion Promotion
abein abein Scope of stmt.
bukrs bukrs_ab Company code
vknuma knuma_vor Predecessor
forzp forzp Time of update
foart foart_na Update type
ident3 wfcid3 Settlement periods
abpar wabpar Sett. Partner
kfrst kfrst Release Status
angrp angrp TrigGrp MesDet
anbednfe anbednfe TrigCondMssgDet
naumf_enaw naumf_enaw Summariz. Level
naumf_snaw naumf_snaw Aggreg. Level
naumf_anaw naumf_anaw Summariz. Level
umsaep umsaep BVComp PartSetl
umnamp umnamp Person resp.
umsdap umsdap Carried out on

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.

-- Agreements
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KONA (
    MANDT,       -- Client [mandt]
    KNUMA,       -- Agreement [knuma]
    VKORG,       -- Sales Org. [vkorg]
    VTWEG,       -- Distr. Channel [vtweg]
    SPART,       -- Division [spart]
    VKBUR,       -- Sales Office [vkbur]
    VKGRP,       -- Sales Group [vkgrp]
    BOART,       -- Agreement type [boart]
    ABTYP,       -- Agreemt categ. [boabtyp]
    KAPPL,       -- Application [kappl]
    ERNAM,       -- Created By [ernam]
    ERDAT,       -- Created On [erdat]
    ERZET,       -- Time [erzet]
    AENAM,       -- Changed By [aenam]
    AEDAT,       -- Changed On [aedat]
    AEZET,       -- Time of change [aezet]
    BONEM,       -- Rebate recip. [bonem]
    WAERS,       -- Currency [waers]
    MAXBO,       -- Max.rebate [maxbo]
    ABREX,       -- Ext.description [abrex]
    EKORG,       -- Purchasing Org. [ekorg]
    BOLIF,       -- Condit. granter [bogew]
    ABSPZ,       -- Verific.level [abspz]
    BOSTA,       -- Agmt status [bosta]
    DATAB,       -- Validity period [abdatab]
    DATBI,       -- Validity period [abdatbi]
    KOBOG,       -- Cond.Type Group [kobog]
    BOTEXT,      -- Description [botext]
    ZLSCH,       -- Pymt Meth. [dzlsch]
    VALTG,       -- Add. Value Days [valtg]
    VALDT,       -- Fixed Val. Date [valdt]
    ZTERM,       -- Pyt Terms [dzterm]
    UKNUMA,      -- High.LevelAgree [knuma_ueb]
    IDENT1,      -- Settlement cal. [wfcid1]
    IDENT2,      -- Arrangemnt.cal. [wfcid2]
    UMNAM,       -- Person resp. [umnam]
    UMSDA,       -- Carried out on [umsda]
    UMSAE,       -- BVComp FinSettl [umsaef]
    EKGRP,       -- Purch. Group [ekgrp]
    AKTNR,       -- Promotion [waktion]
    ABEIN,       -- Scope of stmt. [abein]
    BUKRS,       -- Company code [bukrs_ab]
    VKNUMA,      -- Predecessor [knuma_vor]
    FORZP,       -- Time of update [forzp]
    FOART,       -- Update type [foart_na]
    IDENT3,      -- Settlement periods [wfcid3]
    ABPAR,       -- Sett. Partner [wabpar]
    KFRST,       -- Release Status [kfrst]
    ANGRP,       -- TrigGrp MesDet [angrp]
    ANBEDNFE,    -- TrigCondMssgDet [anbednfe]
    NAUMF_ENAW,  -- Summariz. Level [naumf_enaw]
    NAUMF_SNAW,  -- Aggreg. Level [naumf_snaw]
    NAUMF_ANAW,  -- Summariz. Level [naumf_anaw]
    UMSAEP,      -- BVComp PartSetl [umsaep]
    UMNAMP,      -- Person resp. [umnamp]
    UMSDAP,      -- Carried out on [umsdap]
    PRIMARY KEY (MANDT, KNUMA)
);

Learn More