| 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 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKS_D | Allow NULL? |
| 3 | AUART | Order Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T003O | AUFART | Allow NULL? |
| 4 | VORGANG | Business function (for availability check) | char | 1 | 0 | CHAR | (N' ') | No | | CO_VFVG | Allow NULL? |
| 5 | PRUEFKZ | Indicator: No material availability check | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_PRUEFKZ | Allow NULL? |
| 6 | PRREG | Checking Rule for Availability Check | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T441R | PRREG | Allow NULL? |
| 7 | FRMAT | Release control for material | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_FRMAT | Allow NULL? |
| 8 | CF_VPRKZ | Indicator: Do not check PRT availability | char | 1 | 0 | CHAR | (N' ') | Yes | | CF_VPRKZ | Allow NULL? |
| 9 | CF_PRREG | Checking rule for PRT availability check | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CF_PRREG | Allow NULL? |
| 10 | CF_PRFRS | Release control based on the PRT availability check | char | 1 | 0 | CHAR | (N' ') | Yes | | CF_PRFRS | Allow NULL? |
| 11 | PRART | Indicator: Check status only for material availability | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_PRART | Allow NULL? |
| 12 | VPKAPKZ | Indicator check capacity availability | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_VPKAPA | Allow NULL? |
| 13 | VPKAPPROF | ID of an overall profile for capacity availability check | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TCY30 | CY_KAPPROF | Allow NULL? |
| 14 | VPKAPFR | Release control availability check capacities | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_FRKAPA | Allow NULL? |
| 15 | EROMAT | Creation control for availability check material | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_EROMAT | Allow NULL? |
| 16 | VPKAPERO | Creation control if capacity is missing | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_EROKAPA | Allow NULL? |
| 17 | CF_EROFHM | Creation control when PRTs are not available | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_EROFHM | Allow NULL? |
| 18 | KZAKP | Indicator for type of component check | char | 1 | 0 | CHAR | (N' ') | Yes | | KZAKP | Allow NULL? |
| 19 | ATPSAVEKZ | Check material availability when saving order (network) | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_ATPSAVEKZ | Allow NULL? |
| 20 | FHMSAVEKZ | Indicator: Check PRT availability when saving order | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_FHMSAVEKZ | Allow NULL? |
| 21 | KAPSAVEKZ | Indicator: Check capacity availability when saving | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_KAPSAVEKZ | Allow NULL? |
| 22 | FRBATCH | Release Control for Materials Handled in Batches | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_FRBATCH | Allow NULL? |
