Using format2.file

Use the format2[ ].file.* selectable on business object files to precisely identify locations where files are synchronized, obsolete, or none. The format2.file.synchronized selectable is used to identify the locations where the files are synchronized and the format2.file.status selectable is used to display the status of the file as either: synchronized, obsolete, or none.

Additionally, the subfield needsynchronization can be used to identify files needing synchronization from one store/location to another store/location. This selectable returns either True or False. Items in [FROM_STORE/LOCATION_NAME to_STORE/LOCATION_NAME] must be valid for the file store and separated by a space inside the square brackets. 

print businessobject BO_NAME select
format2.file.needsynchronization [FROM_STORE/LOCATION_NAME
TO_STORE/LOCATION_NAME];

For example: 

Print bus TNR select format2.file.needsynchronization[loc1 loc2]
Format2[f].file[test1.txt].needsynchronization[loc1 loc2]= FALSE
Format2[f1].file[test3.txt]. needsynchronization[loc1 loc2] = TRUE

The needsynchronization selectable can be used with the format.file.store selectable: 

temp query bus TYPE NAME REV
format.file.store=='Mystore'&&format2.file.needsynchronization[Mystore]==TRUE

Although the needsynchronization selectable is easily used in where clauses, the most efficient way to return a list of business objects that need to be synchronized is through the sync store validate command. You can use the validate keyword with the sync store command or sync businessobject to return a list of business objects that need synchronization from the source store/location to the destination store/location specified in the command. Validate may be followed by the optional keyword size and will allow for the alternative dump character. The locations belonging to the store should not have the same name. 

sync store STORE_NAME [from [store][location
LOCATION_SOURCE{,LOCATION_SOURCE]][to [store][location
LOCATION_TARGET{,LOCATION_TARGET}]] [validate] [size] [dump
SEPARATOR_STRING]];

Or 

sync businessobject TYPE NAME REV [from [store][location
LOCATION_SOURCE{,LOCATION_SOURCE]][to [store] [location
LOCATION_TARGET{,LOCATION_TARGET}]] validate [dump
SEPARATOR_STRING]];

The list of business objects will be printed in the following format: 

OID1|format|file1|size
OID2|format|file1|size
OID2|format|file2|size
Total bytes: Number of bytes