0RECORDMODE, 0STORNO, ROCANCEL

[Former Member]

The transfer rules that I am workig with have the 0STORNO mapped to ECC field ROCANCEL. Would this have to be mapped to 0RECORDMODE?

[Former Member · Accepted solution]

oss 399739 - Questions and answers on InfoObject 0RECORDMODE

oss 333492 was created to ensure upward compatibility for those customers already using 0STORNO.

If it is a new ODS, you can use 0recordmode. If it is an existing ODS already using 0STORNO, you will need to add 0recordmode also and map both.

cheers

Sunil

[edwin_harpino]

hi,

depend on your datasource ...

hi,

Note 399739 - Questions and answers on InfoObject 0RECORDMODE

...

2. Note 333492 was created to ensure upward compatibility for those customers already using 0STORNO. This works as planned and is correct; field ROCANCEL must then be mapped to <b>both InfoObjects</b>.

....

Note 581778 - ODS capability of extractors from Inventory Management

...

2. Change the transfer rules

With the transfer rules, do not assign the "ROCANCEL" DataSource field to the "0RECORDMODE" InfoObject in the InfoSource. As a result, only records with "0RECORDMODE" = ' ' are transferred to the ODS. For the ODS, the after images whose characteristics or key figures that are set to overwrite, are not deleted.

...

hope this helps.

[Former Member]

Hi,

0Recordmode is not a field which retrive data from data source, its a field used in ODS for Delta update . 0Record mode only decide how the data is transfered through ODS to data target, this you can find out detail information through Changelog table in ODS. In change log table there is field 0record mode from there u can find 7 default values found, based on the values only data will be transfered during delta update. this field is fully realted to BW value.

For clear info

Orecordmode is the field added by the system, if the ds if delta capable.

In ODS it is added ate the time of creation of the ODS.

First: the recrodmode controls how data is posted into cubes or ODS (DSO) Objects.

N for new records

B for Pre Imgages

' ' for after images

R for Reverse Images

X for Storno

D for Deletion of a Key (only in ODS possible)

Y-Update image

What extractor delivers what different types pof values can be seen via to tables:

ROOSOURCE in the source R/3 System.

There point out the delta mechanism. With this value, check within Table RODELTAM. There you see the different POSSIBLE Values for ROCANCEL delivered by a DataSource.

The relevant objekt for the controlling of the mode in BW is the InfoObject 0RECORDMODE. Each ODS (DSO) has this Object. For Logistic-Extractors (except MaterialManagement) 0RECORDMODE should be mapped with ROCANCEL.

0STORNO generally is an InfoObject for Reports. E.G. Material movements. Stornos are posted in R/3 with particular so called movement types. Each movement typer contains an information if it is of type "Storno". If this is so, the field storno contains an X.

If you now map the storno field onto 0RECORDMODE, the record is interpreted as a storno record an will be wied blank ini the DataTarget.

If you have monotone increasing document numbers (like in CO-PA, CO-OM, MM-INV ...) 0RECORDMODE should be left blank. 0STORNO can be used for Reporting then and be filled differently.

If you can have changes to an already existing document number (like in sales orders or purchase orders) i'd strongly recommend to map 0RECORDMODE onto the delivered ROCALNCEL field.

http://help.sap.com/saphelp_nw04/helpdata/en/bf/37533b1a1df56ae10000000a114084/frameset.htm

Message was edited by:

Kalpana M