| 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 | AVFMA | Company Pension Scheme Pension Organizations | nvarchar | 4 | 0 | CHAR | (N' ') | No | T5DC3 | P01C_AVFMA | Allow NULL? |
| 3 | DTYPE | Statement Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | T5DC7 | P01C_DTYPE | Allow NULL? |
| 4 | VKPF1 | First Company Header | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | P01C_VKPF1 | Allow NULL? |
| 5 | VKPF2 | Second Company Header | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | P01C_VKPF2 | Allow NULL? |
| 6 | VFSS1 | First Company Footer | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | P01C_VFSS1 | Allow NULL? |
| 7 | VFSS2 | Second Company Footer | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | P01C_VFSS2 | Allow NULL? |
| 8 | LOGO1 | Logo of Pension Organization | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | P01C_LOGO1 | Allow NULL? |
| 9 | LOGO2 | Logo of Pension Organization | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | P01C_LOGO1 | Allow NULL? |
| 10 | MAKR1 | Character Field Length = 10 | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CHAR10 | Allow NULL? |
| 11 | MAKR2 | Character Field Length = 10 | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CHAR10 | Allow NULL? |
| 12 | ADRSS | Address | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | P01C_ADRSS | Allow NULL? |
| 13 | ANRE1 | Form-of-Address Key | char | 1 | 0 | CHAR | (N' ') | Yes | T522G | ANRDE | Allow NULL? |
| 14 | ANRE2 | Form-of-Address Key | char | 1 | 0 | CHAR | (N' ') | Yes | T522G | ANRDE | Allow NULL? |
| 15 | SIGN1 | Name of authorized signatory | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P01C_SIGN1 | Allow NULL? |
| 16 | SIGN2 | Name of authorized signatory | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P01C_SIGN1 | Allow NULL? |
| 17 | FUNK1 | Function Description for Authorized Signatories | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P01C_FUNK1 | Allow NULL? |
| 18 | FUNK2 | Function Description for Authorized Signatories | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P01C_FUNK1 | Allow NULL? |
| 19 | FUNKA | Enhanced Function Description for Authorized Signatories | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P01C_FUNKA | Allow NULL? |
| 20 | FUNKB | Enhanced Function Description for Authorized Signatories | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P01C_FUNKA | Allow NULL? |
| 21 | KZSB1 | Indicator: 1st Authorized Signatory = Administrator | char | 1 | 0 | CHAR | (N' ') | Yes | | P01C_KZSB1 | Allow NULL? |
| 22 | KZSB2 | Indicator: 2nd Authorized Signatory = Administrator | char | 1 | 0 | CHAR | (N' ') | Yes | | P01C_KZSB2 | Allow NULL? |
