Pamela - Based on what you stated, it sounds like you're going to look through the text values in T683T and retrieve based on a scan of a string. I would advise against that. I would suggest your program look for the condition types that correspond to the text and select on those (like "K013"). - Lou
| | | ---------------Original Message---------------
From: Pamela79 Pilch
Sent: Thursday, August 04, 2011 8:00 AM
Subject: Pricing description in a custom report
Hello,
We are developing a custom report. The report will fetch invoices from VBRK table for a a given date.
For the selected invoices, we need to pick pricing condition types as in invoices from table KONV ( VBRK-KNUMH=KONV-KNUMH ). In this way we have all the condition types for the invoices.... I have following questions :-
a) in the invoice pricing, I also need to have text elements and their values in our custom report. that is I need to fetch the word "gross price" and its value from line item pricing ( Both KWART and KWERT ).... I also need to have "profit margin" and its value ( both condition base and cond value ),
I also need to have any other description I have in invoice pricing and its value like "rebate basis" and its value etc...
What logic should I use to fetch the above description and their values ( both base value and final value as appearing in pricing screen of invoice line items ! )
b) KONV shows item wise records. Pricing is also stored at header level in invoices... which condition table is used to store header condition and the values ?
regards
Pamela |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  _.____.__ |
