COLLSRSMDRA

Transparent Table Application Table

Draft table for entity R_COLLSRESUBMISSIONTP

COLLSRSMDRA is an SAP database table in S/4HANA. Draft table for entity R_COLLSRESUBMISSIONTP. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CollsResubmissionDraft view from BASIC Resubmission Drafts

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY resubmissionuuid BDM_RSM_GUID Resubmission Key
KEY draftuuid SDRAFT_UUID Draft Document ID
businesspartner BU_PARTNER Busn. Partner
collectionsegment FARP_COLLECTION_SEGMENT Collection Segment
resubmissionduedate BDM_RSM_DATE Resubmission Date
collresubmissiondatetime TIMESTAMP Time Stamp
nocntctuntilresubmsndateisreq COLL_RSM_DONT_CONTACT Don't Contact Until Resubmission Date
resubmissionreason BDM_RSM_REASON Reason
resubmissionstatus BDM_RSM_STATUS Status
createdbyuser SCMG_CREATE_USER Created By
creationdatetime COLL_PR_CREATION_DATE_TIME Created At
changedby SCMG_CHANGE_USER Changed By
changedondatetime COLL_PR_CHANGED_AT Last Changed At
objecttype SWO_OBJTYP Object Type
objectkey SWO_TYPEID Key
bopfuuid SDRAFT_UUID Draft Document ID
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityconsistencystatus abap.char
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes

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.

-- Draft table for entity R_COLLSRESUBMISSIONTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE COLLSRSMDRA (
    MANDT,                          -- Client [MANDT]
    RESUBMISSIONUUID,               -- Resubmission Key [BDM_RSM_GUID]
    DRAFTUUID,                      -- Draft Document ID [SDRAFT_UUID]
    BUSINESSPARTNER,                -- Busn. Partner [BU_PARTNER]
    COLLECTIONSEGMENT,              -- Collection Segment [FARP_COLLECTION_SEGMENT]
    RESUBMISSIONDUEDATE,            -- Resubmission Date [BDM_RSM_DATE]
    COLLRESUBMISSIONDATETIME,       -- Time Stamp [TIMESTAMP]
    NOCNTCTUNTILRESUBMSNDATEISREQ,  -- Don't Contact Until Resubmission Date [COLL_RSM_DONT_CONTACT]
    RESUBMISSIONREASON,             -- Reason [BDM_RSM_REASON]
    RESUBMISSIONSTATUS,             -- Status [BDM_RSM_STATUS]
    CREATEDBYUSER,                  -- Created By [SCMG_CREATE_USER]
    CREATIONDATETIME,               -- Created At [COLL_PR_CREATION_DATE_TIME]
    CHANGEDBY,                      -- Changed By [SCMG_CHANGE_USER]
    CHANGEDONDATETIME,              -- Last Changed At [COLL_PR_CHANGED_AT]
    OBJECTTYPE,                     -- Object Type [SWO_OBJTYP]
    OBJECTKEY,                      -- Key [SWO_TYPEID]
    BOPFUUID,                       -- Draft Document ID [SDRAFT_UUID]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTENTITYCREATIONDATETIME,    -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,   -- abap.char
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    DRAFTFIELDCHANGES,              -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, RESUBMISSIONUUID, DRAFTUUID)
);