| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | USERID | User ID in SAP Business-to-Business Procurement | nvarchar | 16 | 0 | | | | Allow NULL? |
| 3 | USER_TYPE | User Type in SAP Business-to-Business Procurement | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | FIRSTNAME | First name | nvarchar | 40 | 0 | | | | Allow NULL? |
| 5 | LASTNAME | Last name | nvarchar | 40 | 0 | | | | Allow NULL? |
| 6 | TITLE | Formal title | nvarchar | 30 | 0 | | | | Allow NULL? |
| 7 | FORMOFADDR | Form of address | nvarchar | 30 | 0 | | | | Allow NULL? |
| 8 | LANGU | Language Key | char | 1 | 0 | | | | Allow NULL? |
| 9 | BUILDING_P | Building (number or code) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | ROOM_NO_P | Room number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 11 | INHOUSE_ML | Internal mail | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | TEL1_NUMBR | First telephone number | nvarchar | 30 | 0 | | | | Allow NULL? |
| 13 | TEL1_EXT | Extension number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | TEL2_NUMBR | Second telephone number | nvarchar | 30 | 0 | | | | Allow NULL? |
| 15 | TEL2_EXT | Extension number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 16 | FAX_NUMBER | Fax number | nvarchar | 30 | 0 | | | | Allow NULL? |
| 17 | E_MAIL | E-mail address | nvarchar | 241 | 0 | | | | Allow NULL? |
| 18 | DATFM | Date format | char | 1 | 0 | | | | Allow NULL? |
| 19 | DCPFM | Decimal notation | char | 1 | 0 | | | | Allow NULL? |
| 20 | PHOTO | URL of picture | nvarchar | 135 | 0 | | | | Allow NULL? |
| 21 | APPROVE_IND | Approval indicator for creating a user | char | 1 | 0 | | | | Allow NULL? |
| 22 | SECRETARY | User ID in Internet user master | nvarchar | 16 | 0 | | | | Allow NULL? |
| 23 | PASSWORD | Proposed password for component user | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | ITS_DESTINATION | Name of host | nvarchar | 132 | 0 | | | | Allow NULL? |
| 25 | GROUP_NO | Current tree node number | nvarchar | 16 | 0 | | | | Allow NULL? |
| 26 | ORG_UNIT | Object ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | CHANGED_GROUP | Group number from PID tree | nvarchar | 16 | 0 | | | | Allow NULL? |
| 28 | CHANGED_ORG | User Name in User Master Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 29 | FORWARD_WI | General Flag | char | 1 | 0 | | | | Allow NULL? |
| 30 | BBPPCINS | Procurement card company | nvarchar | 4 | 0 | | | | Allow NULL? |
| 31 | PCNUM | Procurement card number | nvarchar | 25 | 0 | | | | Allow NULL? |
| 32 | HOLDER_NAME | Name of procurement cardholder | nvarchar | 40 | 0 | | | | Allow NULL? |
| 33 | WFAGENT2 | Second workflow agent ID for procurement card | nvarchar | 12 | 0 | | | | Allow NULL? |
| 34 | PCDAT_FROM | Procurement card valid from date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 35 | PCDAT_TO | Procurement card expiration date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 36 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 37 | LOC_CURRCY | Local Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 38 | GL_ACCOUNT | General Ledger Account | nvarchar | 10 | 0 | | | | Allow NULL? |
| 39 | COSTCENTER | Cost Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 40 | FLOOR_P | Floor in building | nvarchar | 10 | 0 | | | | Allow NULL? |
| 41 | DUMMY_ITEM | Dummy function in length 1 | char | 1 | 0 | | | | Allow NULL? |
