/ACCGO/T_UISEVNT

Transparent Table Application Table
109 Fields 11 CDS Views

LDC Event Details

/ACCGO/T_UISEVNT is an SAP database table in S/4HANA. LDC Event Details. It contains 109 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
I_ACMLoadDataCaptureData view from BASIC ACM Load Data Capture Event Details Data
I_ACMLoadDataCaptureEvtDet view from BASIC Basic LDC Event Details
I_ACMLoadDataCaptureNomination view_entity from BASIC LDC Data with Nomination Details
I_LoadDataCaptureEvent view from BASIC ACM Basic View For UIS Event
I_LoadDataCaptureEventContract view_entity from BASIC Load Data Capture Event and Contract
I_LoadDataCaptureEventData view inner BASIC Load Data Capture data
P_ACCGO_LDC_DTLS view from BASIC
P_ACMLoadDataCapture view_entity from BASIC
P_LDC_DATA view inner BASIC
P_LDCEventData view from BASIC
P_QREP_VERSION view inner BASIC

Fields (109)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY uis_evnt_key /ACCGO/E_UIS_GUID LDC Key
parent_key /ACCGO/E_UIS_GUID LDC Key
event_type /ACCGO/E_UIS_EVENT Event Type
purchase_org EKORG Purchasing Org.
specific_matnr MATNR Material
material MATNR Material
trace_id /ACCGO/E_UIS_TRACE_ID Trace ID
ticket OIJ_EL_TKT_KEY Ticket key
ticket_rc OIJ_TKTRC Return code
ext_identifier /ACCGO/E_UIS_EXT_ID External ID
final_delivery XFELD Checkbox
dispute_status /ACCGO/E_UIS_DISP_STATUS Dispute Status
evnt_loc_typ OIF_PBLTYP Location type
evnt_loc /ACCGO/E_EVNT_LOC Event Location
rec_loc_typ OIF_PBLTYP Location type
rec_loc /ACCGO/E_REC_LOC Rec Location
planned_unload_loc_typ OIF_PBLTYP Location type
planned_unload_loc /ACCGO/E_EVNT_LOC Event Location
adv_disch_loc_type OIF_PBLTYP Location type
adv_disch_loc /ACCGO/E_ADV_DISCH_LOC Adv Discharge Loc
stage_loc /ACCGO/E_STAGE_LOC Stage Loc
appl_instr /ACCGO/E_UIS_APPL_INSTR Application Instr.
on_acc_of LIFNR Supplier
tc_id TKONN Trading Contract
tc_item TPOSN Item Number
b2b_tc_id TKONN Trading Contract
b2b_tc_item TPOSN Item Number
nomtyp OIJ_NOMTYP Nomination type
tsyst OIJ_TSYST Trans system
po_id EBELN Purchasing Doc.
po_item EBELP Item
sto_id EBELN Purchasing Doc.
sto_item EBELP Item
so_id VBELN_VA Sales Document
so_item POSNR_VA Item
del_id VBELN_VL Delivery
del_item POSNR_VL Item
accnt_addr_flag /ACCGO/E_NEW_ADDR_FLG New Address
storage_agreement /ACCGO/E_STOR_AGRMNT Stor. Agreement
storage_agreement_item /ACCGO/E_STOR_AGRMNT_ITEM Strg Agr Item
mat_doc MBLNR Material Doc.
doc_year MJAHR Mat. Doc. Year
bol BOLNR Bill of Lading
bol_date BLDAT Document Date
nom_key OIJ_NOMTK Nomination key
nom_id OIJ_NOMNR Nomination no.
nom_item OIJ_ITEM Nom. key item
mot VKTRA Mode of Transp.
trnsp_grp TRAGR Trans. Group
means_of_trnsp /ACCGO/E_MEANS_ID Means of Transport
driver_id /ACCGO/E_DRIVER Driver Name
license /ACCGO/E_LICENSE_PLATE Lic. Plate No.
vehicle_id /ACCGO/E_VEH_NO Vehicle No.
lead_car_no /ACCGO/E_LEAD_CAR_NO Lead Car No.
no_of_cars /ACCGO/E_NO_OF_CARS No. of Cars
barge_id /ACCGO/E_TRUCK_RAIL_BARGE_ID Veh. ID
vessel_id /ACCGO/E_VESSEL_NAME Vessel Name
booking_no /ACCGO/E_BOOKING_NO Booking No.
descr /ACCGO/E_DESCRIPTION Description
scale_tkt_no /ACCGO/E_SCALE_TKT_NO Scale Ticket Number
load_rt /ACCGO/E_LD_RATE Load Rate
dis_rt /ACCGO/E_DS_RATE Discharge Rate
crop_season_id /ACCGO/E_CROP_SEASON_ID Crop Season ID
del_period /ACCGO/E_DEL_PERIOD Delivery Period
del_period_end /ACCGO/E_DEL_PERIOD_END Delivery End Date
source_loc /ACCGO/E_SOURCE_LOC Source Location
load_rt_qty /ACCGO/E_LD_RT_QTY Load Rate Quantity
load_rt_tim /ACCGO/E_LD_RT_TM Ld Rt Time UOM
del_pd_uom /ACCGO/E_DL_PD_UOM Del Pd Time UOM
dis_rt_qty /ACCGO/E_DIS_RT_QTY Dis Rate Qty
dis_rt_tim /ACCGO/E_DIS_RT_TM Discharge Rate Tim
load_location /ACCGO/E_LOAD_LOCATION Load Location
discharge_loc /ACCGO/E_DISCH_LOCATION Discharge Location
vktra VKTRA Mode of Transp.
means_trnspt /ACCGO/E_MEANS_ID Means of Transport
inco_terms INCO1 Incoterms
deletion_flag /ACCGO/E_DEL_FLAG Delete
alternate_vendor /ACCGO/ALTER_VENDOR_FLAG Alternate Vendor Fla
evnt_actual_date DATS Date
evnt_actual_time TIMS Field of type TIMS
evnt_actual_on /ACCGO/E_EVENT_ACTUAL_ON Event On
ev_action /ACCGO/E_UIS_EVNT_REL_ACT Evnt Rel. Action
ev_bin LGPLA Storage Bin
ev_storage LGORT_D Location
comments /ACCGO/E_COMMENT Comments
released_by /ACCGO/E_EVNT_RELEASED_BY Evnt Released By
released_date DATS Date
released_time TIMS Field of type TIMS
rel_wgt_qrep_guid /ACCGO/REL_WGT_QREP_GUID Rel Wgt QREP GUID
rel_wgt_qrep_version /ACCGO/REL_WGT_QREP_VER Rel Wgt Version
car_lot_relevant XFELD Checkbox
posting_date SYSTDATLO Local date
dpa_number /ACCGO/E_DPA_NUM Del&Pay.Auth Number
vkorg VKORG Sales Org.
vtveg VTWEG Distr. Channel
spart SPART Division
incoterm_ups INCO1 Incoterms
auto_incoterm BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
werks WERKS_D Plant
created_by /ACCGO/E_CREATED_BY Created By
created_on /ACCGO/E_CREATED_ON Created On
changed_by /ACCGO/E_CHANGED_BY Changed By
changed_on /ACCGO/E_CHANGED_ON Changed On
item POSNR Item
part_wt_ind /ACCGO/E_PART_WT Partial Weight
ldc_objnr J_OBJNR Object number
ca_date /ACCGO/E_COMMODITY_DATE Comm Avail Dt
sdm_version /ACCGO/E_SDM_VERSION SDM Version field

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.

-- LDC Event Details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /ACCGO/T_UISEVNT (
    MANDT,                   -- Client [MANDT]
    UIS_EVNT_KEY,            -- LDC Key [/ACCGO/E_UIS_GUID]
    PARENT_KEY,              -- LDC Key [/ACCGO/E_UIS_GUID]
    EVENT_TYPE,              -- Event Type [/ACCGO/E_UIS_EVENT]
    PURCHASE_ORG,            -- Purchasing Org. [EKORG]
    SPECIFIC_MATNR,          -- Material [MATNR]
    MATERIAL,                -- Material [MATNR]
    TRACE_ID,                -- Trace ID [/ACCGO/E_UIS_TRACE_ID]
    TICKET,                  -- Ticket key [OIJ_EL_TKT_KEY]
    TICKET_RC,               -- Return code [OIJ_TKTRC]
    EXT_IDENTIFIER,          -- External ID [/ACCGO/E_UIS_EXT_ID]
    FINAL_DELIVERY,          -- Checkbox [XFELD]
    DISPUTE_STATUS,          -- Dispute Status [/ACCGO/E_UIS_DISP_STATUS]
    EVNT_LOC_TYP,            -- Location type [OIF_PBLTYP]
    EVNT_LOC,                -- Event Location [/ACCGO/E_EVNT_LOC]
    REC_LOC_TYP,             -- Location type [OIF_PBLTYP]
    REC_LOC,                 -- Rec Location [/ACCGO/E_REC_LOC]
    PLANNED_UNLOAD_LOC_TYP,  -- Location type [OIF_PBLTYP]
    PLANNED_UNLOAD_LOC,      -- Event Location [/ACCGO/E_EVNT_LOC]
    ADV_DISCH_LOC_TYPE,      -- Location type [OIF_PBLTYP]
    ADV_DISCH_LOC,           -- Adv Discharge Loc [/ACCGO/E_ADV_DISCH_LOC]
    STAGE_LOC,               -- Stage Loc [/ACCGO/E_STAGE_LOC]
    APPL_INSTR,              -- Application Instr. [/ACCGO/E_UIS_APPL_INSTR]
    ON_ACC_OF,               -- Supplier [LIFNR]
    TC_ID,                   -- Trading Contract [TKONN]
    TC_ITEM,                 -- Item Number [TPOSN]
    B2B_TC_ID,               -- Trading Contract [TKONN]
    B2B_TC_ITEM,             -- Item Number [TPOSN]
    NOMTYP,                  -- Nomination type [OIJ_NOMTYP]
    TSYST,                   -- Trans system [OIJ_TSYST]
    PO_ID,                   -- Purchasing Doc. [EBELN]
    PO_ITEM,                 -- Item [EBELP]
    STO_ID,                  -- Purchasing Doc. [EBELN]
    STO_ITEM,                -- Item [EBELP]
    SO_ID,                   -- Sales Document [VBELN_VA]
    SO_ITEM,                 -- Item [POSNR_VA]
    DEL_ID,                  -- Delivery [VBELN_VL]
    DEL_ITEM,                -- Item [POSNR_VL]
    ACCNT_ADDR_FLAG,         -- New Address [/ACCGO/E_NEW_ADDR_FLG]
    STORAGE_AGREEMENT,       -- Stor. Agreement [/ACCGO/E_STOR_AGRMNT]
    STORAGE_AGREEMENT_ITEM,  -- Strg Agr Item [/ACCGO/E_STOR_AGRMNT_ITEM]
    MAT_DOC,                 -- Material Doc. [MBLNR]
    DOC_YEAR,                -- Mat. Doc. Year [MJAHR]
    BOL,                     -- Bill of Lading [BOLNR]
    BOL_DATE,                -- Document Date [BLDAT]
    NOM_KEY,                 -- Nomination key [OIJ_NOMTK]
    NOM_ID,                  -- Nomination no. [OIJ_NOMNR]
    NOM_ITEM,                -- Nom. key item [OIJ_ITEM]
    MOT,                     -- Mode of Transp. [VKTRA]
    TRNSP_GRP,               -- Trans. Group [TRAGR]
    MEANS_OF_TRNSP,          -- Means of Transport [/ACCGO/E_MEANS_ID]
    DRIVER_ID,               -- Driver Name [/ACCGO/E_DRIVER]
    LICENSE,                 -- Lic. Plate No. [/ACCGO/E_LICENSE_PLATE]
    VEHICLE_ID,              -- Vehicle No. [/ACCGO/E_VEH_NO]
    LEAD_CAR_NO,             -- Lead Car No. [/ACCGO/E_LEAD_CAR_NO]
    NO_OF_CARS,              -- No. of Cars [/ACCGO/E_NO_OF_CARS]
    BARGE_ID,                -- Veh. ID [/ACCGO/E_TRUCK_RAIL_BARGE_ID]
    VESSEL_ID,               -- Vessel Name [/ACCGO/E_VESSEL_NAME]
    BOOKING_NO,              -- Booking No. [/ACCGO/E_BOOKING_NO]
    DESCR,                   -- Description [/ACCGO/E_DESCRIPTION]
    SCALE_TKT_NO,            -- Scale Ticket Number [/ACCGO/E_SCALE_TKT_NO]
    LOAD_RT,                 -- Load Rate [/ACCGO/E_LD_RATE]
    DIS_RT,                  -- Discharge Rate [/ACCGO/E_DS_RATE]
    CROP_SEASON_ID,          -- Crop Season ID [/ACCGO/E_CROP_SEASON_ID]
    DEL_PERIOD,              -- Delivery Period [/ACCGO/E_DEL_PERIOD]
    DEL_PERIOD_END,          -- Delivery End Date [/ACCGO/E_DEL_PERIOD_END]
    SOURCE_LOC,              -- Source Location [/ACCGO/E_SOURCE_LOC]
    LOAD_RT_QTY,             -- Load Rate Quantity [/ACCGO/E_LD_RT_QTY]
    LOAD_RT_TIM,             -- Ld Rt Time UOM [/ACCGO/E_LD_RT_TM]
    DEL_PD_UOM,              -- Del Pd Time UOM [/ACCGO/E_DL_PD_UOM]
    DIS_RT_QTY,              -- Dis Rate Qty [/ACCGO/E_DIS_RT_QTY]
    DIS_RT_TIM,              -- Discharge Rate Tim [/ACCGO/E_DIS_RT_TM]
    LOAD_LOCATION,           -- Load Location [/ACCGO/E_LOAD_LOCATION]
    DISCHARGE_LOC,           -- Discharge Location [/ACCGO/E_DISCH_LOCATION]
    VKTRA,                   -- Mode of Transp. [VKTRA]
    MEANS_TRNSPT,            -- Means of Transport [/ACCGO/E_MEANS_ID]
    INCO_TERMS,              -- Incoterms [INCO1]
    DELETION_FLAG,           -- Delete [/ACCGO/E_DEL_FLAG]
    ALTERNATE_VENDOR,        -- Alternate Vendor Fla [/ACCGO/ALTER_VENDOR_FLAG]
    EVNT_ACTUAL_DATE,        -- Date [DATS]
    EVNT_ACTUAL_TIME,        -- Field of type TIMS [TIMS]
    EVNT_ACTUAL_ON,          -- Event On [/ACCGO/E_EVENT_ACTUAL_ON]
    EV_ACTION,               -- Evnt Rel. Action [/ACCGO/E_UIS_EVNT_REL_ACT]
    EV_BIN,                  -- Storage Bin [LGPLA]
    EV_STORAGE,              -- Location [LGORT_D]
    COMMENTS,                -- Comments [/ACCGO/E_COMMENT]
    RELEASED_BY,             -- Evnt Released By [/ACCGO/E_EVNT_RELEASED_BY]
    RELEASED_DATE,           -- Date [DATS]
    RELEASED_TIME,           -- Field of type TIMS [TIMS]
    REL_WGT_QREP_GUID,       -- Rel Wgt QREP GUID [/ACCGO/REL_WGT_QREP_GUID]
    REL_WGT_QREP_VERSION,    -- Rel Wgt Version [/ACCGO/REL_WGT_QREP_VER]
    CAR_LOT_RELEVANT,        -- Checkbox [XFELD]
    POSTING_DATE,            -- Local date [SYSTDATLO]
    DPA_NUMBER,              -- Del&Pay.Auth Number [/ACCGO/E_DPA_NUM]
    VKORG,                   -- Sales Org. [VKORG]
    VTVEG,                   -- Distr. Channel [VTWEG]
    SPART,                   -- Division [SPART]
    INCOTERM_UPS,            -- Incoterms [INCO1]
    AUTO_INCOTERM,           -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    WERKS,                   -- Plant [WERKS_D]
    CREATED_BY,              -- Created By [/ACCGO/E_CREATED_BY]
    CREATED_ON,              -- Created On [/ACCGO/E_CREATED_ON]
    CHANGED_BY,              -- Changed By [/ACCGO/E_CHANGED_BY]
    CHANGED_ON,              -- Changed On [/ACCGO/E_CHANGED_ON]
    ITEM,                    -- Item [POSNR]
    PART_WT_IND,             -- Partial Weight [/ACCGO/E_PART_WT]
    LDC_OBJNR,               -- Object number [J_OBJNR]
    CA_DATE,                 -- Comm Avail Dt [/ACCGO/E_COMMODITY_DATE]
    SDM_VERSION,             -- SDM Version field [/ACCGO/E_SDM_VERSION]
    PRIMARY KEY (MANDT, UIS_EVNT_KEY)
);

Learn More