This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →The table VSAUFK_CN (Version: Order master data) is a standard table in SAP ERP. It belongs to the package CNVS.
Table | VSAUFK_CN |
Short Text | Version: Order master data |
Package | CNVS |
Table Type | Transparent Table |
Field Name | Key | Description | Data Element | Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
VSNMR | ✔ | Number or description of a version | VSNMR | CHAR | 12 | |
AUFNR | ✔ | Order Number | AUFNR | CHAR | 12 | * |
AUART | Order Type | AUFART | CHAR | 4 | T003O | |
AUTYP | Order category | AUFTYP | NUMC | 2 | ||
REFNR | Reference order number | AUFREFNR | CHAR | 12 | AUFK | |
ERNAM | Entered by | AUFERFNAM | CHAR | 12 | ||
ERDAT | Created on | AUFERFDAT | DATS | 8 | ||
AENAM | Last changed by | AUFAENAM | CHAR | 12 | ||
AEDAT | Change date for Order Master | AUFAEDAT | DATS | 8 | ||
KTEXT | Description | AUFTEXT | CHAR | 40 | ||
LTEXT | Long Text Exists | AUFLTEXT | CHAR | 1 | ||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | |
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | |
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | |
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | |
CCKEY | Cost collector key | CCKEY | CHAR | 23 | ||
KOSTV | Responsible cost center | AUFKOSTV | CHAR | 10 | * | |
STORT | Location | AUFSTORT | CHAR | 10 | T499S | |
SOWRK | Location plant | AUFSOWRK | CHAR | 4 | T001W | |
ASTKZ | Identifier for statistical order | AUFSTKZ | CHAR | 1 | ||
WAERS | Order Currency | AUFWAERS | CUKY | 5 | TCURC | |
ASTNR | Order status | AUFASTNR | NUMC | 2 | TKO03 | |
STDAT | Date of last status change | AUFSTDAT | DATS | 8 | ||
ESTNR | Status reached so far | AUFESTNR | NUMC | 2 | TKO03 | |
PHAS0 | Phase "Order created" | AUFPHAS0 | CHAR | 1 | ||
PHAS1 | Phase "Order released" | AUFPHAS1 | CHAR | 1 | ||
PHAS2 | Phase "order completed" | AUFPHAS2 | CHAR | 1 | ||
PHAS3 | Phase "order closed" | AUFPHAS3 | CHAR | 1 | ||
PDAT1 | Planned release date | AUFPDAT1 | DATS | 8 | ||
PDAT2 | Planned completion date | AUFPDAT2 | DATS | 8 | ||
PDAT3 | Planned closing date | AUFPDAT3 | DATS | 8 | ||
IDAT1 | Release date | AUFIDAT1 | DATS | 8 | ||
IDAT2 | Technical completion date | AUFIDAT2 | DATS | 8 | ||
IDAT3 | Close date | AUFIDAT3 | DATS | 8 | ||
OBJID | Object ID | CCOBJID | CHAR | 1 | ||
VOGRP | Group of disallowed transactions | AUFSPSET | CHAR | 4 | TKAVG | |
LOEKZ | Deletion flag | AUFLOEKZ | CHAR | 1 | ||
PLGKZ | Identifier for planning with line items | PLGKZ | CHAR | 1 | ||
KVEWE | Usage of the condition table | KVEWE | CHAR | 1 | T681V | |
KAPPL | Application | KAPPL | CHAR | 2 | T681A | |
KALSM | Costing Sheet | AUFKALSM | CHAR | 6 | T683 | |
ZSCHL | Overhead key | AUFZSCHL | CHAR | 6 | ||
ABKRS | Processing group | AUFABKRS | NUMC | 2 | TKO08 | |
KSTAR | Settlement cost element | AUFKSTAR | CHAR | 10 | CSKB | |
KOSTL | Cost center for basic settlement | AUFKOSTL | CHAR | 10 | CSKS | |
SAKNR | G/L account for basic settlement | AUFSAKNR | CHAR | 10 | SKB1 | |
SETNM | Allocation set | AUFSETNM | CHAR | 12 | ||
CYCLE | Cost center to which costs are actually posted | ST_KOSTL | CHAR | 10 | CSKS | |
SDATE | Start Date | SDATE | DATS | 8 | * | |
SEQNR | Sequence number | AUFSEQNR | NUMC | 4 | * | |
USER0 | Applicant | AUFUSER0 | CHAR | 20 | ||
USER1 | Applicant's telephone number | AUFUSER1 | CHAR | 20 | ||
USER2 | Person responsible | AUFUSER2 | CHAR | 20 | ||
USER3 | Telephone number of person in charge | AUFUSER3 | CHAR | 20 | ||
USER4 | Estimated total costs of order | AUFUSER4 | CURR | 11 | ||
USER5 | Application Date | AUFUSER5 | DATS | 8 | ||
USER6 | Department | AUFUSER6 | CHAR | 15 | ||
USER7 | Work Start | AUFUSER7 | DATS | 8 | ||
USER8 | End of Work | AUFUSER8 | DATS | 8 | ||
USER9 | Identifier for work permit issued | AUFUSER9 | CHAR | 1 | ||
OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | |
PRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | |
PSPEL | Work breakdown structure element (WBS element) | PS_PSP_ELE | NUMC | 8 | VSPRPS_CN | |
AWSLS | Variance Key | AWSLS | CHAR | 6 | TKV01 | |
ABGSL | Results Analysis Key | ABGR_SCHL | CHAR | 6 | TKKAA | |
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | |
FUNC_AREA | Functional Area | FKBER | CHAR | 16 | TFKB | |
SCOPE | Object Class | SCOPE_CV | CHAR | 2 | ||
PLINT | Indicator for Integrated Planning | PLINT | CHAR | 1 | ||
KDAUF | Sales Order Number | KDAUF | CHAR | 10 | VBUK | |
KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | ||
AUFEX | External order number | AUFEX | CHAR | 20 | ||
IVPRO | Investment measure profile | IM_PROFIL | CHAR | 6 | TAPRF | |
LOGSYSTEM | Logical System | LOGSYSTEM | CHAR | 10 | TBDLS | |
FLG_MLTPS | Order with multiple items | CO_MLTPS | CHAR | 1 | ||
ABUKR | Requesting company code | IM_ABUKRS | CHAR | 4 | T001 | |
AKSTL | Requesting cost center | PS_AKSTL | CHAR | 10 | CSKS | |
SIZECL | Scale of investment objects | IM_SIZECL | CHAR | 2 | TAIF5 | |
IZWEK | Reason for investment | IZWEK | CHAR | 2 | T087I | |
UMWKZ | Reason for environmental investment | AM_UMWKZ | CHAR | 5 | T087K | |
KSTEMPF | Indicator: Direct cost collector | CO_KSTEMPF | CHAR | 1 | ||
ZSCHM | Interest Profile for Project/Order Interest Calculation | PS_ZSCHM | CHAR | 7 | TPI01 | |
PKOSA | Cost collector for production process PROCNR | PKOSA_D | CHAR | 12 | * | |
ANFAUFNR | Requesting order | AUFANFNR | CHAR | 12 | AUFK | |
PROCNR | Production alternative | CKML_PROCNR | NUMC | 12 | * | |
PROTY | Process Category (Procurement/Consumption) | CKML_PROZESS_TYP | CHAR | 4 | * | |
RSORD | Refurbishment order indicator (PM) | RSORD | CHAR | 1 | ||
BEMOT | Accounting Indicator | BEMOT | CHAR | 2 | TBMOT | |
ADRNRA | Address number | AD_ADDRNUM | CHAR | 10 | * | |
ERFZEIT | Time created | CO_INS_TIME | TIMS | 6 | ||
AEZEIT | Changed at | CO_CHG_TIME | TIMS | 6 | ||
CSTG_VRNT | Costing Variant | CK_KLVAR | CHAR | 4 | * | |
COSTESTNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC | 12 | * | |
VERAA_USER | Person Responsible for CO Internal Order | VERAA_USER | CHAR | 12 | * | |
DUMMY_CI_AUFK | Single-Character Indicator | CHAR1 | CHAR | 1 | ||
ZFIELD99 | Text, 40 Characters Long | TEXT40 | CHAR | 40 | ||
VNAME | Joint Venture | JV_NAME | CHAR | 6 | T8JV | |
RECID | Recovery Indicator | JV_RECIND | CHAR | 2 | T8JJ | |
ETYPE | Equity type | JV_ETYPE | CHAR | 3 | T8JG | |
OTYPE | Joint Venture Object Type | JV_OTYPE | CHAR | 4 | ||
JV_JIBCL | JIB/JIBE Class | JV_JIBCL | CHAR | 3 | T8J6A | |
JV_JIBSA | JIB/JIBE Subclass A | JV_JIBSA | CHAR | 5 | T8J6C | |
JV_OCO | JV original cost object | JV_OR_CO | CHAR | 1 | ||
ORGKEY | Order Number | AUFNR | CHAR | 12 | * | |
EXT_AUFNR | Order Number | AUFNR | CHAR | 12 | * | |
INACT | Version inactive indicator | VSINACT | CHAR | 1 | ||
AUFK_STATUS | Status Combination | ACTCMB_DELE | INT1 | 3 | ACTCMB_TAB | |
/CUM/INDCU | CU: Order is Used for Compatible Units | /CUM/INDCU | CHAR | 1 | ||
/CUM/CMNUM | CU: Construction Measure Number | /CUM/CMNUM | CHAR | 12 | ||
/CUM/AUEST | CU: Automatic Copy of Estimated Costs | /CUM/AUEST | CHAR | 1 | ||
/CUM/DESNUM | CU: Design Number | /CUM/DESNUM | CHAR | 12 | * | |
/MRSS/PL_STRU_ID | Resource planning nodes | /MRSS/T_PLAN_STRUCT_ID | NUMC | 8 | * | |
/MRSS/PL_MAN_TYP | Assignment to resource planner or contact person | /MRSS/T_MANAGER_TYPE | CHAR | 1 | ||
/MRSS/ORDER_PROB | Order probability in percent | /MRSS/T_ORDER_PROB | CHAR | 3 | ||
/MRSS/ACT_TYPE | Process variant | /MRSS/T_ACTIVITY_TYPE | CHAR | 1 | ||
/MRSS/INIT_DONE | Internal initialization carried out once | /MRSS/T_INIT_DONE | CHAR | 1 | ||
/MRSS/DATACHANGE | Data was changed in the controls on the user screen | /MRSS/T_USCREENCTL_DATACHANGED | CHAR | 1 | ||
/MRSS/SALES_ORG | Sales Organization | VKORG | CHAR | 4 | * | |
/MRSS/NW_BOOKED | Network Set to "Booked" | /MRSS/T_NW_BOOKED | CHAR | 1 | ||
AD01PROFNR | Dynamic Item Processor Profile | AD01PROFNR | CHAR | 8 | * | |
VAPLZ | Main work center for maintenance tasks | GEWRK | CHAR | 8 | ||
WAWRK | Plant associated with main work center | WERGW | CHAR | 4 | * | |
FERC_IND | Regulatory indicator | FE_IND | CHAR | 4 | FERC_C7 | |
CLAIM_CONTROL | Claim creation control indicator | WTYSC_CLAIM_CONTROL | CHAR | 1 | WTYSCC_CLM_CONT | |
UPDATE_NEEDED | Claim inconsistency with order indicator | WTYSC_UPDATE_NEEDED | CHAR | 1 | ||
UPDATE_CONTROL | Claim update trigger point from service order | WTYSC_UPDATE_CONTROL | CHAR | 1 | WTYSCC_UPDT_CONT |