SAP table T7CN28 (Service Fee to Holding Location)

SAP table T7CN28 has 3 primary key fields being MANDT,PLCOD,ENDDA.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
PLCOD Personal file holding location code CHAR 8 0 PCN_PLCOD
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
PLACE Personal file holding location CHAR 60 0 PCN_PLACE
FEAMT Service fee amount to holding location CURR 13 2 PCN_FEAMT
FCURR Currency for service fee amount CUKY 5 0 TCURC PCN_FCURR
COMCH Commission charge to personal file holding location CURR 13 2 PCN_COMCH
CCURR Currency for commission charge CUKY 5 0 TCURC PCN_CCURR
FSTID Payment indicator for the first month and end month CHAR 1 0 PCN_FSTID
1 Pay commission charge only
2 Pay total service fee
3 Pay service fee by percentage
LANGU Language Key LANG 1 0 * LANGU

T7CN28 foreign key relationships

Table Field Check Table Check Field
0 T7CN28 CCURR TCURC Currency Codes MANDT
0 T7CN28 CCURR TCURC Currency Codes WAERS
1 T7CN28 FCURR TCURC Currency Codes MANDT
1 T7CN28 FCURR TCURC Currency Codes WAERS