A PO Tec hnic a l Informa Informa tion tion
A PO Te c hnic a l Inf Info o rm a tio tio n 26/08/09
SA RA TH BA BA BU PA LLEBO YI YIN NA Sa ra rath.p th.p @tc s.c o m TATA Consultancy Services
Internal use
Page 1
APO Tec hnic a l Informa tion
Ta b le of c ontents Introd uc tion o f APO Tec hnic al d oc ume nt Useful tab les Useful Func tion m od ules Useful BAPI’s Use ful BADI’s
Useful Reports Useful User Exits ‐
Additional Information Common transactions
TATA Consultancy Services
Internal use
Page 2
APO Tec hnic a l Informa tion
Introduction of APO Technical document This document is specifically meant for collecting relevant technical information for APO. Useful Tables, Function modules BAPIs, BADIs, user-Exits and reports are placed here.
Useful tables The useful tables are listed in the table1:
Table Name
/SAPAPO/APPLOCS /SAPAPO/LOC /SAPAPO/LOCMAP /SAPAPO/PLANNER /SAPAPO/MATKEY SAPAPO/MATLOC
/SAPAPO/MATLOTSZ
/SAPAPO/TRPROD
/SAPAPO/RES_HEAD
TATA Consultancy Services
Details Location Types in APO Location Details in APO Mapping Table for Location between APO and R/3 Planner Codes in APO Product Master details in APO - equivalent to MARA table in R/3 Location Product Master details in APO (use /SAPAPO/V_MATLOC) - equivalent to MARC table in R/3 Lot Size related details in APO Source of Supply - contains both PDS and Transportation Lane reference Resource Header details in APO
Internal use
Page 3
APO Tec hnic a l Informa tion
/SAPAPO/RES_UNIT
Resource related details in APO
/SAPAPO/TR /SAPAPO/TRM /SAPAPO/TRPMOD
Transportation Lane Means of Transport for Transportation Lane Assignment of Source of Supply to Model
/SAPAPO/CULLHDR
Determine Key for Cluster Table
/SAPAPO/CURTOWUL
CURTO: Usage of Components
/SAPAPO/CURTOPPE
Additional Header Data for PP/DS Production Data Structures
/SAPAPO/CURTOSNP
Additional Header Data for SNP Production Data Structures
/SAPAPO/TS_SEL* BAL*
Tables related to selection profile variants Tables related to Application Log details
/SAPAPO/PCMH /SAPAPO/PCM_CP
Production Campaign, Header Production Campaign: Changes to Orders as to Campaigns
Table - 1
USEFUL FUNCTION MODULES The useful Function modules are listed in the table 2:
Function Module Name
Details
OWN_LOGICAL_SYSTEM_GET
Logical System fo current logged-on system
RFC_TRUSTED_CHECK
Checking RFC connection to the partner system
GUID_CONVERT
To convert between 16, 22 and 32 digits
/SAPAPO/FOT_CONVERT_QUANTITY /SAPAPO/MCPSH_SELECTION_*
TATA Consultancy Services
Quantity conversion based on Product master Function modules related to Selection profiles (save,Change,Delete,Get,Rename,Show,Descr)
Internal use
Page 4
APO Tec hnic a l Informa tion
/SAPAPO/TS_DM_LOCK
USer Change/Display mode in Interactive Planning
/SAPAPO/TS_PLOB_CREATE
Create CVCs
/SAPAPO/TS_PLOB_DELETE
Delete CVCs
/SAPAPO/DPBW_CUBE_READ
Infocube Data read
/SAPAPO/DM_ACCID_GET_ORDERS /SAPAPO/EFPL_ORD_NET_GET
For pegging relationship across entire strucuture
/SAPAPO/DM_MATERIAL_GET_PEGID
Determine PEGID for Material
/SAPAPO/RRP_LC_PEGID_GET_IO
Fetching MRP related data from liveCache
/SAPAPO/OM_PEG_CAT_GET_ORDERS /SAPAPO/RRP_HEURISTIC_GET_DATA
Fetch Order elements by ATP Categories Heuristic Related Data
/ SAPAPO/ DM _RESERVA TION_MAINT
To delete the purchase orders
/ SAPAPO / CIF_IRQ_REDUCT_INBO UND
To reverse the forecast
/SAPAPO/DM_ORDKEY_SELECT_ORDNO GUID of Order from live Cache
/SAPAPO/ADV_ALERT_SET
/SAPAPO/MSDP_NOTE_WRITE
/SAPAPO/TS_PLOB_CREATE
Generate Alert Write notes in Creates CVC
/SAPAPO/TS_LCM_PLOB_DELTA_SYNC
After all char combos have been created call the sync function.
/SAPAPO/TS_PLOB_DELETE
CVC Deletion
Table - 2
TATA Consultancy Services
Internal use
Page 5
APO Tec hnic a l Informa tion USEFUL BAPI’S The usef ul BAPIs a re liste d in the ta b le 3.
BAPI Name
Details
BAPI_PIRSRVAPS_GETLIST
Planned Independent Requirement i.e. Forecast
BAPI_POSRVAPS_GETLIST3
Procurement Order (Purchase Requisition / Stock Transfer Requisition)
BAPI_MOSRVAPS_GETLIST2
Planned / Production Order I.e. Manufacturing Order
BAPI_SLSRVAPS_GETLIST2
Sales Order / Deliveries
BAPI_STSRVAPS_GETLIST2
To remove the Stocks from live cahce
BAPI_LOCSRVAPS_GETLIST2
Locations
BAPI_PRDSRVAPS_GETLIST2
Products
BAPI_RSSRVAPS_GETLIST
Resources
BAPI_TRLSRVAPS_GETLIST
Transportation Lane
BAPI_PROCRELATION_GETLIST2
Procurement Relationship
BAPI_STSRVAPS_SAVEMULTI2
To create the stock categories in Live cache
BAPI_SLSRVAPS_SAVEMULTI2
To create the sales orders in live cache
BAPI_POSRVAPS_SAVEMULTI3
To create the intra Affiliate stock transfer orders in live cache
BAPI_MOSRVAPS_SAVEMULTI3
To create C0-packaging purchase orders in live cache.
BAPI_SLSRVAPS_DELMULTI
To delete the sales orders from the live cache.
BAPI_MOSRVAPS_DELEMULTI
To delete the co-packaging orders from the live cache.
Ta b le – 3
TATA Consultancy Services
Internal use
Page 6
APO Tec hnic a l Informa tion USEFUL BADI’S The usef ul SCM BADIs a re liste d in the ta b le 4.
BADI
Sho rt d esc ription
/SAPAPO/DM_PO_OP_DA2
BAdI: Change Opening Period Product Overview, Product and Calendar View, DS Planning Board, Interactive SDP
/SAPAPO/CDPS_SIMCTRL
PP/DS Heuristic: Save/Merge/Delete Own Data
Product Overview, Product View, DS Planning Board
/SAPAPO/PPT_TREE_COL
Additional Columns in Navigation Tree
Product Overview, Product View
/SAPAPO/RRP_SRC_EXIT
BAdI for Selecting Source of Supply, Creating Planned Orders
Product Overview, Product View
/SAPAPO/CULLRTOEXPL
Enhancement for PP/DS PDS Product Overview Explosion
/SAPAPO/POV_COL
POV: BADI for Columns
For Transac tion
Product Overview
/SAPAPO/RRP_COVPARAM
Time Parameters for Receipts in the Days' Supply Calculation
/SAPAPO/RRP_IO_COL
User-Exit for Enhancement of Product View the Order View
Configuration of Interface for DS Planning Board Error-Tolerant Scheduler
/SAPAPO/CDPS_FT
/SAPAPO/PRODU_CONVEX
Product Number Conversion
Product Overview, Product View
DS Planning Board, Interactive SDP
/SAPAPO/PROD_DEPOBJ
Product Usages (Deletion Blocks)
DS Planning Board, Interactive SDP
/SAPAPO/CDPS_RC_CDAT
Change Curve Data for the Resource Utilization Chart
DS Planning Board
/SAPAPO/CDPS_MC_CDAT
Change to Curve Data for Product Stock Chart
DS Planning Board
/SAPAPO/SDP_INTERACT
SDP: Interactive Planning
TATA Consultancy Services
Internal use
Interactive S&D Planning
Page 7
APO Tec hnic a l Informa tion /SAPAPO/SDP_COLWIDTH
Planning Period Column Width Default
/SAPAPO/SDP_SELECTOR
User Exits for SDP Selector
/SAPAPO/SDP_SAVE
/SAPAPO/ADVX
/SAPAPO/CURTO_CREATE, /SAPAP/CURTO_SNP
Data Save Operation Check Use this BADI for complex calculations in Planning book
Interactive S&D Planning Interactive S&D Planning Interactive S&D Planning DP/SNP Macro Builder
PPDS and SNP PDS Creation
Ta b le - 4
Useful Reports The useful rep orts a re liste d in the ta b le 5.
Reports
For
Remarks
/SAPAPO/OM_DELETE_INCON_ORDERS Delete inconsistent orders
Need to provide Order GUID.
Need to provide Model Name
/SAPAPO/VERSION_CREATE
/SAPAPO/RMDP_CHANGE_SEL_ORG
Create Version Maintain Selection Id's
/SAPAPO/RSDP_CALC_SAFETY_STOCK
Safety Stock Calculation
Activate Standard Objects (Info Objects)
/SAPAPO/TS_D_OBJECTS_COPY l
Need to provide Planning Book
/SAPAPO/TS_REALIGN_COPY
Performs Realignment
/SAPAPO/AMON_REORG
Deletion of Alerts
/SAPAPO/VERSION_COPY_PAR
FUNCTION_LOADER_INLAY
TATA Consultancy Services
For copying the data from one version to other version
Source and Destination Version
Load Data from Excel Sheet using BAPI
Internal use
Page 8
APO Tec hnic a l Informa tion
Relev a nt R/ 3 Rep o rts a re liste d in the t a b le 6.
R/3 Report
For
Remarks
RCIFORDER_RESERVATIONS_COMPARE
Reconciliation of Order Reservations
Refer OSS Note 538111
SDRQCR21
Reconciliation of Sales Order from R/3
Ta b le - 6
Useful User Exits ‐
The useful use r-Exits a re liste d in the t a b le 7.
Exit Name
Details
EXIT_/SAPAPO/SAPLCIF_LOC_001
APO CIF Inbound - Location
EXIT_SAPLCLOC_004
R/3 CIF Outbound - Location
EXIT_/SAPAPO/SAPLCIF_PROD_001
APO CIF Inbound - Product
EXIT_SAPLCMAT_001
R/3 CIF Outbound - Material
EXIT_/SAPAPO/SAPLCIF_RES_001
APO CIF Inbound - Resource
EXIT_SAPLCRES4_001
R/3 CIF Outbound - Resource
Ta b le - 7
TATA Consultancy Services
Internal use
Page 9
APO Tec hnic a l Informa tion
Additional Information Common terminologies in APO are listed in the table 8.
Terminology
Details
Planned Order
Manufacturing Order created in APO resulting from Production Planning run for In-house Produced Product
Production Order
Planned Order is converted to a Production Order in R/3 which is then executed up (actual production carried out)
Purchase Requisition / STR
Planned requisition resulting from Production Planning run for an Externally Procured Product
Purchase Order / STO
Requisition is converted to a firmed Order in R/3 for subsequent execution
Independent Requirement / Demand
Requirement for a finished product coming from customer. This may not be the firm demand but just a plan
Sales Order
Firm demand from customer with a confirmed requirement date and quantity
Stock
Quantity of product available at a location either after production or procurement
Pegging Area
Combination of Product - Location - Account Assignment Object - Planning Version = Planning Segment in R/3
GUID
Unique ID used to identify each Master and Transaction Data element in APO. 40 character alpha-numeric code automatically system generated
Planning Version
All Transaction and many Master data in APO stored in live Cache against a planning version. Default Planning Version to use is 000 - Active Version
Table - 8
TATA Consultancy Services
Internal use
Page 10
APO Tec hnic a l Informa tion
Common transactions used in APO The t ransa c tion a re liste d in the ta b le 9.
Transaction Name
Transaction Code
Details
Location
/SAPAPO/LOC3
Plants (Manufacturing / DC), Vendors, Customers, MRP Areas in R/3 all map to Location master in APO differentiated by Location Type (1001, 1002, 1011, 1010, 1007)
Product
/SAPAPO/MAT1
Material in R/3 is mapped to Product in APO. Have multiple tabs similar to that in R/3. Many field values come from R/3 while APOspecific field values are either manually populated or automatically during CIF transfer from R/3 to APO
Resource
/SAPAPO/RES01
Work Center (or Capacity) in R/3 defines the machine or equipment used for Production, Storage or Transportation
PDS
/SAPAPO/CURTO_SIMU
Combination of Bill-of-Material and Routing in R/3 (Production Version). Used for In-house Produced Products to determine components and resource (capacity and time) requirements
Transportation Lane
/SAPAPO/SCC_TL3
Purchasing Info records and Contracts in R/3 map to Transportation Lanes in APO that define from where - to where products can be moved and the transportation duration
Master Data Related
TATA Consultancy Services
Internal use
Page 11
APO Tec hnic a l Informa tion Procurement Relationship
/SAPAPO/PWBSRC1
Displays Contracts, Purchasing Info records and Scheduling Agreements coming from R/3
Transaction Data Related Product View
/SAPAPO/RRP3
Most commonly used - needs Planning Version 000, Product and Location. This is equivalent to MD04 txn in R/3
Planning Board
/SAPAPO/CDPSO
Detailed View of Orders/operations used by End-users for Scheduling. Not much useful from Technical perspective
Order Resource Reporting
Interactive SDP
/SAPAPO/SDP94
Used to display DP and SNP data through a Planning Book / Data View combination and selecting CVCs
Interactive Load Builder
/SAPAPO/SNPTLB
Used to carry out Transport Load Building - creation of Shipments
Display LC Contents
/SAPAPO/OM16
User-friendly way to display LC data by type of data. Need to know Order Type, Business System Group (BSG01)
liveCache Browser
/SAPAPO/OM19
You need to select live Cache option and browse the tables. This is not a very user-friendly option
/SAPAPO/CDPS_REPT
Combination of multiple reports
Ta b le – 9
TATA Consultancy Services
Internal use
Page 12