SAP Table T8JVB15
JV Structure Billing TA Fields Table
T8JVB15 (JV Structure Billing TA Fields Table) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link T8JVB15 to other SAP tables.
T8JVB15 table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||
PARTN | JV partner | JV_PARTN | T8JO | CHAR | 10 | 0 | ||||||
KURSF | Exchange rate | KURSF | DEC | 9 | 5 | |||||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | 0 | |||||||
SELECT | Selection Field | JV_SEL | CHAR | 1 | 0 |
Possible values
|
||||||
BKTXT | Billing header text | JV_BKTXT | CHAR | 25 | 0 | |||||||
WWERT | Translation Date | WWERT_D | DATS | 8 | 0 | |||||||
XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | 0 | |||||||
MONAT | Fiscal Period | MONAT | NUMC | 2 | 0 | |||||||
PRODPER | JVA_PROD_MONTH | ACCP | 6 | 0 | ||||||||
VNAME | Joint Venture | JV_NAME | T8JV | CHAR | 6 | 0 | ||||||
FUNDCUR | Funding currency | JV_FUNDCUR | T8JC2 | CUKY | 5 | 0 | ||||||
FCVAL | Funding Currency Amount | JV_FCVAL | CURR | 17 | 2 | |||||||
LCVAL | Local Currency Amount | JV_LCVAL | CURR | 17 | 2 | |||||||
NOBNO | JV Non-Operated Billing Number | JV_NOBNO | T8J4C | CHAR | 10 | 0 | ||||||
NGTEXT | JV Net or Gross Indicator Text | JV_NGTEXT | CHAR | 5 | 0 | |||||||
NBTEXT | JV Line Text for Non-Op Billing (Same as JV_DATA_ENTRY_TEXT) | LTEXT_8J3D | CHAR | 35 | 0 | |||||||
VTEXT | Joint Venture Text | JV_LTEXT | CHAR | 35 | 0 | |||||||
NBNET | Net Input Only | JV_NBNET | CHAR | 1 | 0 |
Possible values
|
||||||
NAME1 | Name | NAME1 | CHAR | 30 | 0 | |||||||
LTEXT | JV Text43 | JV_TEXT43 | CHAR | 43 | 0 | |||||||
UNAME | User Name | SYUNAME | CHAR | 12 | 0 | |||||||
SDATE | Date | DATUM | DATS | 8 | 0 | |||||||
KOSTL | Cost Center | KOSTL | CSKS | CHAR | 10 | 0 | ||||||
TOTAMT | Total Amount | JV_TOTAMT | CURR | 13 | 2 | |||||||
TOTTAX | Total Tax | JV_TOTTAX | CURR | 13 | 2 | |||||||
NETAMTF | JV Net amount funding currency | JV_NETAMTF | CURR | 13 | 2 | |||||||
TAXAMTF | Tax invoice amount | JV_TAXAMTF | CURR | 13 | 2 | |||||||
TAMNTF | JV tax amount in funding currency for header information | JV_TAMNTF | CURR | 13 | 2 | |||||||
EGRUP | Equity group | JV_EGROUP | T8JF | CHAR | 3 | 0 | ||||||
EGTXT | Investment Group Description | LTEXT_8JF | CHAR | 35 | 0 | |||||||
PROJN | WBS Element | PS_POSNR | PRPS | NUMC | 8 | 0 | ||||||
HKONT | G/L Account Number | SAKNR | SKA1 | CHAR | 10 | 0 | ||||||
LAND1 | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||||||
PAYMETHOD | Payment Method | DZLSCH | T042Z | CHAR | 1 | 0 | ||||||
PAYTERM | Terms of Payment Key | DZTERM | CHAR | 4 | 0 | |||||||
NOPSHARE | Non-Operated Share | JV_NOSHARE | DEC | 9 | 6 | |||||||
POSTFCVAL | non-op billing actual funding currency posting amount | JV_FCPVAL | CURR | 13 | 2 | |||||||
POSTUCVAL | non-op billing actual user currency posting amount | JV_UCPVAL | CURR | 13 | 2 | |||||||
USERCUR | User Currency | JV_USERCUR | TCURC | CUKY | 5 | 0 | ||||||
FUC_RATE | Exchange rate of user currency to funding currency | JV_FUCRATE | DEC | 9 | 5 | |||||||
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | 0 | |||||||
ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4 | 0 | |||||||
VYEAR | Acquisition year of the asset (manually changeable) | VYEAR | NUMC | 4 | 0 | |||||||
VMNTH | Asset Accounting: Acquis. month (in depreciation area) | VMNTH | NUMC | 3 | 0 | |||||||
ASSETTYPE | Asset Type | ASSETTYPE | CHAR | 12 | 0 | |||||||
ANLHTXT | Asset main number text | ANLHTXT | CHAR | 50 | 0 | |||||||
ASSETAMT | Non-Operated Billing Asset line amount | JV_ASSETVL | CURR | 13 | 2 | |||||||
FLAG | General Flag | FLAG | CHAR | 1 | 0 |
Possible values
|
||||||
ACQUISTVAL | Acquisition Value | ACQUSITION | CURR | 13 | 2 | |||||||
BUDGET | Old: Project number : No longer used --> PS_POSNR | PROJN | CHAR | 16 | 0 | |||||||
NETAMTL | JV Net amount local currency | JV_NETAMTL | CURR | 13 | 2 | |||||||
LOCLCUR | Local currency | JV_LOCLCUR | CUKY | 5 | 0 | |||||||
LCATXT | JV text length of 20 | JV_TEXT20 | CHAR | 22 | 0 | |||||||
LCTXT | JV text length of 20 | JV_TEXT20 | CHAR | 22 | 0 | |||||||
TRX_AMOUNT | JV General Billing Amount in transaction currency | JV_AMOUNT | CURR | 13 | 2 |
T8JVB15 foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
T8JVB15 | BUKRS | T8JVB15 | BUKRS | T001 | Company Codes | BUKRS |
T8JVB15 | BUKRS | * | T001 | Company Codes | MANDT | |
T8JVB15 | EGRUP | T8JVB15 | VNAME | T8JF | Investment Group | VNAME |
T8JVB15 | EGRUP | T8JVB15 | EGRUP | T8JF | Investment Group | EGRUP |
T8JVB15 | EGRUP | * | T8JF | Investment Group | MANDT | |
T8JVB15 | EGRUP | T8JVB15 | BUKRS | T8JF | Investment Group | BUKRS |
T8JVB15 | FUNDCUR | T8JVB15 | VNAME | T8JC2 | Funding Currency by Equity Group | VNAME |
T8JVB15 | FUNDCUR | T8JVB15 | EGRUP | T8JC2 | Funding Currency by Equity Group | EGRUP |
T8JVB15 | FUNDCUR | T8JVB15 | FUNDCUR | T8JC2 | Funding Currency by Equity Group | FUNDCUR |
T8JVB15 | FUNDCUR | SY | MANDT | T8JC2 | Funding Currency by Equity Group | MANDT |
T8JVB15 | FUNDCUR | T8JVB15 | BUKRS | T8JC2 | Funding Currency by Equity Group | BUKRS |
T8JVB15 | HKONT | * | SKA1 | G/L Account Master (Chart of Accounts) | MANDT | |
T8JVB15 | HKONT | * | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL | |
T8JVB15 | HKONT | T8JVB15 | HKONT | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
T8JVB15 | KOSTL | * | CSKS | Cost Center Master Data | MANDT | |
T8JVB15 | KOSTL | * | CSKS | Cost Center Master Data | KOKRS | |
T8JVB15 | KOSTL | T8JVB15 | KOSTL | CSKS | Cost Center Master Data | KOSTL |
T8JVB15 | KOSTL | T8JVB15 | SDATE | CSKS | Cost Center Master Data | DATBI |
T8JVB15 | LAND1 | * | T005 | Countries | MANDT | |
T8JVB15 | LAND1 | T8JVB15 | LAND1 | T005 | Countries | LAND1 |
T8JVB15 | NOBNO | T8J4C | MANDT | T8J4C | Bill Trans Fields Table (Deprecated -> replaced by T8J4G) | MANDT |
T8JVB15 | NOBNO | T8JVB15 | BUKRS | T8J4C | Bill Trans Fields Table (Deprecated -> replaced by T8J4G) | BUKRS |
T8JVB15 | NOBNO | T8JVB15 | NOBNO | T8J4C | Bill Trans Fields Table (Deprecated -> replaced by T8J4G) | NOBNO |
T8JVB15 | PARTN | SYST | MANDT | T8JO | Partner | MANDT |
T8JVB15 | PARTN | T8JVB15 | BUKRS | T8JO | Partner | BUKRS |
T8JVB15 | PARTN | T8JVB15 | PARTN | T8JO | Partner | PARTN |
T8JVB15 | PAYMETHOD | * | T042Z | Payment Methods for Automatic Payment | MANDT | |
T8JVB15 | PAYMETHOD | T8JVB15 | LAND1 | T042Z | Payment Methods for Automatic Payment | LAND1 |
T8JVB15 | PAYMETHOD | T8JVB15 | PAYMETHOD | T042Z | Payment Methods for Automatic Payment | ZLSCH |
T8JVB15 | PROJN | T8JVB15 | PROJN | PRPS | WBS (Work Breakdown Structure) Element Master Data | PSPNR |
T8JVB15 | PROJN | * | PRPS | WBS (Work Breakdown Structure) Element Master Data | MANDT | |
T8JVB15 | USERCUR | SY | MANDT | TCURC | Currency Codes | MANDT |
T8JVB15 | USERCUR | T8JVB15 | USERCUR | TCURC | Currency Codes | WAERS |
T8JVB15 | VNAME | T8JVB15 | BUKRS | T8JV | Joint Venture | BUKRS |
T8JVB15 | VNAME | T8JVB15 | VNAME | T8JV | Joint Venture | VNAME |
T8JVB15 | VNAME | * | T8JV | Joint Venture | MANDT |