P_ACMTransactionalFeeData

Basic View on Transactional Fee Data | view: PTRANSACLDATA1 | TRAN | Extraction: Not supported | Component: SAP Agricultural Contract Management

Tables used: /ACCGO/T_FEE_ASG

🔑 Keys (6)
💰 Amounts (13)
∑ Quantities (1)
📅 Dates (6)
☰ Categorical (57)
Other (31)
🔗 Relations (8)

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
💲 Currency Key (PCF_FLAT_FEE_CURR):
PCF_FLAT_FEE	Flat Amount
💲 Condition Unit (Currency or Percentage) (FEE_AMT_CURR):
FEE_CALC_AMT	Fee Amount
💲 Maximum Charge Currency (MAX_CHARGE_CURR):
INCHARGE_AMOUNT_TOT	In Charge Amount
RECCHARGE_AMOUNT_TOT	Recurring Charge Amount
MAX_CHARGE_AMOUNT_TOT	Maximum Charge Amount
PREM_CREDIT_AMOUNT_TOT	Premium Credit 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

Column Name	Description
PRICE_BY_DATE	Price By Date
IN_CHARGE_BEGIN_DATE	In Charge Begin Date
IN_CHARGE_END_DATE	In Charge End Date
REC_CHARGE_BEGIN_DATE	Recurring Charge Begin Date
CREATED_ON	Created On
CHANGED_ON	Changed On

Column Name	Description
DOCTYPE	Document Type	Show values
SIDE	Side	Show values
FEE_OBSOLETE	Fee Marked Obsolete	Show values
FEE_STORAGE	Storage Fee Indicator	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
FREE_ATT1	Free Attribute for Properties in Fee Framework	Show values
FREE_ATT2	Free Attribute for Properties in Fee Framework	Show values
FREE_ATT3	Free Attribute for Properties in Fee Framework	Show values
FREE_ATT4	Free Attribute for Properties in Fee Framework	Show values
FREE_ATT5	Free Attribute for Properties in Fee Framework	Show values
FREE_ATT6	Free Attribute for Properties in Fee Framework	Show values
FREE_ATT7	Free Attribute for Properties in Fee Framework	Show values
FREE_ATT8	Free Attribute for Properties in Fee Framework	Show values
FREE_ATT9	Free Attribute for Properties in Fee Framework	Show values
FREE_ATT10	Free Attribute for Properties in Fee Framework	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
REL_SEP_INVOICES	Relevant for Accrual	Show values
REL_SEP_TIME	Separate Invoices Time	Show values
RATE_PERCENT	Rate Required on Percentage Fee	Show values
PCF_CALC_REF	Percentage Fee Calculation	Show values
ON_FIRST_LOAD	Apply on First Load	Show values
RATE_TYPE	Fee Rate Type	Show values
STOP_STL_PROV	Stop Settlement on Provisional	Show values
STOP_STL_FINAL	Stop Settlement on Final	Show values
UOM_TYPE	UoM Type	Show values
GOV_DATE_EVENT	Governing Date Event	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
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
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
COPIED_STATUS	Fee Copied Status	Show values
EVENT	Fee Event	Show values
IS_PRORATED	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')	Show values
REVIEW	Fee Review	Show values
FEE_CAT	Fee Category	Show values

Column Name	Description	Domain name
FEE_ID	Fee ID (Fee Framework)	/ACCGO/D_FEEID
VERSION	Fee Version	NUM03
REL_PP_STL	Relevant for Prepayment Settlement	CHAR1
RATE_RAW	Fee Rate (Raw)	/ACCGO/D_FEE_RATE_RAW
QUANTITY	Quantity
DECIMAL_PLACE	Decimal Places	/ACCGO/D_FEE_DECIMAL
CHARACTERISTIC	Characteristic Name	ATNAM
CHAR_DESC	Characteristic Description	ATNAM
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
STOP_NULL	Single-Character Flag	CHAR1
PCF_PERCENT_FEE	Percentage Fee	/ACCGO/D_PERCENT_FEE
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
CREATED_BY	Created By	XUBNAME
CREATED_TSTMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	/ACCGO/D_TZNTSTMPS
CHANGED_BY	Changed By	XUBNAME
CHANGED_TSTMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	/ACCGO/D_TZNTSTMPS
GL_ACCOUNT	G/L Account Number	SAKNR
LOCATION	LDC Event Location	OIJ_LOCID
PREPAYMENTAGRMTDISTRUUID	UUID serving as key (parent key, root key)	SYSUUID

Master Data Relations	Join Conditions
Currency Key Currency Key Client	`P_ACMTRANSACTIONALFEEDATA.CURRENCY == TCURC.WAERS` `P_ACMTRANSACTIONALFEEDATA.MANDT == TCURC.MANDT`
Currency Key Currency Key Client	`P_ACMTRANSACTIONALFEEDATA.CURRENCY_EXT == TCURC.WAERS` `P_ACMTRANSACTIONALFEEDATA.MANDT == TCURC.MANDT`
Unit of Measure for Fee Unit of Measure for Fee Client	`P_ACMTRANSACTIONALFEEDATA.HEADER_UOM == T006.MSEHI` `P_ACMTRANSACTIONALFEEDATA.MANDT == T006.MANDT`
In Charge Unit of Measure Client In Charge Unit of Measure	`P_ACMTRANSACTIONALFEEDATA.MANDT == T006.MANDT` `P_ACMTRANSACTIONALFEEDATA.IN_CHARGE_UOM == T006.MSEHI`
Maximum Charge Unit of Measurement Client Maximum Charge Unit of Measurement	`P_ACMTRANSACTIONALFEEDATA.MANDT == T006.MANDT` `P_ACMTRANSACTIONALFEEDATA.MAX_CHARGE_UOM == T006.MSEHI`
Currency Key Client Currency Key	`P_ACMTRANSACTIONALFEEDATA.MANDT == TCURC.MANDT` `P_ACMTRANSACTIONALFEEDATA.PCF_FLAT_FEE_CURR == TCURC.WAERS`
Recurring Charge Unit of Measure Client Recurring Charge Unit of Measure	`P_ACMTRANSACTIONALFEEDATA.MANDT == T006.MANDT` `P_ACMTRANSACTIONALFEEDATA.REC_CHARGE_UOM == T006.MSEHI`
Unit of Measure for Fee Unit of Measure for Fee Client	`P_ACMTRANSACTIONALFEEDATA.UOM == T006.MSEHI` `P_ACMTRANSACTIONALFEEDATA.MANDT == T006.MANDT`