relationship between tables..Please.

[Former Member]

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_ORDERADM_H : Business Transactions CRM

2) CRMD_ORDERADM_I : Business Transaction Item

3) BBP_PDBEI : Backend Specific Item Data

4) CRM_JEST : Individual Status per Object

common primary key is GUID and MANDT

According to the current Requirements

We need to Enhance the view ZBW_SHOPCART with the following table fields

Step Name : Table SWWWIHEAD : Workflow Runtime: Header Table for All Work Item Types

Field WI_TEXT

Status : Table SWWWIHEAD

Field WI STAT

Results : Table SWDSTEXT : Workflow definition: Language-dependent texts

Field WFD_TEXT

Date : Table SWWWIHEAD

Field WI_CD

Time : Table SWWWIHEAD

Field WI_CT

Agent : Table SWWWIHEAD

Field WI_AAGENT

Problem : There is no common( Primary key ) key between the tables SWWWIHEAD, SWDSTEXT and the View ZBW_SHOPCART to join the tables with the View.

Folks please suggest me in this regard, are there any ways to join the tables SWWWIHEAD and SWDSTEXT with the view

I will wait for your valuable suggestion,

thank you

DJ

[Former Member]

Hi

<b> Creating custom database Views does not ensure that you will get correct data.</b>

<u>So go for standard BW reports and in fources available in SRM -></u>

<i>BW Reports for SRM</i>

Regards

- Atul

[Former Member]

Hi,

Already we are extracting Shopping carts data, based on costum data base view, I can not do any thing now as you suggested.

I have to enhace that data source with the few fields of SWWWIHEAD and SWDSTEXT tables, I got the common key between SWWWIHEAD & CRM_ORDERADM_H

The link is :SWWWIHEAD-wi_id with CRM_ORDERADM_H-OBJECT_ID

But I did not find the common key between SWWWIHEAD and SWDSTEXT

SRM folks please give an idea,

Thank you

DJ

[Former Member]

Hi,

IF you need to link the ZBW_SHOPCART you have created with Work item details,then you need to see the table "SWW_WI2OBJ" where INSTID is same as the GUID in CRMD_ORDERADM_H.

Also other link is:

CRMD_ORDERADM_H-CREATED_BY with SWWWIHEAD-WI_CRUSER

i.e The user who created the SC and the user who created the Witem is same thats not unique.

BR,

Disha.

Pls reward points for useful answers.

[Former Member]

Hi Disha,

Your reply is very helpful for me thank you,

I dont have the table entries in the table SWW_WI2OBJ and CRMD_ORDERADM_H-CREATED_BY with SWWWIHEAD-WI_CRUSER is not primary key combination,

Could you give me more suggestions on this

Thank you

DJ

[Former Member]

Hi,

What is your exact requirement?Why have you selected the specific tables(mentioned in your earlier post) for the creation of VIEW?

BR,

Disha.

Pls reward points for useful answers.

[Former Member]

Hi,

Currently we are extracting the data from EBP to SAP BW based on the view

<b>ZBW_SHOPCART : View for extracting Shopping Cart data to BW</b>

is containing the tables & fields as follows

Tables:

CRMD_ORDERADM_H

CRMD_ORDERADM_I

BBP_PDBEI

CRM_JEST

Field Table

CLIENT -CRMD_ORDERADM_H

HEADER_GUID -CRMD_ORDERADM_H

OBJECT_ID -CRMD_ORDERADM_H

ITEM_GUID -CRMD_ORDERADM_I

STAT -CRM_JEST

INACT -CRM_JEST

CHGNR -CRM_JEST

DESCRIPTION -CRMD_ORDERADM_H

CREATED_AT -CRMD_ORDERADM_H

BE_OBJECT_ID -BBP_PDBEI

CHANGED_AT -CRMD_ORDERADM_H

now Current requirement is to enhance that view with some more fields as follows

Step Name : Table SWWWIHEAD : Workflow Runtime: Header Table for All Work Item Types

Field WI_TEXT

Status : Table SWWWIHEAD

Field WI STAT

Results : Table SWDSTEXT : Workflow definition: Language-dependent texts

Field WFD_TEXT

Date : Table SWWWIHEAD

Field WI_CD

Time : Table SWWWIHEAD

Field WI_CT

Agent : Table SWWWIHEAD

Field WI_AAGENT

I need to join this fields into the view, am not able to see the common( Primary key ) key.

Please help me

Message was edited by:

Jangareddy dasari

Message was edited by:

Jangareddy dasari

Message was edited by:

Jangareddy dasari