SOOD

Transparent Table Application Table
92 Fields 3 CDS Views

SAPoffice: Object definition

SOOD is an SAP database table in S/4HANA. SAPoffice: Object definition. It contains 92 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_InspectionLotAttachment view inner BASIC Inspection Lot Attachment
I_InspectionLotUrl view inner BASIC Assigned URL to Inspection Lot
I_OMEQ_SNDREQ view inner Interface view for the send requests

Fields (92)

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
objla SO_OBJ_LA Language
objsrt SO_OBJ_SRT Sort field
objnam SO_OBJ_NAM Name
objdes SO_OBJ_DES Title
owntp SO_OWN_TP Owner type
ownyr SO_OWN_YR Owner year
ownno SO_OWN_NO Owner number
ownnam SO_OWN_NAM Owner
crotp SO_CRO_TP User Type
croyr SO_CRO_YR User year
crono SO_CRO_NO User number
cronam SO_CRO_NAM Created
crdat SO_DAT_CR Date created
crtim SO_TIM_CR Created at
chotp SO_CHO_TP User Type
choyr SO_CHO_YR User year
chono SO_CHO_NO User no.
chonam SO_CHO_NAM Changed
chdat SO_DAT_CH Changed on
chtim SO_TIM_CH Changed At
nottp SO_NOT_TP Default class
notyr SO_NOT_YR Note year
notno SO_NOT_NO Note number
objapp SO_OBJ_APP Application
objfil SO_OBJ_FIL SAPfile
folrg SO_FOL_RG Folder area
notes SO_NOTES Flag:Attachment
uhcnt SO_UHCNT No. of status HOLD
enccnt SO_ENC_CNT No. attachments
ptfol SO_PTFOL Pointer folders
ptenc SO_PTENC Pointer attach.
pthyp SO_PTHYP No. hyperlinks
ptnot SO_PTNOT Pointer note
ptmbo SO_PTMBO Pointer MBO
pafol SO_PAFOL Archived fldrs
paenc SO_PAENC Arch.pt.attchm.
pahyp SO_PAHYP No. hyperlinks
panot SO_PANOT Arch. pt. note
pambo SO_PAMBO Archived MBO
archi SO_ARCHI Archived
ladat SO_DAT_LA Last changed
dldat SO_DAT_DL Expiration Date
dltim SO_TIM_DL Expiry time
objpri SO_OBJ_PRI Priority
objsns SO_OBJ_SNS Sensitivity
objenc SO_OBJ_ENC Coded
objsnd SO_OBJ_SND Object sent
sddat SO_DAT_SD Send date
sdtim SO_TIM_SD Sent at
reccnt SO_RECCNT Number of Recipients
rrdcnt SO_RRDCNT Read Counter
rrrcnt SO_RRRCNT Rep.required counter
rrpcnt SO_RRPCNT Replied counter
rarcnt SO_RARCNT No.recips with ToDo
rapcnt SO_RAPCNT Number in proc.
ratcnt SO_RATCNT No.recips taken act
rexcnt SO_REXCNT No. express
rcpcnt SO_RCPCNT Send copy
rbccnt SO_RBCCNT Send blind copy
acone SO_ACONE ToDo by one
acout SO_ACOUT ToDo externally
frout SO_FROUT Forw. externally
vmtyp SO_VM_TYP Execution type
skips SO_SKIPS Exec.: Skip screen
acnam SO_ACNAM Exec. element
acmem SO_ACMEM Memory ID
hyptp SO_HYP_TP Object type
hypyr SO_HYP_YR Object year
hypno SO_HYP_NO Object number
auttp SO_AUT_TP Auth. list type
autyr SO_AUT_YR Auth. list year
autno SO_AUT_NO Auth. list no.
pctrl SO_PCTRL External del.
ccotp SO_CCO_TP Ch. copy type
ccoyr SO_CCO_YR Ch. copy year
ccono SO_CCO_NO Change copy no.
objcp SO_OBJ_CP Not Modifiable
prtct SO_PRTCT Tit. modifiable
fixed SO_FIXED ChIn/ChOut
exthd SO_EXTHD Header ext.
extct SO_EXTCT Contents external
file_ext SO_FILEEXT File extension
objlen SO_OBJ_LEN Document size
objdblen SO_OBJ_LEN Document size
creator SO_CREATOR Creator
attlen SO_ATT_LEN Attachment size
if_doc_bcs OS_GUID GUID
if_doc_cls 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: Object definition
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SOOD (
    MANDT,       -- Client [MANDT]
    OBJTP,       -- Class [SO_OBJ_TP]
    OBJYR,       -- Object year [SO_OBJ_YR]
    OBJNO,       -- Object number [SO_OBJ_NO]
    OBJLA,       -- Language [SO_OBJ_LA]
    OBJSRT,      -- Sort field [SO_OBJ_SRT]
    OBJNAM,      -- Name [SO_OBJ_NAM]
    OBJDES,      -- Title [SO_OBJ_DES]
    OWNTP,       -- Owner type [SO_OWN_TP]
    OWNYR,       -- Owner year [SO_OWN_YR]
    OWNNO,       -- Owner number [SO_OWN_NO]
    OWNNAM,      -- Owner [SO_OWN_NAM]
    CROTP,       -- User Type [SO_CRO_TP]
    CROYR,       -- User year [SO_CRO_YR]
    CRONO,       -- User number [SO_CRO_NO]
    CRONAM,      -- Created [SO_CRO_NAM]
    CRDAT,       -- Date created [SO_DAT_CR]
    CRTIM,       -- Created at [SO_TIM_CR]
    CHOTP,       -- User Type [SO_CHO_TP]
    CHOYR,       -- User year [SO_CHO_YR]
    CHONO,       -- User no. [SO_CHO_NO]
    CHONAM,      -- Changed [SO_CHO_NAM]
    CHDAT,       -- Changed on [SO_DAT_CH]
    CHTIM,       -- Changed At [SO_TIM_CH]
    NOTTP,       -- Default class [SO_NOT_TP]
    NOTYR,       -- Note year [SO_NOT_YR]
    NOTNO,       -- Note number [SO_NOT_NO]
    OBJAPP,      -- Application [SO_OBJ_APP]
    OBJFIL,      -- SAPfile [SO_OBJ_FIL]
    FOLRG,       -- Folder area [SO_FOL_RG]
    NOTES,       -- Flag:Attachment [SO_NOTES]
    UHCNT,       -- No. of status HOLD [SO_UHCNT]
    ENCCNT,      -- No. attachments [SO_ENC_CNT]
    PTFOL,       -- Pointer folders [SO_PTFOL]
    PTENC,       -- Pointer attach. [SO_PTENC]
    PTHYP,       -- No. hyperlinks [SO_PTHYP]
    PTNOT,       -- Pointer note [SO_PTNOT]
    PTMBO,       -- Pointer MBO [SO_PTMBO]
    PAFOL,       -- Archived fldrs [SO_PAFOL]
    PAENC,       -- Arch.pt.attchm. [SO_PAENC]
    PAHYP,       -- No. hyperlinks [SO_PAHYP]
    PANOT,       -- Arch. pt. note [SO_PANOT]
    PAMBO,       -- Archived MBO [SO_PAMBO]
    ARCHI,       -- Archived [SO_ARCHI]
    LADAT,       -- Last changed [SO_DAT_LA]
    DLDAT,       -- Expiration Date [SO_DAT_DL]
    DLTIM,       -- Expiry time [SO_TIM_DL]
    OBJPRI,      -- Priority [SO_OBJ_PRI]
    OBJSNS,      -- Sensitivity [SO_OBJ_SNS]
    OBJENC,      -- Coded [SO_OBJ_ENC]
    OBJSND,      -- Object sent [SO_OBJ_SND]
    SDDAT,       -- Send date [SO_DAT_SD]
    SDTIM,       -- Sent at [SO_TIM_SD]
    RECCNT,      -- Number of Recipients [SO_RECCNT]
    RRDCNT,      -- Read Counter [SO_RRDCNT]
    RRRCNT,      -- Rep.required counter [SO_RRRCNT]
    RRPCNT,      -- Replied counter [SO_RRPCNT]
    RARCNT,      -- No.recips with ToDo [SO_RARCNT]
    RAPCNT,      -- Number in proc. [SO_RAPCNT]
    RATCNT,      -- No.recips taken act [SO_RATCNT]
    REXCNT,      -- No. express [SO_REXCNT]
    RCPCNT,      -- Send copy [SO_RCPCNT]
    RBCCNT,      -- Send blind copy [SO_RBCCNT]
    ACONE,       -- ToDo by one [SO_ACONE]
    ACOUT,       -- ToDo externally [SO_ACOUT]
    FROUT,       -- Forw. externally [SO_FROUT]
    VMTYP,       -- Execution type [SO_VM_TYP]
    SKIPS,       -- Exec.: Skip screen [SO_SKIPS]
    ACNAM,       -- Exec. element [SO_ACNAM]
    ACMEM,       -- Memory ID [SO_ACMEM]
    HYPTP,       -- Object type [SO_HYP_TP]
    HYPYR,       -- Object year [SO_HYP_YR]
    HYPNO,       -- Object number [SO_HYP_NO]
    AUTTP,       -- Auth. list type [SO_AUT_TP]
    AUTYR,       -- Auth. list year [SO_AUT_YR]
    AUTNO,       -- Auth. list no. [SO_AUT_NO]
    PCTRL,       -- External del. [SO_PCTRL]
    CCOTP,       -- Ch. copy type [SO_CCO_TP]
    CCOYR,       -- Ch. copy year [SO_CCO_YR]
    CCONO,       -- Change copy no. [SO_CCO_NO]
    OBJCP,       -- Not Modifiable [SO_OBJ_CP]
    PRTCT,       -- Tit. modifiable [SO_PRTCT]
    FIXED,       -- ChIn/ChOut [SO_FIXED]
    EXTHD,       -- Header ext. [SO_EXTHD]
    EXTCT,       -- Contents external [SO_EXTCT]
    FILE_EXT,    -- File extension [SO_FILEEXT]
    OBJLEN,      -- Document size [SO_OBJ_LEN]
    OBJDBLEN,    -- Document size [SO_OBJ_LEN]
    CREATOR,     -- Creator [SO_CREATOR]
    ATTLEN,      -- Attachment size [SO_ATT_LEN]
    IF_DOC_BCS,  -- GUID [OS_GUID]
    IF_DOC_CLS,  -- GUID [OS_GUID]
    PRIMARY KEY (MANDT, OBJTP, OBJYR, OBJNO)
);

Learn More