T8JQ
Joint Venture Owner Equity
T8JQ is an SAP database table in S/4HANA. Joint Venture Owner Equity. It contains 21 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_JntVntrPartOwnrEquityShr | view | from | BASIC | Joint Venture Owner Equity Share |
| I_JointVentureDetails | view | left_outer | BASIC | Master Data for Joint Venture |
Fields (21)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | bukrs | BUKRS | Company Code | |||
| KEY | vname | JV_NAME | Joint venture | |||
| KEY | egrup | JV_EGROUP | Equity group | |||
| KEY | partn | JV_PARTN | Partner | |||
| eqshare | JV_ESHARE | Equity Share | ||||
| ownsusp | JV_OWNSUSP | Owner Suspended | ||||
| ownsusper | JV_OSUSPER | OSusper | ||||
| ownsusyear | JV_OSUSYR | OSysY | ||||
| ownunsus | JV_OWNUSP | OwnUsp | ||||
| ownususper | JV_GUSUSP | GUSUSP | ||||
| ownususyr | JV_GUSUSYR | Grp Unsusp Yr | ||||
| inttype | JV_INTTYPE | Interest Type | ||||
| drillrecpc | JV_DRILLRP | DrillRecPerc | ||||
| operrecpc | JV_OPERRP | OperRP | ||||
| stoppay | JV_STOPPAY | StopPay | ||||
| cioutper | JV_CIPER | Out of CI Per. | ||||
| cioutyear | JV_CIYEAR | Out of CI Year | ||||
| cigroup | JV_CIGRP | CI Group | ||||
| npigroup | JV_NPIGRP | NPI Group | ||||
| regio | JV_REGIO | Area |
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 Venture Owner Equity
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T8JQ (
MANDT, -- Client [MANDT]
BUKRS, -- Company Code [BUKRS]
VNAME, -- Joint venture [JV_NAME]
EGRUP, -- Equity group [JV_EGROUP]
PARTN, -- Partner [JV_PARTN]
EQSHARE, -- Equity Share [JV_ESHARE]
OWNSUSP, -- Owner Suspended [JV_OWNSUSP]
OWNSUSPER, -- OSusper [JV_OSUSPER]
OWNSUSYEAR, -- OSysY [JV_OSUSYR]
OWNUNSUS, -- OwnUsp [JV_OWNUSP]
OWNUSUSPER, -- GUSUSP [JV_GUSUSP]
OWNUSUSYR, -- Grp Unsusp Yr [JV_GUSUSYR]
INTTYPE, -- Interest Type [JV_INTTYPE]
DRILLRECPC, -- DrillRecPerc [JV_DRILLRP]
OPERRECPC, -- OperRP [JV_OPERRP]
STOPPAY, -- StopPay [JV_STOPPAY]
CIOUTPER, -- Out of CI Per. [JV_CIPER]
CIOUTYEAR, -- Out of CI Year [JV_CIYEAR]
CIGROUP, -- CI Group [JV_CIGRP]
NPIGROUP, -- NPI Group [JV_NPIGRP]
REGIO, -- Area [JV_REGIO]
PRIMARY KEY (MANDT, BUKRS, VNAME, EGRUP, PARTN)
);
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