Workbook
Tech name: BW_WBK_CPSDAE01_SD001
Description: Quote report
Query
Tech name: BW_QRY_CPSDAE01_0001
Description: BW - Quote report (Core Query)
Authorization role
ZR_RCS_CA_M49
1) Added the characteristics Price group (0PRICE_GRP) and Document Date (Quotation) (0DOC_DATE) into existent DSOs DPSDSO42 (Propagation layer – Sales Document Item Data (Rhodia)) and DBSDSO51 (Business layer - SO Global: Sales Document Item Data (Rhodia)).
The source are, respectivelly, the fields KONDA and AUDAT.
By the business ADSO, ABDSAE01R, are possible to filter only sales category B (Quote) and to threat the Unit Price by lookup in the condition table and to establish the Net value in USD based on the document date tax.
2) Combined data from VBPA (Partner table and KONV structure to generate a new datasource and ADSO in the acquisition layer based on fields.
The main purposes of this step is get the conditions price ZPRE and PR00 to be part of the formula of Unit price.
This DSO does part of cross check process to ensure the key figure to be filled according to the delta process.
3) Combined data from VBPA (Partner table) and ADRC (Address) to get real description from “One Time Customers”.
3) Reuse the dataflow for Doc number to get the quote status in the GBSTK field from VBUK. Create a new infoobject C_GBSTK
The link bellow allows to check the metadata repository from development system:
Quote quantity
BW infoobject CML_OR_QTY (confirmation order) coming from DSO DBSDSO51 based on VBAP-KWMENG.
In the query is also available using unit conversion QCT_MATNR4 (Quantity conversion based on material) according to the prompt choose, the key figure is hide but can be shown.
NET Value Item
BW infoobject 0NET_VALUE coming from DSO DBSDSO51 based on VBAP-NETWR.
In the query is also available using currency conversion CTK_OBAS7 (OBAS- Prompt transfers value (type M) according to the prompt choose.
NET Value Item (USD)
BW infoobject 0NET_VALUE coming from DSO DBSDSO51 based on VBAP-NETWR, but with the conversion by function module CONVERT_TO_LOCAL_CURRENCY passing local currency ‘USD’, type of rate ‘M’ and the document date.
Unit price
The Price/UoM for ZPRE OR PR00 (KONV-KSCHL) price should check
if the KONV-KMEIN (currency) = VBAP-VRKME (currency sales unit):
Case KONV-WAERS (currency) equal ‘USD4/EUR4/GBP4’:
Divide KONV-KBETR (amount) by 100
fetch the KONV-KBETR (amount),
Else.
KONV-KWERT (tot amount) divide by VBAP-KWMENG (quantity).
Price per unit of measure
Where VBAK-KNUMV (Doc condition) = KONV-KNUMV
and VBAP-POSNR (item) = KONV-KPOSN
and VBAP-PSTYV (Ctg.) = ZKIT
and KONV-KSCHL (type) = ZPRE OR PR00
KONV- KBETR (amount) / KONV- KPEIN (unit price).
