| 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 | TABNR | Reference Number to Table Part | nvarchar | 32 | 0 | CHAR | (N' ') | No | HRITABNR | HRTABNR | Allow NULL? |
| 3 | TABSEQNR | Sequence Number in Table Part of Table Infotype | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | HRTABSEQNR | Allow NULL? |
| 4 | COLUMN_ID | Appraisal Document Column ID | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | HAP_COLUMN_ID | Allow NULL? |
| 5 | COLUMN_OWNER | Column Owner | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T77HAP_FLT_CAO | HAP_COLUMN_OWNER | Allow NULL? |
| 6 | ACCESS_P1_OWNER | Planning: Column Access Authorizations for Owners | char | 1 | 0 | CHAR | (N' ') | Yes | | HAP_ACCESS_P1_OWNER | Allow NULL? |
| 7 | ACCESS_P1_OTHER | Planning: Column Access Authorizations for Others | char | 1 | 0 | CHAR | (N' ') | Yes | | HAP_ACCESS_P1_OTHER | Allow NULL? |
| 8 | ACCESS_P2_OWNER | Review: Column Access Authorizations for Owners | char | 1 | 0 | CHAR | (N' ') | Yes | | HAP_ACCESS_P2_OWNER | Allow NULL? |
| 9 | ACCESS_P2_OTHER | Review: Column Access Authorizations for Others | char | 1 | 0 | CHAR | (N' ') | Yes | | HAP_ACCESS_P2_OTHER | Allow NULL? |
| 10 | ACCESS_P3A_OWNER | Part Appraisal: Column Access Authorizations for Owners | char | 1 | 0 | CHAR | (N' ') | Yes | | HAP_ACCESS_P3A_OWNER | Allow NULL? |
| 11 | ACCESS_P3A_OTHER | Part Appraisal: Column Access Authorizations for Others | char | 1 | 0 | CHAR | (N' ') | Yes | | HAP_ACCESS_P3A_OTHER | Allow NULL? |
| 12 | ACCESS_P3B_OWNER | Final Appraisal: Column Access Authorizations for Owners | char | 1 | 0 | CHAR | (N' ') | Yes | | HAP_ACCESS_P3B_OWNER | Allow NULL? |
| 13 | ACCESS_P3B_OTHER | Final Appraisal: Column Access Authorizations for Others | char | 1 | 0 | CHAR | (N' ') | Yes | | HAP_ACCESS_P3B_OTHER | Allow NULL? |