COMCPRFORMAT (TCODE) – Lexicograph Format Info

 

1. In CRM, the transaction COMCPRFORMAT ( for Defining Product ID Settings ) has the settings for ‘Save Lexicographically’ as inactive then….
With nonlexicographical storage, the product IDs 123 and 0123 refer to the same product, that is, the leading zeros are meaningless. Both product numbers are stored in the database as 0000000000000000000000000000000000000123 and are thus identical.

2. But if In R3, the corresponding transaction OMSL has the settings for ‘Lexicographical’ as active then these 2 products will be considered as separate products….

Process to Get Partner function (BP Address) related to Sales Order

Using table CRMC_OBJECTS try to locate the entry “partner” and get the corresponding object type 7.

From table CRMD_ORDERADM_H take the GUID and select the entries in table CRMD_LINK table. Select the entry which has the objtype set = 7 and objtype_hi = 5. Get the corresponding GUID_SET entry.

Using the GUID_SET entry, select the entries in the CRMD_PARTNER table. Select the entry for the partner function you want to investigate. Get the corresponding address number.

Using this address number we can get the address information for the partner from ADRC table.

 

Source – www.erpgenie.com