Developing SAP Query for Task List Data Extraction
...Previous
Between
PLPO and CRHD, the default link is with field OBJTY. You need to delete this
link and create with PLPO-ARBID and CRHD-OBJID. For this click on ARBID in PLPO
table and drag the cursor towards OBJID in CRHD table. Afterwards it should like
After you
finish with above activities the screen will look like
Following
tables explain the link details between different tables used above:
|
Table
1
MAPL
|
Table2
PLKO
|
Table
3
MARA
|
|
PLNTY
|
PLNTY
|
|
|
PLNNR
|
PLNNR
|
|
|
PLNAL
|
PLNAL
|
|
|
MATNR
|
|
MATNR
|
|
PLKO
|
PLAS
|
|
|
PLNTY
|
PLNTY
|
|
|
PLNNR
|
PLNNR
|
|
|
PLNAL
|
PLNAL
|
|
|
PLAS
|
PLPO
|
|
|
PLNTY
|
PLNTY
|
|
|
PLNNR
|
PLNNR
|
|
|
PLNKN
|
PLNKN
|
|
|
PLPO
|
CRHD
|
|
|
ARBID
|
OBJID
|
|
|
CRHD
|
CRTX
|
|
|
OBJID
|
OBJID
|
|
|
MARA
|
MAKT
|
|
|
MATNR
|
MATNR
|
|
In the
following steps, mainly you need to select which fields you want to see in
selection screen and which one in output.
Click here to continue...
|