EWA_WA_WEIGHPROC

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.

-- Weighing Transaction
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EWA_WA_WEIGHPROC (
    MANDT,              -- Client [MANDT]
    WEIGHINGNR,         -- Weighing Trans. [EWAWA_WEIGHINGNR]
    APPROVAL_RECN,      -- GUID Nr. Identifi. [EWAEL_RECN_UUID_32]
    APPROVAL_ACTN,      -- GUID Nr. Action [EWAEL_ACTN_UUID_32]
    CAR,                -- Equ. Nr. Vehicle [EWAEL_EQUNR_CAR]
    TRAILER,            -- Equ. Nr. Trailer [EWAEL_EQUNR_TRAILER]
    TREATMENT,          -- Waste Treatment [EWAEL_TREATMENT]
    ORDERNR,            -- WD Order [EORDERNR]
    WCNT,               -- Cons.No.WghData [EWEIGHCNT]
    EXT_ID,             -- Ext. No. WDR [EWEIGHEXTID]
    WASTE,              -- Waste [WASTE_TYPE]
    LICENSE_NUM,        -- License Plate [LICENSE_NUM]
    GROSS_ID,           -- Gross Weigh.No. [EWEIGHID_GROSS]
    GROSS_WDATE,        -- Date Gross [EWEIGHDATE_GROSS]
    GROSS_WTIME,        -- Time Gross [EWEIGHTIME_GROSS]
    GROSS_WEIGHT,       -- Gross Weight [EWEIGHT_GROSS]
    GROSS_SCALE,        -- Gross weight [ESCALE_GROSS]
    TARE_ID,            -- Wt No. Empty [EWEIGHID_TARE]
    TARE_WDATE,         -- Date Tare [EWEIGHDATE_TARE]
    TARE_WTIME,         -- Time Tare [EWEIGHTIME_TARE]
    TARE_WEIGHT,        -- Tare Weight [EWEIGHT_TARE]
    TARE_SCALE,         -- Empty-weight [ESCALE_TARE]
    WEIGHT_UNIT,        -- Unit of weight [WEIGHT_UNIT]
    NET_WEIGHT,         -- Net Weight [EWEIGHT_NET]
    VOLUME,             -- Waste volume [EVOLUME]
    VOL_UNIT,           -- Volume unit [VOL_UNIT]
    ANALYSE,            -- Waste Analysis [EWEIGH_ANALYSE]
    WDPLANT,            -- WD Facility [EWAEL_WDPLANTNR]
    WERKS,              -- Plant [WERKS_D]
    LGORT,              -- Location [LGORT_D]
    LGTYP_W,            -- Storage Type [LGTYP]
    LGPLA_W,            -- Storage Bin [LGPLA]
    STOCK_TYPE,         -- Stock Type [MB_INSMK]
    POBJNR,             -- Object Number [EWA_ODITEM_OBJ]
    PSTNG_DATE,         -- Posting Date [BUDAT]
    PROCESSTYPE,        -- Transact. Type [EWAEL_PROCESSTYPE]
    GM_FLAG,            -- Goods Mvmt Ind. [GM_FLAG]
    BILLING_FLAG,       -- Bill. Indicator [BILLING_FLAG]
    QUANTITY,           -- Quantity [EWADELWGHQUANTITY]
    QUANTITY_UNIT,      -- Unit [EWADELWGHQUANTITYUNIT]
    WDPLANT_DST,        -- Target Facility [EEWAD_WDPLANTNR_DST]
    WERKS_DST,          -- Target Plant [EEWAD_WERKS_DST]
    LGORT_DST,          -- Target Stor Loc [EEWAD_LGORT_DST]
    LGPLA_DST,          -- TargetStor.Loc. [EEWAD_LGPLA_DST]
    LGTYP_DST,          -- Targ.Stor.Type [EEWAD_LGTYP_DST]
    WASTE_REDECLARED,   -- Waste: Redeclaration [WASTE_TYPE_REDECLARED]
    GENERATOR_RECN,     -- Generator GUID Iden. [EWAEL_GEN_RECN_UUID_32]
    GENERATOR_ACTN,     -- Generator GUID Act. [EWAEL_GEN_ACTN_UUID_32]
    TRANSPORTER_RECN,   -- Transport. GUID Iden [EWAEL_TRA_RECN_UUID_32]
    TRANSPORTER_ACTN,   -- Transporter GUID Act [EWAEL_TRA_ACTN_UUID_32]
    DISPOSER_RECN,      -- Disposer GUID Ident. [EWAEL_DIS_RECN_UUID_32]
    DISPOSER_ACTN,      -- Disposer GUID Action [EWAEL_DIS_ACTN_UUID_32]
    VSTELLE,            -- Premise [VSTELLE]
    SERVLOC,            -- Container Loc. [SERVLOC]
    ZTERM,              -- Pyt Terms [DZTERM]
    ZTAGG,              -- Day Limit [DZTAGG_052]
    KUNNR,              -- Customer [KUNNR]
    LOAD_TIME_BEGIN,    -- Load. Time From [EWAEL_LOAD_TIME_BEGIN]
    LOAD_TIME_END,      -- Loading Time To [EWAEL_LOAD_TIME_END]
    UNLOAD_TIME_BEGI,   -- Unload.Tme.From [EWAEL_UNLOAD_TIME_BEGIN]
    UNLOAD_TIME_END,    -- Unload.Time To [EWAEL_UNLOAD_TIME_END]
    KAPID,              -- Capacity ID [KAPID]
    VERSN,              -- Version [KAPVERSION]
    DATUB,              -- End Date [ENDDA]
    TAGNR,              -- Weekday number [CR_TAGNR]
    SCHNR,              -- Capacity Shift [SCHICHTNR]
    SCHDATUM,           -- Shift Date [EWAEL_SCHDATUM]
    SCHUZEIT,           -- Time [EWAEL_SCHUZEIT]
    VERTRAG,            -- Contract [VERTRAG]
    DISPATCHNOTE,       -- GUID Note [EWAEL_NOTE_UUID_32]
    BUCHDATUM,          -- Posting Date [EWAWA_BUCHDATUM]
    CAR_CONT_NR,        -- Vh. Con. Mat. Nr. [EWAEL_MATNR_CAR]
    CAR_CONT_COUNT,     -- Veh. Con. Number [EWAWA_CONTCOUNT_CAR]
    TRLR_CONT_NR,       -- Tra. Con. Mat. Nr. [EWAEL_MATNR_TRLR]
    TRLR_CONT_COUNT,    -- Trai.Con.Number [EWAWA_CONTCOUNT_TRLR]
    MBLNR,              -- Material Doc. [MBLNR]
    MJAHR,              -- Mat. Doc. Year [MJAHR]
    VBELN,              -- SD Document [VBELN]
    BRUTTO_WEIGHT,      -- Gross Weight [EWEIGHT_GROSS]
    BRUTTO_UNIT,        -- Unit of weight [WEIGHT_UNIT]
    TARA_WEIGHT,        -- Tare Weight [EWEIGHT_TARE]
    TARA_UNIT,          -- Unit of weight [WEIGHT_UNIT]
    NETTO_WEIGHT,       -- Net Weight [EWEIGHT_NET]
    CONTRACT_VBELN,     -- Sales Document [VBELN_VA]
    CONTRACT_POSNR,     -- Item [POSNR_VA]
    GEMARK,             -- Loc Subdistrict [VVGEMARK]
    NFLURNR,            -- Tract of Land [NFLURNR]
    XFLURST,            -- Parcel of Land [XFLURST]
    GUARANTOR,          -- Guarantor Ctr. [E_GUARANTOR_CONTRACT]
    WEIGHING_TYPE,      -- Weigh.Data Type [WEIGHING_TYPE]
    STORNO,             -- Reversal [EWEIGHSTORNO]
    WDPPROTYNR,         -- Transact. Cat. [EWAEL_WDPPROTYNR]
    WDPPROCNR,          -- Number [EWAEL_WDPPROCNR]
    WAKEYIDE,           -- Waste Code [EHS_WAKEYIDE]
    RECNWAKEY,          -- Waste Code [EHS_WAKEY]
    WAKEYCATLG,         -- Waste Catalog [EHS_WAKEYCATLG]
    CHARG,              -- Batch [CHARG_D]
    FLAG_TARA,          -- Maint.Tare Man. [FLAG_TARA]
    GMFLAG_DONE,        -- Goods Movement [GMFLAG_DONE]
    BILLINGFLAG_DONE,   -- Bill. Indicator [BILLINGFLAG_DONE]
    LGNUM,              -- Warehouse No. [LGNUM]
    LGTYP,              -- Storage Type [LGTYP]
    LGPLA,              -- Storage Bin [LGPLA]
    WDPLANTORDERTYPE,   -- OrdTyp.WstDspFa [EWAEL_WDPLANTORDERTYPE]
    TR_LICENSE_NUM,     -- Lic.Pl.Nr.:Trailer [EWAEL_LICENSE_NUM_TR]
    SPLITT_CANCELED,    -- Split. Canceled [SPLITTING_CANCELED]
    NOTE,               -- Description [EWAEL_DESCRIPTION]
    COBELDAT,           -- CO Posting Date [EWADCOBELDAT]
    FEE,                -- Weighing Fee [EWAWA_WEIGHFEE]
    CUSTADDRNUM,        -- Address Number [AD_ADDRNUM]
    DEVGRPNR_TARE,      -- Profile Group: Tare [EWAWA_DEVICEGROUPNR_TARE]
    DEVGRPNR_GROSS,     -- Profile Group:Gross [EWAWA_DEVICEGROUPNR_GROSS]
    GROSSINFOID,        -- Wgh. Data Gross [EWADWA_GROSSINFOID]
    TAREINFOID,         -- Wghng Data Tare [EWADWA_TAREINFOID]
    BILLING_TYPE,       -- Flag Payment Transa. [EWAWA_BILLING_TYPE]
    DELIVERYTYPE,       -- intern./extern. [EWADWA_WEIGHPROCINTEXT]
    OBJNR,              -- Object number [J_OBJNR]
    WEIGHINGNR_LEAD,    -- Leading Weigh.Trans. [EWAWA_WEIGHINGNR_LEAD]
    WEIGHINGNR_EXT,     -- Fac-Rel.Weigh.Number [EWAWA_DWEIGHINGNR_EXT]
    WEIGHINGNR_SPLIT,   -- Wei.Tran.(Splitting) [EWAWA_WEIGHINGNR_SPLIT]
    MATSPLIT_LAUFNR,    -- Serial Split No [EWADWASPLIT_LAUFNR]
    MATSPLIT_PRZ_FLAG,  -- Percentage Flag [EWADWA_PROCFLAG]
    MATSPLIT_PROCENT,   -- Percentage [EWADWA_PROCENT]
    MATSPLIT_TYPE,      -- MatSplitTyp [EWADWA_MATSPLITTYPE]
    NETINFOID,          -- Weighing Info Net [EWADWA_NETINFOID]
    BEH_TYPE_DEDUCT,    -- Container cat. [BEH_TYPE]
    MINNETWEIGHT_FLAG,  -- MinimunNetWeightFlag [EWADWA_MINNETWEIGHTFLAG]
    DEVGROUPNR_MANUAL,  -- Hardware Prof. Group [EWAWA_DEVICEGROUPNR]
    VOLSPLIT_PROCENT,   -- Percentage [EWADWA_PROCENT_VOL]
    PRIMARY KEY (MANDT, WEIGHINGNR)
);