NOMITEM

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 NOMITEM (
    NOMINATIONDOC,
    NOMINATIONDOCITEM,
    ACMNOMINATIONISDELTD,
    ACTUALSCHEDULEDQUANTITY,
    ACTUALSCHEDULEDQUANTITYUNIT,
    BATCHDESTINATIONLOCATION,
    BATCHORIGINLOCATION,
    CONFIRMEDNOMINATIONITEM,
    CONFIRMEDNOMINATIONNUMBER,
    CONSIGNEEPARTNER,
    CONTRACTPARTNER,
    DEMANDMATERIAL,
    IMPORTEXPORTPARTNER,
    ISIMPORTEXPORTPARTNER,
    ISNOMINATIONWORKLISTENTRY,
    LASTCHANGEDBYUSER,
    LOCATIONID,
    LOCATIONNAME,
    LOCATIONPARTNER,
    NOMINATIONCHANGEDDATE,
    NOMINATIONCREATEDBYUSER,
    NOMINATIONCREATIONDATE,
    NOMINATIONCREATIONTIME,
    NOMINATIONINSPECTOR,
    NOMINATIONISBLOCKED,
    NOMINATIONISINCOMPLETE,
    NOMINATIONISMARKEDFORDELETION,
    NOMINATIONITEMISCOMPLETE,
    NOMINATIONITEMSTATUS,
    NOMINATIONITEMSUBSTATUS,
    NOMINATIONREFDOCCODE,
    NOMINATIONREFERENCEDOCITEM,
    NOMINATIONREFERENCEDOCTYPE,
    NOMINATIONREFERENCEDOCUMENT,
    NOMINATIONSCHEDULEDATE,
    NOMINATIONSCHEDULETYPE,
    QUICKCONFIRM,
    SCHEDULEDBATCHENDDATETIME,
    SCHEDULEDBATCHSTARTDATETIME,
    SCHEDULEDQUANTITY,
    SCHEDULEDQUANTITYUNIT,
    VALUATIONTYPEDESTINATION,
    VALUATIONTYPEORIGIN,
    PRIMARY KEY (NOMINATIONDOC, NOMINATIONDOCITEM)
);