Not able to fid tables DOM_STATV AND DOM_STATVT

[Former Member]

Hello ALL,

We are implementing HANA RDS Solution for operational reporting. Most of the tables I found from ECC. 2 tables mentioned above I am not able to find.

The related attribute view for this is : AT_STAT_DELIVERY_HEADER.

I really appreciate if anybody can provide a tip how to get these tables.

Also error attached

Thanks,

Boni

Message was edited by: Brian Bernard

[rindia · Accepted solution]

Hi Boni,

SAP provides the Quick Guide document which gives step by step guide for RDS solution. Have you followed those steps (Note:1739432).

In the page 22 of Quick guide, it says

drop table "SAP_ERP"."DOM_STATV";

drop table "SAP_ERP"."DOM_STATVT";

create column table "SAP_ERP"."DOM_STATV" ("DOMVALUE_L" NVARCHAR (10) not null default ' ' , primary key ("DOMVALUE_L"));

create column table "SAP_ERP"."DOM_STATVT" ("DOMVALUE_L" NVARCHAR (10) not null default ' ', "DDLANGUAGE" NVARCHAR (1) not null default ' ',"DDTEXT" NVARCHAR (60) not null default ' ', primary key ("DOMVALUE_L","DDLANGUAGE"));

insert into "SAP_ERP"."DOM_STATV" select domvalue_l from "SAP_ERP"."DD07L" where domname = 'STATV' and as4local = 'A';

insert into "SAP_ERP"."DOM_STATVT" select domvalue_l, ddlanguage, ddtext from "SAP_ERP"."DD07T" where domname = 'STATV';

Read the document thoroughly before doing anything.

Regards

Raj

Message was edited by: Raj Kumar Salla

[Former Member · Accepted solution]

Hello Raj,

Thanks for the quick response. I did follow the note but did not look at the guide earlier. It helped me to resolve it.

Thanks,

Boni