Extract Structures in LO Extraction:
For preparation of Sales data , we have to require shipping data,Billing data,Purchasing data
Sales:
Extract Structures
|
Description
|
Datasource
|
Table/Structures |
MC11VA0HDR
|
Sales Doc. Header Data
|
2LIS_11_VAHDR
|
MCVBAK
MCVBUK
|
MC11VA0ITM
|
Sales Doc. Item Data
|
2LIS_11_VAITM
|
MCVBAK
MCVBUK
MCVBAP
MCVBKD
MCVBUP
|
MC11VA0SCL
|
Sales Doc. Schedule Line Item Data
|
2LIS_11_VASCL
|
MCVBAK
MCVBUK
MCVBEP
MCVBAP
MCVBKD
MCVBUP
|
MC11V_0ITM
|
Sales Doc: Item Allocation
|
2LIS_11_V_ITM
|
MCVBAK
MCVBUK
MCVBAP
MCVBKD
MCVBUP
|
MC11V_0SCL
|
Sales Doc. Allocation Schedule Line Item
|
2LIS_11_V_SCL
|
MCVBAK
MCVBUK
MCVBEP
MCVBAP
MCVBKD
MCVBUP
|
Shipping:
| Extract Structures |
Description
|
Datasource
|
Table/Structures |
MC12VC0HDR
|
Shipping Doc. Header Data
|
2LIS_12_VCHDR
|
MCLIKP
MCVBUK
|
MC12VC0ITM
|
Shipping Doc. Item Data
|
2LIS_12_VCITM
|
MCLIKP
MCLIPS
MCVBUK
MCVBUP
|
MC12VC0SCL
|
Shipping Doc Schedule Line Delivery Item
Data
|
2LIS_12_VCSCL
|
MCLIKP
MCLIPS
MCVBEL
MCVBUK
MCVBUP
|
Billing:
| Extract Structures |
Description
|
Datasource
|
Table/Structures |
MC13VD0HDR
|
Billing Doc. Header Data
|
2LIS_13_VDHDR
|
MCVBRK
MCVBUK
|
MC13VD0ITM
|
Billing Doc. Item Data
|
2LIS_13_VDITM
|
MCVBRK
MCVBRP
MCVBUK
MCVBUP
|
Purchasing:
| Extract Structures |
Description
|
Datasource
|
Table/Structures |
MC02M_0HDR
|
Purchasing Header Data
|
2LIS_02_HDR
|
MCEKKO
MCEKPA
|
MC02M_0ITM
|
Purchasing Item Data
|
2LIS_02_ITM
|
MCEKKO
MCEKPA
MCEKPO
|
MC02M_0SCL
|
Purchasing Schedule Item Data
|
style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 110.7pt;" valign="top" width="148">
2LIS_02_SCL
|
MCEKKO
MCEKET
MCEKPO
|
0 comments:
Post a Comment