SAP Table ODQSSNREQ

Operational Delta Queue: Queue Subscription Request

ODQSSNREQ (Operational Delta Queue: Queue Subscription Request) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ODQSSNREQ to other SAP tables.

Source: ODQSSNREQ (Operational Delta Queue: Queue Subscription Request)

ODQSSNREQ table fields

Field

Data element

Checktable

Datatype

Length

Decimals

CLIENT

Client

MANDT

CLNT

RID

Request

ODQ_RID

ODQREQ

DEC

SUBSCRIBER_TYPE

Subscriber Type

ODQ_SUBSCRIBER_TYPE

CHAR

SUBSCRIBER_ID

Subscriber

ODQ_SUBSCRIBER_ID

CHAR

SUBSCRIPTION_ID

Subscription for Delta Queue

ODQ_SUBSCRIPTION_ID

ODQSSN

DEC

SUBSCR_MODE

Subscription Type

ODQ_SUBSCRIPTION_MODE

CHAR

Possible values

C	Initialization with Opening Dataset
F	One-Off Dataset
S	Initialization without Opening Dataset

TSN_SUBSCRIBED

Transaction Sequence Number (TSN)

ODQ_TSN

DEC

TSN_CONFIRMED

Transaction Sequence Number (TSN)

ODQ_TSN

DEC

STATUS_ICON

Status

ODQ_STATUS_ICON

CHAR

Possible values

NULL	Not Defined
@0V@	Confirmed
@0W@	Invalid
@5C@	Cancel Extraction
@5Y@	Confirmed and flagged for deletion
@6Q@	Extraction Scheduled
@9O@	Extraction Failed
@9P@	Extraction Successful
@9Y@	Extraction Running
@F1@	Invalid and flagged for deletion

ODQSSNREQ foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table		Check field
ODQSSNREQ	RID	ODQSSNREQ	CLIENT	ODQREQ	Operational DeltaQueue: General Request	CLIENT
ODQSSNREQ	RID	ODQSSNREQ	RID	ODQREQ	Operational DeltaQueue: General Request	RID
ODQSSNREQ	SUBSCRIPTION_ID	ODQSSNREQ	CLIENT	ODQSSN	Operational Delta Queue: Subscription	CLIENT
ODQSSNREQ	SUBSCRIPTION_ID	ODQSSNREQ	SUBSCRIBER_TYPE	ODQSSN	Operational Delta Queue: Subscription	SUBSCRIBER_TYPE
ODQSSNREQ	SUBSCRIPTION_ID	ODQSSNREQ	SUBSCRIBER_ID	ODQSSN	Operational Delta Queue: Subscription	SUBSCRIBER_ID
ODQSSNREQ	SUBSCRIPTION_ID	ODQSSNREQ	SUBSCRIPTION_ID	ODQSSN	Operational Delta Queue: Subscription	SUBSCRIPTION_ID