SOOS

Transparent Table Application Table
68 Fields 1 CDS Views

SAPoffice: send process

SOOS is an SAP database table in S/4HANA. SAPoffice: send process. It contains 68 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OMEQ_SNDREQ view from Interface view for the send requests

Fields (68)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY objtp SO_OBJ_TP Class
KEY objyr SO_OBJ_YR Object year
KEY objno SO_OBJ_NO Object number
KEY fortp SO_FOR_TP Forwarder type
KEY foryr SO_FOR_YR Forwarder year
KEY forno SO_FOR_NO Number of forwarder
KEY rectp SO_REC_TP Recipient Type
KEY recyr SO_REC_YR Recipient year
KEY recno SO_REC_NO Recipient no.
sndtp SO_SND_TP Sender type
sndyr SO_SND_YR Sender year
sndno SO_SND_NO Sender no.
sndnam SO_SND_NAM Sender name
sddat SO_DAT_SD Send date
sdtim SO_TIM_SD Sent at
recnam SO_REC_NAM Recipient Name
rcdat SO_DAT_RC Date received
rctim SO_TIM_RC Time received
fornam SO_FOR_NAM Forwarder
nottp SO_NOT_TP Default class
notyr SO_NOT_YR Note year
notno SO_NOT_NO Note number
refer SO_REFER Reference
rddat SO_DAT_RD Read
rdtim SO_TIM_RD Viewed at
objrd SO_OBJ_RD Object read
sndart TDDEVICE Device
sndspo RSPOID Number
reclan LAND1 Country/Reg.
rectel SKTELNR Number
snddr SO_SND_DR Send as disregard
sndex SO_SND_EX Send express
sndcp SO_SND_CP Send as copy
sndbc SO_SND_BC Blind copy
forfb SO_FORFB No forwarding
prifb SO_PRIFB No printing
sndpri SO_SND_PRI Send priority
acdat SO_DAT_AC ToDo by
actim SO_TIM_AC ToDo by
atdat SO_DAT_AT Done on
attim SO_TIM_AT Completed at
acall SO_ACALL ToDo
acone SO_ACONE ToDo by one
acinp SO_ACINP ToDo: status
objac SO_OBJ_AC ToDo
rrdat SO_DAT_RR Reply by
rrtim SO_TIM_RR Reply by
rsdat SO_DAT_RS Reply sent on
rstim SO_TIM_RS Reply sent at
objrr SO_OBJ_RR Reply required
objrs SO_OBJ_RS Reply sent
objrn SO_OBJ_RN No reply
delre SO_DEL_RE Unviewed obj.
delrr SO_DEL_RR Unanswered obj.
delac SO_DEL_AC Not done
reptp SO_REP_TP Recipient type
repyr SO_REP_YR Reply recip. year
repno SO_REP_NO Recipient number
repnam SO_REP_NAM Recipient Name
repdna SO_REP_DNA DL name
fpttp SO_FPT_TP Object type
fptyr SO_FPT_YR Object year
fptno SO_FPT_NO Object number
bpttp SO_BPT_TP Obj. type
bptyr SO_BPT_YR Obj.year
bptno SO_BPT_NO Object no.
sndreq OS_GUID GUID

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- SAPoffice: send process
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SOOS (
    MANDT,   -- Client [MANDT]
    OBJTP,   -- Class [SO_OBJ_TP]
    OBJYR,   -- Object year [SO_OBJ_YR]
    OBJNO,   -- Object number [SO_OBJ_NO]
    FORTP,   -- Forwarder type [SO_FOR_TP]
    FORYR,   -- Forwarder year [SO_FOR_YR]
    FORNO,   -- Number of forwarder [SO_FOR_NO]
    RECTP,   -- Recipient Type [SO_REC_TP]
    RECYR,   -- Recipient year [SO_REC_YR]
    RECNO,   -- Recipient no. [SO_REC_NO]
    SNDTP,   -- Sender type [SO_SND_TP]
    SNDYR,   -- Sender year [SO_SND_YR]
    SNDNO,   -- Sender no. [SO_SND_NO]
    SNDNAM,  -- Sender name [SO_SND_NAM]
    SDDAT,   -- Send date [SO_DAT_SD]
    SDTIM,   -- Sent at [SO_TIM_SD]
    RECNAM,  -- Recipient Name [SO_REC_NAM]
    RCDAT,   -- Date received [SO_DAT_RC]
    RCTIM,   -- Time received [SO_TIM_RC]
    FORNAM,  -- Forwarder [SO_FOR_NAM]
    NOTTP,   -- Default class [SO_NOT_TP]
    NOTYR,   -- Note year [SO_NOT_YR]
    NOTNO,   -- Note number [SO_NOT_NO]
    REFER,   -- Reference [SO_REFER]
    RDDAT,   -- Read [SO_DAT_RD]
    RDTIM,   -- Viewed at [SO_TIM_RD]
    OBJRD,   -- Object read [SO_OBJ_RD]
    SNDART,  -- Device [TDDEVICE]
    SNDSPO,  -- Number [RSPOID]
    RECLAN,  -- Country/Reg. [LAND1]
    RECTEL,  -- Number [SKTELNR]
    SNDDR,   -- Send as disregard [SO_SND_DR]
    SNDEX,   -- Send express [SO_SND_EX]
    SNDCP,   -- Send as copy [SO_SND_CP]
    SNDBC,   -- Blind copy [SO_SND_BC]
    FORFB,   -- No forwarding [SO_FORFB]
    PRIFB,   -- No printing [SO_PRIFB]
    SNDPRI,  -- Send priority [SO_SND_PRI]
    ACDAT,   -- ToDo by [SO_DAT_AC]
    ACTIM,   -- ToDo by [SO_TIM_AC]
    ATDAT,   -- Done on [SO_DAT_AT]
    ATTIM,   -- Completed at [SO_TIM_AT]
    ACALL,   -- ToDo [SO_ACALL]
    ACONE,   -- ToDo by one [SO_ACONE]
    ACINP,   -- ToDo: status [SO_ACINP]
    OBJAC,   -- ToDo [SO_OBJ_AC]
    RRDAT,   -- Reply by [SO_DAT_RR]
    RRTIM,   -- Reply by [SO_TIM_RR]
    RSDAT,   -- Reply sent on [SO_DAT_RS]
    RSTIM,   -- Reply sent at [SO_TIM_RS]
    OBJRR,   -- Reply required [SO_OBJ_RR]
    OBJRS,   -- Reply sent [SO_OBJ_RS]
    OBJRN,   -- No reply [SO_OBJ_RN]
    DELRE,   -- Unviewed obj. [SO_DEL_RE]
    DELRR,   -- Unanswered obj. [SO_DEL_RR]
    DELAC,   -- Not done [SO_DEL_AC]
    REPTP,   -- Recipient type [SO_REP_TP]
    REPYR,   -- Reply recip. year [SO_REP_YR]
    REPNO,   -- Recipient number [SO_REP_NO]
    REPNAM,  -- Recipient Name [SO_REP_NAM]
    REPDNA,  -- DL name [SO_REP_DNA]
    FPTTP,   -- Object type [SO_FPT_TP]
    FPTYR,   -- Object year [SO_FPT_YR]
    FPTNO,   -- Object number [SO_FPT_NO]
    BPTTP,   -- Obj. type [SO_BPT_TP]
    BPTYR,   -- Obj.year [SO_BPT_YR]
    BPTNO,   -- Object no. [SO_BPT_NO]
    SNDREQ,  -- GUID [OS_GUID]
    PRIMARY KEY (MANDT, OBJTP, OBJYR, OBJNO, FORTP, FORYR, FORNO, RECTP, RECYR, RECNO)
);

Learn More