| 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 | OBJNR | Object number for financial transactions | nvarchar | 22 | 0 | CHAR | (N' ') | No | ONR00 | JBOBJNR | Allow NULL? |
| 3 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 4 | PARTNR | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | BUT000 | BP_PARTNR_NEW | Allow NULL? |
| 5 | SLPG | Limit Product Group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATLPG | TB_SLPG | Allow NULL? |
| 6 | RPORTB | Portfolio | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TWPOB | RPORTB | Allow NULL? |
| 7 | RDEALER | Trader | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | TZDEA | RDEALER | Allow NULL? |
| 8 | WAERS | Currency as Limit Characteristic | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | TB_WCHAR | Allow NULL? |
| 9 | CONTROL01 | Monitoring Unit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | TB_CONTROL | Allow NULL? |
| 10 | INTORG | Internal Organizational Unit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KLINTORG | TB_INTORGUNIT | Allow NULL? |
| 11 | RCOUNTRY | Relevant Country for Country Risk | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | TB_RISKCOUNTRY | Allow NULL? |
| 12 | COUNTRY | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAND1_GP | Allow NULL? |
| 13 | SECTOR | Industry of Business Partner | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TB038A | TB_INDSECT | Allow NULL? |
| 14 | RATING | Rating | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TP06 | BP_RATING | Allow NULL? |
| 15 | CRATING | Country Rating | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | TB_COUNTRYRATING | Allow NULL? |
| 16 | RRFIND | Recovery Rate | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | KL_RRFIND | Allow NULL? |
| 17 | CEQCLASS | CEQ Class | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | KL_CEQCLASS | Allow NULL? |
| 18 | LEQCLASS | Loss Equivalent Class | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | KL_LEQCLASS | Allow NULL? |
| 19 | SKE | Selection of Counterparty - Issuer Risk | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | KL_SKE | Allow NULL? |
| 20 | SPS | Primary - Secondary Risk | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | KL_SPS | Allow NULL? |
| 21 | LRB | Country Risk Area | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | KL_LRB | Allow NULL? |
| 22 | SRE | Transaction is Risk-Reducing | char | 1 | 0 | CHAR | (N' ') | Yes | | KL_RISK_EFFECT | Allow NULL? |
| 23 | SARAKT | Indicator: Counterparty/Issuer Risk Active | char | 1 | 0 | CHAR | (N' ') | Yes | | KL_ARAKT | Allow NULL? |
| 24 | SLRAKT | Indicator: Country Risk Active | char | 1 | 0 | CHAR | (N' ') | Yes | | KL_LRAKT | Allow NULL? |
| 25 | ARR | Default Risk Rule | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KLARRC | KL_DEFRIRE | Allow NULL? |
| 26 | DFIKT | Base Date for Fiction | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | KL_DFIKT | Allow NULL? |
| 27 | SKALID | Factory Calendar | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFACD | KL_SKALID | Allow NULL? |
| 28 | DMWAE | Base Date for Calculating Market Value Change Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | KL_DMWAE | Allow NULL? |
| 29 | DRBD | Base Date for Calculating the Risk Commitment Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | KL_DRBD | Allow NULL? |
| 30 | DBLFZ | Term Start (Original Term) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | KL_DBLFZ | Allow NULL? |
| 31 | DELFZ | Term End (Original Term) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | KL_DELFZ | Allow NULL? |
| 32 | DBMWAE | Base Date for Calculating Market Value Change Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | KL_DMWAE | Allow NULL? |
| 33 | DFIKTVGL | Base Date for Fiction | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | KL_DFIKT | Allow NULL? |
