- Accounting - General (AC)
- Controlling (CO)
- Cross-Application Sources (OCA)
- Customer Service (0CS)
- Enterprise Controlling (EC)
- Financial Accounting (FI)
- Investment Management (IM)
- Logistics - General (LO)
- Materials Management (MM)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Quality Management (QM)
- Real Estate Management (0RE)
- Sales and Distribution (SD)
- Time Management (PT)
- Training and Event Management (PE)
- Treasury (TR)
0APO_RESNAM_ATTR
APO Resource Attributes |
#ATTR |
Extraction method: F1 |
No Delta
| Component: Master Data Advanced Planner and Optimizer
Tables used:
/SAPAPO/RES_HEAD, /SAPAPO/RESDIM, /SAPAPO/RESKEY, /SAPAPO/MATKEY, /SAPAPO/MATLOC ... +7 more
- 🔑 Keys (12)
- 💰 Amounts
- ∑ Quantities (8)
- 📅 Dates
- ☰ Categorical (23)
- Other (42)
- 🔗 Relations (4)
| Column Name | Description | |
|---|---|---|
| MANDT FK | Client (APO Conversion to Client-Dependency) | |
| RESUID FK | Internal Key (GUID) of a Resource | |
| SIMVERSID | GUID | |
| SIMSESSID | GUID | |
| NAME | Resource Name | |
| LOCID | Internal Location Number for Customer, Supplier, or Plant | |
| DIMENSION | Dimension key | |
| PLANNER | Resource Planner Group | |
| DIMENSION_BUCKET FK | Dimension of the Resource (Bucket View) | |
| LOGQS | Business System Group | |
| EXT_LOCNO | External Location Identifier | |
| LOCTYPE | Location Type | Show values |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| 📏 Unit of Measure for the Capacity of a Multiactivity Resource (NOINDIVRES_UNIT): | ||
| NOINDIVRES | Capacity of Resource | |
| 📏 Unit of Measure for Capacity of a Bucket Resource (CAPACITY_A_UNIT): | ||
| INDIVRES_CAP | Size of the Transportation Resource | |
| CAPACITY_A | Capacity of the Bucket Resource | |
| 📏 Unit Measure of Rate (BR_QUNIT): | ||
| BR_QUANT | Number of Units for the Base Rate | |
| 📏 Time Unit of Rate (BR_TUNIT): | ||
| BR_TIME | Number of Time Units for a Rate | |
| 📏 Stock Unit (STORAGE_UNIT): | ||
| MIN_STORAGE | Minimum Production Quantity | |
| MAX_STORAGE | Maximum Stock Level | |
| MIN_REPLENISHMNT | Quantity up to Which a Product Receipt is Allowed | |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| RESTYPE | Resource Category | Show values |
| TYPE | Resource Type | Show values |
| UTILIZATION | Rate of Utilization (Percent) | Show values |
| PERIOD | Period Type | Show values |
| FINITE_PLANNING | Consider Resource Capacity Load | Show values |
| IS_BOTTLENECK | The Resource is a Bottleneck Resource | Show values |
| MIN_GAPS | Reduce Gaps | Show values |
| OVERLAP_BUCKETS | Activities can Overlap into Another Period | Show values |
| START_ON_GRID | Activities can Only Begin at the Start of the Bucket | Show values |
| LOSS_FACTOR | Percentage Loss Factor when Deriving Bucket Capacity | Show values |
| SYNC_START | Synchronization of Activities when Overlapping Occurs | Show values |
| SYNC_COMPATIBLE | Synchronization of Activities when Overlapping Occurs | Show values |
| DEFINE_BUCKETS | Definition of Bucket Capacity for Mixed Resource | Show values |
| STORAGE_CAPABLE | Resource has Storage Characteristics | Show values |
| STORAGE_TO_ZERO | Handling the Remaining Fill Level | Show values |
| SNPLC | Resource is not Relevant for SNP | Show values |
| UTIL_BUCKET | Rate of Bucket-Oriented Capacity Utilization (%) | Show values |
| MIX_PLAN_TYPE | Defining Finite Capacity | Show values |
| CAMPAIGN_PPDS | Resource is Campaign-Relevant | Show values |
| CAMPAIGN_SNP | Period Lot Size | Show values |
| TSTREAM_EXTERNAL | Capacity Data is From an External System | Show values |
| MULTIPLE_PRODUCT | Allow Multiple Products | Show values |
| LOCTYPE | Location Type | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| LCRESID | Internal Key (UID) for a Resource with Sim. Vers. for LC | /SAPAPO/LCRESID | |
| TSTREAMID | APO-Internal Number (GUID) for Time Stream | SYSUUID_22 | |
| RESOURCE_GROUP | Resource Group | CHAR12 | |
| CALENDAR | Factory Calendar ID | WFCID | |
| BEGTI | Start Time in Seconds (Internal) | /SAPAPO/CRES_TIME_INT4 | |
| ENDTI | End Time in Seconds (Internal) | /SAPAPO/CRES_TIME_INT4 | |
| BREAKTIME | Cumulated Break Time in Seconds | /SAPAPO/CRES_TIME_INT4 | |
| BUFFERTIME | Resource-Dependent Buffer Time | /SAPAPO/CRES_BUFFTIME | |
| STRFACT | Max. Stretch Factor | NUMC3 | |
| SHRFACT | Max. Shrink Factor | NUMC3 | |
| NUM_OF_PERIODS | Number of Periods to which the Capacity Applies | NUM3 | |
| PLANNER_SNP | Supply Network Planner | /SAPAPO/DISPO | |
| OUTPUT_RATE | Resource Output Rate | NUMC6 | |
| VERSION_ACTIVE | Active Available Capacity Variant | /SAPAPO/CRES_VERSION | |
| OVERLOAD | Maximum Capacity Overload of Resource | NUM3 | |
| UNDERLOAD | Minimum Capacity Load for the Resource | NUM3 | |
| MIN_OVERLAP | null | ||
| MATRIX_ID | Matrix Identification | /SAPAPO/CDPS_MATRIX_ID | |
| CHANGEUSER | User Name | SYCHAR12 | |
| CHANGEDATE | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | |
| REF_PROCTIME | Processing Duration for Reference Operation in Seconds | /SAPAPO/CRES_REF_PROCTIME | |
| TZONE | Time Zone | TZNZONE | |
| TAKTS | Number of Takts | /SAPAPO/NUM_TAKTS | |
| RITT_FLG | Rate-Independent Takt Time | /SAPAPO/RITT_FLG | |
| MDRMODEL | Defintion Name for the Product-Dependent Rate | /SAPAPO/CRES_DEFINITION_NAME | |
| SORT | Freely Selectable Character Sequence for Sorting Resources | TEXT30 | |
| SINGLE_RES_LC | GUID | TEXT22 | |
| SINGLE_RES_TID | GUID | TEXT22 | |
| LC_DAYS_MINUS | Validity Period of Available Capacity (In Past) | NUMC4 | |
| LC_DAYS_PLUS | Vailidity Period of Res. Capacity (from Today into Future) | NUMC4 | |
| TRATY | Means of Transport | /SAPAPO/CRES_TRATY | |
| FINITY_LEVEL | Finiteness Level of the Resource | ||
| DIM_STORAGE | Dimension for Storage Characteristics of a Resource | DIMID | |
| LOCNO | Location | CHAR20 | |
| TEXT | Short Description | TEXT60 | |
| UPD | Update Indicator | /SAPAPO/CRES_UPD | |
| RESNAME | Resource Name | /SAPAPO/CRES_NAME | |
| R3KAPID | Object ID of Capacity/Work Center in SAP R/3 | /SAPAPO/CRES_R3OBJID | |
| R3ARBID | Object ID of Capacity/Work Center in SAP R/3 | /SAPAPO/CRES_R3OBJID | |
| EXT_PLANT | Plant | /SAPAPO/PLANT | |
| EXT_CUSTOMER | APO -> BW: Client Number | /SAPAPO/BWEX_CUSTOMER | |
| EXT_VENDOR | APO->BW: Supplier Number | /SAPAPO/BWEX_VENDOR |
| Master Data Relations | Join Conditions |
|---|---|
Dimension of the Resource (Bucket View)
| |
| Client (APO Conversion to Client-Dependency) | 0APO_RESNAM_ATTR.MANDT == T000.MANDT |
Internal Key (GUID) of a Resource
|
|
Internal Key (GUID) of a Resource
|
|