WLF_D_SDOCITEM_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_SETTLMTDOCITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WLF_D_SDOCITEM_D (
    MANDT,                           -- Client [mandt]
    SETTLMTDOC,                      -- Settlement Doc. [wbeln_zr]
    SETTLMTDOCITEM,                  -- Item [wposnr_lf]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                 -- Draft Document ID [sdraft_uuid]
    SETTLMTDOCCURRENCY,              -- Doc. Currency [waerl]
    SUPPLIERPRICINGDOCUMENT,         -- Supplier Document Condition [wlf_knumv_k]
    CUSTOMERPRICINGDOCUMENT,         -- Customer Document Condition [wlf_knumv_d]
    PRODUCT,                         -- Product [productnumber]
    PRODUCTGROUP,                    -- Product Group [productgroup]
    PLANT,                           -- Plant [werks_d]
    SUPPLIERTAXCODE,                 -- Supplier Tax Code [wlf_mwskz_k]
    CUSTOMERTAXCODE,                 -- Customer Tax Code [wlf_mwskz_d]
    SUPLRSETTLMTTXRATEVALDFRMDATE,   -- Supplier Tax Rate Valid-From [wlf_fot_txdat_from_k]
    CUSTSETTLMTTXRATEVALDFRMDATE,    -- Customer Tax Rate Valid-From [wlf_fot_txdat_from_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]
    SUPPLIERITEMGROSSAMOUNT,         -- Supplier Item Gross Amount [wlf_brtwr_lfp]
    SUPPLIERITEMNETAMOUNT,           -- Supplier Item Net Amount [wlf_netwr_lfp]
    SUPPLIERREBATEBASISAMOUNT,       -- Suplr Rebate Basis [wlf_suplr_bonba]
    SUPPLIEREFFECTIVEITEMAMOUNT,     -- Supplier Effective Item Amount [wlf_effwr_k]
    SUPLRITMELIGIBLEAMTFORCSHDISC,   -- Csh.Disc.Bas [skfbp]
    SUPPLIERITEMTAXAMOUNT,           -- Suplr Item Tax Amnt [wlf_suplr_mwsbp]
    CUSTOMERITEMGROSSAMOUNT,         -- Customer Item Gross Amount [wlf_brtwrd_lfp]
    CUSTOMERITEMNETAMOUNT,           -- Customer Item Net Amount [wlf_netwrd_lfp]
    CUSTOMERREBATEBASISAMOUNT,       -- Cust Rebate Basis [wlf_cust_bonba]
    CUSTOMEREFFECTIVEITEMAMOUNT,     -- Customer Effective Item Amount [wlf_effwr_d]
    CUSTITMELIGIBLEAMTFORCSHDISC,    -- Cash Disc. Base [skfbpd]
    CUSTOMERITEMTAXAMOUNT,           -- Customer Item Tax Amount [wlf_cust_mwsbp]
    SETTLMTITMSTATISTICALPRPTY,      -- Statistical Prpty [wlf_wkowrr]
    CASHDISCOUNTISDEDUCTIBLE,        -- Cash Discount [sktof]
    CREATEDBYUSER,                   -- Created By [wlf_created_by]
    CREATIONDATE,                    -- Created On [wlf_created_on]
    CREATIONTIME,                    -- Created At [wlf_created_at]
    SETTLMTSOURCEDOC,                -- Source Doc. [wbelnv]
    SETTLMTSOURCEDOCITEM,            -- Item of the Source Document [wlf_settlmt_source_doc_item]
    SETTLMTSOURCEDOCCAT,             -- SourceDocCat [wftypv]
    SETTLMTSOURCEDOCFISCALYEAR,      -- Fiscal Year of Source Document [wlf_source_fiscal_year]
    SETTLMTITEMACTIVITYREASON,       -- Activity Reason [wfgru]
    SETTLMTDOCITEMTEXT,              -- Short Text [txz01]
    SUPPLIERPRODUCTID,               -- Supp. Mat. No. [idnlf]
    TAXJURISDICTION,                 -- Tax Jurisdiction [fis_txjcd]
    INTERCOMPANYTAXJURISDICTION,     -- Tax Jur Intercompany [wlf_txjcd_ic]
    PRODUCTPURCHASEPOINTSQTYUNIT,    -- Points Unit [punei]
    PRODUCTPURCHASEPOINTSQTY,        -- Points [anzpu]
    PRIORSUPPLIER,                   -- Prior Supplier [kolif]
    NONDEDUCTIBLEINPUTTAXAMOUNT,     -- Non-deductible [navnw]
    INVENTORYVALUATIONTYPE,          -- Valuation Type [bwtar_d]
    SUPLRSETTLMTBUSINESSAREA,        -- Business Area [fis_rbusa]
    CUSTSETTLMTBUSINESSAREA,         -- Cust. Business Area [wlf_gsber_customer]
    SUPLRSETTLMTCONTROLLINGAREA,     -- Controlling Area [fis_kokrs]
    SUPLRSETTLMTCOSTCENTER,          -- Cost Center [fis_kostl]
    SUPLRSETTLMTPROFITCENTER,        -- Profit Center [fis_prctr]
    INCOTERMSVERSION,                -- Inco. Version [incov]
    INCOTERMSCLASSIFICATION,         -- Incoterms [inco1]
    INCOTERMSLOCATION1,              -- Inco. Location1 [inco2_l]
    INCOTERMSLOCATION2,              -- Inco. Location2 [inco3_l]
    CUSTSETTLMTCONTROLLINGAREA,      -- Customer Ctrl Area [wlf_kokrs_customer]
    CUSTSETTLMTCOSTCENTER,           -- Cust Cost Ctr [wlf_kostl_customer]
    CUSTSETTLMTPROFITCENTER,         -- Cust. Profit Center [wlf_prctr_customer]
    BATCH,                           -- Batch [charg_d]
    SUPPLIERPRCDETNISINCMPLT,        -- Supplier Pricing Elements Incomplete [wlf_suplr_wuvprs]
    CUSTOMERPRCDETNISINCMPLT,        -- Customer Pricing Elements Incomplete [wlf_cust_wuvprs]
    SETTLMTPRECDGDOC,                -- Pre. Document [wbeln_v]
    SETTLMTPRECDGDOCITEM,            -- Item of Preceding Document [wlf_settlmt_precdg_doc_item]
    SETTLMTPRECDGDOCCAT,             -- PreDocCat [wftyp_v]
    SETTLMTPRECDGDOCFISCALYEAR,      -- Fiscal Year of Preceding Document [wlf_precdg_fiscal_year]
    SETTLMTDOCITEMCAT,               -- Item Category [wshkzg]
    SETTLMTITEMRELTDREFDOCCAT,       -- Settlement Item Related Ref. Doc. Cat. [wlf_settlmt_itm_rel_refdoc_cat]
    SETTLMTITEMRELTDREFDOC,          -- Settlement Item Related Reference Doc. [wlf_settlmt_itm_rel_refdoc]
    SETTLMTITEMRELTDREFDOCITEM,      -- Settlement Item Related Ref. Doc. Item [wlf_settlmt_itm_rel_refdoc_itm]
    SETTLMTITEMRELTDCNDNCONTR,       -- ItmRelatedCndnContr [wlf_item_related_coco_num]
    SETTLMTDOCITEMSTATUS,            -- Status [wlf_item_status]
    SETTLMTDOCITEMCANCLD,            -- Item Canceled [wlf_item_canceled]
    SUPPLIERSETTLEMENTORDER,         -- Order [wlf_suplr_aufnr]
    SUPPLIERITEMSETTLMTSTATUS,       -- Sttlmnt Sts Itm Sup. [wlf_settlement_status_item_v]
    CUSTOMERITEMSETTLMTSTATUS,       -- Settlmt StatusItemCu [wlf_settlement_status_item_c]
    SUPPLIERITEMSETTLMTBLKGREASON,   -- Supplier Settlement Item Blocking Reason [wlf_settlement_block_item_v]
    CUSTOMERITEMSETTLMTBLKGREASON,   -- Customer Settlement Item Blocking Reason [wlf_settlement_block_item_c]
    ITEMSETTLMTRELEVANCE,            -- Itm Sttlm Relevance [wlf_settlement_item_relevance]
    SERVICESRENDEREDDATE,            -- Services Rendered Date [wlf_fbuda]
    SUPLRSETTLMTCOMPANYCODE,         -- Suppl. Company Code [wlf_suplr_bukrs]
    GLACCOUNT,                       -- G/L Account [fis_racct]
    SETTLEMENTFISCALYEAR,            -- Fiscal Year of Settlement [wb2_ccs_gjahr_no_cnext]
    HIGHERLEVELITEM,                 -- Higher-Lev.Item [uepos]
    LOWERLEVELITEMEXISTS,            -- Subitems [wlf_posnr_sub_exist]
    ITEMDISTRIBUTIONSTATUS,          -- Distributn Status [wlf_distribution_status]
    SETTLMTREFDOCTYPE,               -- Settlement Reference Document Type [wlf_ref_doc_type]
    SETTLMTREFDOC,                   -- Settlmt. Ref. Doc. [wlf_ref_doc_number]
    SETTLMTREFDOCITEM,               -- SettlmtRefDocItem [wlf_ref_item_number]
    SETTLMTREFDOCFISCALYEAR,         -- Year of Reference Document [wlf_ref_doc_year_no_cnext]
    SETTLMTREFDOCLOGICALSYST,        -- SM Ref Log Sys [wlf_ref_log_sys]
    SETTLMTREFDOCCOMPANYCODE,        -- Ref. Company Code [wlf_ref_company_code]
    SETTLMTREFDOCCAT,                -- SettlmtRefDocCat [wlf_ref_type]
    ITEMINTRASTATRELEVANCE,          -- Item Intrastat Relevance [wlf_itm_intrastat_relevant_cat]
    CUSTOMERSETTLEMENTORDER,         -- Customer Order [wlf_aufnr_customer]
    SUPLRSETTLMTWBSELMNTINTERNALID,  -- WBS Element [wlf_psp_pnr_no_cnext]
    CUSTSETTLMTWBSELMNTINTERNALID,   -- Customer WBS Element [wlf_ps_psp_pnr_cust_no_cnext]
    SETTLMTDOCITEMCOLLSTS,           -- Collective Settlement Status Item [wlf_collection_status_item]
    COLLSETTLMTITEMBLKGREASON,       -- Collective Settlement Item Block Reason [wlf_collection_block_item]
    ITMSETTLMTDOCCOLLRELEVANCE,      -- Collective Settlement Relevance [wlf_collection_relevance]
    SETTLMTADDLREFDOCTYPE,           -- Additional Reference Doc Type in Settlmt [wlf_ref_doc_type_2]
    SETTLMTADDLREFDOC,               -- SettlmtAddlRefDoc [wlf_ref_doc_number_2]
    SETTLMTADDLREFDOCFISCALYEAR,     -- Year of Additional Reference Document [wlf_ref_doc_year_2_no_cnext]
    SETTLMTADDLREFDOCLOGICALSYST,    -- SM Addl Ref Log Sys [wlf_ref_log_sys_2]
    SETTLMTADDLREFDOCITEM,           -- SettlmtAddlRefDocItm [wlf_ref_item_number_2]
    SETTLMTADDLREFDOCCAT,            -- SettlmtAddlRefDocCat [wlf_ref_type_2]
    CUSTOMERSETTLMTRECIPIENT,        -- Cust Settlmt Recpnt [wlf_cust_settlmt_recpnt]
    SUPPLIERSUBRANGE,                -- Suppl. Subrange [ltsnr]
    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]
    BUSVOLDOCSALESORGANIZATION,      -- Sales Org in Business Volume Document [wlf_bvdoc_sales_org]
    BUSVOLDOCDISTRIBUTIONCHANNEL,    -- Distr Chnl in Business Volume Document [wlf_bvdoc_distr_chnl]
    BUSVOLDOCDIVISION,               -- Division in Business Volume Document [wlf_bvdoc_division]
    PRODUCTCOMMISSIONGROUP,          -- Commission Grp [provg]
    PRICESPECIFICATIONPRODUCTGROUP,  -- Prd.Price Grp [pricespecificationproductgroup]
    SALESVOLUMEREBATEGROUP,          -- Volume Rebate Group [wlf_rebate_grp_sls]
    INTERCOMPANYTAXCOUNTRY,          -- Tax Ctry/Reg. Intercompany [wlf_fot_tax_country]
    TAXCOUNTRY,                      -- Tax Ctry/Reg. [fot_tax_country]
    SETTLMTDOCITEMCHANGESTATE,       -- Item Change State [wlf_change_state_item]
    PRIMARY KEY (MANDT, SETTLMTDOC, SETTLMTDOCITEM, DRAFTUUID)
);