P_FEE_DETAILS

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_FEE_DETAILS (
    MANDT,                    -- Client [MANDT]
    FEE_ID,                   -- Fee ID [/ACCGO/E_FEEID]
    VERSION,                  -- Fee Version [/ACCGO/E_FEE_VERSION]
    DOCTYPE,                  -- Document Level [/ACCGO/E_FEE_DOCTYPE]
    DOCID,                    -- Reference Doc. ID [/ACCGO/E_FEE_REFDOC_ID]
    DOCITEM,                  -- Reference Doc. Item [/ACCGO/E_FEE_REFDOCITEM]
    DOCSUBITEM,               -- RefDoc Sub-Item [/ACCGO/E_FEE_REFDOC_SUBITEM]
    DOCYEAR,                  -- Ref. Doc. Year [/ACCGO/E_FEE_REFDOC_YEAR]
    SEQUENCE_NO,              -- RefDoc Sequence No [/ACCGO/E_FEE_REFSEQUENCE_NO]
    SIDE,                     -- Side [WLF_PR_SIDE]
    FEE_OBSOLETE,             -- Fee Obsolete [/ACCGO/E_FEE_OBSOLETE]
    FEE_STORAGE,              -- Storage Fee [/ACCGO/E_FEE_STORAGE]
    FEE_MANUAL_CHG,           -- Manually Override [/ACCGO/E_FEE_MANUAL_CHG]
    ALLOC_MODE,               -- Allocation Mode [/ACCGO/E_FEE_MODE]
    VALID_STATUS,             -- Fee Valid Status [/ACCGO/E_FEE_VALID_STATUS]
    CALONGQ,                  -- Calc. on GrQty. [/ACCGO/E_FEE_GROSS_QTY]
    DUPLMSG,                  -- Notify On Duplicate [/ACCGO/E_FEE_DUPL_MSG]
    NOT_RELEVANT,             -- Not Rel for Prov. [/ACCGO/E_FEE_NOT_RELEVANT]
    FREE_ATT1,                -- Free Attribute [/ACCGO/E_FEE_FREE_ATTRIBUTE]
    FREE_ATT2,                -- Free Attribute [/ACCGO/E_FEE_FREE_ATTRIBUTE]
    FREE_ATT3,                -- Free Attribute [/ACCGO/E_FEE_FREE_ATTRIBUTE]
    FREE_ATT4,                -- Free Attribute [/ACCGO/E_FEE_FREE_ATTRIBUTE]
    FREE_ATT5,                -- Free Attribute [/ACCGO/E_FEE_FREE_ATTRIBUTE]
    FREE_ATT6,                -- Free Attribute [/ACCGO/E_FEE_FREE_ATTRIBUTE]
    FREE_ATT7,                -- Free Attribute [/ACCGO/E_FEE_FREE_ATTRIBUTE]
    FREE_ATT8,                -- Free Attribute [/ACCGO/E_FEE_FREE_ATTRIBUTE]
    FREE_ATT9,                -- Free Attribute [/ACCGO/E_FEE_FREE_ATTRIBUTE]
    FREE_ATT10,               -- Free Attribute [/ACCGO/E_FEE_FREE_ATTRIBUTE]
    ADD_GROSS,                -- Add to Gross [/ACCGO/E_FEE_ADD_GROSS]
    INCLD_NS,                 -- Incl. in NS [/ACCGO/E_FEE_INC_NS]
    REL_ACCRUAL,              -- Rel for Accrual [/ACCGO/E_FEE_REL_ACCRUAL]
    RATE_ASSIGN,              -- Rate on Assign [/ACCGO/E_FEE_RATE_ASSIGN]
    NON_MODIFIABLE,           -- Non. Mod. [/ACCGO/E_FEE_NON_MODIFIABLE]
    ACCRUAL_PURCHASE,         -- Accrual Time [/ACCGO/E_FEE_ACCR_TIME]
    ACCRUAL_TIME_SALES,       -- Accrual Time [/ACCGO/E_FEE_ACCR_TIME]
    REL_SEP_INVOICES,         -- Rel for Sep Invoices [/ACCGO/E_FEE_REL_SEP_INVOICE]
    REL_SEP_TIME,             -- SI Time [/ACCGO/E_FEE_SI_TIME]
    RATE_RAW,                 -- Fee Rate Raw [/ACCGO/E_FEE_RATE_RAW]
    RATE,                     -- Fee Rate [/ACCGO/E_FEE_RATE]
    CURRENCY_EXT,             -- Currency [/ACCGO/E_FEE_CURRENCY]
    CURRENCY,                 -- Currency [/ACCGO/E_FEE_CURRENCY]
    QUANTITY,                 -- Quantity [/ACCGO/E_FEE_QTY]
    UOM,                      -- Unit of Measure Fee [/ACCGO/E_FEE_UOM]
    DECIMAL_PLACE,            -- Decimal Places [/ACCGO/E_FEE_DECIMAL]
    HEADER_UOM,               -- Unit of Measure Fee [/ACCGO/E_FEE_UOM]
    RATE_TYPE,                -- Fee Rate Type [/ACCGO/E_FEE_RATE_TYPE]
    STOP_STL_PROV,            -- Stop Stl on Prov [/ACCGO/E_FEE_STOP_STL_PROV]
    STOP_STL_FINAL,           -- Stop Stl on Final [/ACCGO/E_FEE_STOP_STL_FINAL]
    CHARACTERISTIC,           -- Characteristic [/ACCGO/E_FEE_CHAR]
    CHAR_DESC,                -- CharDesc [/ACCGO/E_FEE_CHAR_DESC]
    UOM_TYPE,                 -- UoM Type [/ACCGO/E_FEE_UOMTYPE]
    PRICE_BY_DATE,            -- Price By Date [/ACCGO/E_FEE_PRICE_BY_DATE]
    GOV_DATE_EVENT,           -- Governing Date Event [/ACCGO/E_FEE_GOV_DATE_EVENT]
    GOV_ENDDATE_EVENT,        -- Governing Date Event [/ACCGO/E_FEE_GOV_ENDDATE_EVENT]
    IN_CHARGE_RATE,           -- Incharge Rate [/ACCGO/E_FEE_IN_CHARGE_RATE]
    IN_CHARGE_CURR,           -- In Charge Currency [/ACCGO/E_FEE_IN_CHARGE_CURR]
    IN_CHARGE_QTY,            -- In Charge Quantity [/ACCGO/E_FEE_IN_CHARGE_QTY]
    IN_CHARGE_UOM,            -- In Charge UoM [/ACCGO/E_FEE_IN_CHARGE_UOM]
    IN_CHARGE_GRACE_PERIOD,   -- Grace Period [/ACCGO/E_FEE_GRACE_PERIOD]
    IN_CHARGE_DURATION,       -- Duration [/ACCGO/E_FEE_DURATION]
    IN_CHARGE_BEGIN_DATE,     -- In Charge Begin Date [/ACCGO/E_FEE_IN_CHARGE_BEG_DAT]
    IN_CHARGE_END_DATE,       -- In Charge End Date [/ACCGO/E_FEE_IN_CHARGE_END_DAT]
    REC_CHARG_BEGDATE_EVENT,  -- Rec. Charge Start DE [/ACCGO/E_REC_CHRG_BEG_DAT_EVNT]
    REC_CHARGE_BEGIN_DATE,    -- Rc Charge Begin Date [/ACCGO/E_FEE_REC_CHARG_BEG_DAT]
    REC_CHARG_ENDDATE_EVENT,  -- Rec Charg End D Even [/ACCGO/E_REC_CHRG_END_DAT_EVNT]
    REC_CHARGE_RATE,          -- Recurring Charge Rat [/ACCGO/E_FEE_REC_CHARGE_RATE]
    REC_CHARGE_CURR,          -- Rec. Charge Currency [/ACCGO/E_FEE_REC_CHARGE_CURR]
    REC_CHARGE_QTY,           -- Rec Charge Quantity [/ACCGO/E_FEE_REC_CHARGE_QTY]
    REC_CHARGE_UOM,           -- Rec. Charge UoM [/ACCGO/E_FEE_REC_CHARGE_UOM]
    REC_CHARGE_RATE_DUR,      -- Rec. Rate Duration [/ACCGO/E_FEE_REC_RATE_DURATION]
    REC_CHARGE_GRACE_PERIOD,  -- Grace Period [/ACCGO/E_FEE_GRACE_PERIOD]
    REC_CHARGE_DURATION,      -- Duration [/ACCGO/E_FEE_DURATION]
    PRORATE_TO_DAILY,         -- Prorate to Daily [/ACCGO/E_FEE_PRORATE_TO_DAILY]
    MAX_CHARGE_RATE,          -- Maximum Charge Rat [/ACCGO/E_FEE_MAX_CHARGE_RATE]
    MAX_CHARGE_CURR,          -- Max. Charge Currency [/ACCGO/E_FEE_MAX_CHARGE_CURR]
    MAX_CHARGE_QTY,           -- Max Charge Quantity [/ACCGO/E_FEE_MAX_CHARGE_QTY]
    MAX_CHARGE_UOM,           -- Maximum Charge UoM [/ACCGO/E_FEE_MAX_CHARGE_UOM]
    PREMIUM_CREDIT_GOV_EVNT,  -- Governing Date Event [/ACCGO/E_FEE_PRE_GOV_DAT_EVENT]
    PRE_CREDIT_ENDDATE_EVNT,  -- Governing Date Event [/ACCGO/E_FEE_PRE_ENDDATE_EVENT]
    PREMIUM_CREDIT_RATE,      -- Premium Credit Rate [/ACCGO/E_FEE_PREM_CHARGE_RATE]
    PREMIUM_CREDIT_CURR,      -- Prem Credit Currency [/ACCGO/E_FEE_PREM_CHARGE_CURR]
    PREMIUM_CREDIT_QTY,       -- Premium Credit Quant [/ACCGO/E_FEE_PREM_CHARGE_QTY]
    PREMIUM_CREDIT_UOM,       -- Premium Credit UoM [/ACCGO/E_FEE_PREM_CHARGE_UOM]
    PRE_CREDIT_GRACE_PERIOD,  -- Grace Period [/ACCGO/E_FEE_GRACE_PERIOD]
    PREMIUM_CREDIT_DURATION,  -- Duration [/ACCGO/E_FEE_DURATION]
    DOCTYPEREF,               -- Document Level [/ACCGO/E_FEE_DOCTYPE]
    DOCIDREF,                 -- Reference Doc. ID [/ACCGO/E_FEE_REFDOC_ID]
    DOCITEMREF,               -- Reference Doc. Item [/ACCGO/E_FEE_REFDOCITEM]
    DOCSUBITEMREF,            -- RefDoc Sub-Item [/ACCGO/E_FEE_REFDOC_SUBITEM]
    DOCYEARREF,               -- Ref. Doc. Year [/ACCGO/E_FEE_REFDOC_YEAR]
    SEQUENCE_NOREF,           -- RefDoc Sequence No [/ACCGO/E_FEE_REFSEQUENCE_NO]
    FEE_CALC_AMT,             -- Fee Amount [/ACCGO/E_FEE_AMOUNT]
    FEE_AMT_CURR,             -- Cond. Currency [KONWA]
    FX_RATE,                  -- FX Rate [/ACCGO/E_FX_RATE]
    AMT_TYPE_GUID,            -- GUID [GUID]
    CREATED_BY,               -- Created By [/ACCGO/E_FEE_CREATED_BY]
    CREATED_ON,               -- Created On [/ACCGO/E_FEE_CREATED_ON]
    CREATED_TSTMP,            -- Time Stamp [/ACCGO/E_TIMESTAMP]
    CHANGED_BY,               -- Changed By [/ACCGO/E_FEE_CHANGED_BY]
    CHANGED_ON,               -- Changed On [/ACCGO/E_FEE_CHANGED_ON]
    CHANGED_TSTMP,            -- Time Stamp [/ACCGO/E_TIMESTAMP]
    MANUAL_OVR_IND,           -- Manual Override Ind [/ACCGO/E_MAN_OVR_IND]
    APP_FIRST_UNIT,           -- Apply to First Unit [/ACCGO/E_APP_FIRST_UNIT]
    COPIED_STATUS,            -- Fee Copied Status [/ACCGO/E_FEE_COPIED_STATUS]
    EVENT,                    -- Fee Event [/ACCGO/E_FEE_EVENT]
    IS_PRORATED,              -- TRUE [BOOLE_D]
    REVIEW,                   -- Fee Review [/ACCGO/E_FEE_REVIEW]
    FEE_CAT,                  -- Fee Category [/ACCGO/E_FEE_CAT]
    GL_ACCOUNT,               -- G/L Account [SAKNR]
    INCHARGE_AMOUNT_TOT,      -- In Charge Amount [/ACCGO/E_INCHARGE_AMOUNT]
    RECCHARGE_AMOUNT_TOT,     -- Recurring Charge Amo [/ACCGO/E_RECCHARGE_AMOUNT]
    MAX_CHARGE_AMOUNT_TOT,    -- Max Charge Amount [/ACCGO/E_MAX_CHARGE_AMOUNT]
    PREM_CREDIT_AMOUNT_TOT,   -- Premium Credit Amoun [/ACCGO/E_PREM_CREDIT_AMOUNT]
    LOCATION,                 -- Event Location [/ACCGO/E_EVNT_LOC]
    PREPAYMENT_AMT,           -- Payment Amount [/ACCGO/E_PMT_AMT]
    PREPAYMENT_CURR,          -- Currency [WAERS]
    PREPAYMENTDISTRQUANTITY,  -- Distribution Qnty [PPMGAG_E_DISTRQUANTITY]
    PREPAYMENTDISTRUOM,       -- Distri. UoM [PPMGAG_E_DISTRUOM]
    PREPAYMENTDISTRAMOUNT,    -- Distribution Amount [PPMGAG_E_DISTRAMOUNT]
    PREPAYMENTDISTRCURRENCY,  -- Currency [PPMGAG_E_DISTRCURRENCY]
    FEE_NAME,                 -- Fee Name [/ACCGO/E_FEE_NAME]
    FEE_NAME_EXT,             -- External Fee Name [/ACCGO/E_FEE_NAME_EXT]
    FEE_TYPE,                 -- Fee Type [/ACCGO/E_FEETYPE]
    INT_DESC,                 -- Internal Description [/ACCGO/E_FEE_INTDESC]
    EXT_DESC,                 -- External Description [/ACCGO/E_FEE_EXTDESC]
    STATUS,                   -- Fee Status [/ACCGO/E_FEE_STATUS]
    VALID_FROM,               -- Valid From [/ACCGO/E_VALID_FROM]
    VALID_TO,                 -- Valid To [/ACCGO/E_VALID_TO]
    CONTRACT_HEADER,          -- Contract Header Rel [/ACCGO/E_FEE_REL_CON_HDR]
    CONTRACT_ITEM,            -- Contract Item [/ACCGO/E_FEE_REL_CON_ITEM]
    CONTRACT_PL,              -- Price Fixation [/ACCGO/E_FEE_REL_CON_PL]
    NOM_ITEM,                 -- Nomination Relevant [/ACCGO/E_FEE_REL_NOM_ITEM]
    ORDER_ITEM,               -- SO Item [/ACCGO/E_FEE_REL_ORDER_ITEM]
    PO_ITEM,                  -- PO Item [/ACCGO/E_FEE_REL_PO_ITEM]
    STO_ITEM,                 -- STO Item [/ACCGO/E_FEE_REL_STO_ITEM]
    LDC_LOAD,                 -- LDC Load Event [/ACCGO/E_FEE_REL_LDC]
    LDC_UNLOAD,               -- LDC Unload Event [/ACCGO/E_FEE_REL_LDC_U]
    STLMNT_UNIT,              -- Settlement Unit [/ACCGO/E_FEE_REL_STL_UNIT]
    NON_STD_STLMNT,           -- Non-Std. Settlement [/ACCGO/E_FEE_REL_NS_STL]
    STORAGE_AGMNT,            -- Storage Relevant [/ACCGO/E_FEE_REL_STR_AGMNT]
    STORAGE_STLMNT,           -- Storage Settlement [/ACCGO/E_FEE_REL_STR_STL]
    SET_BASIS,                -- Set Basis Event [/ACCGO/E_FEE_EVENT_SET_BASIS]
    SET_FUTURES,              -- Set Futures Event [/ACCGO/E_FEE_EVENT_SET_FUTURES]
    SET_FLAT,                 -- Set Flat Event [/ACCGO/E_FEE_EVENT_SET_FLAT]
    SET_FX_BASIS,             -- Set FX Basis Event [/ACCGO/E_FEE_EVENT_SET_FX_BSIS]
    SET_FX_FUTURES,           -- Set FX Futures Event [/ACCGO/E_FEE_EVENT_SET_FX_FUT]
    SET_FX_FLAT,              -- Set FX Flat Event [/ACCGO/E_FEE_EVENT_SET_FX_FLAT]
    LIFT_BASIS,               -- Lift Basis Event [/ACCGO/E_FEE_EVENT_LIFT_BASIS]
    LIFT_FUTURE,              -- Lift Futures Event [/ACCGO/E_FEE_EVENT_LIFT_FUTURE]
    LIFT_FLAT,                -- Lift Flat Event [/ACCGO/E_FEE_EVENT_LIFT_FLAT]
    LIFT_FX_BASIS,            -- Lift FX Basis Event [/ACCGO/E_FEE_EVENT_FX_BASIS]
    LIFT_FX_FUTURES,          -- Lift FX Futures [/ACCGO/E_FEE_EVENT_FX_FUTURES]
    LIFT_FX_FLAT,             -- Lift FX Flat [/ACCGO/E_FEE_EVENT_FX_FLAT]
    LIFT_EQUITY_BASIS,        -- Lift wth Equit Basis [/ACCGO/E_FEE_EVENT_LIFT_EQ_BIS]
    LIFT_EQUITY_FUTURES,      -- Lft wth Equi Futures [/ACCGO/E_FEE_EVENT_LIFT_EQ_FUT]
    LIFT_EQUITY_FLAT,         -- Lft with Equity Flat [/ACCGO/E_FEE_EVENT_LIFT_EQ_FLT]
    PRICE_ROLL_BASIS,         -- Price Roll Basis [/ACCGO/E_FEE_EVENT_PRCE_RL_BAS]
    PRICE_ROLL_FUTURES,       -- Price Roll Futures [/ACCGO/E_FEE_EVENT_PRCE_RL_FUT]
    OVERFILL,                 -- Overfill Event [/ACCGO/E_FEE_EVENT_OVERFILL]
    PRICING_METHOD,           -- Pricing Method [/ACCGO/E_FEE_EVENT_PRCING_METH]
    WEIGHT_EVENT,             -- Weight Event [/ACCGO/E_FEE_EVENT_WEIGHT]
    ANALYSIS_EVENT,           -- Analysis Event [/ACCGO/E_FEE_EVENT_ANALYSIS]
    UNLOAD_W_EVENT,           -- Weight Event [/ACCGO/E_FEE_EVENT_U_WEIGHT]
    UNLOAD_A_EVENT,           -- Analysis Event [/ACCGO/E_FEE_EVENT_U_ANALYSIS]
    SALES_MSG_TYP,            -- Sales Message Type [/ACCGO/E_FEE_SALES_MSG_TYP]
    PURCH_MSG_TYP,            -- Purchase Msg. Ty. [/ACCGO/E_FEE_PURCH_MSG_TYP]
    GL_SOURCE,                -- G/L Source [/ACCGO/E_GL_SOURCE]
    PCF_FLAT_FEE,             -- Flat Amount [/ACCGO/E_FLAT_FEE]
    PCF_FLAT_FEE_CURR,        -- Currency [/ACCGO/E_FEE_CURRENCY]
    PCF_PERCENT_FEE,          -- Percentage Fee [/ACCGO/E_PERCENT_FEE]
    PCF_STAGGERED,            -- Tiered [/ACCGO/E_PC_IS_STAGGER]
    PCF_NON_STAGGERED,        -- Non Tiered [/ACCGO/E_PC_IS_NON_STAGGER]
    PCF_CALC_REF,             -- % Fee Calculation [/ACCGO/E_PRCNT_FEE_CAL_REF]
    REL_PP_STL,               -- Rel. for Settlement [/ACCGO/E_REL_PP_STL]
    PRIMARY KEY (MANDT, FEE_ID, VERSION)
);