| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PVGUID | Internal Number of the PVS Variant | varbinary | 16 | 0 | | | | |
| 3 | PVCDCNT | Internal Counter for iPPE Objects | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | AENNR | Change Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 5 | DELFLG | Deletion Indicator | char | 1 | 0 | | | | Allow NULL? |
| 6 | STDVAR | Indicator: Standard Variant (Recipe) | char | 1 | 0 | | | | Allow NULL? |
| 7 | ISTATUS | Individual Status of Object | nvarchar | 5 | 0 | | | | Allow NULL? |
| 8 | STATUS_CHG_COUNT | Copy counter | tinyint | 3 | 0 | | | | |
| 9 | OBJNR | Object Number | nvarchar | 22 | 0 | | | | Allow NULL? |
| 10 | ISTATUS_OLD | Object status | nvarchar | 5 | 0 | | | | Allow NULL? |
| 11 | RCPDCNT | Change State in Recipe | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | RCPVERS | Version of the General Recipe | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | VALFROM | Valid-From Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | VALTO | Valid-To Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | LOTMIN | Lower Limit of Lot-Size Range | decimal | 13 | 3 | | | | |
| 16 | LOTMAX | Upper Limit of Lot-Size Range | decimal | 13 | 3 | | | | |
| 17 | LOTUNIT | Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | PV_PLANT | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | PV_MAT | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 20 | PV_NR | Production Version | nvarchar | 4 | 0 | | | | Allow NULL? |
| 21 | OTYPE_ORGID | Object Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 22 | REALO | Responsible | nvarchar | 45 | 0 | | | | Allow NULL? |
| 23 | RCP_TIMSTMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun) | decimal | 21 | 7 | | | | |
| 24 | RCP_CREADAT | Date of Application | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | RCP_CREABY | User who created record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 26 | RCP_CHNGDAT | Date of Last Change | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | RCP_CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 28 | REFQUANT | Reference Quantity | decimal | 13 | 3 | | | | |
| 29 | PROJECT | WBS Element | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | DEV_TIME | Recipe Development Time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 31 | PROD_TIME | Productive Time of Recipe | nvarchar | 6 | 0 | | | | Allow NULL? |
| 32 | CONF_FLAG | Confidential | char | 1 | 0 | | | | Allow NULL? |
| 33 | REFLANG | Reference Language | char | 1 | 0 | | | | Allow NULL? |
| 34 | PVTXCNT | Counter for Text Tables | nvarchar | 5 | 0 | | | | Allow NULL? |
| 35 | RESCREATXCNT | Counter for Text Tables | nvarchar | 5 | 0 | | | | Allow NULL? |
| 36 | COPY_FROM | Origin | varbinary | 16 | 0 | | | | |
| 37 | COPY_FROM_RCP | Copied from | varbinary | 16 | 0 | | | | |
| 38 | PREF_RCP_FLG | Preferred Recipe | char | 1 | 0 | | | | Allow NULL? |
| 39 | CONS_FLG | Consistent | char | 1 | 0 | | | | Allow NULL? |
