JVSO1

JV LI Table with Objects for JVTO1 | #transactional | Component: Joint Venture und Production Sharing Accounting

🔑 Keys (2)
💰 Amounts (3)
∑ Quantities (1)
📅 Dates (10)
☰ Categorical (6)
Other (32)
🔗 Relations (35)

Column Name	Description
RCLNT FK	Client
GL_SIRID	Record number of the line item record

Column Name	Description
💲 Currency Key (RTCUR):
TSL	Value in Transaction Currency
💲 Currency key of currency 2 (T882.CURR1):
HSL	Value in local currency
💲 Currency key of currency 3 (T882.CURR2):
KSL	Value in group currency

Column Name	Description
📏 Base Unit of Measure (RUNIT):
MSL	Quantity

Column Name	Description
BUDAT	Posting Date in the Document
WSDAT	Value Date for Currency Translation
VALUT	Value date
CPUDT	Day On Which Accounting Document Was Entered
CPUTM	Time of Entry
BLDAT	Document Date in Document
BILLM	Billing Month
POM	Processing operational month
SDATE	Start Date
PRODPER	Production Month (Date to find period and year)

Column Name	Description
RRCTY	Record Type	Show values
DRCRK	Debit/Credit Indicator	Show values
DOCCT	Document Category	Show values
REFDOCCT	Document Category	Show values
MMACT	JVA MM Activity Type	Show values
XSBL	Flag: Line is Split Basis Line	Show values

Column Name	Description	Domain name
RYEAR	Fiscal Year	GJAHR
POPER	Posting period	POPER
DOCNR	Document Number of an Accounting Document	BELNR
DOCLN	Line Item in Joint Venture Document	BUZEI
RPRCTR	Profit Center	PRCTR
RDPOM	Posting Period Difference for Operational Month	CHAR4
RDBILLM	Invoice Month: Posting Period Difference	CHAR4
AUFPL	Task List Number for Operations in Order	AUFPL
APLZL	General Counter for Order	CO_APLZL
VORNR	Operation/Activity Number	VORNR
SGTXT	Item Text	TEXT50
AUTOM	Indicator: Automatic posting lines	TEXT1
ACTIV	Business Transaction	CHAR4
REFDOCNR	Document Number of an Accounting Document	BELNR
REFRYEAR	Fiscal Year	GJAHR
REFDOCLN	Line Item in Joint Venture Reference Doc	NUMC5
REFACTIV	Business Transaction	CHAR4
REFFIDLN	Number of Line Item Within Accounting Document	BUZEI
USNAM	User Name	XUBNAME
CBPERIOD	JV Cutback Period	POPER
KTOSL	Transaction Key	CHAR3
CYCLE	Allocation/cycle	CYCLE
SEQNAME	Name of a Segment in Assessment/Distribution	SEQNAME
REFCYC	Reference Field for Allocation Cycle	TEXT10
AWORG	Reference Organizational Units	AWORG
REFAWREF	Reference document number	AWREF
REFAWORG	Reference Organizational Units	AWORG
REFFIDOC	Document Number of an Accounting Document	BELNR
CBCUSTOMER	Customer Number	KUNNR
CBVENDOR	Account Number of Supplier	LIFNR
CBPAYTERM	Terms of payment key	ZTERM
SBREFLN	Reference Split Basis Line Number	JV_SBREFLN

Master Data Relations	Join Conditions
Additional unit of measure	`JVSO1.RCLNT == T006.MANDT` `JVSO1.AUNIT == T006.MSEHI`
Reference procedure	`JVSO1.AWTYP == TTYP.AWTYP`
Billing indicator	`JVSO1.RCLNT == T8JA.MANDT` `JVSO1.BILID == T8JA.BILIND`
Joint Venture Indicator (Condition Key) Company Code Joint Venture Indicator (Condition Key) Client	`JVSO1.RBUKRS == T8JX.BUKRS` `JVSO1.CONDI == T8JX.CONDCODE` `JVSO1.RCLNT == T8JX.MANDT`
Document type Document Type Client	`JVSO1.DOCTY == T003.BLART` `JVSO1.RCLNT == T003.MANDT`
Logical system	`JVSO1.LOGSYS == TBDLS.LOGSYS`
Activity Type Controlling Area Activity Type Posting Date in the Document	`JVSO1.RCLNT == CSLA.MANDT` `JVSO1.RKOKRS == CSLA.KOKRS` `JVSO1.LSTAR == CSLA.LSTAR` `JVSO1.BUDAT == CSLA.DATBI`
Material Number Material Number Client	`JVSO1.MATNR == MARA.MATNR` `JVSO1.RCLNT == MARA.MANDT`
Tax code ? Tax on sales/purchases code	`JVSO1.RCLNT == T007A.MANDT` `JVSO1.[column in domain "KALSM_D"] == T007A.KALSM` `JVSO1.MWSKZ == T007A.MWSKZ`
Network Number for Account Assignment Network Number for Account Assignment Client	`JVSO1.NPLNR == AUFK.AUFNR` `JVSO1.RCLNT == AUFK.MANDT`
Original recovery indicator Company Code Original Recovery Indicator	`JVSO1.RCLNT == T8JJ.MANDT` `JVSO1.RBUKRS == T8JJ.BUKRS` `JVSO1.ORECID == T8JJ.RECID`
G/L account number ? Client Account Number	`JVSO1.[column in domain "KTOPL"] == SKA1.KTOPL` `JVSO1.RCLNT == SKA1.MANDT` `JVSO1.RACCT == SKA1.SAKNR`
Asset Transaction Type	`JVSO1.RCLNT == TABW.MANDT` `JVSO1.RANBWA == TABW.BWASL`
Asset Subnumber Asset Subnumber Company Code Main Asset Number	`JVSO1.RCLNT == ANLA.MANDT` `JVSO1.RANLN2 == ANLA.ANLN2` `JVSO1.RBUKRS == ANLA.BUKRS` `JVSO1.RANLN1 == ANLA.ANLN1`
Company Code	`JVSO1.RCLNT == T001.MANDT` `JVSO1.RBUKRS == T001.BUKRS`
Business area	`JVSO1.RCLNT == TGSB.MANDT` `JVSO1.RBUSA == TGSB.GSBER`
Client	`JVSO1.RCLNT == T000.MANDT`
Cost Center Posting Date in the Document Cost Center Controlling Area	`JVSO1.RCLNT == CSKS.MANDT` `JVSO1.BUDAT == CSKS.DATBI` `JVSO1.RCNTR == CSKS.KOSTL` `JVSO1.RKOKRS == CSKS.KOKRS`
Reference procedure	`JVSO1.REFAWTYP == TTYP.AWTYP`
Logical system	`JVSO1.REFLOGSYS == TBDLS.LOGSYS`
Equity group Joint venture Client Equity group Company Code	`JVSO1.RJVNAM == T8JF.VNAME` `JVSO1.RCLNT == T8JF.MANDT` `JVSO1.REGROU == T8JF.EGRUP` `JVSO1.RBUKRS == T8JF.BUKRS`
Joint venture Company Code Joint venture Client	`JVSO1.RBUKRS == T8JV.BUKRS` `JVSO1.RJVNAM == T8JV.VNAME` `JVSO1.RCLNT == T8JV.MANDT`
Controlling Area	`JVSO1.RCLNT == TKA01.MANDT` `JVSO1.RKOKRS == TKA01.KOKRS`
Ledger Ledger Client	`JVSO1.RLDNR == T881.RLDNR` `JVSO1.RCLNT == T881.MANDT`
Order Number Order Number Client	`JVSO1.RORDNR == AUFK.AUFNR` `JVSO1.RCLNT == AUFK.MANDT`
Partner account number	`JVSO1.RCLNT == KNA1.MANDT` `JVSO1.RPARTN == KNA1.KUNNR`
Recovery Indicator Company Code Recovery Indicator	`JVSO1.RCLNT == T8JJ.MANDT` `JVSO1.RBUKRS == T8JJ.BUKRS` `JVSO1.RRECIN == T8JJ.RECID`
Currency Key	`JVSO1.RCLNT == TCURC.MANDT` `JVSO1.RTCUR == TCURC.WAERS`
Base Unit of Measure	`JVSO1.RCLNT == T006.MANDT` `JVSO1.RUNIT == T006.MSEHI`
Version Ledger Client Version	`JVSO1.RLDNR == T894.RLDNR` `JVSO1.RCLNT == T894.MANDT` `JVSO1.RVERS == T894.RVERS`
Segment number within a cycle ? Segment number within a cycle Client ? Allocation/cycle	`JVSO1.[column in domain "SDATE"] == T811S.SDATE` `JVSO1.SEQNR == T811S.SEQNR` `JVSO1.RCLNT == T811S.MANDT` `JVSO1.[column in domain "DBNAM"] == T811S.TAB` `JVSO1.CYCLE == T811S.CYCLE`