SOOS

Transparent Table Application Table
68 Fields 1 CDS Views

SAPoffice: Sendevorgang

SOOS is an SAP database table in S/4HANA. SAPoffice: Sendevorgang. 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: Sendevorgang
-- 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