| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | RBUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 3 | PROCESS | Joint venture process | nvarchar | 4 | 0 | CHAR | (N' ') | No | | JV_PROC_EV | Allow NULL? |
| 4 | RYEAR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR | Allow NULL? |
| 5 | DOCNR | Doc. Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | DOCNR | Allow NULL? |
| 6 | DOCLN | Document line | nvarchar | 3 | 0 | CHAR | (N' ') | No | | DOCLN | Allow NULL? |
| 7 | POPER | Posting period | nvarchar | 3 | 0 | NUMC | (N'000') | No | | POPER | Allow NULL? |
| 8 | SEQNO | JV event sequence number | nvarchar | 3 | 0 | NUMC | (N'000') | No | | JV_EV_SEQ | Allow NULL? |
| 9 | RJVNAM | Joint Venture | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | JV_NAME | Allow NULL? |
| 10 | REGROU_OLD | Equity Group Old | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | JV_EGROUP_OLD | Allow NULL? |
| 11 | REGROU_NEW | Equity Group New | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | JV_EGROUP_NEW | Allow NULL? |
| 12 | REFDOCNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BELNR_D | Allow NULL? |
| 13 | REFRYEAR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 14 | REFDOCLN | Line Item in Joint Venture Reference Doc | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | JV_REFDLN | Allow NULL? |
| 15 | REFDOCCT | Document Type | char | 1 | 0 | CHAR | (N' ') | Yes | | DOCCT | Allow NULL? |
| 16 | REFACTIV | Business Transaction | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | GLVOR | Allow NULL? |
| 17 | REFFIDLN | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | BUZEI | Allow NULL? |
| 18 | REFFIDOC | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BELNR_D | Allow NULL? |
| 19 | REV_AWTYP | Reference Transaction | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | AWTYP | Allow NULL? |
| 20 | REV_AWORG | Reference Organizational Units | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AWORG | Allow NULL? |
| 21 | REV_AWREF | Reference Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AWREF | Allow NULL? |
| 22 | REV_BELNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BELNR_D | Allow NULL? |
| 23 | REV_BUZEI | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | BUZEI | Allow NULL? |
| 24 | REP_AWTYP | Reference Transaction | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | AWTYP | Allow NULL? |
| 25 | REP_AWORG | Reference Organizational Units | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AWORG | Allow NULL? |
| 26 | REP_AWREF | Reference Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AWREF | Allow NULL? |
| 27 | REP_BELNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BELNR_D | Allow NULL? |
| 28 | REP_BUZEI | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | BUZEI | Allow NULL? |
| 29 | CPUDT | Day On Which Accounting Document Was Entered | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CPUDT | Allow NULL? |
| 30 | CPUTM | Time of Entry | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CPUTM | Allow NULL? |
| 31 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
