- SAP Managed Tags
Hello friends,
I'm quite new with creating queries in SAP and am having trouble with creating one. The problem that I'm experiencing is with users who split the delivery in two and create two separate transfer orders and two separate HU but after that they do not combine them manually.The query that I'm trying to create is about these split deliveries and their Handling units and trying to figure out a way to display the ones who were not combined manually.
There is a transaction that that displays this information but when the fields themselves are not fields in a table.
I've found that the transaction is made of tables LIKP,LEDSPD_FLOW and VEKP and found a way to connect LIKP and VEKP using table VEPO(by using the forum) but I'm not able to duplicate columns Traegertyp and Liefertyp.
This is the way the transaction displays the results and I'm trying to implement them in the query itself but it's quite diffucult because the last two fields are not in any table.
The fields are as follows:LIKP-ZZLVWERKS,LIKP-VSTEL,LIKP-KUNNR,LIKP-ZZLVWGRV,LEDSPD_FLOW-VBELN_NEW,LIKP-LFDAT,VEKP-NAMBE,VEKP-EXIDV,LIKP-VBELN,LIKP-ZZLVPALTYP,LIKP-LFART,VEKP-VEGR4,
VEKP-VEGR5 and the last three fields seem to not be fields from a table.
My question is if anyone knows any other table or a field in the forementioned tables that can diplay such information as the last two fields or if there is any table that can display deliveries that were split and afterwards their handling units were not combined?
Thanks in advance!
Hello friends,
I'm quite new with creating queries in SAP and am having trouble with creating one. The problem that I'm experiencing is with users who split the delivery in two and create two separate transfer orders and two separate HU but after that they do not combine them manually.The query that I'm trying to create is about these split deliveries and their Handling units and trying to figure out a way to display the ones who were not combined manually.
There is a transaction that that displays this information but when the fields themselves are not fields in a table.
I've found that the transaction is made of tables LIKP,LEDSPD_FLOW and VEKP and found a way to connect LIKP and VEKP using table VEPO(by using the forum) but I'm not able to duplicate columns Traegertyp and Liefertyp.
This is the way the transaction displays the results and I'm trying to implement them in the query itself but it's quite diffucult because the last two fields are not in any table.
The fields are as follows:LIKP-ZZLVWERKS,LIKP-VSTEL,LIKP-KUNNR,LIKP-ZZLVWGRV,LEDSPD_FLOW-VBELN_NEW,LIKP-LFDAT,VEKP-NAMBE,VEKP-EXIDV,LIKP-VBELN,LIKP-ZZLVPALTYP,LIKP-LFART,VEKP-VEGR4,
VEKP-VEGR5 and the last three fields seem to not be fields from a table.
My question is if anyone knows any other table or a field in the forementioned tables that can diplay such information as the last two fields or if there is any table that can display deliveries that were split and afterwards their handling units were not combined?
Thanks in advance!
Bluesky
- SAP Managed Tags
Do you know what a text table is?
Ex: Delivery Type (LIKP-LFART) belongs to a domain (LFART) which has a value table (TVLK) this table is associated to a text table (TVLKT) with values for installed languages in your system.
You should perform some search in SE11, and then convert codes values to text in logon language.
hint: You could also execute an Abap (SAT) or SQL (ST05) trace executinh the standard transaction to get a list of required tables.
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
