SDAC_LOG

Transparent Table Application Table
22 Fields 1 CDS Views

Sales Document Autocompletion Log

SDAC_LOG is an SAP database table in S/4HANA. Sales Document Autocompletion Log. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SlsDocFldRecmdnLogBasic view_entity from BASIC Recommendation Log of Sales Doc Field

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY slsdocautomcompltnlguuid sdac_slsdocautomcompltnlguuid
inferenceobjectuuid sdac_inferenceobjectuuid
isdraft sdac_entry_is_draft
salesdocument vbeln_va Sales Document
salesdocumentitem posnr_va Item
handle tsegguid_vbak Int.ID
databasetable tabname Table Name
databasetablefieldname sdac_dbfieldname
salesdocumentglobalfieldname sdac_slsdocglobalfieldname
inferencefieldname sdac_inferencefieldname
autocompletedvalue sdac_autofilledvalue
fieldlastchangedbyuser last_changed_by_user Last Changed By
fieldlastchangedatetime last_changed_date_time Last Changed On
autocompletedvalueprobability sdac_initialprobability
fieldrecommendationstatus sdac_currecmdnapplystatus
currentfieldvalue sdac_currentfilledvalue
currentfieldvalueprobability sdac_currentprobability
creationdatetime creation_date_time Created On
createdbyuser ernam Created By
lastchangedbyuser last_changed_by_user Last Changed By
lastchangedatetime last_changed_date_time Last Changed On

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.

-- Sales Document Autocompletion Log
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SDAC_LOG (
    MANDT,                          -- Client [mandt]
    SLSDOCAUTOMCOMPLTNLGUUID,       -- sdac_slsdocautomcompltnlguuid
    INFERENCEOBJECTUUID,            -- sdac_inferenceobjectuuid
    ISDRAFT,                        -- sdac_entry_is_draft
    SALESDOCUMENT,                  -- Sales Document [vbeln_va]
    SALESDOCUMENTITEM,              -- Item [posnr_va]
    HANDLE,                         -- Int.ID [tsegguid_vbak]
    DATABASETABLE,                  -- Table Name [tabname]
    DATABASETABLEFIELDNAME,         -- sdac_dbfieldname
    SALESDOCUMENTGLOBALFIELDNAME,   -- sdac_slsdocglobalfieldname
    INFERENCEFIELDNAME,             -- sdac_inferencefieldname
    AUTOCOMPLETEDVALUE,             -- sdac_autofilledvalue
    FIELDLASTCHANGEDBYUSER,         -- Last Changed By [last_changed_by_user]
    FIELDLASTCHANGEDATETIME,        -- Last Changed On [last_changed_date_time]
    AUTOCOMPLETEDVALUEPROBABILITY,  -- sdac_initialprobability
    FIELDRECOMMENDATIONSTATUS,      -- sdac_currecmdnapplystatus
    CURRENTFIELDVALUE,              -- sdac_currentfilledvalue
    CURRENTFIELDVALUEPROBABILITY,   -- sdac_currentprobability
    CREATIONDATETIME,               -- Created On [creation_date_time]
    CREATEDBYUSER,                  -- Created By [ernam]
    LASTCHANGEDBYUSER,              -- Last Changed By [last_changed_by_user]
    LASTCHANGEDATETIME,             -- Last Changed On [last_changed_date_time]
    PRIMARY KEY (MANDT, SLSDOCAUTOMCOMPLTNLGUUID)
);

Learn More