| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | /SAPCEM/BDNUM | Number of Requisition Note | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | /SAPCEM/VKORG | Sales Organization, but Obsolete | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | /SAPCEM/VTWEG | Distribution Channel, but Obsolete | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | /SAPCEM/SPART | Division, but Obsolete | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | /SAPCEM/EMPFAE | Recipient | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | /SAPCEM/AGEXT | Debtor of Recipient | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | /SAPCEM/WEEXT | External Ship-To Party - Recipient | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | /SAPCEM/KTEXT | Short text for Requirements Header | nvarchar | 40 | 0 | | | | Allow NULL? |
| 10 | /SAPCEM/EXNUM | External Number of Requisition Note | nvarchar | 10 | 0 | | | | Allow NULL? |
| 11 | /SAPCEM/BDBEG | Requirement Start: Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | /SAPCEM/BDEND | Requirement End | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | /SAPCEM/PARNR | Number of contact person | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | /SAPCEM/BEDID | ID of the capacity requirements record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 15 | PSPNR | WBS Element | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 17 | ERZET | Entry time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 18 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | UNAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 20 | AEZET | Time last change was made | nvarchar | 6 | 0 | | | | Allow NULL? |
| 21 | AEDTM | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |