- Accounting - General (AC)
- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Business intelligence solutions (BI)
- Collaborative Cross Applications (XAP)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Customer Service (CS)
- Discrete Industries (DI)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise Performance Management (EPM)
- Enterprise Portal (EP)
- Enterprise Portal (EP)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Financials (FIN)
- Global Trade Services (SLL)
- Governance, Risk and Compliance (GRC)
- Incentive and Commission Management (ICM) (ICM)
- Investment Management (IM)
- Knowledge Management (KM)
- LOD Components (LOD)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Obsolete Product: mySAP.com Workplace (WP)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Personnel Time Management (PT)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP HANA (HAN)
- SAP NetWeaver Master Data Management (MDM)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Training and Event Management (PE)
- Transportation Management (TM)
- Treasury (TR)
- Web Channel (WEC)
/SMERP/STG_PM014
Data staging LAM - Functional Location complex table
|
#masterdata
|
Component: Mobile Application Integration - ERP Core
- 🔑 Keys (2)
- 💰 Amounts (1)
- ∑ Quantities (1)
- 📅 Dates (5)
- ☰ Categorical (39)
- Other (88)
- 🔗 Relations (18)
| Column Name | Description | |
|---|---|---|
| MANDT | Client | |
| DSF_GUID | DSF GUID |
| Column Name | Description | |
|---|---|---|
| 💲 Currency Key (WAERS): | ||
| ANSWT | Acquisition Value | |
| Column Name | Description | |
|---|---|---|
| 📏 Weight Unit (GEWEI): | ||
| BRGEW | Gross weight | |
| Column Name | Description | |
|---|---|---|
| ERDAT | Date on which the object was created | |
| AEDAT | Date on which the object was last changed | |
| DATAB | Start-up Date of the Technical Object | |
| ANSDT | Acquisition date | |
| ENDOFUSE | End-of-Use Date of the Technical Object |
| Column Name | Description | |
|---|---|---|
| SUBMTI | Data origin for construction type field | Show values |
| IEQUI | Installation of equipment allowed at the functional location | Show values |
| IEQUII | Data origin for equip. inst. allowed field | Show values |
| EINZL | Single equipment installation at functional location | Show values |
| EINZLI | Data origin for authorization group field | Show values |
| IWERKI | Data origin for planning plant field | Show values |
| INGRPI | Data origin for maintenance planner group field | Show values |
| PM_OBJTY | Object Type of CIM Resources for Work Center | Show values |
| LGWIDI | Data Origin for the Field 'Work Center' | Show values |
| RBNR_I | Data origin for maintenance catalog field | Show values |
| ISTYP | Object category for Industry Solutions (IS) | Show values |
| BAUMM | Month of construction | Show values |
| FLLB_DUTY | Logbook Duty | Show values |
| FLLB_HIDE | Hide Logbook Display | Show values |
| ABCKZI | Data origin for ABC indicator field | Show values |
| EQFNRI | Data origin for sort field | Show values |
| SWERKI | Data origin for maintenance plant field | Show values |
| STORTI | Data origin for location field | Show values |
| MSGRPI | Data origin for room number field | Show values |
| BEBERI | Data origin for plant section field | Show values |
| CR_OBJTY | Object types of the CIM resource | Show values |
| PPSIDI | Data origin for PP work center field | Show values |
| GSBERI | Data origin for business area field | Show values |
| KOKRSI | Data origin for controlling area field | Show values |
| KOSTLI | Data origin for cost center field | Show values |
| PROIDI | Data origin for WBS element field | Show values |
| BUKRSI | Data origin for company code field | Show values |
| ANLNRI | Data origin for asset main no./sub-no. fields | Show values |
| ANLUNI | Data origin indicator | Show values |
| DAUFNI | Data origin of standing order number field | Show values |
| AUFNRI | Data origin for settlement order field | Show values |
| TPLNRI | Data origin for functional location field | Show values |
| VKORGI | Data origin for sales organization field | Show values |
| VTWEGI | Data origin of distribution channel field | Show values |
| SPARTI | Data origin for division field | Show values |
| ADRNRI | Data origin for address field | Show values |
| OWNER | Object reference indicator | Show values |
| KZLTX | Long Text Exists | Show values |
| LAM_FLAG | Boolean Type: 'X' == True '' == False | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| DSF_DSTORE_ID | Data Store ID | /SMFND/DSF_DSTORE_ID | |
| USER_GUID | User GUID | SYSUUID_C | |
| DSF_RECORD_ID | DSF Record ID | NUM10 | |
| DSF_CHANGED_BY | Last Changed By | USNAM | |
| DSF_CHANGED_TS | Changed time stamp | TZNTSTMPS | |
| TPLNR | Functional Location | TPLNR | |
| ERNAM | Name of User Who Created the Object | USNAM | |
| AENAM | Name of the user who last changed the object | USNAM | |
| PSTAE | SAP Development reserve: Format CHAR, length 4 | CHAR4 | |
| STNAM | SAP Development Reserve: Format CHAR, Length 12 | CHAR12 | |
| LVORM | SAP Development Reserve: Format CHAR, Length 1 | CHAR1 | |
| MAPAR | Manufacturer part number | MAPAR | |
| MAPARI | SAP Development Reserve: Format CHAR, Length 1 | CHAR1 | |
| POSNR | Position in superior technical object | CHAR4 | |
| PREMS | Premise | CHAR10 | |
| INVNR | Inventory number | INVNR_ANLA | |
| GROES | Size/dimension | GROES | |
| HERST | Manufacturer of Asset | TEXT30 | |
| BAUJJ | Year of construction | CJAHR | |
| TYPBZ | Manufacturer model number | TYPBZ | |
| EMATN | Material number corresponding to manufacturer part number | MATNR | |
| SERGE | Manufacturer's Serial Number | CHAR30 | |
| HANDLE | SAP Development Reserve: Integration of Date Segment (Key) | SYSUUID_22 | |
| TSEGTP | SAP Development Reserve: Integration Date Segment (Tempate) | TSEGTEMPLA | |
| CHANGEDDATETIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | |
| DUMMY_IFLOT_INCL_EEW_PS | Custom Fields: Dummy for Use in Extension Includes | ||
| IFLOT_SRTYPE | Shift Report Type for Object | ||
| ABCKZ | ABC Indicator for Technical Object | ABCKZ | |
| EQFNR | Sort Field | CHAR30 | |
| SWERK | Maintenance Plant | WERKS | |
| STORT | Location of maintenance object | AP_STAND | |
| MSGRP | Room | CHAR8 | |
| BEBER | Plant Section | BEBER | |
| PPSID | Object ID of PP work center | CR_OBJID | |
| GSBER | Business Area | GSBER | |
| KOKRS | Controlling Area | CACCD | |
| KOSTL | Cost Center | KOSTL | |
| PROID | Work Breakdown Structure Element (WBS Element) | PS_POSNR | |
| BUKRS | Company Code | BUKRS | |
| ANLNR | Main Asset Number | ANLN1 | |
| ANLUN | Asset Subnumber | ANLN2 | |
| DAUFN | Standing order number | AUFNR | |
| AUFNR | Settlement order | AUFNR | |
| VKORG | Sales Organization | VKORG | |
| VTWEG | Distribution Channel | VTWEG | |
| SPART | Division | SPART | |
| ADRNR | Address Number | AD_ADDRNUM | |
| VKBUR | Sales office | VKBUR | |
| VKGRP | Sales group | VKGRP | |
| SYSTEM_STATUS | Display lines for system status | TEXT40 | |
| USER_STATUS | Display lines for user status | TEXT40 | |
| SYST_STATUS_CODE | Name | TEXT50 | |
| USER_STATUS_CODE | Name | TEXT50 | |
| PLTXT | Description of functional location | TEXT40 | |
| KZMLA | Primary language indicator for text segment | CHAR1 | |
| PLTXU | Description of functional location in capital letters | CHAR40 | |
| TEXTCHANGEDDATETIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | |
| ARBPL_LOC | Work Center | ARBPL | |
| ARBPL_LOC_TEXT | Short description | TEXT40 | |
| ARBPL | Work Center | ARBPL | |
| ARBPL_TEXT | Short description | TEXT40 | |
| TYPTX | Description of functional location category | TEXT30 | |
| EARTX | Text for Object Type | TEXT20 | |
| STORT_TEXT | Text, Length 40 | TEXT40 | |
| BEBER_TEXT | Text, Length 40 | TEXT40 | |
| TPLNR_EXT | null | ||
| TPLMA_EXT | null | ||
| OBART | Object Type for Linear Data | ||
| TABKEY | Table Key of Reference Object | CHAR30 | |
| START_POINT | Start Point in SI Unit | ||
| START_POINT_CHAR | Value in target unit | CHAR22 | |
| END_POINT | End Point in SI Unit | ||
| END_POINT_CHAR | Value in target unit | CHAR22 | |
| LINEAR_LENGTH | Length in SI Unit | ||
| LINEAR_LENGTH_C | Value in target unit | CHAR22 | |
| MARKER_START | Marker for Start Point | ||
| MARKER_DIST_STA | Distance between Start Marker and Start Point in SI | ||
| MARKER_DIST_STAC | Value in target unit | CHAR22 | |
| MARKER_END | Marker for End Point | ||
| MARKER_DIST_END | Distance between End Marker and End Point in SI | ||
| MARKER_DIST_ENDC | Value in target unit | CHAR22 | |
| LRPID | Linear Reference Pattern | ||
| OFFSET1_TYPE | Type of First Offset | ||
| OFFSET1_VALUE | Value of Offset 1 | ||
| OFFSET1_VALUE_C | Value in target unit | CHAR22 | |
| OFFSET2_TYPE | Type of Second Offset | ||
| OFFSET2_VALUE | Value of Offset 2 | ||
| OFFSET2_VALUE_C | Value in target unit | CHAR22 |
| Master Data Relations | to Other Relations ↓ | Join Conditions |
|---|---|
| Technical Object Authorization Group | |
| Type of Technical Object | |
| Functional location category | |
| Weight Unit | |
Country/Region of Manufacture
| |
| Notification Type for Shift Note for Object | |
| Location and account assignment for technical object | |
Object ID of the Work Center
| |
| Primary language for object texts | /SMERP/STG_PM014.MLANG == T002.SPRAS |
| Catalog Profile | |
Construction type material of the object
| |
| Functional Location Structure Indicator | |
| Superior functional location | |
Reference functional location
| |
| Currency Key |
| Other Relations | to Master Data Relations ↑ | Join Conditions |
|---|---|
Planner Group for Customer Service and Plant Maintenance
| |
Maintenance Planning Plant
|