| 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 | LEADOBJ | Leading Organizational Unit for Asset Accounting | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | FAA_ORG_CA | Allow NULL? |
| 3 | ANLN1 | Main Asset Number | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | ANLN1 | Allow NULL? |
| 4 | ANLN2 | Asset Subnumber | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | ANLN2 | Allow NULL? |
| 5 | TC_ID | Test Case ID (File Name) | nvarchar | 60 | 0 | CHAR | (N' ') | No | | FAA_TENV_TC_ID | Allow NULL? |
| 6 | RDC_DSC | Description for Requested Data Collection | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | FAA_TENV_RDC_DSC | Allow NULL? |
| 7 | ANL_DSC1 | Asset description | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | TXA50_ANLT | Allow NULL? |
| 8 | ANL_DSC2 | Additional asset description | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | TXA50_MORE | Allow NULL? |
| 9 | ADD_ANL_DSC | Additional Description of Your Choice | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | FAA_TENV_ADD_DSC | Allow NULL? |
| 10 | CATEGORY1 | Category, Selection Criteria, of Your Choice | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | FAA_TENV_CATEGORY | Allow NULL? |
| 11 | CATEGORY2 | Category, Selection Criteria, of Your Choice | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | FAA_TENV_CATEGORY | Allow NULL? |
| 12 | CATEGORY3 | Category, Selection Criteria, of Your Choice | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | FAA_TENV_CATEGORY | Allow NULL? |
| 13 | CFG_ID | Configuration ID (File Name) | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | FAA_TENV_CFG_ID | Allow NULL? |
| 14 | SAP_INST_NUMBER | SAP Installation Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | FAA_TENV_SAP_INST_NUMBER | Allow NULL? |
| 15 | LOGSYS | Logical system | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LOGSYS | Allow NULL? |
| 16 | LEADOBJ_TYPE | | nvarchar | 50 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 17 | TMSTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
