| 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 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T5B1S | BUKRS | Allow NULL? |
| 3 | INSTG | Institution Group | nvarchar | 4 | 0 | CHAR | (N' ') | No | T5F99IG | P_99S_INSTGR | Allow NULL? |
| 4 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ENDDA | Allow NULL? |
| 5 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDA | Allow NULL? |
| 6 | INSTL | Institution Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5F99IE | P_99S_INST | Allow NULL? |
| 7 | REGNO | Registration Number at Institution | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P12_REGNO | Allow NULL? |
| 8 | CONTACTINST | Person to be contacted 1 | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | PERS1 | Allow NULL? |
| 9 | CONTACTFUNC | Person to be contacted | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | PERSF | Allow NULL? |
| 10 | FAX_INST | Fax Number of Contact Person (00678) | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P12_FAXNK | Allow NULL? |
| 11 | TEL_INST | Phone Number of Contact Person | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P12_TELNK | Allow NULL? |
| 12 | MOB_INST | Mobile Phone Number of Contact Person | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P12_MOBNR | Allow NULL? |
| 13 | EMAIL_INST | Email Address of Contact Person (00637) | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | P12_EMAIL | Allow NULL? |
| 14 | DIPBX_INST | P.O. Box Number | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | P12_DIPBX | Allow NULL? |
| 15 | CONTACT1 | Personnel number | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PERSNO | Allow NULL? |
| 16 | FAX1 | Fax Number of Contact Person (00678) | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P12_FAXNK | Allow NULL? |
| 17 | TEL1 | Phone Number of Contact Person | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P12_TELNK | Allow NULL? |
| 18 | MOB1 | Mobile Phone Number of Contact Person | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P12_MOBNR | Allow NULL? |
| 19 | EMAIL1 | Email Address of Contact Person (00637) | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | P12_EMAIL | Allow NULL? |
| 20 | DIPBX1 | P.O. Box Number | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | P12_DIPBX | Allow NULL? |
| 21 | CONTACT2 | Personnel number | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PERSNO | Allow NULL? |
| 22 | FAX2 | Fax Number of Contact Person (00678) | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P12_FAXNK | Allow NULL? |
| 23 | TEL2 | Phone Number of Contact Person | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P12_TELNK | Allow NULL? |
| 24 | MOB2 | Mobile Phone Number of Contact Person | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P12_MOBNR | Allow NULL? |
| 25 | EMAIL2 | Email Address of Contact Person (00637) | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | P12_EMAIL | Allow NULL? |
| 26 | DIPBX2 | P.O. Box Number | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | P12_DIPBX | Allow NULL? |
