WLF_D_FCAITEM_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_FRTCOSTALLOCITMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WLF_D_FCAITEM_D (
    MANDT,                          -- Client [mandt]
    FREIGHTCOSTALLOCATIONDOCUMENT,  -- Freight Cost Allocation Document [wlf_fcadoc_wbeln]
    FRTCOSTALLOCDOCUMENTITEM,       -- Item [wposnr_lf]
    DRAFTUUID,                      -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                -- Draft Document ID [sdraft_uuid]
    FRTCOSTALLOCDOCCURRENCY,        -- Doc. Currency [waerl]
    PRICINGDOCUMENT,                -- Document Condition [wlf_knumv]
    PRODUCT,                        -- Product [productnumber]
    PRODUCTGROUP,                   -- Product Group [productgroup]
    PLANT,                          -- Plant [werks_d]
    INVENTORYVALUATIONTYPE,         -- Valuation Type [bwtar_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]
    PRODUCTPURCHASEPOINTSQTYUNIT,   -- Points Unit [punei]
    PRODUCTPURCHASEPOINTSQTY,       -- Points [anzpu]
    FRTCOSTALLOCITEMGROSSAMOUNT,    -- Gross Amount of Item [wlf_itm_gross_amt]
    FRTCOSTALLOCITEMNETAMOUNT,      -- Net Amount of Item [wlf_itm_net_amt]
    FRTCOSTALLOCSUBTOTAL1AMOUNT,    -- Subtotal 1 Amount [wlf_kzwi1]
    FRTCOSTALLOCSUBTOTAL2AMOUNT,    -- Subtotal 2 Amount [wlf_kzwi2]
    FRTCOSTALLOCSUBTOTAL3AMOUNT,    -- Subtotal 3 Amount [wlf_kzwi3]
    FRTCOSTALLOCSUBTOTAL4AMOUNT,    -- Subtotal 4 Amount [wlf_kzwi4]
    FRTCOSTALLOCSUBTOTAL5AMOUNT,    -- Subtotal 5 Amount [wlf_kzwi5]
    FRTCOSTALLOCSUBTOTAL6AMOUNT,    -- Subtotal 6 Amount [wlf_kzwi6]
    FRTCOSTALLOCEFFCTVITEMAMOUNT,   -- Effective Amnt [wlf_effwr]
    FRTCOSTALLOCITMSTSTCLPRPTY,     -- Statistical Prpty [wlf_wkowrr]
    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,            -- Source Document Category [wlf_fcadoc_srce_doc_cat]
    SETTLMTSOURCEDOCFISCALYEAR,     -- Fiscal Year of Source Document [wlf_source_fiscal_year]
    FRTCOSTALLOCITMACTIVITYREASON,  -- Activity Reason [wfgru]
    FRTCOSTALLOCDOCITEMTEXT,        -- Short Text [txz01]
    SUPPLIERPRODUCTID,              -- Supp. Mat. No. [idnlf]
    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]
    INCOTERMSVERSION,               -- Inco. Version [incov]
    INCOTERMSCLASSIFICATION,        -- Incoterms [inco1]
    INCOTERMSTRANSFERLOCATION,      -- Incoterms 2 [inco2]
    INCOTERMSLOCATION1,             -- Inco. Location1 [inco2_l]
    INCOTERMSLOCATION2,             -- Inco. Location2 [inco3_l]
    BATCH,                          -- Batch [charg_d]
    PRCDETNISINCMPLT,               -- Price Determination Is Incomplete [wlf_prc_detn_is_incmplt]
    SETTLMTPRECDGDOC,               -- Pre. Document [wbeln_v]
    SETTLMTPRECDGDOCITEM,           -- Item of Preceding Document [wlf_settlmt_precdg_doc_item]
    SETTLMTPRECDGDOCCAT,            -- Preceding Document Category [wlf_fcadoc_precdg_doc_cat]
    SETTLMTPRECDGDOCFISCALYEAR,     -- Fiscal Year of Preceding Document [wlf_precdg_fiscal_year]
    FRTCOSTALLOCDOCITMCAT,          -- Item Category [wshkzg]
    SETTLMTITEMRELTDPURGDOC,        -- ItmRelatedPurgDoc [wlf_item_related_ebeln]
    SETTLMTITEMRELTDPURGDOCITEM,    -- ItmRelatedPurgDocItm [wlf_related_ebelp]
    SETTLMTITEMRELTDBILLGDOC,       -- ItmRelatedBillingDoc [wlf_item_related_vbeln]
    SETTLMTITEMRELTDBILLGDOCITEM,   -- ItmReltdBillgDocItm [wlf_related_posnr]
    FREIGHTCOSTALLOCATIONORDER,     -- Order [wlf_suplr_aufnr]
    SERVICESRENDEREDDATE,           -- Services Rendered Date [wlf_fbuda]
    COMPANYCODE,                    -- Company Code [fis_bukrs]
    GLACCOUNT,                      -- G/L Account [fis_racct]
    FISCALYEAR,                     -- Fiscal Year of Settlement [wb2_ccs_gjahr_no_cnext]
    FRTCOSTALLOCREFDOCTYPE,         -- Settlement Reference Document Type [wlf_ref_doc_type]
    FRTCOSTALLOCREFDOC,             -- Settlmt. Ref. Doc. [wlf_ref_doc_number]
    FRTCOSTALLOCREFDOCFSCLYR,       -- Year of Reference Document [wlf_ref_doc_year_no_cnext]
    FRTCOSTALLOCREFDOCLGCLSYST,     -- SM Ref Log Sys [wlf_ref_log_sys]
    FRTCOSTALLOCREFDOCCOMPANYCODE,  -- Ref. Company Code [wlf_ref_company_code]
    FRTCOSTALLOCREFDOCITEM,         -- SettlmtRefDocItem [wlf_ref_item_number]
    FRTCOSTALLOCREFDOCCAT,          -- SettlmtRefDocCat [wlf_ref_type]
    FRTCOSTALLOCADDLREFDOCTYPE,     -- Additional Reference Doc Type in Settlmt [wlf_ref_doc_type_2]
    FRTCOSTALLOCADDLREFDOC,         -- SettlmtAddlRefDoc [wlf_ref_doc_number_2]
    FRTCOSTALLOCADDLREFDOCFSCLYR,   -- Year of Additional Reference Document [wlf_ref_doc_year_2_no_cnext]
    FRTCOSTALLOCADDLREFLGCLSYST,    -- SM Addl Ref Log Sys [wlf_ref_log_sys_2]
    FRTCOSTALLOCADDLREFDOCITEM,     -- SettlmtAddlRefDocItm [wlf_ref_item_number_2]
    FRTCOSTALLOCADDLREFDOCCAT,      -- SettlmtAddlRefDocCat [wlf_ref_type_2]
    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]
    PRIMARY KEY (MANDT, FREIGHTCOSTALLOCATIONDOCUMENT, FRTCOSTALLOCDOCUMENTITEM, DRAFTUUID)
);