Extraction of Mapping Information 

Definition

The logic that underlies the assignment of fields between R/3 and APO means that the values for the data fields in APO are built based on information in R/3. This logic can be queried directly at the corresponding point within function modules and Includes. Access is gained using transaction SE37 for function modules, and transaction SE38 for Includes.

Structure

The following list contains all the Includes and function modules from the objects in question that are relevant for APO-R/3 mapping and from which the relevant information can be extracted.

Stocks

The following function modules are relevant for stocks:

Purchase orders and purchase order requisitions

For the current release PI 2000.1, mapping of the APO structures in R/3 is carried out in the function module ME_APO_GENERATE_REQ_PO in the form ONVERT_TABLES_FROM_APO.

Production orders and process orders

The following function modules are relevant for production orders and process orders in R/3:

Campaign

All function modules required for integrating the campaign into R/3 are located in the function group CPCM1. The following function modules are relevant for the campaign:

In APO, the corresponding function group is called PCM_BAPI and has the following function modules:

Product allocation

Product allocation is transferred via ATP testing (online). When updating, it is transferred via the standard SD module.

The transactions used for the transfer are QTSP (customizing) and QTSA (product allocation). These can be used as an example for the transfer. The CIF modules are called up in these transactions.

The APO function modules are /SAPAPO/QUOTA_PROCEDURE_GET and /SAPAPO/QUOTA_ALLOCATION_GET.

Storage resources

The table /SAPAPO/PRODFLOW describes how orders and storage resources interact. The table is filled in by the function module /SAPAPO/PFLOW_PPM_MAINTAIN.

Delivery document and sales order

Delivery documents are transferred to APO by means of the function group V45V. The following Includes are relevant for this:

Mapping in CIF

The following function modules are relevant for mapping in CIF:

Planned order

The following list contains function modules and Includes (and the relevant subprograms within the Includes) for the object planned order.

Include LMRP6F10 and its subprograms

List of function modules

Production Process Model (PPM)

The following function modules and data fields are relevant for the transfer of master data from the R/3 System to create a PPM in SAP APO:

Function modules

Data fields for material assignment to plan

PPM: Material Assignment to Plan

APO field

R/3 field

CONVERSION

Internal number (UID) for production version in PPM

PRODVERZ -PPMID

/

/

Alternative BOM

PRODVERZ –STLAL

MKAL-STLAL

/

BOM usage

PRODVERZ -STLAN

MKAL-STLAN

/

Task list type

PRODVERZ -PLNTY

MKAL-PLNTY

/

Key of task list group

PRODVERZ –PLNNR

MKAL-PLNNR

/

Group counter

PRODVERZ-ALNAL

MKAL-ALNAL

/

Production procedure

PRODVERZ-R3VERID

MKAL-VERID

/

PPM: Plan

APO field

R/3 field

CONVERSION

Internal plan number (UID) in APO

PLAN-PLANID

/

/

External routing number in the production process model

PLAN-PLANNR

MKAL-PLNTY

MKAL-PLNNR

MKAL-PLNAL

MKAL-VERID

(MKAL-MATNR

MKAL-WERKS)

/

Penalty (variable)

PLAN-COST1

/

/

Penalty fix

PLAN-COST2

/

/

Status of a plan in the production process model

PLAN-STATE

/

/

USAGUsage of the production process model (SNP and/or PP/DS)

PLAN-PL_USAGE

/

/

Fixed portion of total costs beginning with this level

PLAN-COST_FIX

/

/

Variable portion of total costs beginning with this level

PLAN-COST_VAR

/

/

Product and location product

The corresponding function module in R/3 is CIF_MATERIAL_PRODUCT_MAP

R/3 Capacity/APO Resources

The following function modules are relevant for R/3 capacity and APO resources

in R/3:

in APO:

/SAPAPO/CIF_RES_INBOUND (mapping the inbound structures onto BAPI structures)

BAPI_RSSRVAPS_SAVEMULTI_30A (BAPI for creating and changing model-independent resources and for assigning to model 000)

Transferring planning file entries (APO – R/3)

The following function modules are relevant for transferring planning file entries (APO -> R/3):

Transferring dependent requirements (APO -> R/3)

The following function modules are relevant for transferring dependent requirements (APO -> R/3):

Usage scenario

Consumption data is sent from R/3 to APO (initial transfer)

Function modules come under the E-class CIF. In the function group, the following function modules are relevant to the usage scenario:

The CIF_SERMSL is a transfer structure and is received by the VMI interface in APO.

The scenario is available from APO 3.0A on.

Location

Because location in APO and R/3 are not identical, the mapping fields are executed individually. The following data fields are relevant for the transfer of location data from the R/3 System to APO:

Location: Mapping Table (/SAPAPO/LOCMAP)

APO field

R/3 field

Conversion

External location number

LOCMAP-EXT_LOCNO

Object-dependent

R/3 (or other external systems) number

Location type

LOCMAP-LOCTYPE

CIF mapping

1001 (Plant), 1002 (DC), 1005 (Transportation Zone), 1007 (Mrparea), 1010 (Customer), 1011 (Supplier), 1020 (Carrier)

BSG

LOCMAP-LOGQS

CIF mapping

 

Customer number

LOCMAP-LOCNO

 

Standard 1:1

It is possible for you to define your own mapping.

See Customer-Exits [External] .

Internal location number

LOCMAP-LOCID

NA

Internal conversion for integration

Logical System

LOCMAP-LOGSYS

CIF mapping

 

Internal plant number

(only Mrparea)

LOCMAP-PL_LOCID

NA

Not used in R/3

External plant number

(only Mrparea)

LOCMAP-PL_EXT_LOCNO

T001W-WERKS

 

Storage location (Mprarea only)

LOCMAP-SUBLOKATION

   

 

Location: Customer

APO field

R/3 field

Conversion

Internal location number

LOC-LOCID

NA

Internal conversion for integration

Location type

LOC-LOCTYPE

CIF mapping

1010

Customer number

LOC-LOCNO

KNA1-KUNNR

Standard 1:1

It is possible for you to define your own mapping.

See Customer-Exits [External] .

Time zone

LOC-TZONE

KNA1-LAND1

KNA1-REGIO

Time zone calculated from country and region

 

Both fields can be viewed in the address screen

Longitude in GPS

LOC-XPOS

NA

Not used in R/3

Latitude in GPS

LOC-YPOS

NA

Not used in R/3

Production calendar

LOC-PPCAL

NA

Not used in R/3

Delivery calendar

LOC-SDCAL

NA

Not used in R/3

Storage calendar

LOC-STCAL

NA

Not used in R/3

 

Location: Customer Description

APO field

R/3 field

CONVERSION

Language key

LOCT-SPRAS

KNA1-SPRAS

/

Internal location number

LOCT-LOCID

NA

Internal conversion for integration

Location type

LOCT-DESCR40

KNA1-NAME1

/

 

Location: Supplier

APO field

R/3 field

CONVERSION

Internal location number

LOC-LOCID

NA

Internal conversion for integration

Location type

LOC-LOCTYPE

/

1011

Supplier number

LOC-LOCNO

LFA1-LIFNR

Standard 1:1

It is possible for you to define your own mapping.

See Customer-Exits [External] .

Time zone

LOC-TZONE

LFA1-LAND1

LFA1-REGIO

Time zone calculated from country and region

 

Both fields can be viewed in the address screen

Longitude in GPS

LOC-XPOS

NA

Not used in R/3

Latitude in GPS

LOC-YPOS

NA

Not used in R/3

Production calendar

LOC-PPCAL

NA

Not used in R/3

Delivery calendar

LOC-SDCAL

NA

Not used in R/3

Storage calendar

LOC-STCAL

NA

Not used in R/3

Time zone

LOC-TZONE

LFA1-LAND1

LFA1-REGIO

Time zone calculated from country and region

 

Both fields can be viewed in the address screen

Longitude in GPS

LOC-XPOS

NA

Not used in R/3

Latitude in GPS

LOC-YPOS

NA

Not used in R/3

Production calendar

LOC-PPCAL

NA

Not used in R/3

Delivery calendar

LOC-SDCAL

NA

Not used in R/3

Storage calendar

LOC-STCAL

NA

Not used in R/3

 

Location: Supplier Description

APO field

R/3 field

CONVERSION

Language key

LOCT-SPRAS

LFA1-SPRAS

/

Internal location number

LOCT-LOCID

NA

Internal conversion for integration

Location type

LOCT-DESCR40

LFA1-NAME1

/

 

Location: Plant

APO field

R/3 field

CONVERSION

Internal location number

LOC-LOCID

NA

Internal conversion for integration

Location type

LOC-LOCTYPE

/

1001

Plant number

LOC-LOCNO

T001W-WERKS

Standard 1:1

It is possible for you to define your own mapping.

See Customer-Exits [External] .

Time zone

LOC-TZONE

T001W-LAND1

T001W-REGIO

Time zone calculated from country and region

 

Both fields can be viewed in the details screen

Longitude in GPS

LOC-XPOS

NA

Not used in R/3

Latitude in GPS

LOC-YPOS

NA

Not used in R/3

Production calendar

LOC-PPCAL

NA

Not used in R/3

Delivery calendar

LOC-SDCAL

NA

Not used in R/3

Storage calendar

LOC-STCAL

NA

Not used in R/3

 

Location: Plant Description

APO field

R/3 field

CONVERSION

Language key

LOCT-SPRAS

T001W-SPRAS

/

Internal location number

LOCT-LOCID

NA

Internal conversion for integration

Location type

LOCT-DESCR40

T001W-NAME1

/

 

Location: Mrparea

APO field

R/3 field

CONVERSION

Internal location number

LOC-LOCID

NA

Internal conversion for integration

Location type

LOC-LOCTYPE

CIF mapping

1007

Customer number

LOC-LOCNO

 

Standard 1:1

It is possible for you to define your own mapping.

See Customer-Exits [External] .

Time zone

LOC-TZONE

 

 

 

Time zone calculated from country and region

 

Both fields can be viewed in the details screen

Longitude in GPS

LOC-XPOS

NA

Not used in R/3

Latitude in GPS

LOC-YPOS

NA

Not used in R/3

Production calendar

LOC-PPCAL

NA

Not used in R/3

Delivery calendar

LOC-SDCAL

NA

Not used in R/3

Storage calendar

LOC-STCAL

NA

Not used in R/3

 

 

Location: Mrparea description

APO field

R/3 field

CONVERSION

Language key

LOCT-SPRAS

   

Internal location number

LOCT-LOCID

NA

Internal conversion for integration

Location type

LOCT-DESCR40

   

 

Location: Carrier

APO field

R/3 field

CONVERSION

Internal location number

LOC-LOCID

NA

Internal conversion for integration

Location type

LOC-LOCTYPE

CIF mapping

1020

Customer number

LOC-LOCNO

LFA1-LIFNR

Standard 1:1

It is possible for you to define your own mapping.

See Customer-Exits [External] .

Standard Carrier Access Code

LOC-TZONE

 

 

 

Time zone calculated from country and region

 

Both fields can be viewed in the address screen

Standard Carrier Access Code

LOC-SCACD

LFA1-SCACD

 

Longitude in GPS

LOC-XPOS

NA

Not used in R/3

Latitude in GPS

LOC-YPOS

NA

Not used in R/3

Production calendar

LOC-PPCAL

NA

Not used in R/3

Delivery calendar

LOC-SDCAL

NA

Not used in R/3

Storage calendar

LOC-STCAL

NA

Not used in R/3

 

Location: Carrier Description

APO field

R/3 field

CONVERSION

Language key

LOCT-SPRAS

   

Internal location number

LOCT-LOCID

NA

Internal conversion for integration

Location type

LOCT-DESCR40

   

 

Location: Transportation Zone

APO field

R/3 field

CONVERSION

Internal location number

LOC-LOCID

NA

Internal conversion for integration

Location type

LOC-LOCTYPE

CIF mapping

1005

Customer number

LOC-LOCNO

 

Standard country + ‘-’ + transport zone in table TZONE 1:1

It is possible for you to define your own mapping (however, this is not recommended in this case).

See Customer-Exits [External] .

Time zone

LOC-TZONE

 

 

 

Time zone calculated from country and region

 

Both fields can be viewed in the address screen

Longitude in GPS

LOC-XPOS

NA

Not used in R/3

Latitude in GPS

LOC-YPOS

NA

Not used in R/3

Production calendar

LOC-PPCAL

NA

Not used in R/3

Delivery calendar

LOC-SDCAL

NA

Not used in R/3

Storage calendar

LOC-STCAL

NA

Not used in R/3

 

Location: Transportation Zone Description

APO field

R/3 field

CONVERSION

Language key

LOCT-SPRAS

   

Internal location number

LOCT-LOCID

NA

Internal conversion for integration

Location type

LOCT-DESCR40