0CRM_SALES_ACT_1 Tables - FIeld USSTAT

[Former Member]

There are a field ZZSTAT and STAT_NEW as part of the 0CRM_SALES_ACT_1 extract. Can someone tell me which table this value comes from?

it's not the tables:

TJ30

TJ30T

TJ02

TJ02T

CRMD_ORDERADM_H

CRMD_ORDERADM_I

CRM_ORDER_READ

CRM_JEST

CRM_JCDS

tks

Kind regards

Raphael Brandão Torres de Melo

[spencer_liang]

You may find info about this datasource from https://help.sap.com/saphelp_crm700_ehp02/helpdata/en/18/7de8539b0e424de10000000a174cb4/frameset.htm

It is used to extract item information from activity.

So the status should be stored in crm_jest, and the status field in this datasource should extract data from crm_jest

None of others below are related.

TJ30: status profile customizing

TJ02: system status repository

CRMD_ORDERADM_H: activity header is stored in this table but it has no status

CRMD_ORDERADM_I: activity item is stored in this table but it has no status

CRM_ORDER_READ: this is the FM to read any data from an activity. activity status might be read by this FM when running this datasource

CRM_JEST: bingo, this should be table you are asking

CRM_JCDS: status change history in an activity, not related.