BIW_COOR SAP (BW Data Collection of Order Master (BW 2.0Aff)) Structure details
Description: BW Data Collection of Order Master (BW 2.0Aff)
Structure field list including key, data, relationships and ABAP select examples
BIW_COOR is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "BW Data Collection of Order Master (BW 2.0Aff)" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_BIW_COOR TYPE BIW_COOR.
The BIW_COOR table consists of various fields, each holding specific information or linking keys about BW Data Collection of Order Master (BW 2.0Aff) data available in SAP. These include AUFNR (Order Number), AUART (Order Type), ERLOESE (Identifier 'Revenue posting allowed'), OBLIGOX (Commitments Management Active).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP BIW_COOR structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
AUART | Order Type | AUFART | CHAR | 4 | Assigned to domain | AUFART | AAT | ||
ERLOESE | Identifier 'Revenue posting allowed' | ERLOESE | CHAR | 1 | ERLOESE | ||||
OBLIGOX | Commitments Management Active | CO_OBLIGOX | CHAR | 1 | XFELD | ||||
AUTYP | Order category | AUFTYP | NUMC | 2 | AUFTYP | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
KOSTV | Responsible cost center | AUFKOSTV | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | ||
WAERS | Order Currency | AUFWAERS | CUKY | 5 | Assigned to domain | WAERS | |||
AKSTL | Requesting cost center | PS_AKSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
PSPEL | Work breakdown structure element (WBS element) | PS_PSP_ELE | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
SIZECL | Scale of investment objects | IM_SIZECL | CHAR | 2 | Assigned to domain | ALPHA | SIZECL | ||
OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
POSID | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24 | PROJN | PS_POSID | PRO | ||
KTEXT | Description | AUFTEXT | CHAR | 40 | TEXT40 | ||||
BWSTSYS0 | System Status | BWSTSYS0 | NUMC | 2 | J_STONR | ||||
REFNR | Reference order number | AUFREFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANV | |
ERNAM | Entered by | AUFERFNAM | CHAR | 12 | USNAM | ||||
ERDAT | Created on | AUFERFDAT | DATS | 8 | DATUM | ||||
AENAM | Last changed by | AUFAENAM | CHAR | 12 | USNAM | ||||
AEDAT | Change date for Order Master | AUFAEDAT | DATS | 8 | DATUM | ||||
LTEXT | Long Text Exists | AUFLTEXT | CHAR | 1 | XFELD | ||||
CCKEY | Cost collector key | CCKEY | CHAR | 23 | CCKEY | ||||
STORT | Location | AUFSTORT | CHAR | 10 | Assigned to domain | AP_STAND | |||
SOWRK | Location plant | AUFSOWRK | CHAR | 4 | Assigned to domain | WERKS | |||
ASTKZ | Identifier for statistical order | AUFSTKZ | CHAR | 1 | XFELD | ||||
ASTNR | Order status | AUFASTNR | NUMC | 2 | Assigned to domain | AUFSTNR | |||
STDAT | Date of last status change | AUFSTDAT | DATS | 8 | DATUM | ||||
ESTNR | Status reached so far | AUFESTNR | NUMC | 2 | Assigned to domain | AUFSTNR | |||
PHAS0 | Phase 'Order created' | AUFPHAS0 | CHAR | 1 | XFELD | ||||
PHAS1 | Phase 'Order released' | AUFPHAS1 | CHAR | 1 | XFELD | ||||
PHAS2 | Phase 'order completed' | AUFPHAS2 | CHAR | 1 | XFELD | ||||
PHAS3 | Phase 'order closed' | AUFPHAS3 | CHAR | 1 | XFELD | ||||
PDAT1 | Planned release date | AUFPDAT1 | DATS | 8 | DATUM | ||||
PDAT2 | Planned completion date | AUFPDAT2 | DATS | 8 | DATUM | ||||
PDAT3 | Planned closing date | AUFPDAT3 | DATS | 8 | DATUM | ||||
IDAT1 | Release date | AUFIDAT1 | DATS | 8 | DATUM | ||||
IDAT2 | Technical completion date | AUFIDAT2 | DATS | 8 | DATUM | ||||
IDAT3 | Close date | AUFIDAT3 | DATS | 8 | DATUM | ||||
OBJID | Object ID | CCOBJID | CHAR | 1 | CHAR1 | ||||
VOGRP | Group of disallowed transactions | AUFSPSET | CHAR | 4 | Assigned to domain | VOGRP | |||
LOEKZ | Deletion flag | AUFLOEKZ | CHAR | 1 | XFELD | ||||
PLGKZ | Identifier for planning with line items | PLGKZ | CHAR | 1 | XFELD | ||||
KVEWE | Usage of the condition table | KVEWE | CHAR | 1 | Assigned to domain | KVEWE | KVW | ||
KAPPL | Application | KAPPL | CHAR | 2 | Assigned to domain | KAPPL | KAP | ||
KALSM | Costing Sheet | AUFKALSM | CHAR | 6 | Assigned to domain | KALSM | |||
ZSCHL | Overhead key | AUFZSCHL | CHAR | 6 | CHAR6 | ||||
ABKRS | Processing group | AUFABKRS | NUMC | 2 | Assigned to domain | AKREIS | AKR | ||
KSTAR | Settlement cost element | AUFKSTAR | CHAR | 10 | Assigned to domain | ALPHA | KSTAR | ||
KOSTL | Cost center for basic settlement | AUFKOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
SAKNR | G/L account for basic settlement | AUFSAKNR | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | SAK | |
SETNM | Allocation set | AUFSETNM | CHAR | 12 | SETNR | GSE | |||
CYCLE | Cost center to which costs are actually posted | ST_KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | ||
SDATE | Start Date | SDATE | DATS | 8 | Assigned to domain | SDATE | GAS | ||
SEQNR | Sequence number | AUFSEQNR | NUMC | 4 | Assigned to domain | SQNR | |||
USER0 | Applicant | AUFUSER0 | CHAR | 20 | AUFUSER0 | ||||
USER1 | Applicant's telephone number | AUFUSER1 | CHAR | 20 | AUFUSER1 | ||||
USER2 | Person responsible | AUFUSER2 | CHAR | 20 | AUFUSER2 | ||||
USER3 | Telephone number of person in charge | AUFUSER3 | CHAR | 20 | AUFUSER3 | ||||
USER4 | Estimated total costs of order | AUFUSER4 | CURR | 11(2) | AUFUSER4 | ||||
USER5 | Application Date | AUFUSER5 | DATS | 8 | AUFUSER5 | ||||
USER6 | Department | AUFUSER6 | CHAR | 15 | AUFUSER6 | ||||
USER7 | Work Start | AUFUSER7 | DATS | 8 | AUFUSER7 | ||||
USER8 | End of Work | AUFUSER8 | DATS | 8 | AUFUSER8 | ||||
USER9 | Identifier for work permit issued | AUFUSER9 | CHAR | 1 | AUFUSER9 | ||||
AWSLS | Variance Key | AWSLS | CHAR | 6 | Assigned to domain | AWSLS | |||
ABGSL | Results Analysis Key | ABGR_SCHL | CHAR | 6 | Assigned to domain | ABGR_SCHL | ACS | ||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
FUNC_AREA | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
SCOPE | Object Class | SCOPE_CV | CHAR | 2 | SCOPE | SCOPE_CV | PCO | ||
PLINT | Indicator for Integrated Planning | PLINT | CHAR | 1 | XFELD | ||||
KDAUF | Sales Order Number | KDAUF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
AUFEX | External order number | AUFEX | CHAR | 20 | ALPHA | AUFEX | |||
IVPRO | Investment measure profile | IM_PROFIL | CHAR | 6 | Assigned to domain | IM_PROFIL | |||
LOGSYSTEM | Logical System | LOGSYSTEM | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
FLG_MLTPS | Order with multiple items | CO_MLTPS | CHAR | 1 | KREUZ | ||||
ABUKR | Requesting company code | IM_ABUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | ||
IZWEK | Reason for investment | IZWEK | CHAR | 2 | Assigned to domain | IZWEK | |||
UMWKZ | Reason for environmental investment | AM_UMWKZ | CHAR | 5 | Assigned to domain | AM_UMWKZ | |||
KSTEMPF | Indicator: Direct cost collector | CO_KSTEMPF | CHAR | 1 | CO_KSTEMPF | ||||
ZSCHM | Interest Profile for Project/Order Interest Calculation | PS_ZSCHM | CHAR | 7 | Assigned to domain | PS_ZSCHM | |||
PKOSA | Cost collector for production process PROCNR | PKOSA_D | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ||
ANFAUFNR | Requesting order | AUFANFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ||
PROCNR | Production Process | CKML_F_PROCNR | NUMC | 12 | Assigned to domain | CK_KALNR | CKML_PROCNR | ||
PROTY | Process Category (Procurement/Consumption) | CKML_PROZESS_TYP | CHAR | 4 | Assigned to domain | CKML_PROZESS_TYP | |||
RSORD | Refurbishment order indicator (PM) | RSORD | CHAR | 1 | XFELD | ||||
BEMOT | Accounting Indicator | BEMOT | CHAR | 2 | Assigned to domain | BEMOT | |||
ADRNRA | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
ERFZEIT | Time created | CO_INS_TIME | TIMS | 6 | UZEIT | ||||
AEZEIT | Changed at | CO_CHG_TIME | TIMS | 6 | UZEIT | ||||
CSTG_VRNT | Costing Variant | CK_KLVAR | CHAR | 4 | Assigned to domain | KLVAR | KRT | ||
COSTESTNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC | 12 | Assigned to domain | CK_KALNR | KNR | ||
VERAA_USER | Person Responsible for CO Internal Order | VERAA_USER | CHAR | 12 | Assigned to domain | XUBNAME | XUS | ||
DUMMY_CI_AUFK | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
.INCLU--AP | 0 | ||||||||
/MRSS/PL_STRU_ID | Resource planning nodes | /MRSS/T_PLAN_STRUCT_ID | NUMC | 8 | Assigned to domain | CR_OBJID | |||
/MRSS/PL_MAN_TYP | Assignment to resource planner or contact person | /MRSS/T_MANAGER_TYPE | CHAR | 1 | /MRSS/_MANAGER_TYPE | ||||
/MRSS/ORDER_PROB | Order probability in percent | /MRSS/T_ORDER_PROB | CHAR | 3 | OPROB | /MRSS/_ORDER_PROB | |||
/MRSS/ACT_TYPE | Process variant | /MRSS/T_ACTIVITY_TYPE | CHAR | 1 | /MRSS/_ACTIVITY_TYPE | ||||
/MRSS/INIT_DONE | Internal initialization carried out once | /MRSS/T_INIT_DONE | CHAR | 1 | FLAG | ||||
/MRSS/DATACHANGE | Data was changed in the controls on the user screen | /MRSS/T_USCREENCTL_DATACHANGED | CHAR | 1 | FLAG | ||||
/MRSS/SALES_ORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
/MRSS/NW_BOOKED | Network Set to 'Booked' | /MRSS/T_NW_BOOKED | CHAR | 1 | FLAG |
Key field | Non-key field |
How do I retrieve data from SAP structure BIW_COOR using ABAP code?
As BIW_COOR is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on BIW_COOR as there is no data to select.How to access SAP table BIW_COOR
Within an ECC or HANA version of SAP you can also view further information about BIW_COOR and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects