Question:
hi,
I have created an ODS for Order,Delivery and Billing.
For the documents which are cancelled in Order and Delivery only one record is generated therefore the record has value 'R' in 0STORNO (reversal Indicator).So, we can identify which are the documents that has been cancelled.
But in case of Billing when the document is cancelled ,three records are created at the item level:
1) The original document with value 'X' in 0STORNO (reversal Indicator)
2) The original document with value ' ' in 0STORNO (reversal Indicator)
3) New document with value ' ' in 0STORNO (reversal Indicator)
and one record is created at header level:
1) New document with value ' ' in 0STORNO (reversal Indicator)
I want to know if anybody has created a billing ODS and was able to identify cancelled documents. If yes,how ?
thanks in advance.
regards,
Anuj
Answer:
Hi there,
In R/3 in table VBRK there is a field FKSTO which shows if a billing document is cancelled or not.
This field is not 'standard' available in the Billing header LO extractor but you can simply add it in the LO cockpit via structure maintenance (add field MCVBRK-FKSTO to structure MC13VD0HDR). And also map it in BW to a new infoobject which you add to your ODS and then you don't have to look to your recordmode.
Good luck
Answer:
Thanks a lot .
Anuj