MOV

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 MOV (
    BATCH,
    BUSINESSPLACE,
    CHARTOFACCOUNTS,
    CNSMPNLATESTPOSTGDATE,
    COMPANYCODE,
    COSTESTIMATE,
    CURRENCY,
    CUSTOMER,
    INVENTORYPRICE,
    INVENTORYSTOCKTYPE,
    MATERIAL,
    MATERIALBASEUNIT,
    MATERIALGROUP,
    MATERIALGROUPNAME,
    MATERIALNAME,
    MATERIALPRICEUNITQTY,
    MATERIALTYPE,
    MATERIALTYPENAME,
    MATLDOCLATESTPOSTGDATE,
    MATLWRHSSTKQTYINMATLBASEUNIT,
    NUMBEROFDAYSSINCELASTCNSMPN,
    NUMBEROFDAYSSINCELASTMOVEMENT,
    PLANT,
    PLANTNAME,
    SDDOCUMENT,
    SDDOCUMENTITEM,
    SPECIALSTOCKIDFGSTOCKOWNER,
    STOCKVALUEINCCCRCY,
    STORAGELOCATION,
    SUPPLIER,
    VALUATIONAREA,
    WBSELEMENTINTERNALID
);