|
Functionality
This method is used for reading actual data for costing-basedProfitability Analysis.
For this, the data source (summarization levels, the object level orline items) is selected automatically depending on which source isexpected to deliver the desired data most quickly. Summarization levelsare not locked against entry when data is read from them (this meansthat, if the summarization levels are updated at the same time as datais being read, inconsistencies can occur when the data is returned).
If data is read from line items, then the current structure is alwaystaken.
All characteristic values have an internal representation (for enteringthe selection criterion as well as in the table ResultData)!
The module is not suitable for reading mass data! If the selection isnot sufficiently reduced, the process can terminate due to longruntimes. If you need to read large amounts of data, you should choosethe appropriate selection criteria so that several callups areimplemented to read data on a package basis.
It is important that you watch for messages in the Return parameter. Example
You wish to read the sales volume and the revenue for all products indivision "01" and for the period "001.1999" through "012.1999". Theactual data is posted to operating concern "S001" with record type "F"and currency type "B0" for costing-based Profitability Analysis.
For this, the import parameters should be defined as follows:
OperatingConcern: S001
CurrencyType: B0
MaxRecords: 500 (for example)
Table SelectedFields:
FIELDNAME
VRGAR
PERIO
SPART
ARTNR
ABSMG
ABSMG_ME
ERLOS
Table Selection:
FIELDNAME|SIGN|OPTION|LOW |HIGH
VRGAR |I |EQ |F |
PERIO |I |BT |1999001 |1999012
SPART |I |EQ |01 |
Note: All values must be entered using internal representation."1999001" is the internal representation for period "001.1999".
Table ResultData is then filled with the actual data for two products,for example, in the following way (if data were only found in theperiod "001.1999"):
Table ResultData:
RECORD_ID|FIELDNAME|VALUE |CURRENCY
000001 |VRGAR |F |
000001 |PERIO |1999001 |
000001 |SPART |01 |
000001 |ARTNR |A1 |
000001 |ABSMG |20 |
000001 |ABSMG_ME |KG |
000001 |ERLOS |1000 |DEM
000002 |VRGAR |F |
000002 |PERIO |1999001 |
000002 |SPART |01 |
000002 |ARTNR |A2 |
000002 |ABSMG |30 |
000002 |ABSMG_ME |ST |
000002 |ERLOS |2000 |DEM Description
This field selects the valuation approach (the combination of currencytype and valuation view). Value range
10 = Controlling area currency, legal valuation
B0 = Operating concern currency, legal valuation
12 = Controlling area currency, profit center valuation
B2 = Operating concern currency, profit center valuation
INCLUDE COPAQUERY_MAXRECORDS OBJECT DOKU ID TX
INCLUDE COPAQUERY_FIELDLIST OBJECT DOKU ID TX
INCLUDE COPAQUERY_SELECTION OBJECT DOKU ID TX |