COOI

Transparent Table Application Table
51 Fields 2 CDS Views

Obligoverwaltung: Einzelposten

COOI is an SAP database table in S/4HANA. Obligoverwaltung: Einzelposten. It contains 51 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ControllingCommitment view from BASIC Commitment for Controlling
P_MstrProjCommitment view from BASIC

Fields (51)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY refbt co_refbtyp Ref. Document Catg.
KEY refbn co_refbn Ref.document no
KEY rfpos cc_rfpos Ref Item
KEY rfknt cc_rfknt Acct Assnmt No.
KEY rftrm cc_rftrm Deadline Item
KEY rfart cc_rfart AAC
KEY lifnr lifnr Supplier
KEY lednr lednr Ledger
KEY objnr j_objnr Object number
KEY hrkft co_subkey CO subkey
KEY rforg aworg Refer. Org.Unit
KEY rftyp awtyp Ref. procedure
KEY rfsys awsys Logical System
vrgng co_vorgang Bus.Transaction
gjahr gjahr Fiscal Year
wrttp co_wrttp Value Type
versn versn Version
sakto sakto Cost element
vbund rassc Trading Partner
pargb pargb Trdg Part.BA
beknz beknz Dr/Cr indicator
twaer twaer Trans. Currency
uname uname User Name
bldat co_bldat Document Date
budat co_podat Debit Date
perio co_perio Period
bukrs bukrs Company Code
kokrs kokrs CO Area
matnr matnr Material
matkl matkl Material Group
sgtxt co_sgtxt Name
gesmng menge1 Qty/Plan
meinh co_meinh Unit of Measure
megbtr megxxx Total Quantity
mbgbtr mbgxxx Total quantity
meinb meinb Posted UofMeas.
wkurs wkurs Exchange Rate
orgwth werth1 Plan/LC
whgbtr whgxxx Value/LC
orgwtk wertk1 Plan/COCurrency
wkgbtr wkgxxx Val/COArea Crcy
orgwtt wertt1 Plan/TC
wtgbtr wtgxxx Value TranCurr
orgwto werto1 Plan/ObjectCur.
wogbtr wogxxx Value/Obj. Crcy
orgwtl wertl1 Plan/LdgrC
wlgbtr wlgxxx Value/LedgerCur
loekz eloek Del. Indicator
dabrz dabrbez Reference date
timestmp rke_tstmp Time (GMT)

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.

-- Obligoverwaltung: Einzelposten
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE COOI (
    MANDT,     -- Client [mandt]
    REFBT,     -- Ref. Document Catg. [co_refbtyp]
    REFBN,     -- Ref.document no [co_refbn]
    RFPOS,     -- Ref Item [cc_rfpos]
    RFKNT,     -- Acct Assnmt No. [cc_rfknt]
    RFTRM,     -- Deadline Item [cc_rftrm]
    RFART,     -- AAC [cc_rfart]
    LIFNR,     -- Supplier [lifnr]
    LEDNR,     -- Ledger [lednr]
    OBJNR,     -- Object number [j_objnr]
    HRKFT,     -- CO subkey [co_subkey]
    RFORG,     -- Refer. Org.Unit [aworg]
    RFTYP,     -- Ref. procedure [awtyp]
    RFSYS,     -- Logical System [awsys]
    VRGNG,     -- Bus.Transaction [co_vorgang]
    GJAHR,     -- Fiscal Year [gjahr]
    WRTTP,     -- Value Type [co_wrttp]
    VERSN,     -- Version [versn]
    SAKTO,     -- Cost element [sakto]
    VBUND,     -- Trading Partner [rassc]
    PARGB,     -- Trdg Part.BA [pargb]
    BEKNZ,     -- Dr/Cr indicator [beknz]
    TWAER,     -- Trans. Currency [twaer]
    UNAME,     -- User Name [uname]
    BLDAT,     -- Document Date [co_bldat]
    BUDAT,     -- Debit Date [co_podat]
    PERIO,     -- Period [co_perio]
    BUKRS,     -- Company Code [bukrs]
    KOKRS,     -- CO Area [kokrs]
    MATNR,     -- Material [matnr]
    MATKL,     -- Material Group [matkl]
    SGTXT,     -- Name [co_sgtxt]
    GESMNG,    -- Qty/Plan [menge1]
    MEINH,     -- Unit of Measure [co_meinh]
    MEGBTR,    -- Total Quantity [megxxx]
    MBGBTR,    -- Total quantity [mbgxxx]
    MEINB,     -- Posted UofMeas. [meinb]
    WKURS,     -- Exchange Rate [wkurs]
    ORGWTH,    -- Plan/LC [werth1]
    WHGBTR,    -- Value/LC [whgxxx]
    ORGWTK,    -- Plan/COCurrency [wertk1]
    WKGBTR,    -- Val/COArea Crcy [wkgxxx]
    ORGWTT,    -- Plan/TC [wertt1]
    WTGBTR,    -- Value TranCurr [wtgxxx]
    ORGWTO,    -- Plan/ObjectCur. [werto1]
    WOGBTR,    -- Value/Obj. Crcy [wogxxx]
    ORGWTL,    -- Plan/LdgrC [wertl1]
    WLGBTR,    -- Value/LedgerCur [wlgxxx]
    LOEKZ,     -- Del. Indicator [eloek]
    DABRZ,     -- Reference date [dabrbez]
    TIMESTMP,  -- Time (GMT) [rke_tstmp]
    PRIMARY KEY (MANDT, REFBT, REFBN, RFPOS, RFKNT, RFTRM, RFART, LIFNR, LEDNR, OBJNR, HRKFT, RFORG, RFTYP, RFSYS)
);

Learn More