General presentation
Objective of the application
The infoprovider has all the data related to the Billing items.
Tool Leader + IT leader of the application: Craig Wanamaker
Usage information
Users use this information Worldwide where the Billing items are used in the queries
History
The Condition record number(CONDREC) from KONV , Reference Document number (XBLNR) from VBRK table and Preferential flag(PREFE) from VBRP is extracted to the C_BILLITM through Datasources :
- ZZ_VBRK_KONV for WP1 data flows
- ZZ_VBRKP_KONV for PF1 data flows
These Datasources are enhanced from May 2023, to also include below information from KONV table :
- KHERK (Condit.origin) -> C_BILLITM__C_KNORIG
- KOAID (Condition class) -> C_BILLITM__C_KNCLASS
- KMPRS (Changed manual) -> C_BILLITM__C_KMPRS
Datasource ZZ_VBRK_KONV for WP1 is also enhanced with specific text from KONP table :
- SMARTPJ (Price Justification) -> C_BILLITM__C_SMARTPJ
Dataflow overview
The characteristics C_CONDREC, C_PREFE1 and C_XBLNR are added to the ADPSDSO47 (Billing and Conditions DSO).
The new characteristic C_SMARTPJ is added to the ADPSDSO47, and mappings are updated as below.
From PF1 :
From WP1 :
The ADPSDSO47 is then populating Master Data C_BILLITM as below.
Functional and Technical rules on Workbench + Reporting
Rules & Explanations
The Queries which were changed are
BW_QRY_MVSDSO45_SD0005 - The condition record number C_BILLITM__C_CONDREC is added as a characteristic
BW_QRY_MVSDSO45_SD0001.- The reference Document number C_BILLITM__C_XBLNR is added as a characteritstic
BW_QRY_MVSDSO53_0001 - The preferential flag C_BILLITM_C_PREFE1 is added as a characteristic.
Dependencies with other applications
NA
Data loadings
Info providers and objects loaded
PC_GL_SALES_C_BILLITM
Loading frequency
Daily
Average performance
| Key Figure | Estimation |
|---|---|
| ~ Average Process Chain Runtime | |
| ~ Average nb of rows loaded per load | |
| ~ Total nb of rows loaded (if full) | |
| ~ Average Runtime for 10k lines |