L&W - Field Mapping (2006-03-30) 3.0
L&W - Field Mapping (2006-03-30) 3.0
L&W - Field Mapping (2006-03-30) 3.0
Green Yellow Red Total Green+Yellow Green: Field accessible within Standard Business
SD 18 5 10 33 Content
54.5% 15.2% 30.3% Yellow: Field can be retrieved with minor modifications
SD Detail 40 26 25 91 to standard extractors.
44.0% 28.6% 27.5% 72.5% Red: Field cannot be derived from standard
Inventory Management 1 3 1 5 extractors without custom user exits(ABAP/4).
20.0% 60.0% 20.0%
Inventory Management Detail 1 12 12 25
4.0% 48.0% 48.0% 52.0%
Project / Networks N/A N/A N/A N/A
57551284.xls 1 05/05/2011
SD
Subject Area SD
Source System SAP R/3
Target System SAP-BW
57551284.xls 2 05/05/2011
SD
57551284.xls 3 05/05/2011
SD
57551284.xls 4 05/05/2011
SD
2LIS_11_V_ITM
0STORNO
0REJECTN_ST
0COMP_CODE
0BILL_BLOCK
0SOLD_TO
0CUST_GRP1
0CUST_GRP2
0CUST_GRP3
0CUST_GRP4
0CUST_GRP5
0DEL_BLOCK
0STAT_CURR
0SALES_OFF
0SALESORG
0DISTR_CHAN
0REASON_REJ
0BATCH
0EANUPC
0CREATEDON
0BILBLK_ITM
0MAT_ENTRD
0MATL_GRP_1
0MATL_GRP_2
0MATL_GRP_3
0MATL_GRP_4
0MATL_GRP_5
0BILLTOPRTY
0PAYER
0SHIP_TO
0PROD_HIER
0FORWAGENT
0SALESEMPLY
0ROUTE
0DB_CRD_IND
0STAT_DATE
0EXCHG_STAT
0DENOMINTR
0NUMERATOR
0VOLUMEUNIT
0SHIP_POINT
0DOC_CURRCY
57551284.xls 5 05/05/2011
SD
2LIS_12_VCHDR
0STORNO
0UNLOAD_PT
0COMP_CODE
0SALES_DIST
0BILL_BLOCK
0UNIT_OF_WT
0INCOTERMS
0INCOTERMS2
0CUST_GROUP
0SOLD_TO
0SHIP_TO
0DEL_TYPE
0SHIP_DATE
0DEL_BLOCK
0LOAD_PT
0NET_WGT_DL
0BILLTOPRTY
0PAYER
0FORWAGENT
0SALESEMPLY
0ROUTE
0DOC_CATEG
0SALESORG
0VOLUMEUNIT
0VOLUME_DL
57551284.xls 6 05/05/2011
SD
2LIS_12_VCITM
0STORNO
0PICK_CONF
0STS_PICK
0GOODSMV_ST
0UNLOAD_PT
0COMP_CODE
0SALES_DIST
0BILL_BLOCK
0INCOTERMS
0INCOTERMS2
0CUST_GROUP
0SOLD_TO
0SHIP_TO
0DEL_TYPE
0SHIP_DATE
0DEL_BLOCK
0LOAD_PT
0ROUTE
0SALESORG
0SHIP_POINT
0GI_DATE
0ACT_GI_DTE
0CH_ON
0RT_PROMO
0GRS_WGT_DL
0PROCESSKEY
0BATCH
0EANUPC
0CREATEDON
0CREATEDBY
0BILBLK_DL
0UNIT_OF_WT
0BUS_AREA
0PICK_INDC
0CUST_GRP1
0CUST_GRP2
0CUST_GRP3
0CUST_GRP4
0CUST_GRP5
0CONSU_FLAG
0DLV_QTY
0ACT_DL_QTY
57551284.xls 7 05/05/2011
SD
2LIS_13_VDHDR
0STORNO
0COMP_CODE
0SALES_DIST
0CREATEDON
57551284.xls 8 05/05/2011
SD
2LIS_13_VDITM
0STORNO
0CH_ON
0COMP_CODE
0SALES_DIST
0BILL_TYPE
0BILL_DATE
0BILL_CAT
0CUST_GROUP
0SOLD_TO
0PAYER
0EXRATE_ACC
0STAT_CURR
0DOC_CURRCY
0RT_PROMO
0DOC_NUMBER
0S_ORD_ITEM
0REBATE_BAS
0REBATE_GRP
0GRS_WGT_DL
0BATCH
0EANUPC
0CREATEDON
0SERV_DATE
0INV_QTY
0BILL_QTY
0UNIT_OF_WT
0SALESDEAL
0EXCHG_RATE
0TRANS_DATE
0CUST_GRP1
0CUST_GRP2
0CUST_GRP3
0CUST_GRP4
0CUST_GRP5
0STOR_LOC
57551284.xls 9 05/05/2011
SD
57551284.xls 10 05/05/2011
SD
57551284.xls 11 05/05/2011
SD
Customer group 5
Delivery block
Sales Employee
Statist. curr.
SD Document Category
Delivery date
Sales Office
Sales group
Sales Organization
Distribution Channel
Document currency
Division
SD docCat. refDocu.
Orders
Fiscal Year Variant
Update Mode
57551284.xls 12 05/05/2011
SD
Rejection status
Item
Item
Item bill.data
Pricing
Item deliv.data
Quotation from
Sales doc. type
Reason for order
Valid to
Company code
Billing block
Local currency
Sold-to party
Exchange rate type
Customer group 1
Customer group 2
Customer group 3
Customer group 4
Customer group 5
Delivery block
Statist. curr.
SD Document Category
Sales Office
Sales group
Sales Organization
Distribution Channel
Reason for rejection
Changed on
Order probability
Gross weight
Application comp.
BW: Transaction Key
Batch
Exchange rate
EAN/UPC
Created on
Created by
Time
Billing block
Weight unit
CumConfirmedQty
CumConfirmedQty
Condition unit
Sales Deal
Order quantity
Subtotal 1
Subtotal 2
Subtotal 3
Subtotal 4
Subtotal 5
Subtotal 6
Delivery quantity
Storage location
Target delivery qty
Material group
57551284.xls 13 05/05/2011
SD
Material Entered
Base Unit
MaterialGroup 1
MaterialGroup 2
MaterialGroup 3
MaterialGroup 4
MaterialGroup 5
Net price
Net value
Net weight
UnloadPt ShiptoParty
Bill-to party
Payer
Ship-To Party
Prod.hierarchy
Forw.Agent
Item category
Sales Employee
Route
Delivery from Whse
Division
Statistics date
Exch.rate stats
Ind. Deliv.Tolerance
Tol. Limit for OD %
Denominator(divisor)
Numerator for
Denominator
Numerator
Tol. Limit for UD %
UpdateDateStatistics
Prec.doc.categ.
Volume unit
Volume of order item
Sales unit
Shipping point
Document currency
Cost
Plant
Target qty UoM
Target quantity
Target value
Sales District
Serv.rendered on
Billing doc. date
Incoterms
Incoterms 2
Customer group
AcctAssgGr
Exchange rate
Conversion Date
Pricing date
Promotion
Catalog
PurchOrderCurrency
Division
57551284.xls 14 05/05/2011
SD
SD docCat. refDocu.
WBS Element
Order Items
Fiscal Year Variant
Price Unit
MMat-ReasonforSubst.
Material
Tax Amount
Update Mode
Reference document
Reference item
Planning in SAP APO
Source System
57551284.xls 15 05/05/2011
SD
Sales District
Incoterms
Incoterms 2
Customer group
Exchange rate
Conversion Date
Promotion
Delivery quantity
Fiscal Year Variant
Sales unit
Sales document
Item
Local currency
SD Document Category
Sales group
Material group
Material
Base Unit
Open orders qty
Open orders
Division
Plant
Division
WBS Element
No. Open Order Items
Delivered Value
Net Price per 1*VKME
Exchange rate type
Update Mode
57551284.xls 16 05/05/2011
SD
Shipping point
Act.goods issue date
Number of deliveries
Fiscal Year Variant
Gross W, dels.
Goods issue
Vendor
Number of Packages
Delay Goods Issue
Delivery
Created on
Update Mode
57551284.xls 17 05/05/2011
SD
Warehouse number
Storage location
Storage bin
Storage type
Material Entered
MaterialGroup 1
MaterialGroup 2
MaterialGroup 3
MaterialGroup 4
MaterialGroup 5
Net weight
Bill-to party
Payer
Item type
Prod.hierarchy
Forw.Agent
Sales Employee
Statistics date
Denominator(divisor)
Numerator for
Reference document
Reference item
SD Document Category
Sales Office
Volume unit
Volume delivered
Distribution Channel
Number of deliveries
Fiscal Year Variant
Delay Goods Issue
Plant
Sales unit
Base Unit
Delivery
Vendor
Application comp.
Time
Material group
Material
Item category
Ship.Proc.Time Fixed
Ship.Proc.Time Var.
Sales group
Division
WBS Element
Item
Prec.doc.categ.
UpdateDateStatistics
Update Mode
Source System
57551284.xls 18 05/05/2011
SD
Billing type
Billing doc. date
Billing category
Customer group
Sold-to party
Payer
Exch.rate-acct.
Sales Employee
Statist. curr.
Document currency
No.of billing docs
Fiscal Year Variant
Sales document
Local currency
SD Document Category
Sales Organization
Distribution Channel
Exchange rate type
Update Mode
57551284.xls 19 05/05/2011
SD
Requirement quantity
Material Entered
MaterialGroup 1
MaterialGroup 2
MaterialGroup 3
MaterialGroup 4
MaterialGroup 5
Tax amount
Net weight
Bill-to party
Ship-To Party
Item type
Prod.hierarchy
Commission grp
Pricing date
Item category
Sales Employee
Discount base
Scale quantity
Statistics date
Denominator(divisor)
Numerator for
UpdateDateStatistics
Reference document
Reference item
Sales Office
Volume unit
Volume delivered
Shipping point
Cost
No. of billing items
Fiscal Year Variant
Plant
Sales unit
Base Unit
Local currency
Exchange rate type
SD Document Category
Sales Organization
Distribution Channel
Controlling area
Cost Center
Subtotal 1
Subtotal 2
Subtotal 3
Subtotal 4
Subtotal 5
Subtotal 6
Material group
Material
Division
Division
Sales group
WBS Element
Net value
Exch.rate stats
57551284.xls 20 05/05/2011
SD
Billing document
Item
Application comp.
BW: Transaction Key
Gross Value
Update Mode
Billing Rule
Exact Exchange Rate
57551284.xls 21 05/05/2011
SD Detail
Source Target
DataSource InfoSource
Description Technical Name Effort Comments Table Field Description Name InfoObject
GOF Contact Name Master Data Attr. 0CUSTOMER_ATTR 0NAME
Ship Via LIKP-BOLNR Standad Business Content LIKP BOLNR Carrier Tracking Number 2LIS_12_VCHDR 0FORWAGENT
tracking number LIKP-BOLNR Standad Business Content LIKP BOLNR Carrier Tracking Number 2LIS_12_VCHDR 0FORWAGENT
CC_SHORTNAME
CG
CDT Contact Email Master Data Attr.
GOF Contact Phone Master Data Attr. 0PHONE_ATTR 0PHONE
container no# VEKP-EXIDV VEKP EXIDV Container Id
dimensions
Container Pro
Weight per container
Country Master Data Attr. 0COUNTRY
CROJ Customer Requested On Job DERIVED Customer need PS network and activity
(Item) Requested On tables, calculated by the report -
Job (Item) AFVV-FSEDD depends on the
value of AFKO-USER03 = D010
57551284.xls 22 05/05/2011
SD Detail
Source Target
DataSource InfoSource
Description Technical Name Effort Comments Table Field Description Name InfoObject
MCR Ind
network AUFK-AUFNR Standad Business Content AUFK AUFNR Network Order 0PS_DAT_NAE 0NETWORK
item level AUFK-KDPOS Standad Business Content AUFK KDPOS Sales Order Item 2LIS_11_VAITM 0DOC_NUMBER
SALES_ORDER_LINE_NO VBAK-VBELN Standad Business Content VBAK / VBUK VBELN Sales document 2LIS_11_VAHDR 0DOC_NUMBER
LUCENT_ITEM_NUMBER VBAK-VBELN Standad Business Content VBAK / VBUK VBELN Sales document 2LIS_11_VAHDR 0DOC_NUMBER
Order Level HRC VBAK-VBELN Standad Business Content VBAK / VBUK VBELN Sales document 2LIS_11_VAHDR 0DOC_NUMBER
Qty VBAP-KWMENG Standard Business Content VBAP/VBKD/ VBUP
KWMENG Order quantity 2LIS_11_VAITM 0CML_OR_QTY
SHIPPED_QTY VBAP-KWMENG Standard Business Content VBAP/VBKD/ VBUP
KWMENG Order quantity 2LIS_11_VAITM 0CML_OR_QTY
ordered qty VBAP-KWMENG Standard Business Content VBAP/VBKD/ VBUP
KWMENG Order quantity 2LIS_11_VAITM 0CML_OR_QTY
quantities VBAP-KWMENG Standard Business Content VBAP/VBKD/ VBUP
KWMENG Order quantity 2LIS_11_VAITM 0CML_OR_QTY
Quantity Shipped VBAP-KWMENG Standard Business Content VBAP/VBKD/ VBUP
KWMENG Order quantity 2LIS_11_VAITM 0CML_OR_QTY
Removal Req #
Percent Complete in LSC
LAST_STATUS
performed by
PM Name
PO EKKO-EBELN Standard Business Content EKKO EBELN Purchasing Doc. 2LIS_02_HDR 0DOC_NUM
RECEIVED_QTY
Type
Project Master Data Attr. PS_POSID WBS element 0PS_DAT_NAE 0PROJECT
REGION Master Data Attr. 0REGION
SDS code
show nodes of shipment thru delivered EKKO-LGORT Standard Business Content EKKO LGORT Stor. Location 2LIS_02_ITM 0STOR_LOC
Shipment ID VTTP-TKNUM VTTP TKNUM Shipment Number
replenishment/outbound delivery number
OrderedReceived at LSC
Percent Shipped from LSC
TTL Shippable Lines
weight
STO
Supplier Code EKKO-LIFNR Standard Business Content EKKO LIFNR Vendor 2LIS_02_HDR 0VENDOR
Technology
current date Standad Business Content
Carrier
Consignee
Dest Country
Origin Country
MAWB/MBLHAWB/HBLPO/Cust Ref
Customs Release
Pre Docs Dt
Export Dt
File Open Dt
Pickup Date
Arrival Dt
Transmit to Customs Dt
Entry Number
Lucent SO
Dest Station
40 44.0%
26 28.6%
25 27.5%
91
57551284.xls 23 05/05/2011
SD Detail
Description
Name 1
Name 1
Forw.Agent
Forw.Agent
Country
need PS network and activity tables, calculated by
the report - AFVV-FSEDD depends on the value of
AFKO-USER03 = D010
Location
Postal Code
Region (State,Province,County)
Region (State,Province,County)
Sold-to party
Customer grp 5
Name1
Stor. Location
Stor. Location
Stor. Location
Stor. Location
WBS element
Material Number
57551284.xls 24 05/05/2011
SD Detail
Description
Network Order
Sales Order Item
Sales document
Sales document
Sales document
Order quantity
Order quantity
Order quantity
Order quantity
Order quantity
Purchasing Doc.
WBS element
Region (State,Province,County)
Stor. Location
Shipment Number
Vendor
57551284.xls 25 05/05/2011
Inventory Management
Subject Area IM
Source System SAP R/3
Target System SAP-BW
Material Stocks/Movements
This InfoCube allows you to evaluate stocks from ERP.
57551284.xls 26 05/05/2011
Inventory Management
2LIS_03_UM Revaluations
0STORNO Reversal indicator
0RT_PROMO Promotion
0VAL_CLASS Valuation class
0DOC_DATE Document Date
0COMP_CODE Company code
0BWAPPLNM Application comp.
0MOVETYPE Movement Type
0CPPVLC BW: Purchase Value
0CPQUABU BW: Amount in BUnitM
0PROCESSKEY BW: Transaction Key
0FISCYEAR Fiscal year
0BUS_AREA Business area
0SOLD_TO Sold-to party
0DCINDIC Debit/Credit
0FISCVARNT Fiscal Year Variant
0CPNOITEMS BW: Number
0LOC_CURRCY Local currency
0BASE_UOM Base Unit
0COSTCENTER Cost Center
0CO_AREA Controlling area
0DOC_NUM BW: Document Number
57551284.xls 27 05/05/2011
Inventory Management
0
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
57551284.xls 28 05/05/2011
Inventory Management Detail
Source Target
DataSource InfoSource
Description Technical Name Effort Comments Table Field Description Name InfoObject Description
Container Dimensions
Container type MSEG-LOGTYP MSEG LOGTYP Storage Type 2LIS_03_BF 0STRGE_TYPE Storage Type
Cost Center MSEG-KOSTL Standard Business Content MSEG KOSTL Cost Center 2LIS_03_BF 0COSTCENTER Cost Center
Actual LSC Date
Promise to Deliver Date
Scheduled Final LSC Date
Hazardous indicator
Item number MSEG-KDPOS MSEG KDPOS Item Number in Sales Order 2LIS_03_BF 0S_ORD_ITEM Sales Order Item Number
Shippable/non-shippable Ind
# pieces
Material changed and unavailable for use
Line item status text
Total pieces
Item quantity
Field with calculated value: number of hours
from carrier delivery till warehouse receipt
Export Dt
File Open Dt
Pickup Date
Arrival Dt
Pre Docs Dt
Transmit to Customs Dt
Lucent SO MSEG-KDAUF MSEG KDAUF Sales Order Number 2LIS_03_BF 0SALES_ORD Sales Order
Dest Station
Broker Location
Brkr Ref
1 4.0%
12 48.0%
12 48.0%
25
57551284.xls 29 05/05/2011
Inventory Management Detail
Source Target
DataSource InfoSource
Description Technical Name Effort Comments Table Field Description Name InfoObject Description
#DIV/0!
#DIV/0!
#DIV/0!
57551284.xls 30 05/05/2011
Projects & Networks
Subject Area PS
Source System SAP R/3
Target System SAP-BW
57551284.xls 31 05/05/2011
Projects & Networks
0PS_DAT_WBS
0CALDAY
0CH_ON
0CREATEDON
0DATE_EVENT
0DATE_KYF
0DATE_SRCE
0DATE_ZONE
0DURATION
0DUR_UNIT
0PROJECT
0TIME_KYF
0VTYPE
0WBS_ELEMT
0PSGUID
0PS_DAT_NTW
0CALDAY
0CH_ON
0CREATEDON
0DATE_EVENT
0DATE_KYF
0DATE_SRCE
0DATE_ZONE
0DURATION
0DUR_UNIT
0NETWORK
0PROJECT
0TIME_KYF
0VTYPE
0WBS_ELEMT
0PSGUID
0PS_DAT_NAE
0ACTIVITY
57551284.xls 32 05/05/2011
Projects & Networks
0CO_OM_OPA_6
0AMOUNT
0AMOUNTFX
0AMOUNTVR
0AUXACCTYPE
0AUXACCVAL
0BUS_AREA
0CHRT_ACCTS
0CO_AREA
0CO_DOC_NO
0CO_ITEM_NO
0CO_ITEM_TX
0COMP_CODE
0COORDER
0COSTELMNT
0CREDITOR
0CURRENCY
0CURTYPE
0DB_CR_IND
0DEBITOR
0DOC_DATE
0EMPLOYEE
0FISCPER
0FISCVARNT
0FM_AREA
0FUNC_AREA
0FUND
0GL_ACCOUNT
0GRANT_NBR
0MATERIAL
0METYPE
0NOTIFICATN
0PART_ABCPR
57551284.xls 33 05/05/2011
Projects & Networks
57551284.xls 34 05/05/2011
Projects & Networks
Project Deadlines
Changed on
Created on
Event
Date
Origin
Time zone
Duration
Duration unit
Project Definition
Time
Value type
Calendar Day
GUID of PS Object
Milestone Date
Network Activity
Calendar Day
57551284.xls 35 05/05/2011
Projects & Networks
Changed on
Created on
Event
Date
Origin
Time zone
Duration
Duration unit
Milestone
Network
Project Definition
Time
Value type
WBS Element
Reporting Time
GUID of PS Object
Network Dates
Calendar Day
Changed on
Created on
Event
Date
Origin
Time zone
Duration
Duration unit
Network
Project Definition
Time
Value type
WBS Element
GUID of PS Object
Network-Activity-Element Dates
Network Activity
57551284.xls 36 05/05/2011
Projects & Networks
Activity Element
Float
Unit buffer
Calendar Day
Changed on
Created on
Event
Date
Origin
Time zone
Duration
Duration unit
Network
Project Definition
Time
Value type
WBS Element
GUID of PS Object
57551284.xls 37 05/05/2011
Projects & Networks
Partner Activity
Partner Cost Center
Partner Order
Partner WBS Element
Partner company code
Partner FArea
Partner Fund
Partner Grant
Partner Object Type
Partner object
Plant
Posting date
Quantity
Fixed quantity
Variable quantity
Update Mode
Unit of measure
Valuation view
Version
Detail for valueT
Statistics ID
Value type
57551284.xls 38 05/05/2011
Projects & Networks Detail
Source Target
DataSource
Description Technical Name Effort Comments Table Field Description
ELEMENT_1_2 PRPS-POSID Standard Business Content PRPS POSID WBS element
network AUFK-AUFNR Standard Business Content AUFK AUFNR Network Order
Project PROJ-PSPID Standard Business Content PROJ PSPID Project
3 100.0%
0 0.0%
0 0.0%
3
57551284.xls 39 05/05/2011
Projects & Networks Detail
Source Target
DataSource
Description Technical Name Effort Comments Table Field Description
57551284.xls 40 05/05/2011
Projects & Networks Detail
InfoSource
Name InfoObject Description
0PS_DAT_NAE 0WBS_ELEMT WBS element
0PS_DAT_NAE 0NETWORK Network Order
0PS_DAT_NAE 0PROJECT Project
57551284.xls 41 05/05/2011
Projects & Networks Detail
InfoSource
Name InfoObject Description
57551284.xls 42 05/05/2011
Sales Delivery Purchasing
0SD_C01 Customer 0SD_C02 Deliveries 0PUR_C01 Purchasing Data
0DISTR_CHAN Distribution Channel 0FORWAGENT Forw.Agent 0COUNTRY Country key
0DIVISION Division 0RECIPCNTRY Destination country 0MATERIAL Material