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]
    DRAFTENTITYCREATIONDATETIME,    -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_WBRP_INCL_EEW_PS,         -- Dummy [WBRP_INCL_EEW]
    PRIMARY KEY (MANDT, FREIGHTCOSTALLOCATIONDOCUMENT, FRTCOSTALLOCDOCUMENTITEM, DRAFTUUID)
);