P_ACCGO_ACRUAL_FEES

Fees for accrual | view: P_ACCRUALFEE | Extraction: Not supported | Component: Agency Business Document, Settlement, Revenue Recognition
Tables used: PPMGAG_T_PPMT, PPMGAG_T_ASS_DOC, /ACCGO/T_FEE_ASG, /ACCGO/T_APPDATA, /ACCGO/T_CAS_CAB, /ACCGO/T_CAS_CAH, /ACCGO/T_CAS_CAI, JEST, /ACCGO/T_CAS_CAI, WBGT, WBHD, WBHK, WB2_D_ASGT_DIST, WB2_D_ASSGMT, /ACCGO/T_STLHEAD, /ACCGO/T_STLITEM, JEST, /ACCGO/T_CAS_CAB, /ACCGO/T_CAS_CAH, JEST, /ACCGO/T_STLHEAD, /ACCGO/T_STLITEM, JEST, /ACCGO/T_CMN_STM, /ACCGO/T_CPE_BRI, TJ04, /ACCGO/T_CMN_STM, TJ04
Column Name Description
doctype Document Type Show values
docid Reference Document ID
docitem Reference Document Item
docsubitem Reference Document Sub-Item
docyear Reference Document Year
sequence_no Reference Document Sequence Number
Column Name Description
💲 Currency Key (currency):
rate Fee Rate
in_charge_rate Incharge Rate
rec_charge_rate Recurring Charge Rate
max_charge_rate Maximum Charge Rate
premium_credit_rate Premium Credit Rate
💲 Condition Unit (Currency or Percentage) (fee_amt_curr):
fee_calc_amt Fee Amount
💲 Currency Key (pcf_flat_fee_curr):
pcf_flat_fee Flat Amount
💲 Currency Key (prepayment_curr):
prepayment_amt Payment Amount
Column Name Description
📏 Unit of Measure (adj_uom):
full_ship_qty Full Shipment Quantity
tot_quantity_adj Quantity Adjustment
📏 Per Unit UoM (unit_uom):
unit_quantity Quantity in Base UoM
📏 Contract Units of Measurement (contract_uom):
contract_qty Quantity in Contract UoM
📏 Document Units of Measurement (document_uom):
document_qty Quantity in Document UoM
Column Name Description
in_charge_begin_date In Charge Begin Date
in_charge_end_date In Charge End Date
rec_charge_begin_date Recurring Charge Begin Date
price_by_date Price By Date
Column Name Description
doctype Document Type Show values
side Side Show values
fee_obsolete Fee Marked Obsolete Show values
fee_manual_chg Manually Override Fee ( For Settlement Usage) Show values
alloc_mode Allocation Mode Show values
valid_status Fee Valid Status Show values
calongq Calculation on Gross Quantity Show values
duplmsg Notify On Duplicate Fee Show values
not_relevant Not Relevant for Provisional Show values
add_gross Add to Gross Price Show values
incld_ns Include Fee in Non-Standard Show values
rel_accrual Relevant for Accrual Show values
rate_assign Rate Required on Assignment Show values
non_modifiable Non-Modifiable Show values
accrual_purchase Accrual Time Show values
accrual_time_sales Accrual Time Show values
rate_type Fee Rate Type Show values
doctyperef Document Type Show values
manual_ovr_ind Manually Override Indicator (For General Usage) Show values
app_first_unit Apply to First Unit flag Show values
gov_enddate_event Governing End Date Event Show values
in_charge_duration Duration in days Show values
rec_charg_begdate_event Recurring Charge Begin Date Event Show values
rec_charg_enddate_event Recurring Charge End Date Event Show values
rec_charge_rate_dur Recurring Charge Periodicity Show values
rec_charge_duration Duration in days Show values
prorate_to_daily Prorate to Daily Show values
gov_date_event Governing Date Event Show values
premium_credit_gov_evnt Premium Credit Governing Event Show values
pre_credit_enddate_evnt Premium Credit End Date Event Show values
premium_credit_duration Duration in days Show values
pcf_staggered Tiered Show values
pcf_non_staggered Non Tiered Show values
pcf_calc_ref Percentage Fee Calculation Show values
appldoc_type Document Category Show values
delivery_type Pred Document Type 2 Show values
delivery_side Pred Document Number 2 Side Show values
order_type Pred Document Type 3 Show values
order_side Pred Document Number 3 Side Show values
settl_cat Settlement Document Category Show values
settl_type Settlement Type Show values
settl_side Side Show values
settl_scenario Settlement Scenario Show values
Column Name Description Domain name
fee_id Fee ID (Fee Framework) /ACCGO/D_FEEID
version Fee Version NUM03
quantity Quantity
decimal_place Decimal Places /ACCGO/D_FEE_DECIMAL
docidref Reference Document ID /ACCGO/D_FEE_DOC_ID
docitemref Reference Document Item /ACCGO/D_FEE_DOCITEM
docsubitemref Reference Document Sub-Item /ACCGO/D_FEE_DOC_SUBITEM
docyearref Reference Document Year /ACCGO/D_SETTL_YR
sequence_noref Reference Document Sequence Number /ACCGO/D_FEE_SEQUENCE_NO
fx_rate FX Rate PKURS
amt_type_guid Globally Unique Identifier
in_charge_qty In Charge Quantity
in_charge_grace_period Grace Period: Number of Days or Months NUM04
rec_charge_qty Recurring Charge Quantity
rec_charge_grace_period Grace Period: Number of Days or Months NUM04
max_charge_qty Maximum Charge Quantity
characteristic Characteristic Name ATNAM
premium_credit_qty Premium Credit Quantity
pre_credit_grace_period Grace Period: Number of Days or Months NUM04
pcf_percent_fee Percentage Fee /ACCGO/D_PERCENT_FEE
rel_pp_stl Relevant for Prepayment Settlement CHAR1
item Application Document Item Number WLF_GENERIC_ITEM_NUM
sub_item Application Document Item Number WLF_GENERIC_ITEM_NUM
contract Trading Contract TKONN
contract_itm Item Number of Trading Contract TPOSN
contract_subitem Commodity Subitem Number TPOSN
appl_status_objnr Object number J_OBJNR
stl_status_objnr Object number J_OBJNR
uis_evnt_id Load Data Capture Object ID /ACCGO/D_UIS_ID
uis_evnt_guid Load Data Capture Key SYSUUID_X16
ob_delivery CA Reference Document 2 WLF_GENERIC_DOC_NUM
delivery_item Pred Document Item Number 2 WLF_GENERIC_ITEM_NUM
order_no CA Reference Document 3 WLF_GENERIC_DOC_NUM
order_itm Pred Document Item Number 3 WLF_GENERIC_ITEM_NUM
gross_qty Appdoc Item Quantity Raw (PO UoM) WLF_QUANTITY
laq_qty Applied Quantity Raw
qrep_guid Application GUID SYSUUID_X16
qrep_version Version /ACCGO/D_QREP_ID
created_on Created On /ACCGO/D_TZNTSTMPS
changed_on Changed On /ACCGO/D_TZNTSTMPS
plant Plant WERKS
profit_center Profit Center PRCTR
supplier Account Number of Supplier LIFNR
sold_to_party Sold-to Party KUNNR
nomtk Nomination (technical) Key OIJ_NOMTK
nomnr Nomination number OIJ_NOMNR
nomit Nomination Key Item OIJ_ITEM
prcfx_asg_qty Assigned Quantity WLF_QUANTITY
assgd_quan_orig Original Assigned Quantity WLF_QUANTITY
assgmt_guid GUID of an assignment WLF_GUID
pricing_aspect_id Pricing Aspect WLF_PR_ASPECT
pricing_aspect_counter Pricing Aspect Counter TPOSN
price_fixation_number CPE Term - Number in Formula NUMC5
settl_doc Settlement Unit /ACCGO/D_SETTL_DOC
settl_yr Settlement Unit Year /ACCGO/D_SETTL_YR
settl_item Settlement Item
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_ACCGO_ACRUAL_FEES.COMPANY_CODE == T001.BUKRS
  • P_ACCGO_ACRUAL_FEES.MANDT == T001.MANDT
Check Application Status
  • Application Status of Trading Contract
  • Client
  • P_ACCGO_ACRUAL_FEES.CONTRACT_STATUS == TB2BA.BTBSTA
  • P_ACCGO_ACRUAL_FEES.MANDT == TB2BA.MANDT
Check Trading Contract Type
  • Trading Contract Type
  • Client
  • P_ACCGO_ACRUAL_FEES.CONTRACT_TYPE == TB2BE.TCTYP
  • P_ACCGO_ACRUAL_FEES.MANDT == TB2BE.MANDT
Currency Key
  • Currency Key
  • Client
  • P_ACCGO_ACRUAL_FEES.CURRENCY == TCURC.WAERS
  • P_ACCGO_ACRUAL_FEES.MANDT == TCURC.MANDT
Currency Key
  • Currency Key
  • Client
  • P_ACCGO_ACRUAL_FEES.CURRENCY_EXT == TCURC.WAERS
  • P_ACCGO_ACRUAL_FEES.MANDT == TCURC.MANDT
Check Distribution Channel
  • Distribution Channel
  • Sales Organization
  • Client
  • P_ACCGO_ACRUAL_FEES.DIST_CHNL == TVKOV.VTWEG
  • P_ACCGO_ACRUAL_FEES.SALES_ORG == TVKOV.VKORG
  • P_ACCGO_ACRUAL_FEES.MANDT == TVKOV.MANDT
Check Division
  • Division
  • Distribution Channel
  • Sales Organization
  • Client
  • P_ACCGO_ACRUAL_FEES.DIVISION == TVTA.SPART
  • P_ACCGO_ACRUAL_FEES.DIST_CHNL == TVTA.VTWEG
  • P_ACCGO_ACRUAL_FEES.SALES_ORG == TVTA.VKORG
  • P_ACCGO_ACRUAL_FEES.MANDT == TVTA.MANDT
Currency Key
  • Currency Key
  • Client
  • P_ACCGO_ACRUAL_FEES.DOC_CURR == TCURC.WAERS
  • P_ACCGO_ACRUAL_FEES.MANDT == TCURC.MANDT
CAS Document Type
  • CAS Document Type
  • Client
Unit of Measure for Fee
  • Client
  • Unit of Measure for Fee
  • P_ACCGO_ACRUAL_FEES.MANDT == T006.MANDT
  • P_ACCGO_ACRUAL_FEES.FEE_RATE_UOM == T006.MSEHI
In Charge Unit of Measure
  • In Charge Unit of Measure
  • Client
  • P_ACCGO_ACRUAL_FEES.IN_CHARGE_UOM == T006.MSEHI
  • P_ACCGO_ACRUAL_FEES.MANDT == T006.MANDT
Maximum Charge Unit of Measurement
  • Maximum Charge Unit of Measurement
  • Client
  • P_ACCGO_ACRUAL_FEES.MAX_CHARGE_UOM == T006.MSEHI
  • P_ACCGO_ACRUAL_FEES.MANDT == T006.MANDT
Currency Key
  • Client
  • Currency Key
  • P_ACCGO_ACRUAL_FEES.MANDT == TCURC.MANDT
  • P_ACCGO_ACRUAL_FEES.PCF_FLAT_FEE_CURR == TCURC.WAERS
UoM of the Assigned Quantity
  • Client
  • UoM of the Assigned Quantity
  • P_ACCGO_ACRUAL_FEES.MANDT == T006.MANDT
  • P_ACCGO_ACRUAL_FEES.PRXFX_ASG_UOM == T006.MSEHI
Check Purchasing Group
  • Purchasing Group
  • Client
  • P_ACCGO_ACRUAL_FEES.PURCH_GRP == T024.EKGRP
  • P_ACCGO_ACRUAL_FEES.MANDT == T024.MANDT
Check Purchasing Organization
  • Purchasing organization
  • Client
  • P_ACCGO_ACRUAL_FEES.PURCH_ORG == T024E.EKORG
  • P_ACCGO_ACRUAL_FEES.MANDT == T024E.MANDT
Recurring Charge Unit of Measure
  • Recurring Charge Unit of Measure
  • Client
  • P_ACCGO_ACRUAL_FEES.REC_CHARGE_UOM == T006.MSEHI
  • P_ACCGO_ACRUAL_FEES.MANDT == T006.MANDT
Check Sales Organization
  • Sales Organization
  • Client
  • P_ACCGO_ACRUAL_FEES.SALES_ORG == TVKO.VKORG
  • P_ACCGO_ACRUAL_FEES.MANDT == TVKO.MANDT