| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | CRID | Control recipe number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 3 | WERK | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | BID | Process order | nvarchar | 12 | 0 | | | | Allow NULL? |
| 5 | PHSEQ | Control Recipe Destination | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | ADRES | Address of the Control Recipe Destination | nvarchar | 32 | 0 | | | | Allow NULL? |
| 7 | COTYP | Type of Control Recipe Destination | char | 1 | 0 | | | | Allow NULL? |
| 8 | TSTKZ | Indicator: Message or Control Recipe for Test Purposes | char | 1 | 0 | | | | Allow NULL? |
| 9 | CRSTAT | Control recipe status | nvarchar | 5 | 0 | | | | Allow NULL? |
| 10 | ANDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | ANUZT | Time when the record was created | nvarchar | 6 | 0 | | | | Allow NULL? |
| 12 | AEDAT | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | KTXT | Description | nvarchar | 40 | 0 | | | | Allow NULL? |
| 14 | MATNR | Material Number for Order | nvarchar | 18 | 0 | | | | Allow NULL? |
| 15 | MATXT | Material Description | nvarchar | 40 | 0 | | | | Allow NULL? |
| 16 | PRUEFLOS | Inspection Lot Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 17 | ERRKZ | Processing status of the process message/the control recipe | char | 1 | 0 | | | | Allow NULL? |
| 18 | ARFCIPID | Host ID (IP ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | ARFCPID | Process ID | nvarchar | 4 | 0 | | | | Allow NULL? |
| 20 | ARFCTIME | Time Stamp | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | ARFCTIDCNT | Transaction ID (LUW -> COMMIT WORK) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 22 | EXSTAT | Execution status of a control recipe | nvarchar | 5 | 0 | | | | Allow NULL? |
| 23 | CHARG | Batch Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 24 | FSAVD | Earliest scheduled start: Execution (date) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | FSAVZ | Earliest scheduled start: Execution (time) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 26 | DECNTRL_PRC | Indicator for Decentralized Control Recipe Execution | char | 1 | 0 | | | | Allow NULL? |
| 27 | XS_ID | XSteps: Unique ID of a Node | nvarchar | 22 | 0 | | | | Allow NULL? |
