T8JU

Transparent Table Application Table
33 Fields 1 CDS Views

Joint Operating Agreement

T8JU is an SAP database table in S/4HANA. Joint Operating Agreement. It contains 33 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_JntOpgAgrmt view from BASIC Joint Operating Agreement

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY joa jv_joa Joint Oper.Agr
contract jv_contrac Contract Number
payset jv_payset Pay. Clear. Set
dfpay jv_dfpay Drilling Pay
ndpay jv_ndpay Non-Drill. Pay.
xsetcon jv_xsetcon Exclude Con.
xsetcat jv_xsetcat Exclude Cat.
conrule jv_conrule Con. Rule
catrule jv_catrule Cat. Rule
per1 jv_per1 O/H percent 1
xper1 jv_xper1 X Set Per. 1
per2 jv_per2 O/H percent 2
xper2 jv_xper2 X Set Per. 2
exprule jv_exprule Exp. Rule
drlrule jv_drlrule Drill. Rule
xsetcap jv_xsetcap Exclude Cap.
offcc jv_offcc Off. C.C.
joaprth jv_joaprth JOA Thresh.
recdoc jv_recdoc Rec. Doc.
flatrate jv_flatrat Flat Rate
escal jv_escal Escalatable
aclass jv_aclass JOA class
cruser jv_cruser Creator
crtime jv_crtime Time Created
crdate jv_crdate Date Created
chuser jv_chuser Who Changed
chtime jv_chtime Time Changed
chdate jv_chdate Date Changed
noncomp jv_noncomp Non-compulsory
drillp jv_drillp Prior Period
allwbs jv_allwbs All WBS elem.

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.

-- Joint Operating Agreement
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T8JU (
    MANDT,     -- Client [mandt]
    BUKRS,     -- Company Code [bukrs]
    JOA,       -- Joint Oper.Agr [jv_joa]
    CONTRACT,  -- Contract Number [jv_contrac]
    PAYSET,    -- Pay. Clear. Set [jv_payset]
    DFPAY,     -- Drilling Pay [jv_dfpay]
    NDPAY,     -- Non-Drill. Pay. [jv_ndpay]
    XSETCON,   -- Exclude Con. [jv_xsetcon]
    XSETCAT,   -- Exclude Cat. [jv_xsetcat]
    CONRULE,   -- Con. Rule [jv_conrule]
    CATRULE,   -- Cat. Rule [jv_catrule]
    PER1,      -- O/H percent 1 [jv_per1]
    XPER1,     -- X Set Per. 1 [jv_xper1]
    PER2,      -- O/H percent 2 [jv_per2]
    XPER2,     -- X Set Per. 2 [jv_xper2]
    EXPRULE,   -- Exp. Rule [jv_exprule]
    DRLRULE,   -- Drill. Rule [jv_drlrule]
    XSETCAP,   -- Exclude Cap. [jv_xsetcap]
    OFFCC,     -- Off. C.C. [jv_offcc]
    JOAPRTH,   -- JOA Thresh. [jv_joaprth]
    RECDOC,    -- Rec. Doc. [jv_recdoc]
    FLATRATE,  -- Flat Rate [jv_flatrat]
    ESCAL,     -- Escalatable [jv_escal]
    ACLASS,    -- JOA class [jv_aclass]
    CRUSER,    -- Creator [jv_cruser]
    CRTIME,    -- Time Created [jv_crtime]
    CRDATE,    -- Date Created [jv_crdate]
    CHUSER,    -- Who Changed [jv_chuser]
    CHTIME,    -- Time Changed [jv_chtime]
    CHDATE,    -- Date Changed [jv_chdate]
    NONCOMP,   -- Non-compulsory [jv_noncomp]
    DRILLP,    -- Prior Period [jv_drillp]
    ALLWBS,    -- All WBS elem. [jv_allwbs]
    PRIMARY KEY (MANDT, BUKRS, JOA)
);

Learn More