LOG

43 Fields

LOG is an SAP database table in S/4HANA. It contains 43 fields.

Fields (43)

KeyField CDS FieldsUsed in Views
KEY bname AccessUser 1
KEY bukrs CompanyCode 2
KEY bwber GeneralLedgerValuationArea 2
KEY datum CalendarDate 2
KEY gjahr FiscalYear 2
KEY ManufacturingObjectLog ManufacturingExecutionDocument 3
KEY ManufacturingOrder ManufacturingOrder 2
KEY rldnr Ledger 1
KEY StatryRptCategory StatryRptCategory 17
KEY StatryRptgEntity StatryRptgEntity 17
KEY StatryRptRunID StatryRptRunID 17
BOMExplosionDate BOMExplosionDate 1
changed_at changed_at 1
CostingErrorLogID CostingErrorLogID 1
CostingErrorLogObject CostingErrorLogObject 1
CostingRunStatusHistorySqnc CostingRunStatusHistorySqnc 1
errorflag errorflag 1
IsDisabled IsDisabled 1
LastChangedAtDateTime LastChangedAtDateTime 1
LocalLastChangedAtDateTime LocalLastChangedAtDateTime 1
ManufacturingActionReasonCode ManufacturingActionReasonCode 3
MaterialComponent MaterialComponent 2
MfgActionReasonCodeGroup MfgActionReasonCodeGroup 3
MfgActionReasonCodeGroupCtlg MfgActionReasonCodeGroupCtlg 3
MfgExecHistMsgVarblField1 MfgExecHistMsgVarblField1 3
MfgExecHistMsgVarblField2 MfgExecHistMsgVarblField2 3
MfgExecHistMsgVarblField3 MfgExecHistMsgVarblField3 3
MfgExecHistMsgVarblField4 MfgExecHistMsgVarblField4 2
MfgObjectLogEventType MfgObjectLogEventType 3
MfgOrderSplitChildOrder MfgOrderSplitChildOrder 1
MfgProcgExecAttachmentName MfgProcgExecAttachmentName 1
msg_cnt_e NumberOfErrorLogMessages 1
OpActyNtwkElement OpActyNtwkElement 1
OpActyNtwkInstance OpActyNtwkInstance 1
OrderInternalID OrderInternalID 1
OrderOperationInternalID OrderOperationInternalID 1
processdone processdone 1
ProductionUnit ProductionUnit 1
ShopFloorItem ShopFloorItem 3
SubstitutedProduct SubstitutedProduct 3
SuccessorManufacturingOrder SuccessorManufacturingOrder 1
SystemMessageIdentification SystemMessageIdentification 3
SystemMessageNumber SystemMessageNumber 3

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LOG (
    BNAME,
    BUKRS,
    BWBER,
    DATUM,
    GJAHR,
    MANUFACTURINGOBJECTLOG,
    MANUFACTURINGORDER,
    RLDNR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    BOMEXPLOSIONDATE,
    CHANGED_AT,
    COSTINGERRORLOGID,
    COSTINGERRORLOGOBJECT,
    COSTINGRUNSTATUSHISTORYSQNC,
    ERRORFLAG,
    ISDISABLED,
    LASTCHANGEDATDATETIME,
    LOCALLASTCHANGEDATDATETIME,
    MANUFACTURINGACTIONREASONCODE,
    MATERIALCOMPONENT,
    MFGACTIONREASONCODEGROUP,
    MFGACTIONREASONCODEGROUPCTLG,
    MFGEXECHISTMSGVARBLFIELD1,
    MFGEXECHISTMSGVARBLFIELD2,
    MFGEXECHISTMSGVARBLFIELD3,
    MFGEXECHISTMSGVARBLFIELD4,
    MFGOBJECTLOGEVENTTYPE,
    MFGORDERSPLITCHILDORDER,
    MFGPROCGEXECATTACHMENTNAME,
    MSG_CNT_E,
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    ORDERINTERNALID,
    ORDEROPERATIONINTERNALID,
    PROCESSDONE,
    PRODUCTIONUNIT,
    SHOPFLOORITEM,
    SUBSTITUTEDPRODUCT,
    SUCCESSORMANUFACTURINGORDER,
    SYSTEMMESSAGEIDENTIFICATION,
    SYSTEMMESSAGENUMBER,
    PRIMARY KEY (BNAME, BUKRS, BWBER, DATUM, GJAHR, MANUFACTURINGOBJECTLOG, MANUFACTURINGORDER, RLDNR, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID)
);

Learn More