| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | GUID | GUID | varbinary | 16 | 0 | RAW | | No | | /MRSS/T_GUID | |
| 3 | PARTNER_NO | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BU_PARTNER | Allow NULL? |
| 4 | PRODUCT | Product Name Entered | nvarchar | 54 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_ORDERED_PROD | Allow NULL? |
| 5 | KUNNR | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_DEM_KUNNR | Allow NULL? |
| 6 | PROBABILITY | Demand Probability | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_DEM_PROBABILITY | Allow NULL? |
| 7 | SUPERVISOR | Site supervisor indicator of demand | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_DEM_SUPERVISOR | Allow NULL? |
| 8 | SUPERVISOR_NO | Number of Site Supervisors for Demand | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | /MRSS/T_DEM_SUPERVISOR_NO | Allow NULL? |
| 9 | FOUND_RESOURCES | Resources Found for Demand | nvarchar | 200 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_DEM_FOUND_RESOURCES | Allow NULL? |
| 10 | AUTOMATIC_ASGN | Relevant for automatic assignment creation | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_DEM_AUTO_ASGN | Allow NULL? |
| 11 | SCHED_INDICATOR | Scheduling Indicator (Automatic Scheduling & Self Planning) | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SCHED_INDICATOR | Allow NULL? |
| 12 | SALES_ORG | Sales Org | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SALES_ORG | Allow NULL? |
| 13 | REQUESTER_EMAIL | E-Mail Address of Requester | nvarchar | 120 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_REQ_EMAIL | Allow NULL? |
| 14 | REQUESTER_UNAME | User Name of Requester | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_REQ_UNAME | Allow NULL? |
| 15 | REQUESTER_FNAME | Name of Requester | nvarchar | 132 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_REQ_NAME | Allow NULL? |
| 16 | REQUESTER_TLNUM | Telephone Number of Requester | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_REQ_TLNUM | Allow NULL? |
| 17 | DURATN_SRC | Duration of Demand Source | decimal | 13 | 3 | QUAN | ((0)) | Yes | | /MRSS/T_DURATION_SOURCE | |
| 18 | DURATN_SRC_UNIT | Unit of Duration from Demand Source | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /MRSS/T_DURATION_SOURCE_UNIT | Allow NULL? |
| 19 | TIME_CALC_CAPA | Calculation of Demand Duration Active | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGE_TIME_CALC_CAPA | Allow NULL? |
| 20 | STATUS_GRP_ID | ID of status group | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_STATUS_GROUP_ID | Allow NULL? |
| 21 | REF_GUID_H | GUID | varbinary | 16 | 0 | RAW | | Yes | | /MRSS/T_GUID | |
| 22 | REF_GUID_I | GUID | varbinary | 16 | 0 | RAW | | Yes | | /MRSS/T_GUID | |
| 23 | REF_EXT_ID | Project Planning: External Identifier of an Element | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGD_CGPL_EXTID | Allow NULL? |
| 24 | ACTIVITY_TYPE | Process Variant | char | 1 | 0 | CHAR | (N' ') | Yes | | /MRSS/T_SGU_ACTIVITY_TYPE | Allow NULL? |
| 25 | DUMMY | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 26 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | RAW | | Yes | | /MRSS/T_GUID | |
| 27 | APPT_EARL_START | Earliest Start of the Appointment | decimal | 15 | 0 | DEC | ((0)) | Yes | | /MRSS/T_DEM_APPOINT_EARL_START | |
| 28 | APPT_LAT_START | Latest Start of the Appointment | decimal | 15 | 0 | DEC | ((0)) | Yes | | /MRSS/T_DEM_APPOINT_LAT_START | |
| 29 | APPT_EARL_END | Earliest End of the Appointment | decimal | 15 | 0 | DEC | ((0)) | Yes | | /MRSS/T_DEM_APPOINT_EARL_END | |
| 30 | APPT_LAT_END | Latest End of the Appointment | decimal | 15 | 0 | DEC | ((0)) | Yes | | /MRSS/T_DEM_APPOINT_LAT_END | |
| 31 | ZZFUNC_LOC | Functional Location | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | TPLNR | Allow NULL? |
| 32 | ZZFUNC_LOC_TXT | Description of functional location | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PLTXT | Allow NULL? |
| 33 | ZZPLNR_GROUP | Planner Group for Customer Service and Plant Maintenance | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | INGRP | Allow NULL? |
| 34 | ZZREVISION | Revision for Plant Maintenance and Customer Service | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | REVNI | Allow NULL? |
| 35 | ZZEQUIP | Equipment Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | EQUNR | Allow NULL? |
| 36 | ZZEQUIP_TXT | Description of technical object | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | KTX01 | Allow NULL? |
| 37 | ZZABC | ABC indicator for technical object | char | 1 | 0 | CHAR | (N' ') | Yes | * | ABCKZ | Allow NULL? |
| 38 | ZZPLANT_SEC | Plant section | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | BEBER | Allow NULL? |
| 39 | ZZROOM | Room | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | RAUMNR | Allow NULL? |
| 40 | ZZLOCATION | Location of maintenance object | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PMLOC | Allow NULL? |
| 41 | ZZCITY | City | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_CITY1 | Allow NULL? |
| 42 | ZZCUSTOMER | Name 1 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_NAME1 | Allow NULL? |
| 43 | ZZSTREET | Street | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | AD_STREET | Allow NULL? |
| 44 | ZZZIP | City postal code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PSTCD1 | Allow NULL? |