on 09-19-2011 6:24 AM
Hi gurus,
How the SIDs will be generated for a compound infoobject.
the sid will be generated for both are only one (superior infoobject).
Can any one clarify this with an example.
Thanks,
Venu
Hi Venu,
One SID will be created per one combination of the infoobject. Let us say B is the compounding infoobject for A. Now say we have the following records.
B A
100 500
101 501
Then for combination 100 & 500 there will be one SID and for 101 & 501 there will be another SID. You can check the SID table as well for more clarification.
Indrashis
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Venu,
In general key filed of SID table is characteristic.
Say i have 0CUSTOMER and key filed for this SID table is 0CUSTOMER.
Now i have an requirement that i will get same values for 0CUSTOMER from different source systems.In this values 0CUSTOMER values should not get overwrite.
to achieve this i will assign 0SOURCESYSTEM as compounding object for 0CUSTMOER.
now in SID table of 0CUSTOMER, 0SOURCESYSTEM will become key filed.
for unique combination of 0CUSTOMER and 0SOURCESYSTEM values you will get one SID value.
If you have 2 compounding objects, then for unique combination of 3 values you will get one SID value.
Check the SID table of your info object, you will get clear idea.
Regards,
Venkatesh.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
SID will be generated based on the Combination InfoObject given.
Country ==== Region ==== sid
India ==== South =====1
India ===== North ====== 2
India ===== west ====== 3
cuz combination of these two objects are maintaining the consistency of the record..
-
Thanks
BVR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
one sid per combination of the fields. check the content of a S-table to see an example.
M.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
92 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.