LDC

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 LDC (
    UIS_EVNT_KEY,
    UIS_KEY,
    ACCNT_ADDR_FLAG,
    ALTERNATE_VENDOR,
    APPL_INSTR,
    BARGE_ID,
    BLOCK_VSPLT,
    BOL,
    BOL_DATE,
    BOOKING_NO,
    CAR_LOT_RELEVANT,
    CHANGED_BY,
    CHANGED_ON,
    COMMENTS,
    CREATED_BY,
    CREATED_ON,
    CROP_SEASON_ID,
    CUSTOMER,
    DEL_ID,
    DEL_ITEM,
    DEL_PD_UOM,
    DEL_PERIOD,
    DEL_PERIOD_END,
    DELETION_FLAG,
    DESCR,
    DIS_RT,
    DIS_RT_QTY,
    DIS_RT_TIM,
    DISCHARGE_LOC,
    DISPUTE_STATUS,
    DPA_NUMBER,
    DRIVER_ID,
    EV_ACTION,
    EV_BIN,
    EV_STORAGE,
    EVENT_TYPE,
    EVNT_ACTUAL_DATE,
    EVNT_ACTUAL_ON,
    EVNT_ACTUAL_TIME,
    EVNT_LOC,
    EVNT_LOC_TYP,
    EXT_IDENTIFIER,
    EXT_UIS_ID,
    FINAL_DELIVERY,
    GOODS_MOVMNT_IND,
    GOODS_SUPPLIER,
    GROUP_ID,
    GS_ADDR_FLAG,
    HDR_CHG_BY,
    HDR_CHG_ON,
    HDR_CRT_BY,
    HDR_CRT_ON,
    INCO_TERMS,
    INTER_INTRA_REL,
    ITEM,
    LDCEVENTKEY,
    LDCKEY,
    LEAD_CAR_NO,
    LICENSE,
    LOAD_LOCATION,
    LOAD_RT,
    LOAD_RT_QTY,
    LOAD_RT_TIM,
    LOADDATACAPTUREEVENTTYPE,
    MATERIAL,
    MEANS_OF_TRNSP,
    MEANS_TRNSPT,
    MERGE_ID,
    MERGE_KEY,
    MOT,
    NEW_VENDOR_FLAG,
    NO_OF_CARS,
    NOM_ID,
    NOM_ITEM,
    NOM_KEY,
    OBJNR,
    ON_ACC_OF,
    PARENT_KEY,
    PLANNED_UNLOAD_LOC,
    PLANNED_UNLOAD_LOC_TYP,
    PO_ID,
    PO_ITEM,
    POSTING_DATE,
    PURCHASE_ORG,
    REC_LOC,
    REC_LOC_TYP,
    RELEASED_BY,
    RELEASED_DATE,
    RELEASED_TIME,
    SCALP_REL,
    SO_ID,
    SO_ITEM,
    SOURCE_LOC,
    SPECIFIC_MATNR,
    SPLIT_PROFILE,
    STO_ID,
    STO_ITEM,
    STORAGE_AGREEMENT,
    STORAGE_AGREEMENT_ITEM,
    TC_ID,
    TC_ITEM,
    TICKET,
    TICKET_RC,
    TRACE_ID,
    TRADINGCONTRACT,
    TRADINGDOCUMENTITEM,
    TRNSP_GRP,
    UIS_ID,
    UIS_TYPE,
    VEHICLE_ID,
    VENDOR,
    VENDOR_ADDR_FLAG,
    VENDOR_SPLIT_TYPE,
    VESSEL_ID,
    VKTRA,
    WERKS,
    PRIMARY KEY (UIS_EVNT_KEY, UIS_KEY)
);