2006 Aug 28 4:29 PM
I need to get PO number to pass into one of the variable.
To achieve this (as per spec given)I need to do below:
<b>get record REGUP-BELNR (if document >= XXXXXXXXXX or <= XXXXXXXXXX) then invoice is associated to PO.
Store values REGUP-BUKRS, REGUP-BELNR, and REGUP-GJAHR, go to table BKPF and populate fields with stored values (BUKRS, BELNR, GJAHR). Store value BKPF-AWKEY (first 10 digits is BELNR and last 4 is GJAHR), go to table RSEG and populate fields with stored values (BELNR, GJAHR). Store value EBELN and populate IDOC record.</b>
<b>get record REGUP-BELNR (if document >= XXXXXXXXXX or <= XXXXXXXXXX) then invoice is associated to PO.</b>
I have seen in DB TABLES,for the above I have multiple records getting selected.
Based on the above selected REGUP-BUKRS, REGUP-BELNR, and REGUP-GJAHR, am selecting from BKPF table ....so here also again I have multpiple records.
After that RSEG also having multiple records.
How to get single PO out of the above specs ?PLEASE SUGGEST ME ...
I need to get PO number to pass into one of the variable.
To achieve this (as per spec given)I need to do below:
<b>get record REGUP-BELNR (if document >= XXXXXXXXXX or <= XXXXXXXXXX) then invoice is associated to PO.
Store values REGUP-BUKRS, REGUP-BELNR, and REGUP-GJAHR, go to table BKPF and populate fields with stored values (BUKRS, BELNR, GJAHR). Store value BKPF-AWKEY (first 10 digits is BELNR and last 4 is GJAHR), go to table RSEG and populate fields with stored values (BELNR, GJAHR). Store value EBELN and populate IDOC record.</b>
<b>get record REGUP-BELNR (if document >= XXXXXXXXXX or <= XXXXXXXXXX) then invoice is associated to PO.</b>
I have seen in DB TABLES,for the above I have multiple records getting selected.
Based on the above selected REGUP-BUKRS, REGUP-BELNR, and REGUP-GJAHR, am selecting from BKPF table ....so here also again I have multpiple records.
After that RSEG also having multiple records.
How to get single PO out of the above specs ?PLEASE SUGGEST ME ...
2006 Aug 28 4:32 PM
Hi Sam,
You can use <b>Sort</b> statement followed by <b>Delete adjacent duplicates</b> to get single PO.
Regards,
Raj
2006 Aug 28 4:34 PM
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |