Datasources
- 2LIS_13_VDHDR
- 2LIS_13_VDITM
- 2LIS_13_VDKON
TCode
VF01 / VF02 / VF03
Base Tables
VF01 / VF02 / VF03
Base Tables
VBRK ( Billing Document: Header Data )
VBRP ( Billing Document: Item Data)
VBUK
VBUP
KOMV / KONV [ KOMV is only a strucutre ]
Bill Plan Header : FPLA
Bill Plan Item : FPLT
Bill Plan Header : FPLA
Bill Plan Item : FPLT
Set up tables
OLI9BW / RMCVNEUF
Can be run open with out any selection. Has Billing document on the selection screen
Related SAP Notes
SIS/BW: Statistics update for value items, quantities HERE
Creating Billing Document / Change to Bill Plan
Here you can create billing documents for a sales order ( I am doing this for bill plan related stuff )
Go to VF04 - Enter sales document and billing date.
check order type check box in the end.
it will display an entry
save it
this will create a billing document.
Base tables : SAP Link
FKIMG and ZFKIMG / OLIME / NETWR and ZZNETWR
My Notes* ( not sure if below is the right explanation )
In VBRP, we can see FKIMG populated irrespective of POSAR, but in 2LIS_13_VDITM, FKIMG does not get populated for Value Items. SAP Note 368011 will solve the issue.
Basically, for value item OLIME is the field which is populated. This field is not from any table, but a structure which gets populated internally ( not sure where ).
So if you implement Note - solution 2 values from OLIME or FKIMG are moved to ZFKIMG which can be used in BW.
Check code in below function module to see the assignment
Related SAP Notes
SIS/BW: Statistics update for value items, quantities HERE
Creating Billing Document / Change to Bill Plan
Here you can create billing documents for a sales order ( I am doing this for bill plan related stuff )
Go to VF04 - Enter sales document and billing date.
check order type check box in the end.
it will display an entry
save it
this will create a billing document.
2LIS_13_VDITM
Billing Item
FKIMG and ZFKIMG / OLIME / NETWR and ZZNETWR
My Notes* ( not sure if below is the right explanation )
In VBRP, we can see FKIMG populated irrespective of POSAR, but in 2LIS_13_VDITM, FKIMG does not get populated for Value Items. SAP Note 368011 will solve the issue.
Basically, for value item OLIME is the field which is populated. This field is not from any table, but a structure which gets populated internally ( not sure where ).
So if you implement Note - solution 2 values from OLIME or FKIMG are moved to ZFKIMG which can be used in BW.
Check code in below function module to see the assignment
EXIT_SAPLMCS6_002
ZXMCVU06
2LIS_13_VDKON
Base table : VBRK
VBRP
KONV ( In LBWE structure it is KOMV, but KOMV is only a structure)
This datasource works as Item change date as pointer. It will get all new/changed records at item level.
Only Active conditions are considered. KONV-KINAK should be blank.
If Note 1062462 is implemented, Inactive conditions can be extracted, but there are some other other side effects as mentioned in the note - Not sure how they would effect.
Personal experience : In the user exit for the extractor, I added code to add Inactive records to the standard extractor.
No comments:
Post a Comment