Current Position:Home > Relationship between tables CRMD_ORDERADM_H and BBP_PDORG

Relationship between tables CRMD_ORDERADM_H and BBP_PDORG

Update:11-30Source: network consolidation
Advertisement
Hi all,
I need to search all the RFx for a certain condition.
In the transaction BBP_PD i can see that the header table is CRMD_ORDERADM_H and the table for org. data is BBP_PDORG.
But the guid of both tables are different.
Do you know how I can relate the two tables?
Thanks in advance !

The Best Answer

Advertisement
Hello Husalban,
SELECT set_guid FROM bbp_pdorg
SELECT guid_hi FROM crmd_link WHERE guid_set = bbp_pdorg-set_guid
SELECT header FROM crmd_orderadm_i WHERE guid = crmd_link-guid_hi
SELECT object_id process_type FROM crmd_orderadm_h WHERE guid = crmd_orderadm_i-header
Regards.
Laurent.
  • Relationship between tables CRMD_ORDERADM_H and BBP_PDORG Update:11-30

    Hi all, I need to search all the RFx for a certain condition. In the transaction BBP_PD i can see that the header table is CRMD_ORDERADM_H and the table for org. data is BBP_PDORG. But the guid of both tables are different. Do you know how I can rela

  • How to find the link between tables  CRMD_ORDERADM_H and  BBP_PDORG ? Update:11-30

    HI,All     By TCODE  BBP_PD,  I cann't find the link by GUID between tables CRMD_ORDERADM_H (Header) and  BBP_PDORG (Purchase Organization) ,  why?  how to find this link?    thanks   Jesse.Hello Jianxin, It depends on document category type. For Sho

  • Relationship between tables..Please. Update:10-11

    Hi SRM folks,   I am working on EBD-SAP BW project, I have problem of primary key please look at my scenario. I have a view( ZBW_SHOPCART : View for extracting Shopping Cart data to BW), in turn the view is built on the following tables: 1)  CRMD_ORD

  • RElationship of Tables and Fields in cProjects 4.0 Update:10-11

    Hi All Iam writing the functional spec for a custom status report requirement in cProjects. I have experienced deifficulty in getting the information on relationship of tables. Can anyone help me in this regard. I could get the list of tables in PLM,

  • Relationship between tables in a module(urgent) Update:11-30

    Hi , Am new to this domain(SAP)... I want to move datas to SAP through codes... For example,i want to add datas to ItemGroups module of Inventory module....But it failed...On the other hand,i was able to add datas to Item table of the same module...

  • Table CRMD_ORDERADM_H in IS-U ECC System Update:11-30

    Hi all, I hope i don't get wrong, but we realized that there's table CRMD_ORDERADM_H available in our ECC IS-U system? Is this part of standard? I thought CRMD_ORDERADM_H table is a CRM table? Why is it also available in IS-U and what is it for? Woul

  • TRACING RELATIONSHIP BETWEEN TABLES.... Update:11-30

    Hello all, I use the below query to find the hierarchial relationship between tables ... SELECT c.table_name parent_table , c.column_name parent_column,b.table_name child_table ,b.column_name child_COLUMN ,LEVEL lrv FROM USER_constraints a,user_cons_

  • Query to find all relationships between tables Update:11-30

    Please help me wit the following Query to find all relationships between tables SAMPLE OUTPUT: PRIMTAB PRIMCOL FOREIGNTAB FOREIGN KEY DEPT DEPTNO EMP DEPTNO Return all records in the database. PLEASE HELPSET LINESIZE 150 COLUMN primcol FORMAT A30 COL

  • Relationship between tables while using inner joins. Update:10-11

    Hi, I had a few clarifications on "inner joins", and as i was going through the forum, i came across two points, 1. In one of the threads it said " inner joins is applicable for tables that have a parent child relationship. 2. In another th

  • Relationship between tables Update:10-11

    HI all; I need to get the following fields into my ODS. 1. cost center 2. activity type 3. version 5. Fiscal year 6. Posting Period 7. Activity Qty1 8. Activity Qty2 9 Activity Qty12. I see these fields are stored in the following table 1. CSKS 2. CO