| 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 | RPLAN | Reorganization Plan | nvarchar | 10 | 0 | CHAR | (N' ') | No | | FAGL_R_PLAN | Allow NULL? |
| 3 | PLAN_TYPE | Reorganization Plan Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | FAGL_R_PLTY0 | FAGL_R_PLAN_TYPE | Allow NULL? |
| 4 | REORG_DATE | Reorganization Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAGL_R_DATE | Allow NULL? |
| 5 | VERSION | Version of a Derivation Hierarchy | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | FAGL_R_DH_VERSION | Allow NULL? |
| 6 | STATUS | Reorganization Plan Status | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | FAGL_R_PLAN_STATUS | Allow NULL? |
| 7 | XASS_COMBINED | Account Assignment Elements Are Handled Together | char | 1 | 0 | CHAR | (N' ') | Yes | | FAGL_R_XASS_COMBINED | Allow NULL? |
| 8 | DATE_CREATED | Date on which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAGL_R_DATE_CREATED | Allow NULL? |
| 9 | UNAME_CREATED | Name of the User who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | FAGL_R_UNAME_CREATED | Allow NULL? |
| 10 | DATE_CHANGED | Date on which Record Was Changed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAGL_R_DATE_CHANGED | Allow NULL? |
| 11 | UNAME_CHANGED | Name of the Last User to Change the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | FAGL_R_UNAME_CHANGED | Allow NULL? |
| 12 | NUM_STATUS_00 | Number of Objects with "Included in Reorganization" Status | int | 10 | 0 | INT4 | ((0)) | Yes | | FAGL_R_NUM_STATUS_00 | Allow NULL? |
| 13 | 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? |
| 14 | 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? |
| 15 | NUM_STATUS_25 | Number of Objects with "Reassignment Failed" Status | int | 10 | 0 | INT4 | ((0)) | Yes | | FAGL_R_NUM_STATUS_25 | Allow NULL? |
| 16 | NUM_STATUS_30 | Number of Objects with "Reassignment Successful" Status | int | 10 | 0 | INT4 | ((0)) | Yes | | FAGL_R_NUM_STATUS_30 | Allow NULL? |
| 17 | NUM_STATUS_35 | No. of Objects with "Balance Determination Failed" Status | int | 10 | 0 | INT4 | ((0)) | Yes | | FAGL_R_NUM_STATUS_35 | Allow NULL? |
| 18 | NUM_STATUS_40 | No. of Obj. with "Balance Determination Successful" Status | int | 10 | 0 | INT4 | ((0)) | Yes | | FAGL_R_NUM_STATUS_40 | Allow NULL? |
| 19 | NUM_STATUS_45 | Number of Objects with "Transfer Failed" Status | int | 10 | 0 | INT4 | ((0)) | Yes | | FAGL_R_NUM_STATUS_45 | Allow NULL? |
| 20 | NUM_STATUS_50 | No. Objects with "Reorganized Successfully" Status | int | 10 | 0 | INT4 | ((0)) | Yes | | FAGL_R_NUM_STATUS_50 | Allow NULL? |
| 21 | 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? |