P_ACCGO_FEE_DTLS
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_ACCGO_SI_CON_FEES | view | inner | BASIC | |
| P_ACCGO_SI_PPMT_FEES | view | from | BASIC |
Fields (168)
| Key | Field | CDS Fields | Used 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
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA