- 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)
- Advanced Planning and Optimization (SCM-APO)
- Event Management (SCM-EM)
- Execution (SCM-ECT)
- Extended Warehouse Management (SCM-EWM)
- Fulfillment Coordination (SCM-FC)
- SAP S/4HANA (SCM-S4H)
- SAP Yard Logistics (SCM-YL)
- SCM Basis (SCM-BAS)
- Alert Monitor (SCM-BAS-AMO)
- Alert Notification Engine (SCM-BAS-ANO)
- Business Interface Layer (SCM-BAS-BIF)
- Configurable Process Scheduling (SCM-BAS-SCH)
- Cross-System and Cross-Partner Document Flow (SCM-BAS-DF)
- DataMatrix (SCM-BAS-DMX)
- EH&S Services (SCM-BAS-EHS)
- Interfaces (SCM-BAS-INT)
- Lane, Distance and Duration Determination (SCM-BAS-LDD)
- Master Data (SCM-BAS-MD)
- Batch Management (SCM-BAS-MD-BM)
- Bill of Distribution (SCM-BAS-MD-BOD)
- Calendar (SCM-BAS-MD-CAL)
- Hierarchy (SCM-BAS-MD-HI)
- Location (SCM-BAS-MD-LO)
- Model (SCM-BAS-MD-MO)
- Partner-Specific Master Data (SCM-BAS-MD-PRT)
- Product (SCM-BAS-MD-PR)
- Product and Location Interchangeability (SCM-BAS-MD-INC)
- Purchasing (SCM-BAS-MD-PUR)
- Resource (SCM-BAS-MD-RE)
- Route (SCM-BAS-MD-RT)
- Supply Chain Unit (SCM-BAS-MD-SCU)
- Transportation Lanes, TDL Profile and Planning Costs (SCM-BAS-MD-TL)
- Transportation Zone (SCM-BAS-MD-ZON)
- Version Management (SCM-BAS-MD-VM)
- Master Data Layer (SCM-BAS-MDL)
- Order Document Management (SCM-BAS-ODM)
- Packing Basics (SCM-BAS-PAK)
- Planning Object Structure (SCM-BAS-POS)
- Planning Service Manager (SCM-BAS-PSM)
- Process Controller (SCM-BAS-PRC)
- Quantity Offsetting (SCM-BAS-QOS)
- Remote Control and Communication Framework (SCM-BAS-RCC)
- Routing Guide (SCM-BAS-RG)
- SCM Anaylsis Tools - Base Functions (SCM-BAS-SCR)
- Timeseries Data Management (SCM-BAS-TSM)
- Transaction Data Layer (SCM-BAS-TDL)
- Transport Load Builder (SCM-BAS-TLB)
- UI Framework (SCM-BAS-UIF)
- SCM Cross-Application Components (SCM-CA)
- Supply Network Collaboration (SCM-ICH)
- Transportation Resource Planning (SCM-TRP)
- Sustainability management (SUS)
- Training and Event Management (PE)
- Transportation Management (TM)
- Treasury (TR)
- Web Channel (WEC)
/SAPAPO/MATLOC
- 🔑 Keys (3)
- 💰 Amounts
- ∑ Quantities (7)
- 📅 Dates
- ☰ Categorical (44)
- Other (120)
- 🔗 Relations (15)
| Column Name | Description | |
|---|---|---|
| MANDT FK | Client (APO Conversion to Client-Dependency) | |
| MATID FK | Internal Number (UID) for Product | |
| LOCID FK | Internal Location Number for Customer, Supplier, or Plant |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| 📏 Base Unit of Measure (/SAPAPO/MATKEY.MEINS): | ||
| SAFTYC_MAX | Maximum Safety Stock | |
| SAFTYC_MIN | Minimum Safety Stock | |
| OS_LIMIT | Alert Threshold for Out-of-Stock | |
| MIN_PASS_AMOUNT | Minimum Passing Amount for Continuous I/O Pegging | |
| 📏 Unit of Measure: Handling Capacity in Goods Receipt (HUNIT): | ||
| CONHAP | Handling Capacity Consumption in Unit of Measure (Gds Rcpt) | |
| 📏 Unit of Measurement of Size (IUNIT): | ||
| CONINP | Consumption of Storage Capacity per Unit of Material | |
| 📏 Unit of Measure: Handling Capacity in Goods Issue (HUNIT_OUT): | ||
| CONHAP_OUT | Handling Capacity Consumption in Unit of Measure (Gds Issue) | |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| LVORM | Deletion flag | Show values |
| PSSFLAG | Parameter-Dependent ATP Safety Stock Indicator | Show values |
| KZKFG | Indicator: Configurable material | Show values |
| BESKZ | Procurement Type | Show values |
| PART_OF_PACKAGE | Location Product is Part of a Planning Package | Show values |
| WHATBOM | Plan Explosion | Show values |
| EXPLDATE_FINDER | Determination of the BOM Explosion Date | Show values |
| MAXDOS_FLG | Is Max Dos Active | Show values |
| CRITICAL_COMP | Critical Component | Show values |
| AGGR_CTM_PLNG | Aggregated CTM Planning | Show values |
| MSDP_SB_METHOD | Method for Calculating Safety Stock | Show values |
| GET_ALERTS | Alert Relevance of Product | Show values |
| SNPNOFIX | Do not fix orders during manual creation | Show values |
| RESNETSTRAT | Strategy of Resource Net Consideration with Pegging | Show values |
| CONRESSTRAT | Strategy for Container Resource-based Pegging | Show values |
| USE_MIN_PASS_AMT | Use Minimum Passing Amount for Continuous I/O Pegging | Show values |
| TPOP | Third-Party Order Processing | Show values |
| SFT_OVERRIDE | Indicator for Safety Stock Override | Show values |
| CONF_PROPAGATION | Quantity Propagation By Confirmations | Show values |
| CONF_COMPONENTS | Component Adjustment by Confirmation | Show values |
| CONF_DURATION | Remaining Net Duration Adjustment By Confirmation | Show values |
| CONF_GMSYNC | Synchronous Posting of Goods Issue | Show values |
| MAT_PRTMANAGE | Business Partner That Manages the Product | Show values |
| DIBER | Planning in MRP Areas | Show values |
| MATVERS_ACTIVE | Product Version Active | Show values |
| MATVERS_HPLAN | Planning on Product Version | Show values |
| TDFIELDS | Indicator: Whether Time-Dependent Attributes Are Used | Show values |
| PRO_ORD | Do not Cover Sales Deal with VMI Customer Stocks | Show values |
| PRO_LTP | Normal and Sales Deal Deliveries Deliverable | Show values |
| DEADPILE | Indicator: Non-Palletable | Show values |
| SHIPPING | Switch (Time-Dependent) Whether Deliveries are Possible | Show values |
| ARRIVAL | Switch (Time-Dependent) Whether Goods Acceptance Possible | Show values |
| ACT_STATUS | Time-Dependent Status for Location Products | Show values |
| MAXCOVERUP | Shipment Upsizing | Show values |
| MIXTP | Separate Transportation of Baseline and Promotion | Show values |
| USETP | Use of Baseline Stock for Promotions | Show values |
| PROM_PREDL | Advance Delivery of Promotions Allowed | Show values |
| SHELF_LIFE_LOC | Use Location-Dependent Shelf Life of Product when Planning | Show values |
| RPSTATUS | Replenishment Type of Product | Show values |
| SEASON | Season Indicator | Show values |
| LISTINGSTATUS | Listing Status | Show values |
| TEMPRPBLOCK | Temporary Replenishment Blocking | Show values |
| INITBUY | Control of Initial Buy Allocation | Show values |
| SUBSTLOCK | Locking Indicator for Article Usage in Case of Substitution | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| CHKHOR | ATP: Checking Horizon in Days | /SAPAPO/CHKHOR | |
| RCRRCPHOR | ATP: Horizon for Recreating Receipts in Calendar Days | /SAPAPO/RCRRCPHOR | |
| KOSCH | Allocations: Product Allocation Procedure | /SAPAPO/KOSCH | |
| VMIKOSCH | Allocations: Product Allocation Procedure | /SAPAPO/KOSCH | |
| VMIKOSCH_GRP | Prod. Allocations: Sequence of Product Allocation Procedures | /SAPAPO/KOSCH_GRP | |
| CUOBJ | Configuration (Internal Object Number) | ||
| SATID | Internal Number (UID) for Configurable Product | /SAPAPO/MATID | |
| GRPRT | Goods Receipt Processing Time | TSTRDURAG | |
| GIPRT | Goods Issue Processing Time | TSTRDURAG | |
| PLIFZ | Planned Delivery Time in Days | /SAPAPO/DEC3 | |
| LGRAD | Service Level | /SAPAPO/DEC2_1 | |
| SCOST | Product-Dependent Storage Costs | /SAPAPO/DEC13 | |
| SAFTY | Safety stock | FLTP | |
| STOCK_UID | UUID in compressed form (22 character UUENCODEd) | SYSUUID_22 | |
| RELDT | Replenishment Lead Time in Calendar Days | /SAPAPO/DEC3 | |
| RRP_TYPE | PP Planning Procedure | ||
| ERHOR | Opening Period in Workdays | TSTRDURAG | |
| FREIZ | Release Period in hhhhhhh:mm:ss / Externally ttttt,tt | TSTRDURAG | |
| FIXHZ | Product-Specific Planning Time Fence in Workdays | TSTRDURAG | |
| HEUR_ID | PPC Heuristics | ||
| PACKAGE_ID | Planning Package to Which Product Belongs | ||
| CONVH | PP/DS Horizon in Calendar Days | /SAPAPO/HORIZON4 | |
| CTHOR | Requirements Ascertainment Horizon in Workdays | TSTRDURAG | |
| AJHOZ | Adjustment Horizon in Work Days | TSTRDURAG | |
| INTSRC_PROF | Profile for Interactive Sourcing | ||
| DPLCHRPRF_ID | Deployment Characteristics Profile ID | /SAPAPO/DPLCHRPRF_ID | |
| MAXDOS_PEN | Penalty exceeding time dependent Max Days' of Supply | /SAPAPO/DEC13 | |
| ND_STORDU | Network Design: Average Time in Storage in Days | DEC13_2 | |
| ND_MEANPROD_WEEK | Average Number of Production Operations per Week | DEC03_2 | |
| NDCOSTWE | Goods Receiving Costs (Network Design) | /SAPAPO/NDFLOAT | |
| NDCOSTWA | Goods Issue Costs (Network Design) | /SAPAPO/NDFLOAT | |
| SELHORZ | Demand Selection Horizon (in Days) | /SAPAPO/SNPHORIZ | |
| EARLYSHIP | Order Creation Frame (Horizon for Creating Orders) | NUMC3 | |
| PROC_COST | Procurement Costs for Product | /SAPAPO/DEC13 | |
| PROD_COST | Production costs for product | /SAPAPO/DEC13 | |
| SSPEN | Penalty Costs for Safety Stock Violation | /SAPAPO/DEC13 | |
| PRIO | Priority of Product | /SAPAPO/PRIO | |
| RES_NET_ID | GUID of a Resource Net | SYSUUID_22 | |
| RES_NET_NAME | Resource Network | CHAR40 | |
| CCIND | Cycle Counting Indicator | /SCWM/PI_CCIND | |
| SCOST_PRCNT | Cost Factor for Stockholding Costs | /SAPAPO/PERCENT_SCOST | |
| THRUPUT_TIME | Throughput Time | TSTRDURAG | |
| UNS_PRC_SCOST | Holding Cost Factor for Unserviceable Product | /SAPAPO/PERCENT_SCOST | |
| PPSAFTYSTK | Safety Stock at Parent Location | FLTP | |
| PPSAFTYSTK_V | Safety Stock of Parent Location Virtual Child Location | FLTP | |
| ADDSFTSTK | Additional Safety Stock in Days of Demand | FLTP | |
| MAXSTOR_QTY | Recommended Storage Quantity | FLTP | |
| SAFTY_V | Safety Stock for Virtual Child Location | FLTP | |
| REPSAFTY | Repair Safety Stock | FLTP | |
| REPSAFTY_V | Repair Safety Stock for Virtual Child Location | FLTP | |
| MAXSTOCK_V | Maximum Stock Level for Virtual Child Locations | FLTP | |
| REORD_V | Reorder Point for Virtual Child Location | FLTP | |
| FIXTI | Firming Time Fence | TZNTSTMPS | |
| COSID | Supply Network Planning: Internal number for cost function | /SAPAPO/SNPCOSID | |
| SCOST_PER_DAY | Prod.-Dep. Storage Costs Per Day and Base Unit of Measure | /SAPAPO/TMREFDAY | |
| REORD | Reorder Point | FLTP | |
| MAXSTOCK | Maximum Storage Capacity for a Product | FLTP | |
| PLANNER_PUR | Purchasing Planner | /SAPAPO/DISPO | |
| KDMATID | Material Number Used by Customer | /SAPAPO/KDMAT | |
| EKGRP | Purchasing Group | /SAPAPO/EKGRP | |
| VEGRP | VMI Purchasing Group | CHAR20 | |
| LADGR | Loading Group | /SAPAPO/LADGR | |
| FEDEM | Relative Demand Forecast Error in % | /SAPAPO/DEC3_1 | |
| FERLD | Relative Forecast Error of Replenishment Lead Time in % | /SAPAPO/DEC3_1 | |
| PIPRT | Pick/Pack Time | TSTRDURAG | |
| TLPRT | Transportation Lead Time | TSTRDURAG | |
| SNPCHKHOR | SNP: Checking Horizon in Days | /SAPAPO/CHKHOR | |
| ATDSP | Category Group for ATD Quantity (Receipts) | /SAPAPO/MAT_CATGRP | |
| ATDDM | Category Group for ATD Quantity (Issues) | /SAPAPO/MAT_CATGRP | |
| COSTPROF | TLB Cost Profile | /SAPAPO/COSTPROF | |
| MANOT | Material Memo Exists | CHAR1 | |
| SUBLOCID | No longer used. See data element /SAPAPO/SUBLOC | /SAPAPO/SUBLOCID | |
| MATLOCID | Internal Number (UID) for Location Product | /SAPAPO/MATLOCID | |
| AT101 | Free Attribute 1 | CHAR40 | |
| AT102 | Free Attribute 2 | CHAR30 | |
| AT103 | Free Attribute 3 | CHAR20 | |
| AT104 | Free Attribute | CHAR10 | |
| AT105 | Free Attribute | CHAR10 | |
| PLANNER_VMI | SAP SNC Planner | /SAPAPO/DISPO | |
| PLANNER_SMI | SMI Planner | /SAPAPO/DISPO | |
| HUGRP | Handling Unit Group | /SAPAPO/HUGRP | |
| MAXCOVER | Maximum Coverage Period in Days | /SAPAPO/MAXCOVER | |
| SHELF_LIFE_DUR | Location-Dependent Shelf Life | TSTRDURAG | |
| MATURITY_DUR | Location-Dependent Maturation Time | TSTRDURAG | |
| SHLF_LFE_REQ_MIN | Minimum Shelf Life Required: Location-Dependent | TSTRDURAG | |
| SHLF_LFE_REQ_MAX | Maximum Shelf Life Required: Location-Dependent | TSTRDURAG | |
| PHYSICAL_MIN | Unpumpable | FLTP | |
| MEASGRBUY | Unit of Measure Group | CHAR4 | |
| PURTIME | Purchase Order Processing Time Required by Purchasing Dept. | TSTRDURAG | |
| MINSTOCK | Minimum Target Stock on Hand for a Product | FLTP | |
| SALESPRICE | Sales Price of Product | /SAPAPO/DEC13 | |
| SELLCLASS | Selling Class | /SAPAPO/SELLCLASS | |
| CONSREFFAC | Consumption Reference: Factor | /SAPAPO/DEC13 | |
| CONSREFVALTO | Consumption Reference: Valid To | TZNTSTMPS | |
| TARGETSTOCK | Target Stock | FLTP | |
| STOCKMULTIPLE | Stock Multiple | FLTP | |
| RELTIME | Time of Release | TSTRDURAG | |
| PROFCST | Forecast Profile F&R | CHAR10 | |
| PROREPL | Replenishment Profile Forecasting & Replenishment | CHAR10 | |
| PROEXCP | Profile for Handling FRP Errors in F&R | CHAR10 | |
| PROCL | F&R Capital Lockup Profile | CHAR10 | |
| LEADTIMESHIFT | Replenishment Lead Time Shift | NUMC2 | |
| FCHOROP | Operational Forecast Horizon in Weeks | NUMC3 | |
| FCOUTDAY | Exact-to-the-Day Output of Forecast | NUMC3 | |
| FCOUTWEEK | Output of Forecast in Weeks | NUMC3 | |
| PROSL | Service Level Profile F&R | CHAR10 | |
| PROFCFRQ | Frequency Forecast Profile F&R | CHAR10 | |
| MINTROC | Minimum Target Range of Coverage in Days | NUMC3 | |
| MAXTROC | Maximum Target Range of Coverage in Days | NUMC3 | |
| PROCALIB | Frequency Profile for Parameter Optimization | /SAPAPO/PROFILE | |
| BALGR | Purchase Order Balancing Group | /SAPAPO/PROFILE | |
| PROPREALLOC | Requirement Preallocation Profile for FRP | /SAPAPO/PROFILE | |
| OFCHOR | Purchase Order Forecast Horizon (in Days) | NUMC3 | |
| PROOFFRQ | Purchase Order Forecast Frequency Profile | /SAPAPO/PROFILE | |
| DUMMY2_R | null | ||
| DUMMY_PLNT_INCL_EEW_PS | MD product plant extensible field element | PLNT_INCL_EEW | |
| CREATEUSER | Name of Person Responsible for Creating the Object | USNAM | |
| CREATEUTC | Date and Time at Which Object Was Created | /SAPAPO/U_TZNTSTMPS | |
| CHANGEUSER | Name of Person Who Changed Object | USNAM | |
| CHANGEUTC | Date and Time at Which Object Was Last Changed | /SAPAPO/U_TZNTSTMPS |
| Master Data Relations | Join Conditions |
|---|---|
Source of Supply Control
|
|
ATP: Checking Horizon Calendar
| |
Internal Location Number for Customer, Supplier, or Plant
|
|
Internal Number (UID) for Product
|
|
ATP: Unit of Measure for Display
| |
SNP: Deployment Profile ID (GUID)
|
|
SNP: Demand Profile ID (GUID)
|
|
Display Production Unit
| |
Internal Location Number for Customer, Supplier, or Plant
|
|
Internal ID:Lot size/days'supply profile in material master
|
|
| Client (APO Conversion to Client-Dependency) | /SAPAPO/MATLOC.MANDT == T000.MANDT |
Internal Number (UID) for Product
|
|
Material-dependent storage location resource for a location
|
|
Internal Number for Requirement Profile in Product Master
|
|
SNP: Supply Profile ID (GUID)
|
|