T8JZ

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.

-- JV Global Company Parameters
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T8JZ (
    MANDT,           -- Client [mandt]
    BUKRS,           -- Company Code [bukrs]
    ITD,             -- Incept. to date [jv_itd2]
    NETACCOPT,       -- NetAccOpt [jv_net]
    INT_US,          -- Region [jv_inter]
    OPACCNUMB,       -- Operator [jv_oper]
    BILLBASIS,       -- Billing Basis [jv_bbasis]
    CORPVENT,        -- Joint venture [jv_name]
    CORPEQGP,        -- Equity group [jv_egroup]
    CORPRECIND,      -- Corp. RI 1 [jv_corpri1]
    CORPVBACRI,      -- Corp. RI 2 [jv_corpri2]
    BALANCVENT,      -- Balanced Vent [jv_bal]
    FRYEAR,          -- From year [jv_fryear]
    FRPERIOD,        -- From period [jv_frper]
    TOYEAR,          -- To year [jv_toyear]
    TOPERIOD,        -- To period [jv_toper]
    VBANK,           -- VBA active [jv_bank]
    TAXIN,           -- 0% Input tax [jv_taxin]
    INVLEVEL,        -- Invoice Level [jv_invlvl]
    TAXOUT,          -- 0% Output tax [jv_taxout]
    TXJCD,           -- Tax Jur. [txjcd]
    CRPTAXCODE,      -- CRP Tax Code [jv_taxcrp]
    BSTRUCT,         -- Billing Struct. [jv_billstr]
    STPAY,           -- Standard pay. [jv_stpay]
    XSETCON,         -- Exclude Con. [jv_xsetcon]
    XSETCAT,         -- Exclude Cat. [jv_xsetcat]
    XPER1,           -- X Set Per. 1 [jv_xper1]
    XPER2,           -- X Set Per. 2 [jv_xper2]
    XSETCAP,         -- Exclude Cap. [jv_xsetcap]
    NONCOMP,         -- Non-compulsory [jv_noncomp]
    COMPULS,         -- Comp. benefits [jv_compuls]
    OFFCC,           -- Corporate CC [jv_offcc2]
    EXPAND,          -- expand [jv_expand]
    TAXEXPDTL,       -- Tax Exp. Dtl. [jv_taxexp]
    TAXPER,          -- Tax Period [jv_taxper]
    EQGNUM,          -- Max. Active E. Grps. [jv_eqgnum]
    POMACT,          -- Op. & Bill. M. Act [jv_pomact]
    GSTNO,           -- GST reg. number [jv_gstno]
    AFABE_HAN,       -- Book deprec. [afabe_han]
    AFABE_NB,        -- Non billable [afabe_nb]
    AFABE_BI,        -- Billable Cost [afabe_bi]
    CRPCAL,          -- CRP Calculation [jv_crpcal]
    AM_METH,         -- AM/MM Method [jv_ammeth]
    WBIND,           -- Index series [jv_wbind]
    SELTAB,          -- Selection Table [jv_tabname]
    SELFLD,          -- Selection field [jv_fieldname]
    CBYEAR,          -- Cutback Year [jv_cbyear]
    CBPERI,          -- Cutback Period [jv_cbperi]
    KURST,           -- Ex. rate type [jv_kurst]
    OFFPCOCC,        -- Co. PCO CostCtr [jv_offpccc]
    OFFPCOPROJ,      -- CoPCOProj. [jv_offpcpj]
    OFFPCOORNR,      -- Co.PCO.Order [jv_offpcod]
    POSTCORP,        -- Post corp. doc. [jv_postcr1]
    ASSTVENT,        -- Venture deriv. [jv_asstvnt]
    CI_GROSS,        -- Gross CI post [jv_ci_gro]
    CI_FB01,         -- CI/NPI in FI [jv_ci_fb01]
    CB_TCURR,        -- Cutb in TCurr [jv_cu_tcur]
    FSJVCT,          -- FS JV-Ctr Type [jv_fsjvct]
    FSJVOT,          -- FS JV-Ord.Type [jv_fsjvot]
    FSJVPT,          -- FS JV-Proj.Type [jv_fsjvpt]
    BUDGETMESS,      -- Msg.Budg.impact [jv_messbdg]
    VIDIST,          -- Use Std AM TA [jv_vidist]
    OP_AS_PART,      -- Oper. as part. [jv_fl_part]
    KOSTL_CORP,      -- Corp. Cost Center [jv_kostlcp]
    AM_CORP_RI,      -- Corp.RI AM [jv_corpri3]
    BANK_RI_SW,      -- RI Switch [jv_bank_ri]
    BCURR,           -- Billing curr. [jv_bcurr]
    XVBA,            -- VBA used [jv_xvba]
    XASST_CO,        -- No CO Object [jv_asstco]
    BILLTHRES,       -- Bill thr (deb) [jv_bill_thresh]
    BILLTHRESC,      -- Bill thr (cr) [jv_bill_thresh_c]
    TVARCURR,        -- Transfer var. [transvar]
    TVAROLD,         -- Transfer var. [transvar]
    SPLIT_BY_LI,     -- Split by LI [jv_split_by_li]
    EC_USE,          -- CA-JVA-PRC Active [/sappce/jva_ec_usage]
    BILLTHRESS,      -- Sep.Billing [jv_bill_thresh_sep]
    PM_ACT,          -- Production Month [jv_pm_active]
    PM_EG,           -- EG by Prod.Month [jv_pm_eg]
    PM_ACT_YEAR,     -- Years active [jv_pm_act_year]
    FUNDING_ACTIVE,  -- JV Funding [jv_funding_active]
    INTCALC_ACTIVE,  -- JV Int.Calc. [jv_intcalc_active]
    IC_AUTO_GROUP,   -- Auto Group [jv_intcalc_auto_group]
    IC_GROUP_REF,    -- Ref.Int.Group [jv_intcalc_group_ref]
    RLDNR,           -- Ledger [fins_ledger]
    PRIMARY KEY (MANDT, BUKRS)
);