| 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 | T000 | MANDT | Allow NULL? |
| 2 | RPLAN | Reorganization Plan | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | FAGL_R_PLAN | Allow NULL? |
| 3 | NODE_ID | Node in the Derivation Hierarchy | int | 10 | 0 | INT4 | ((0)) | No | | FAGL_R_NODE_ID | Allow NULL? |
| 4 | OBJ_TYPE | Object Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | FAGL_R_OBJ_TYPE | Allow NULL? |
| 5 | NUM_STATUS_00 | Number of Objects with "Included in Reorganization" Status | int | 10 | 0 | INT4 | ((0)) | Yes | | FAGL_R_NUM_STATUS_00 | Allow NULL? |
| 6 | NUM_STATUS_10 | Number of Objects with "Allocated to Object Owner" Status | int | 10 | 0 | INT4 | ((0)) | Yes | | FAGL_R_NUM_STATUS_10 | Allow NULL? |
| 7 | NUM_STATUS_20 | No. of Objects with "Approved for Further Processing" Status | int | 10 | 0 | INT4 | ((0)) | Yes | | FAGL_R_NUM_STATUS_20 | Allow NULL? |
| 8 | NUM_STATUS_25 | Number of Objects with "Reassignment Failed" Status | int | 10 | 0 | INT4 | ((0)) | Yes | | FAGL_R_NUM_STATUS_25 | Allow NULL? |
| 9 | NUM_STATUS_30 | Number of Objects with "Reassignment Successful" Status | int | 10 | 0 | INT4 | ((0)) | Yes | | FAGL_R_NUM_STATUS_30 | Allow NULL? |
| 10 | NUM_STATUS_35 | No. of Objects with "Balance Determination Failed" Status | int | 10 | 0 | INT4 | ((0)) | Yes | | FAGL_R_NUM_STATUS_35 | Allow NULL? |
| 11 | NUM_STATUS_40 | No. of Obj. with "Balance Determination Successful" Status | int | 10 | 0 | INT4 | ((0)) | Yes | | FAGL_R_NUM_STATUS_40 | Allow NULL? |
| 12 | NUM_STATUS_45 | Number of Objects with "Transfer Failed" Status | int | 10 | 0 | INT4 | ((0)) | Yes | | FAGL_R_NUM_STATUS_45 | Allow NULL? |
| 13 | NUM_STATUS_50 | No. Objects with "Reorganized Successfully" Status | int | 10 | 0 | INT4 | ((0)) | Yes | | FAGL_R_NUM_STATUS_50 | Allow NULL? |
| 14 | NUM_STATUS_60 | No. of Objects with "Not Included in Reorganization" Status | int | 10 | 0 | INT4 | ((0)) | Yes | | FAGL_R_NUM_STATUS_60 | Allow NULL? |
| 15 | TIME_GEN | Time of Last Successful Generation | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | FAGL_R_TIME_GEN | Allow NULL? |
| 16 | TIME_REASSIGN | Time of Last Successful Reassignment | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | FAGL_R_TIME_REASSIGN | Allow NULL? |
| 17 | TIME_REPOST | Time of Last Successful Transfer Posting | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | FAGL_R_TIME_REPOST | Allow NULL? |
| 18 | DATE_GEN | Date of Last Time When Record Was Generated Successfully | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAGL_R_DATE_GEN | Allow NULL? |
| 19 | DATE_REASSIGN | Date of Last Successful Reassignment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAGL_R_DATE_REASSIGN | Allow NULL? |
| 20 | DATE_REPOST | Date of Last Successful Transfer Posting | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAGL_R_DATE_REPOST | Allow NULL? |
| 21 | UNAME_GEN | Name of Last User to Successfully Generate | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | FAGL_R_UNAME_GEN | Allow NULL? |
| 22 | UNAME_REASSIGN | Name of Last User to Successfully Reassign | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | FAGL_R_UNAME_REASSIGN | Allow NULL? |
| 23 | UNAME_REPOST | Name of User Who Performed Last Successful Transfer Posting | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | FAGL_R_UNAME_REPOST | Allow NULL? |
| 24 | XDONE_GEN | Assignment Made Completely | char | 1 | 0 | CHAR | (N' ') | Yes | | FAGL_R_XDONE_GEN | Allow NULL? |
| 25 | XDONE_REASSIGN | Reassignment Made Completely | char | 1 | 0 | CHAR | (N' ') | Yes | | FAGL_R_XDONE_REASSIGN | Allow NULL? |
| 26 | XDONE_REPOST | Transfer Posting Made Completely | char | 1 | 0 | CHAR | (N' ') | Yes | | FAGL_R_XDONE_REPOST | Allow NULL? |
| 27 | XERROR_GEN | Error that prevents the XDONE indicator from being set | char | 1 | 0 | CHAR | (N' ') | Yes | | FAGL_R_XDONE_ERROR | Allow NULL? |
| 28 | XERROR_REASSIGN | Error that prevents the XDONE indicator from being set | char | 1 | 0 | CHAR | (N' ') | Yes | | FAGL_R_XDONE_ERROR | Allow NULL? |
| 29 | XERROR_REPOST | Error that prevents the XDONE indicator from being set | char | 1 | 0 | CHAR | (N' ') | Yes | | FAGL_R_XDONE_ERROR | Allow NULL? |