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