CRMD_LINK Table

[Former Member]

Hi,

What is relation b/w CRMD_LINK table and another CRMD_* tables....??

And what are all the object type_Set field in CRMD_LINK table avilable and use of the field??

Plz explain me ...

thanks..

[Former Member]

thx

[Former Member]

Hi

crmd_link table contains link between the header and items details of the document (shopping cart, etc).

for example, your sc status table crmd_partner, sc item purchasing table, sc account assignment table, sc item table, sc tax data table will all have data field (a guid) that will be present in the crmd_link table (set field).

i dont have system access to give you accurate field linkages between the crmd_link and other crmd* tables...

you can explore transaction bbp_pd to get more details...

R/Reddy.

[Former Member]

CRMD_LINK table primarily acts as a connector for Purchase documents with other documents.

For example, it links attachments with purchase documents. CRMD_ORDERADM_H linked to BBP_PDATT table through CRMD_LINK table for header level attachments and CRMD_ORDERADM_I is linked with BBP_PDATT through CRMD_LINK table for item level attachments.

SG

[Former Member]

hi,

In CRMD_LINK table there is a field OBJTYPE_SET, it has value like 18,21,07 etc...

what is the value stands for??

thanks..

[Former Member]

Hi,

It signifies the type of relationship.

For ex : 34 means Tax. : Linked to table bbp_pdtax

31 means Account Assignment : Linked to table bbp_pdacc.

Regards,

Pavan