T8JIX
JV index table
T8JIX is an SAP database table in S/4HANA. JV index table. It contains 34 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_JointVentureLineItemIndex | view | from | BASIC | Jv Line Item Index |
Fields (34)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | rclnt | mandt | Client | |||
| KEY | jv_rec | gu_recid | Record number | |||
| poper | poper | Posting Period | ||||
| ryear | gjahr | Fiscal Year | ||||
| fyearperiod | fins_fyearperiod | Fiscal YPeriod | ||||
| fyearperiod_next | fins_fyearperiod | Fiscal YPeriod | ||||
| rbukrs | bukrs | Company Code | ||||
| rjvnam | jv_name | Joint venture | ||||
| regrou | jv_egroup | Equity group | ||||
| racct | racct | Account Number | ||||
| rbusa | gsber | Business Area | ||||
| rcntr | kostl | Cost Center | ||||
| rordnr | aufnr | Order | ||||
| rprojk | ps_psp_pnr | WBS Element | ||||
| rprctr | prctr | Profit Center | ||||
| ranln1 | anln1 | Asset | ||||
| ranln2 | anln2 | Sub-number | ||||
| ranbwa | anbwa | Ast Transaction Type | ||||
| rrecin | jv_recind | Recovery Ind. | ||||
| rpartn | jv_part | Partner | ||||
| rkokrs | kokrs | CO Area | ||||
| jibcl | jv_jibcl | JIB/JIBE Class | ||||
| jibsa | jv_jibsa | JIB/JIBE SbClsA | ||||
| jibsb | jv_jibsb | JIB/JIBE Sub B | ||||
| billcode | jv_billco | Billing Code | ||||
| ceind | jv_ceind | Expense Type | ||||
| tangind | jv_tangi | Tangible Ind | ||||
| afenum | j_objnrext | Object | ||||
| sds_co | jv_sds | SDS | ||||
| sds_acc | jv_sds | SDS | ||||
| sds_ri | jv_sds | SDS | ||||
| jib_cobj | jib_cobj | JIB Cost Objects | ||||
| jib_ca | jib_ca | JIB/JIBE Class | ||||
| jib_cab | jib_cab | JIB/JIBE Class |
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 index table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T8JIX (
RCLNT, -- Client [mandt]
JV_REC, -- Record number [gu_recid]
POPER, -- Posting Period [poper]
RYEAR, -- Fiscal Year [gjahr]
FYEARPERIOD, -- Fiscal YPeriod [fins_fyearperiod]
FYEARPERIOD_NEXT, -- Fiscal YPeriod [fins_fyearperiod]
RBUKRS, -- Company Code [bukrs]
RJVNAM, -- Joint venture [jv_name]
REGROU, -- Equity group [jv_egroup]
RACCT, -- Account Number [racct]
RBUSA, -- Business Area [gsber]
RCNTR, -- Cost Center [kostl]
RORDNR, -- Order [aufnr]
RPROJK, -- WBS Element [ps_psp_pnr]
RPRCTR, -- Profit Center [prctr]
RANLN1, -- Asset [anln1]
RANLN2, -- Sub-number [anln2]
RANBWA, -- Ast Transaction Type [anbwa]
RRECIN, -- Recovery Ind. [jv_recind]
RPARTN, -- Partner [jv_part]
RKOKRS, -- CO Area [kokrs]
JIBCL, -- JIB/JIBE Class [jv_jibcl]
JIBSA, -- JIB/JIBE SbClsA [jv_jibsa]
JIBSB, -- JIB/JIBE Sub B [jv_jibsb]
BILLCODE, -- Billing Code [jv_billco]
CEIND, -- Expense Type [jv_ceind]
TANGIND, -- Tangible Ind [jv_tangi]
AFENUM, -- Object [j_objnrext]
SDS_CO, -- SDS [jv_sds]
SDS_ACC, -- SDS [jv_sds]
SDS_RI, -- SDS [jv_sds]
JIB_COBJ, -- JIB Cost Objects [jib_cobj]
JIB_CA, -- JIB/JIBE Class [jib_ca]
JIB_CAB, -- JIB/JIBE Class [jib_cab]
PRIMARY KEY (RCLNT, JV_REC)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA