P_ACCGO_SI_FEES

Fees for Separate Invoice | view: P_SIFEE | Extraction: Not supported | Component: Agency Business Document, Settlement, Revenue Recognition
Tables used: PPMGAG_T_PPMT, PPMGAG_T_ASS_DOC, /ACCGO/T_APPDATA, /ACCGO/T_CAS_CAB, /ACCGO/T_CAS_CAH, /ACCGO/T_CAS_CAI, JEST, WBGT, WBHD, WBHK, /ACCGO/T_FEE_ASG, WB2_D_ASGT_DIST, WB2_D_ASSGMT, /ACCGO/T_STLHEAD, /ACCGO/T_STLITEM, JEST, /ACCGO/T_FEE_MD, /ACCGO/T_CMN_STM, /ACCGO/T_CPE_BRI, 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
💲 Prepayment Distribution Currency (prepaymentdistrcurrency):
prepaymentdistramount Prepayment Distribution Amount
Column Name Description
📏 Prepayment Distribution Unit of Measure (prepaymentdistruom):
prepaymentdistrquantity Prepayment Distribution Quantity
📏 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
valid_from Valid From Date
valid_to Valid To Date
Column Name Description
doctype Document Type 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
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
gov_enddate_event Governing End Date Event Show values
rel_sep_time Separate Invoices Time 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
fee_type Fee Type (Fee Framework) Show values
status Fee Status (Fee framework) Show values
gl_source G/L Account Source 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
contract_doc_type Document Type 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
premium_credit_qty Premium Credit Quantity
pre_credit_grace_period Grace Period: Number of Days or Months NUM04
characteristic Characteristic Name ATNAM
fee_name Fee Name /ACCGO/D_FEE_NAME
fee_name_ext External Fee Name /ACCGO/D_FEE_NAME
int_desc Fee Internal Description /ACCGO/D_FEE_INTDESC
ext_desc Fee External Description /ACCGO/D_FEE_EXTDESC
pcf_percent_fee Percentage Fee /ACCGO/D_PERCENT_FEE
rel_pp_stl Relevant for Prepayment Settlement CHAR1
side null
item Application Document Item Number WLF_GENERIC_ITEM_NUM
sub_item Application Document Item Number WLF_GENERIC_ITEM_NUM
ref_app_doc Application Document Number /ACCGO/D_APPLDOC
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
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
qrep_guid Application GUID SYSUUID_X16
qrep_version Version /ACCGO/D_QREP_ID
prepaymentagrmtrefdocument null
prepaymentagrmtrefdocitem Linking Document Number Item POSNR
prepaymentagreement null
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_ACCGO_SI_FEES.MANDT == T001.MANDT
  • P_ACCGO_SI_FEES.COMPANY_CODE == T001.BUKRS
Check Application Status
  • Client
  • Application Status of Trading Contract
  • P_ACCGO_SI_FEES.MANDT == TB2BA.MANDT
  • P_ACCGO_SI_FEES.CONTRACT_STATUS == TB2BA.BTBSTA
Check Trading Contract Type
  • Client
  • Trading Contract Type
  • P_ACCGO_SI_FEES.MANDT == TB2BE.MANDT
  • P_ACCGO_SI_FEES.CONTRACT_TYPE == TB2BE.TCTYP
Currency Key
  • Client
  • Currency Key
  • P_ACCGO_SI_FEES.MANDT == TCURC.MANDT
  • P_ACCGO_SI_FEES.CURRENCY == TCURC.WAERS
Currency Key
  • Client
  • Currency Key
  • P_ACCGO_SI_FEES.MANDT == TCURC.MANDT
  • P_ACCGO_SI_FEES.CURRENCY_EXT == TCURC.WAERS
Check Distribution Channel
  • Client
  • Sales Organization
  • Distribution Channel
  • P_ACCGO_SI_FEES.MANDT == TVKOV.MANDT
  • P_ACCGO_SI_FEES.SALES_ORG == TVKOV.VKORG
  • P_ACCGO_SI_FEES.DIST_CHNL == TVKOV.VTWEG
Check Division
  • Client
  • Sales Organization
  • Distribution Channel
  • Division
  • P_ACCGO_SI_FEES.MANDT == TVTA.MANDT
  • P_ACCGO_SI_FEES.SALES_ORG == TVTA.VKORG
  • P_ACCGO_SI_FEES.DIST_CHNL == TVTA.VTWEG
  • P_ACCGO_SI_FEES.DIVISION == TVTA.SPART
Currency Key
  • Currency Key
  • Client
  • P_ACCGO_SI_FEES.DOC_CURR == TCURC.WAERS
  • P_ACCGO_SI_FEES.MANDT == TCURC.MANDT
CAS Document Type
  • Client
  • CAS Document Type
Unit of Measure for Fee
  • Client
  • Unit of Measure for Fee
  • P_ACCGO_SI_FEES.MANDT == T006.MANDT
  • P_ACCGO_SI_FEES.FEE_RATE_UOM == T006.MSEHI
In Charge Unit of Measure
  • In Charge Unit of Measure
  • Client
  • P_ACCGO_SI_FEES.IN_CHARGE_UOM == T006.MSEHI
  • P_ACCGO_SI_FEES.MANDT == T006.MANDT
Maximum Charge Unit of Measurement
  • Client
  • Maximum Charge Unit of Measurement
  • P_ACCGO_SI_FEES.MANDT == T006.MANDT
  • P_ACCGO_SI_FEES.MAX_CHARGE_UOM == T006.MSEHI
Currency Key
  • Client
  • Currency Key
  • P_ACCGO_SI_FEES.MANDT == TCURC.MANDT
  • P_ACCGO_SI_FEES.PCF_FLAT_FEE_CURR == TCURC.WAERS
UoM of the Assigned Quantity
  • UoM of the Assigned Quantity
  • Client
  • P_ACCGO_SI_FEES.PRXFX_ASG_UOM == T006.MSEHI
  • P_ACCGO_SI_FEES.MANDT == T006.MANDT
Check Purchasing Group
  • Purchasing Group
  • Client
  • P_ACCGO_SI_FEES.PURCH_GRP == T024.EKGRP
  • P_ACCGO_SI_FEES.MANDT == T024.MANDT
Check Purchasing Organization
  • Client
  • Purchasing organization
  • P_ACCGO_SI_FEES.MANDT == T024E.MANDT
  • P_ACCGO_SI_FEES.PURCH_ORG == T024E.EKORG
Recurring Charge Unit of Measure
  • Client
  • Recurring Charge Unit of Measure
  • P_ACCGO_SI_FEES.MANDT == T006.MANDT
  • P_ACCGO_SI_FEES.REC_CHARGE_UOM == T006.MSEHI
Application Document Type
  • Client
  • Application Document Type
Check Sales Organization
  • Client
  • Sales Organization
  • P_ACCGO_SI_FEES.MANDT == TVKO.MANDT
  • P_ACCGO_SI_FEES.SALES_ORG == TVKO.VKORG