| 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 | PCMNR | Production campaign number | nvarchar | 12 | 0 | CHAR | (N' ') | No | | PCMNR | Allow NULL? |
| 3 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 4 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 5 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 6 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 7 | PCART | Production campaign category | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PCART | Allow NULL? |
| 8 | PCSTD | Start of validity period of production campaign | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PCSTDAY | Allow NULL? |
| 9 | PCSTT | Start of production campaign (time) | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PCSTTIME | Allow NULL? |
| 10 | PCEND | End of validity period of production campaign (validity end) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PCENDDAY | Allow NULL? |
| 11 | PCENT | End of production campaign (time) | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PCENDTIME | Allow NULL? |
| 12 | GPROZGR | Group Name | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | GRPNAME | Allow NULL? |
| 13 | GPROZNR | Business Process | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | CO_PRZNR | Allow NULL? |
| 14 | PCTXT | Description of Production Campaign | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PCTXT | Allow NULL? |
| 15 | TAKT | Takt time in the production campaign | decimal | 5 | 0 | QUAN | ((0)) | Yes | | TAKT | |
| 16 | UOM | Unit for production campaign takt | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | | TAKT_UOM | Allow NULL? |
| 17 | PCMID | UUID in compressed form (22 character UUENCODEd) | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | SYSUUID_22 | Allow NULL? |
| 18 | APOZ | Indicator of whether the prod. camp. is relevant for APO | char | 1 | 0 | CHAR | (N' ') | Yes | | PC_APOKZ | Allow NULL? |