SAP Table BW_0CS_ORDER
Generated Table for View
BW_0CS_ORDER (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link BW_0CS_ORDER to other SAP tables.
BW_0CS_ORDER table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| AUFNR | Service Order | BWCSAUFNR | AUFK | CHAR | 12 | 0 | ||
| AUART | Order Type | AUFART | T003O | CHAR | 4 | 0 | ||
| EQUNR | Equipment Number | EQUNR | EQUI | CHAR | 18 | 0 | ||
| BAUTL | Assembly | BAUTL | MARA | CHAR | 18 | 0 | ||
| IWERK | Maintenance Planning Plant | IWERK | T399I | CHAR | 4 | 0 | ||
| INGRP | Planner Group for Customer Service and Plant Maintenance | INGRP | T024I | CHAR | 3 | 0 | ||
| ARBPL | Work center | ARBPL | CHAR | 8 | 0 | |||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||
| KUNUM | Customer Number | KUNUM | KNA1 | CHAR | 10 | 0 | ||
| REVNR | Revision for Plant Maintenance and Customer Service | REVNI | T352R | CHAR | 8 | 0 | ||
| ILART | Maintenance activity type | ILA | T353I | CHAR | 3 | 0 | ||
| TPLNR | Functional Location | TPLNR | IFLOT | CHAR | 30 | 0 | ||
| ABCKZ | ABC indicator for technical object | ABCKZ | T370C | CHAR | 1 | 0 | ||
| SWERK | Maintenance plant | SWERK | T001W | CHAR | 4 | 0 | ||
| STORT | Location of maintenance object | PMLOC | T499S | CHAR | 10 | 0 | ||
| MSGRP | Room | RAUMNR | CHAR | 8 | 0 | |||
| BEBER | Plant section | BEBER | T357 | CHAR | 3 | 0 | ||
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 | 0 | ||
| KOKRS | Controlling Area | KOKRS | TKA01 | CHAR | 4 | 0 | ||
| KOSTL | Cost center for basic settlement | AUFKOSTL | CSKS | CHAR | 10 | 0 | ||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||
| ANLNR | Main Asset Number | ANLN1 | CHAR | 12 | 0 | |||
| ANLUN | Asset Subnumber | ANLN2 | CHAR | 4 | 0 | |||
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 | 0 | ||
| SPART | Division | SPART | TSPA | CHAR | 2 | 0 | ||
| VKGRP | Sales Group | VKGRP | TVBVK | CHAR | 3 | 0 | ||
| VKBUR | Sales Office | VKBUR | TVKBZ | CHAR | 4 | 0 | ||
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 | 0 | ||
| ERDAT | Created on | AUFERFDAT | DATS | 8 | 0 | |||
| AEDAT | Change date for Order Master | AUFAEDAT | DATS | 8 | 0 | |||
| QMNUM | Notification No | QMNUM | QMEL | CHAR | 12 | 0 | ||
BW_0CS_ORDER foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| BW_0CS_ORDER | ABCKZ | BW_0CS_ORDER | ABCKZ | T370C | ABC indicator for technical objects | ABCKZ |
| BW_0CS_ORDER | ABCKZ | BW_0CS_ORDER | MANDT | T370C | ABC indicator for technical objects | MANDT |
| BW_0CS_ORDER | AUART | BW_0CS_ORDER | MANDT | T003O | Order Types | CLIENT |
| BW_0CS_ORDER | AUART | BW_0CS_ORDER | AUART | T003O | Order Types | AUART |
| BW_0CS_ORDER | AUFNR | BW_0CS_ORDER | MANDT | AUFK | Order master data | MANDT |
| BW_0CS_ORDER | AUFNR | BW_0CS_ORDER | AUFNR | AUFK | Order master data | AUFNR |
| BW_0CS_ORDER | BAUTL | BW_0CS_ORDER | MANDT | MARA | General Material Data | MANDT |
| BW_0CS_ORDER | BAUTL | BW_0CS_ORDER | BAUTL | MARA | General Material Data | MATNR |
| BW_0CS_ORDER | BEBER | BW_0CS_ORDER | MANDT | T357 | Plant Section | MANDT |
| BW_0CS_ORDER | BEBER | BW_0CS_ORDER | SWERK | T357 | Plant Section | WERKS |
| BW_0CS_ORDER | BEBER | BW_0CS_ORDER | BEBER | T357 | Plant Section | BEBER |
| BW_0CS_ORDER | BUKRS | BW_0CS_ORDER | MANDT | T001 | Company Codes | MANDT |
| BW_0CS_ORDER | BUKRS | BW_0CS_ORDER | BUKRS | T001 | Company Codes | BUKRS |
| BW_0CS_ORDER | EQUNR | BW_0CS_ORDER | EQUNR | EQUI | Equipment master data | EQUNR |
| BW_0CS_ORDER | EQUNR | BW_0CS_ORDER | MANDT | EQUI | Equipment master data | MANDT |
| BW_0CS_ORDER | GSBER | BW_0CS_ORDER | MANDT | TGSB | Business Areas | MANDT |
| BW_0CS_ORDER | GSBER | BW_0CS_ORDER | GSBER | TGSB | Business Areas | GSBER |
| BW_0CS_ORDER | ILART | BW_0CS_ORDER | ILART | T353I | Maintenance activity types | ILART |
| BW_0CS_ORDER | ILART | BW_0CS_ORDER | MANDT | T353I | Maintenance activity types | MANDT |
| BW_0CS_ORDER | INGRP | BW_0CS_ORDER | IWERK | T024I | Maintenance planner groups | IWERK |
| BW_0CS_ORDER | INGRP | BW_0CS_ORDER | INGRP | T024I | Maintenance planner groups | INGRP |
| BW_0CS_ORDER | INGRP | BW_0CS_ORDER | MANDT | T024I | Maintenance planner groups | MANDT |
| BW_0CS_ORDER | IWERK | BW_0CS_ORDER | MANDT | T399I | Planning plant parameters | MANDT |
| BW_0CS_ORDER | IWERK | BW_0CS_ORDER | IWERK | T399I | Planning plant parameters | IWERK |
| BW_0CS_ORDER | KOKRS | BW_0CS_ORDER | MANDT | TKA01 | Controlling Areas | MANDT |
| BW_0CS_ORDER | KOKRS | BW_0CS_ORDER | KOKRS | TKA01 | Controlling Areas | KOKRS |
| BW_0CS_ORDER | KOSTL | BW_0CS_ORDER | MANDT | CSKS | Cost Center Master Data | MANDT |
| BW_0CS_ORDER | KOSTL | BW_0CS_ORDER | KOKRS | CSKS | Cost Center Master Data | KOKRS |
| BW_0CS_ORDER | KOSTL | BW_0CS_ORDER | KOSTL | CSKS | Cost Center Master Data | KOSTL |
| BW_0CS_ORDER | KOSTL | * | CSKS | Cost Center Master Data | DATBI | |
| BW_0CS_ORDER | KUNUM | BW_0CS_ORDER | MANDT | KNA1 | General Data in Customer Master | MANDT |
| BW_0CS_ORDER | KUNUM | BW_0CS_ORDER | KUNUM | KNA1 | General Data in Customer Master | KUNNR |
| BW_0CS_ORDER | MANDT | BW_0CS_ORDER | MANDT | T000 | Clients | MANDT |
| BW_0CS_ORDER | OBJNR | BW_0CS_ORDER | MANDT | ONR00 | General Object Number | MANDT |
| BW_0CS_ORDER | OBJNR | BW_0CS_ORDER | OBJNR | ONR00 | General Object Number | OBJNR |
| BW_0CS_ORDER | QMNUM | BW_0CS_ORDER | MANDT | QMEL | Quality Notification | MANDT |
| BW_0CS_ORDER | QMNUM | BW_0CS_ORDER | QMNUM | QMEL | Quality Notification | QMNUM |
| BW_0CS_ORDER | REVNR | BW_0CS_ORDER | MANDT | T352R | Maintenance revisions | MANDT |
| BW_0CS_ORDER | REVNR | BW_0CS_ORDER | IWERK | T352R | Maintenance revisions | IWERK |
| BW_0CS_ORDER | REVNR | BW_0CS_ORDER | REVNR | T352R | Maintenance revisions | REVNR |
| BW_0CS_ORDER | SPART | BW_0CS_ORDER | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
| BW_0CS_ORDER | SPART | BW_0CS_ORDER | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
| BW_0CS_ORDER | STORT | BW_0CS_ORDER | STORT | T499S | Location | STAND |
| BW_0CS_ORDER | STORT | BW_0CS_ORDER | MANDT | T499S | Location | MANDT |
| BW_0CS_ORDER | STORT | BW_0CS_ORDER | SWERK | T499S | Location | WERKS |
| BW_0CS_ORDER | SWERK | BW_0CS_ORDER | MANDT | T001W | Plants/Branches | MANDT |
| BW_0CS_ORDER | SWERK | BW_0CS_ORDER | SWERK | T001W | Plants/Branches | WERKS |
| BW_0CS_ORDER | TPLNR | BW_0CS_ORDER | MANDT | IFLOT | Functional Location (Table) | MANDT |
| BW_0CS_ORDER | TPLNR | BW_0CS_ORDER | TPLNR | IFLOT | Functional Location (Table) | TPLNR |
| BW_0CS_ORDER | VKBUR | BW_0CS_ORDER | VKORG | TVKBZ | Org.Unit: Sales Office: Assignment to Organizational Unit | VKORG |
| BW_0CS_ORDER | VKBUR | BW_0CS_ORDER | VTWEG | TVKBZ | Org.Unit: Sales Office: Assignment to Organizational Unit | VTWEG |
| BW_0CS_ORDER | VKBUR | BW_0CS_ORDER | SPART | TVKBZ | Org.Unit: Sales Office: Assignment to Organizational Unit | SPART |
| BW_0CS_ORDER | VKBUR | BW_0CS_ORDER | VKBUR | TVKBZ | Org.Unit: Sales Office: Assignment to Organizational Unit | VKBUR |
| BW_0CS_ORDER | VKBUR | BW_0CS_ORDER | MANDT | TVKBZ | Org.Unit: Sales Office: Assignment to Organizational Unit | MANDT |
| BW_0CS_ORDER | VKGRP | BW_0CS_ORDER | MANDT | TVBVK | Organizational Unit: Sales Groups per Sales Office | MANDT |
| BW_0CS_ORDER | VKGRP | BW_0CS_ORDER | VKBUR | TVBVK | Organizational Unit: Sales Groups per Sales Office | VKBUR |
| BW_0CS_ORDER | VKGRP | BW_0CS_ORDER | VKGRP | TVBVK | Organizational Unit: Sales Groups per Sales Office | VKGRP |
| BW_0CS_ORDER | VKORG | BW_0CS_ORDER | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| BW_0CS_ORDER | VKORG | BW_0CS_ORDER | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| BW_0CS_ORDER | VTWEG | BW_0CS_ORDER | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
| BW_0CS_ORDER | VTWEG | BW_0CS_ORDER | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| BW_0CS_ORDER | WERKS | BW_0CS_ORDER | MANDT | T001W | Plants/Branches | MANDT |
| BW_0CS_ORDER | WERKS | BW_0CS_ORDER | WERKS | T001W | Plants/Branches | WERKS |
