P_ACCGO_FEE_DTLS

CDS View

P_ACCGO_FEE_DTLS is a CDS View in S/4HANA. It contains 168 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_ACCGO_SI_CON_FEES view inner BASIC
P_ACCGO_SI_PPMT_FEES view from BASIC

Fields (168)

KeyField CDS FieldsUsed in Views
accrual_purchase accrual_purchase 2
accrual_time_sales accrual_time_sales 2
add_gross add_gross 2
alloc_mode alloc_mode 2
amt_type_guid amt_type_guid 2
analysis_event analysis_event 2
app_first_unit app_first_unit 2
calongq calongq 2
changed_by changed_by 2
char_desc char_desc 2
characteristic characteristic 2
contract_header contract_header 2
contract_item contract_item 2
contract_pl contract_pl 2
copied_status copied_status 2
created_by created_by 2
currency currency 2
currency_ext currency_ext 2
decimal_place decimal_place 2
docid docid 2
docidref docidref 2
docitem docitem 2
docitemref docitemref 2
docsubitem docsubitem 2
docsubitemref docsubitemref 2
doctype doctype 2
doctyperef doctyperef 2
docyear docyear 2
docyearref docyearref 2
duplmsg duplmsg 2
event event 2
ext_desc ext_desc 2
fee_amt_curr fee_amt_curr 2
fee_calc_amt fee_calc_amt 2
fee_cat fee_cat 2
fee_id fee_id 2
fee_manual_chg fee_manual_chg 2
fee_name fee_name 2
fee_name_ext fee_name_ext 2
fee_obsolete fee_obsolete 2
fee_storage fee_storage 2
fee_type fee_type 2
free_att1 free_att1 2
free_att10 free_att10 2
free_att2 free_att2 2
free_att3 free_att3 2
free_att4 free_att4 2
free_att5 free_att5 2
free_att6 free_att6 2
free_att7 free_att7 2
free_att8 free_att8 2
free_att9 free_att9 2
fx_rate fx_rate 2
gl_account gl_account 2
gl_source gl_source 2
gov_date_event gov_date_event 2
gov_enddate_event gov_enddate_event 2
header_uom header_uom 2
in_charge_begin_date in_charge_begin_date 2
in_charge_curr in_charge_curr 2
in_charge_duration in_charge_duration 2
in_charge_end_date in_charge_end_date 2
in_charge_grace_period in_charge_grace_period 2
in_charge_qty in_charge_qty 2
in_charge_rate in_charge_rate 2
in_charge_uom in_charge_uom 2
incharge_amount_tot incharge_amount_tot 2
incld_ns incld_ns 2
int_desc int_desc 2
is_prorated is_prorated 2
ldc_load ldc_load 2
ldc_unload ldc_unload 2
lift_basis lift_basis 2
lift_equity_basis lift_equity_basis 2
lift_equity_flat lift_equity_flat 2
lift_equity_futures lift_equity_futures 2
lift_flat lift_flat 2
lift_future lift_future 2
lift_fx_basis lift_fx_basis 2
lift_fx_flat lift_fx_flat 2
lift_fx_futures lift_fx_futures 2
location location 2
manual_ovr_ind manual_ovr_ind 2
max_charge_amount_tot max_charge_amount_tot 2
max_charge_curr max_charge_curr 2
max_charge_qty max_charge_qty 2
max_charge_rate max_charge_rate 2
max_charge_uom max_charge_uom 2
nom_item nom_item 2
non_modifiable non_modifiable 2
non_std_stlmnt non_std_stlmnt 2
not_relevant not_relevant 2
order_item order_item 2
overfill overfill 2
pcf_calc_ref pcf_calc_ref 2
pcf_flat_fee pcf_flat_fee 2
pcf_flat_fee_curr pcf_flat_fee_curr 2
pcf_non_staggered pcf_non_staggered 2
pcf_percent_fee pcf_percent_fee 2
pcf_staggered pcf_staggered 2
po_item po_item 2
pre_credit_enddate_evnt pre_credit_enddate_evnt 2
pre_credit_grace_period pre_credit_grace_period 2
prem_credit_amount_tot prem_credit_amount_tot 2
premium_credit_curr premium_credit_curr 2
premium_credit_duration premium_credit_duration 2
premium_credit_gov_evnt premium_credit_gov_evnt 2
premium_credit_qty premium_credit_qty 2
premium_credit_rate premium_credit_rate 2
premium_credit_uom premium_credit_uom 2
prepayment_amt prepayment_amt 2
prepayment_curr prepayment_curr 2
prepaymentdistramount prepaymentdistramount 2
prepaymentdistrcurrency prepaymentdistrcurrency 2
prepaymentdistrquantity prepaymentdistrquantity 2
prepaymentdistruom prepaymentdistruom 2
price_by_date price_by_date 2
price_roll_basis price_roll_basis 2
price_roll_futures price_roll_futures 2
pricing_method pricing_method 2
prorate_to_daily prorate_to_daily 2
purch_msg_typ purch_msg_typ 2
quantity quantity 2
rate rate 2
rate_assign rate_assign 2
rate_raw rate_raw 2
rate_type rate_type 2
rec_charg_begdate_event rec_charg_begdate_event 2
rec_charg_enddate_event rec_charg_enddate_event 2
rec_charge_begin_date rec_charge_begin_date 2
rec_charge_curr rec_charge_curr 2
rec_charge_duration rec_charge_duration 2
rec_charge_grace_period rec_charge_grace_period 2
rec_charge_qty rec_charge_qty 2
rec_charge_rate rec_charge_rate 2
rec_charge_rate_dur rec_charge_rate_dur 2
rec_charge_uom rec_charge_uom 2
reccharge_amount_tot reccharge_amount_tot 2
rel_accrual rel_accrual 2
rel_pp_stl rel_pp_stl 2
rel_sep_invoices rel_sep_invoices 2
rel_sep_time rel_sep_time 2
review review 2
sales_msg_typ sales_msg_typ 2
sequence_no sequence_no 2
sequence_noref sequence_noref 2
set_basis set_basis 2
set_flat set_flat 2
set_futures set_futures 2
set_fx_basis set_fx_basis 2
set_fx_flat set_fx_flat 2
set_fx_futures set_fx_futures 2
status status 2
stlmnt_unit stlmnt_unit 2
sto_item sto_item 2
stop_stl_final stop_stl_final 2
stop_stl_prov stop_stl_prov 2
storage_agmnt storage_agmnt 2
storage_stlmnt storage_stlmnt 2
unload_a_event unload_a_event 2
unload_w_event unload_w_event 2
uom fee_rate_uom 2
uom_type uom_type 2
valid_from valid_from 2
valid_status valid_status 2
valid_to valid_to 2
version version 2
weight_event weight_event 2

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_ACCGO_FEE_DTLS (
    ACCRUAL_PURCHASE,
    ACCRUAL_TIME_SALES,
    ADD_GROSS,
    ALLOC_MODE,
    AMT_TYPE_GUID,
    ANALYSIS_EVENT,
    APP_FIRST_UNIT,
    CALONGQ,
    CHANGED_BY,
    CHAR_DESC,
    CHARACTERISTIC,
    CONTRACT_HEADER,
    CONTRACT_ITEM,
    CONTRACT_PL,
    COPIED_STATUS,
    CREATED_BY,
    CURRENCY,
    CURRENCY_EXT,
    DECIMAL_PLACE,
    DOCID,
    DOCIDREF,
    DOCITEM,
    DOCITEMREF,
    DOCSUBITEM,
    DOCSUBITEMREF,
    DOCTYPE,
    DOCTYPEREF,
    DOCYEAR,
    DOCYEARREF,
    DUPLMSG,
    EVENT,
    EXT_DESC,
    FEE_AMT_CURR,
    FEE_CALC_AMT,
    FEE_CAT,
    FEE_ID,
    FEE_MANUAL_CHG,
    FEE_NAME,
    FEE_NAME_EXT,
    FEE_OBSOLETE,
    FEE_STORAGE,
    FEE_TYPE,
    FREE_ATT1,
    FREE_ATT10,
    FREE_ATT2,
    FREE_ATT3,
    FREE_ATT4,
    FREE_ATT5,
    FREE_ATT6,
    FREE_ATT7,
    FREE_ATT8,
    FREE_ATT9,
    FX_RATE,
    GL_ACCOUNT,
    GL_SOURCE,
    GOV_DATE_EVENT,
    GOV_ENDDATE_EVENT,
    HEADER_UOM,
    IN_CHARGE_BEGIN_DATE,
    IN_CHARGE_CURR,
    IN_CHARGE_DURATION,
    IN_CHARGE_END_DATE,
    IN_CHARGE_GRACE_PERIOD,
    IN_CHARGE_QTY,
    IN_CHARGE_RATE,
    IN_CHARGE_UOM,
    INCHARGE_AMOUNT_TOT,
    INCLD_NS,
    INT_DESC,
    IS_PRORATED,
    LDC_LOAD,
    LDC_UNLOAD,
    LIFT_BASIS,
    LIFT_EQUITY_BASIS,
    LIFT_EQUITY_FLAT,
    LIFT_EQUITY_FUTURES,
    LIFT_FLAT,
    LIFT_FUTURE,
    LIFT_FX_BASIS,
    LIFT_FX_FLAT,
    LIFT_FX_FUTURES,
    LOCATION,
    MANUAL_OVR_IND,
    MAX_CHARGE_AMOUNT_TOT,
    MAX_CHARGE_CURR,
    MAX_CHARGE_QTY,
    MAX_CHARGE_RATE,
    MAX_CHARGE_UOM,
    NOM_ITEM,
    NON_MODIFIABLE,
    NON_STD_STLMNT,
    NOT_RELEVANT,
    ORDER_ITEM,
    OVERFILL,
    PCF_CALC_REF,
    PCF_FLAT_FEE,
    PCF_FLAT_FEE_CURR,
    PCF_NON_STAGGERED,
    PCF_PERCENT_FEE,
    PCF_STAGGERED,
    PO_ITEM,
    PRE_CREDIT_ENDDATE_EVNT,
    PRE_CREDIT_GRACE_PERIOD,
    PREM_CREDIT_AMOUNT_TOT,
    PREMIUM_CREDIT_CURR,
    PREMIUM_CREDIT_DURATION,
    PREMIUM_CREDIT_GOV_EVNT,
    PREMIUM_CREDIT_QTY,
    PREMIUM_CREDIT_RATE,
    PREMIUM_CREDIT_UOM,
    PREPAYMENT_AMT,
    PREPAYMENT_CURR,
    PREPAYMENTDISTRAMOUNT,
    PREPAYMENTDISTRCURRENCY,
    PREPAYMENTDISTRQUANTITY,
    PREPAYMENTDISTRUOM,
    PRICE_BY_DATE,
    PRICE_ROLL_BASIS,
    PRICE_ROLL_FUTURES,
    PRICING_METHOD,
    PRORATE_TO_DAILY,
    PURCH_MSG_TYP,
    QUANTITY,
    RATE,
    RATE_ASSIGN,
    RATE_RAW,
    RATE_TYPE,
    REC_CHARG_BEGDATE_EVENT,
    REC_CHARG_ENDDATE_EVENT,
    REC_CHARGE_BEGIN_DATE,
    REC_CHARGE_CURR,
    REC_CHARGE_DURATION,
    REC_CHARGE_GRACE_PERIOD,
    REC_CHARGE_QTY,
    REC_CHARGE_RATE,
    REC_CHARGE_RATE_DUR,
    REC_CHARGE_UOM,
    RECCHARGE_AMOUNT_TOT,
    REL_ACCRUAL,
    REL_PP_STL,
    REL_SEP_INVOICES,
    REL_SEP_TIME,
    REVIEW,
    SALES_MSG_TYP,
    SEQUENCE_NO,
    SEQUENCE_NOREF,
    SET_BASIS,
    SET_FLAT,
    SET_FUTURES,
    SET_FX_BASIS,
    SET_FX_FLAT,
    SET_FX_FUTURES,
    STATUS,
    STLMNT_UNIT,
    STO_ITEM,
    STOP_STL_FINAL,
    STOP_STL_PROV,
    STORAGE_AGMNT,
    STORAGE_STLMNT,
    UNLOAD_A_EVENT,
    UNLOAD_W_EVENT,
    UOM,
    UOM_TYPE,
    VALID_FROM,
    VALID_STATUS,
    VALID_TO,
    VERSION,
    WEIGHT_EVENT
);