WLF_D_PSDOCITM_D

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.

-- Draft table for entity R_PERSSETTLMTDOCITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WLF_D_PSDOCITM_D (
    MANDT,                         -- Client [mandt]
    PERSONNELSETTLEMENTDOCUMENT,   -- Personnel Settlement Document [wlf_pers_settlmt_doc]
    PERSSETTLMTDOCITEM,            -- Item [wposnr_lf]
    DRAFTUUID,                     -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,               -- Draft Document ID [sdraft_uuid]
    PERSSETTLMTDOCCURRENCY,        -- Doc. Currency [waerl]
    PRICINGDOCUMENT,               -- Document Condition [wlf_knumv]
    PRODUCT,                       -- Product [productnumber]
    PRODUCTGROUP,                  -- Product Group [productgroup]
    PLANT,                         -- Plant [werks_d]
    PRICINGDATE,                   -- Pricing Date [prsdt]
    SETTLMTQUANTITY,               -- SettlmtQuantity [wfimg]
    SETTLMTQUANTITYUNIT,           -- Settlement Unit [wfkme]
    NETPRICEAMOUNT,                -- Net Price [wnetpr]
    NETPRICEQUANTITY,              -- Price Unit [weinh]
    NETPRICEQUANTITYUNIT,          -- SettlmtPrcUnit [wfprme]
    SETTLMTTOBASEQUANTITYNMRTR,    -- Numerator Settlement UoM to Base UoM [wlf_umwfz]
    SETTLMTTOBASEQUANTITYDNMNTR,   -- Denominator Settlement UoM to Base UoM [wlf_umwfn]
    SETTLMTTONETPRICEQTYNMRTR,     -- Numerator: Sett. UoM to Sett. Price UoM [wlf_wpumz]
    SETTLMTTONETPRICEQTYDNMNTR,    -- Denominator: Sett. UoM to Sett. PriceUoM [wlf_wpumn]
    BASEUNIT,                      -- Base Unit [meins]
    ITEMNETWEIGHT,                 -- Net Weight [wlf_ntgew_15]
    ITEMGROSSWEIGHT,               -- Gross Weight [wlf_brgew_15]
    ITEMWEIGHTUNIT,                -- Unit of Weight [gewei]
    ITEMVOLUME,                    -- Volume [wlf_volum_15]
    ITEMVOLUMEUNIT,                -- Volume Unit [voleh]
    ITEMNETAMOUNT,                 -- Net Amount of Item [wlf_itm_net_amt]
    SUBTOTAL1AMOUNT,               -- Subtotal 1 Amount [wlf_kzwi1]
    SUBTOTAL2AMOUNT,               -- Subtotal 2 Amount [wlf_kzwi2]
    SUBTOTAL3AMOUNT,               -- Subtotal 3 Amount [wlf_kzwi3]
    SUBTOTAL4AMOUNT,               -- Subtotal 4 Amount [wlf_kzwi4]
    SUBTOTAL5AMOUNT,               -- Subtotal 5 Amount [wlf_kzwi5]
    SUBTOTAL6AMOUNT,               -- Subtotal 6 Amount [wlf_kzwi6]
    REBATEBASISAMOUNT,             -- Rebate Basis Amount [wlf_bonba]
    PERSSETTLMTDOCITMSTSTCLPRPTY,  -- Statistical Prpty [wlf_wkowrr]
    CREATEDBYUSER,                 -- Created By [wlf_created_by]
    CREATIONDATE,                  -- Created On [wlf_created_on]
    CREATIONTIME,                  -- Created At [wlf_created_at]
    PERSSETTLMTDOCITMACTYREASON,   -- Activity Reason [wfgru]
    PERSSETTLMTDOCITEMTEXT,        -- Short Text [txz01]
    BUSINESSAREA,                  -- Business Area [fis_rbusa]
    CONTROLLINGAREA,               -- Controlling Area [fis_kokrs]
    COSTCENTER,                    -- Cost Center [fis_kostl]
    PROFITCENTER,                  -- Profit Center [fis_prctr]
    WBSELEMENTINTERNALID,          -- WBS Element [wlf_psp_pnr_no_cnext]
    PERSSETTLMTDOCORDER,           -- Order Acct Assgmt [wlf_aufnr]
    PRCDETNISINCMPLT,              -- Incmplt Price Detn [wlf_wuvprs]
    PERSSETTLMTDOCITEMCAT,         -- Item Category [wshkzg]
    SETTLMTITEMRELTDCNDNCONTR,     -- ItmRelatedCndnContr [wlf_item_related_coco_num]
    PERSSETTLMTDOCITEMSTATUS,      -- Status [wlf_item_status]
    PERSSETTLMTDOCITEMRVSD,        -- Item Canceled [wlf_item_canceled]
    SERVICESRENDEREDDATE,          -- Services Rendered Date [wlf_fbuda]
    SETTLEMENTFISCALYEAR,          -- Fiscal Year of Settlement [wb2_ccs_gjahr_no_cnext]
    COMPANYCODE,                   -- Company Code [fis_bukrs]
    GLACCOUNT,                     -- G/L Account [fis_racct]
    PRODUCTHIERARCHY,              -- Prod. Hierarchy [prodh_d]
    SALESSPCFCPRODUCTGROUP1,       -- Sales-Specific Product Group 1 [wlf_salesspcfcproductgroup1]
    SALESSPCFCPRODUCTGROUP2,       -- Sales-Specific Product Group 2 [wlf_salesspcfcproductgroup2]
    SALESSPCFCPRODUCTGROUP3,       -- Sales-Specific Product Group 3 [wlf_salesspcfcproductgroup3]
    SALESSPCFCPRODUCTGROUP4,       -- Sales-Specific Product Group 4 [wlf_salesspcfcproductgroup4]
    SALESSPCFCPRODUCTGROUP5,       -- Sales-Specific Product Group 5 [wlf_salesspcfcproductgroup5]
    BUSTRANSDOCREFERENCEID,        -- Item Ref. Doc. [wlf_ref_id]
    BUSTRANSDOCREFERENCEITEMID,    -- Item RefItemID [wlf_ref_item_id]
    PRIMARY KEY (MANDT, PERSONNELSETTLEMENTDOCUMENT, PERSSETTLMTDOCITEM, DRAFTUUID)
);