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 VSPLAF_CN (Version: Planned order) is a standard table in SAP ERP. It belongs to the package CNVS.
Table | VSPLAF_CN |
Short Text | Version: Planned order |
Package | CNVS |
Table Type | Transparent Table |
Field Name | Key | Description | Data Element | Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | ✔ | Client | MANDT | CLNT | 3 | * |
VSNMR | ✔ | Number or description of a version | VSNMR | CHAR | 12 | |
PLNUM | ✔ | Planned order number | PLNUM | CHAR | 10 | * |
MATNR | Planning material | PLMAT | CHAR | 18 | * | |
PLWRK | Planning Plant | PLWRK | CHAR | 4 | * | |
PWWRK | Production plant in planned order | PWWRK | CHAR | 4 | * | |
PAART | Order type | PAART | CHAR | 4 | ||
BESKZ | Procurement Type | BESKZ | CHAR | 1 | ||
SOBES | Special procurement type | SOBES | CHAR | 1 | ||
GSMNG | Total planned order quantity | GSMNG | QUAN | 13 | ||
TLMNG | Partial lot quantity | TLMNG | QUAN | 13 | ||
AVMNG | Fixed quantity of scrap from production | AVMNG | QUAN | 13 | ||
BDMNG | Requirement Quantity | BDMNG | QUAN | 13 | ||
PSTTR | Order start date in planned order | PSTTR | DATS | 8 | ||
PEDTR | Order finish date in the planned order | PEDTR | DATS | 8 | ||
PERTR | Planned opening date in planned order | PERTR | DATS | 8 | ||
WEBAZ | Goods receipt processing time in days | PLWEZ | DEC | 3 | ||
DISPO | MRP controller | PLDSP | CHAR | 3 | * | |
UMSKZ | Conversion indicator for planned order | PLUMS | CHAR | 1 | ||
AUFFX | Firming indicator for planned order data | PLAFX | CHAR | 1 | ||
STLFX | Fixing indicator for BOM explosion | PLSFX | CHAR | 1 | ||
KNTTP | Account Assignment Category | KNTTP | CHAR | 1 | * | |
KDAUF | Sales Order Number | KDAUF | CHAR | 10 | * | |
KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | ||
KDEIN | Delivery Schedule for Sales Order | KDEIN | NUMC | 4 | ||
PROJN | Old: Project number : No longer used --> PS_POSNR | PROJN | CHAR | 16 | ||
RSNUM | Number of Reservation/Dependent Requirement | RSNUM | NUMC | 10 | * | |
QUNUM | Number of Quota Arrangement | QUNUM | CHAR | 10 | ||
QUPOS | Quota Arrangement Item | QUPOS | NUMC | 3 | ||
FLIEF | Fixed Vendor | FLIEF | CHAR | 10 | * | |
KONNR | Number of Principal Purchase Agreement | KONNR | CHAR | 10 | * | |
KTPNR | Item Number of Principal Purchase Agreement | KTPNR | NUMC | 5 | * | |
EKORG | Purchasing Organization | EKORG | CHAR | 4 | * | |
LGORT | Storage Location | LGORT_D | CHAR | 4 | * | |
NUMVR | Version number | NUMVR | NUMC | 2 | ||
KZVBR | Consumption Posting | KZVBR | CHAR | 1 | ||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | * | |
PSPEL | WBS Element | PS_POSNR | NUMC | 8 | * | |
SERNR | BOM explosion number | SERNR | CHAR | 8 | * | |
PALTR | Explosion date | PALTR | DATS | 8 | ||
TECHS | Parameter Variant/Standard Variant | TECHS | CHAR | 12 | ||
STLAN | BOM Usage | STLAN | CHAR | 1 | * | |
STALT | Alternative BOM | STALT | CHAR | 2 | ||
AENNR | Change Number | AENNR | CHAR | 12 | * | |
ARSNR | Settlement reservation number | ARSNR | NUMC | 10 | ||
ARSPS | Item number of the settlement reservation | ARSPS | NUMC | 4 | ||
VERTO | Distribution key for quantity produced | SA_VERTO | CHAR | 4 | * | |
VERID | Production Version | VERID | CHAR | 4 | * | |
AUFNR | Run schedule header number | SA_AUFNR | CHAR | 12 | * | |
TRART | Scheduling type of the planned order | TRART | CHAR | 1 | ||
PLGRP | Responsible planner group/department | VAGRP | CHAR | 3 | * | |
TERST | Start date for production | TERST | DATS | 8 | ||
TERED | Finish date for production | TERED | DATS | 8 | ||
BEDID | ID of the capacity requirements record | BEDID | NUMC | 12 | * | |
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | ||
LINID | ID for a schedule record | SP_OPID | NUMC | 15 | ||
TRMKZ | Scheduling indicator | TRMKZ | CHAR | 1 | ||
TRMER | Scheduling error | TRMER | CHAR | 2 | ||
REDKZ | Reduction indicator for scheduling | REDKZ | CHAR | 1 | ||
TRMHK | Scheduling source | TRMHK | CHAR | 1 | ||
PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | ||
PLNAL | Group Counter | PLNAL | CHAR | 2 | ||
PLNTY | Task List Type | PLNTY | CHAR | 1 | * | |
FRTHW | Production note in the planned order | FRTHW | CHAR | 1 | ||
RGEKZ | Indicator: Backflushing for order | CO_RGEKZ | CHAR | 1 | ||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | * | |
CUOBJ | Configuration (internal object number) | CUOBJ | NUMC | 18 | ||
REVLV | Revision Level | REVLV | CHAR | 2 | ||
ABMNG | Reduced quantity in the planned order | ABMNG | QUAN | 13 | ||
RATID | Index for the results of scheduling production rates | RATID | NUMC | 12 | * | |
GROID | Index for rough scheduling results | GROID | NUMC | 12 | * | |
RATER | Scheduling error in scheduling production rates | RATER | CHAR | 2 | ||
GROER | Scheduling error in rough scheduling | GROER | CHAR | 2 | ||
OBART | Object type | OBART | CHAR | 1 | ||
PLSCN | Planning Scenario of Long-Term Planning | PLSCN | NUMC | 3 | * | |
SBNUM | Simulation requirements number | SBNUM | NUMC | 10 | * | |
KBNKZ | Kanban Indicator | KBNKZ | CHAR | 1 | ||
KAPFX | Indicator: capacity for planned order dispatched | KAPFX | CHAR | 1 | ||
SEQNR | Seq. number order | CY_SEQNR | NUMC | 14 | ||
PSTTI | Start Time of Planned Order | PSTTI | TIMS | 6 | ||
PEDTI | End Time of Planned Order | PEDTI | TIMS | 6 | ||
MONKZ | Indicator: for assembly order procedures | MONKZ | CHAR | 1 | ||
STSTA | BOM status | STLST | NUMC | 2 | * | |
PRNKZ | Ind.: Leading order in collective order is planned ordre | PRNKZ | CHAR | 1 | ||
MDPBV | Planned order: confirmation of availability | MDPBV | CHAR | 1 | ||
VFMNG | Planned order: committed quantity | VFMNG | QUAN | 13 | ||
MDACH | Action control: planned order processing | MDACH | CHAR | 2 | * | |
MDACC | Action: planned order processing | MDACC | CHAR | 4 | * | |
MDACD | Date of action: planned order | MDACD | DATS | 8 | ||
MDACT | Time of action: Planned order processing | MDACT | TIMS | 6 | ||
GSBTR | Total commitment date of plnd ord. after ATP check f.comps. | GSBTR_PLAF | DATS | 8 | ||
PLETX | Planned order shift quantities exist | PLETX | CHAR | 1 | ||
PRSCH | Planned order: scheduling using production dates | MD_PRSCHED | CHAR | 1 | ||
LVSCH | Planned order: leading scheduling level (determines dates) | MD_LVSCHED | CHAR | 1 | ||
KZAVC | Indicator for type of availability check | KZAVC | CHAR | 1 | ||
VRPLA | Indicator: planning without final assembly | VRPLA | CHAR | 1 | ||
PBDNR | Requirements Plan Number | PBDNR | CHAR | 10 | ||
AGREQ | Requirements totaling | AGREQ | CHAR | 1 | ||
UMREZ | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5 | ||
UMREN | Denominator for conversion to base units of measure | UMREN | DEC | 5 | ||
ERFMG | Quantity in Unit of Entry | ERFMG | QUAN | 13 | ||
ERFME | Unit of Entry | ERFME | UNIT | 3 | T006 | |
RQNUM | Requirements record number | RQNUM | NUMC | 10 | * | |
KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1 | ||
WEMNG | Quantity of Goods Received | WEMNG | QUAN | 13 | ||
WAMNG | Issued Quantity | WAMNG | QUAN | 13 | ||
EDGNO | Internal number for edge of object dependencies tree | EDGNO | NUMC | 17 | M60I | |
LBLKZ | Subcontracting vendor | LBLKZ | CHAR | 1 | ||
EMLIF | Vendor to be supplied/who is to receive delivery | EMLIF | CHAR | 10 | * | |
BERID | MRP Area | BERID | CHAR | 10 | * | |
UBERI | Issuing MRP area when transferring stock | UBERI | CHAR | 10 | * | |
EMATN | Material Number Corresponding to Manufacturer Part Number | EMATN | CHAR | 18 | * | |
REMFL | Repetitive Manufacturing indicator | REMFL | CHAR | 1 | ||
PSTMP | Last Change to Planned Order: Time Stamp | PSTMP | DEC | 15 | ||
PUSER | Last Change to Planned Order: User | PUSER | CHAR | 12 | ||
BADI | Object change via active Business Add-In | MD_BADI | CHAR | 1 | ||
STAEX | Status information on BOM explosion in planned order | MD_STAEX | CHAR | 2 | ||
RESLO | Issuing Storage Location for Stock Transport Order | RESLO | CHAR | 4 | * | |
MEDKZ | Indicator for Distributed Planned Order | MEDKZ | CHAR | 1 | ||
CNFQTY | Total Confirmed Qty Planned Order (Repetitive Manufacturing) | MD_MES_CNF_QTY | QUAN | 13 | ||
SRM_CONTRACT_ID | Central Contract | SRM_CONTRACT_ID | CHAR | 10 | ||
SRM_CONTRACT_ITM | Central Contract Item Number | SRM_CONTRACT_ITEM | NUMC | 10 | ||
M_MRP | Indicator: Matrix Is Activated | MMRP_ACTIVE | CHAR | 1 |