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