FGL_REC_N_SUM_PB

Reconciliation | view: FGLV_REC_N_SUMPB | Extraction: Not supported | Component: SAP Simple Finance data migration

Tables used: ACDOCA, FAGLFLEXT_BCK, JVGLFLEXT, SKA1, T001, FINSC_LD_CMP, FINSC_LEDGER_REP, FINS_MIG_PERIODS

🔑 Keys
💰 Amounts (4)
∑ Quantities (1)
📅 Dates
☰ Categorical (2)
Other (7)
🔗 Relations (30)

Column Name	Description

Column Name	Description
tsl	null
hsl	null
ksl	null
osl	null

Column Name	Description
msl	null

Column Name	Description

Column Name	Description
drcrk	Debit/Credit Indicator	Show values
rrcty	Record Type	Show values

Column Name	Description	Domain name
ryear	General Ledger Fiscal Year	GJAHR
poper	Posting period	POPER
activ	FI-SL Business Transaction	ACTIVITY
rvers	null
cost_elem	Account Number	SAKNR
rgrant_nbr	Grant	GM_GRANT_NBR
sgrant_nbr	Partner Grant	GM_GRANT_NBR

Master Data Relations	Join Conditions
Reference procedure	`FGL_REC_N_SUM_PB.AWTYP == TTYP.AWTYP`
Equity group ? Client Equity group Joint venture	`FGL_REC_N_SUM_PB.[column in domain "BUKRS"] == T8JF.BUKRS` `FGL_REC_N_SUM_PB.MANDT == T8JF.MANDT` `FGL_REC_N_SUM_PB.EGRUP == T8JF.EGRUP` `FGL_REC_N_SUM_PB.VNAME == T8JF.VNAME`
Financial Management Area Client Financial Management Area	`FGL_REC_N_SUM_PB.MANDT == FM01.MANDT` `FGL_REC_N_SUM_PB.FIKRS == FM01.FIKRS`
Controlling Area Client Controlling Area	`FGL_REC_N_SUM_PB.MANDT == TKA01.MANDT` `FGL_REC_N_SUM_PB.KOKRS == TKA01.KOKRS`
Logical system of source document	`FGL_REC_N_SUM_PB.LOGSYS == TBDLS.LOGSYS`
Partner Profit Center ? Client Controlling Area Partner Profit Center	`FGL_REC_N_SUM_PB.[column in domain "DATBI"] == CEPC.DATBI` `FGL_REC_N_SUM_PB.MANDT == CEPC.MANDT` `FGL_REC_N_SUM_PB.KOKRS == CEPC.KOKRS` `FGL_REC_N_SUM_PB.PPRCTR == CEPC.PRCTR`
Profit Center ? Client Controlling Area Profit Center	`FGL_REC_N_SUM_PB.[column in domain "DATBI"] == CEPC.DATBI` `FGL_REC_N_SUM_PB.MANDT == CEPC.MANDT` `FGL_REC_N_SUM_PB.KOKRS == CEPC.KOKRS` `FGL_REC_N_SUM_PB.PRCTR == CEPC.PRCTR`
Partner Segment for Segmental Reporting Client Partner Segment for Segmental Reporting	`FGL_REC_N_SUM_PB.MANDT == FAGL_SEGM.MANDT` `FGL_REC_N_SUM_PB.PSEGMENT == FAGL_SEGM.SEGMENT`
Account Number Client Company Code Account Number	`FGL_REC_N_SUM_PB.MANDT == SKB1.MANDT` `FGL_REC_N_SUM_PB.RBUKRS == SKB1.BUKRS` `FGL_REC_N_SUM_PB.RACCT == SKB1.SAKNR`
Company ID of Trading Partner Company ID of Trading Partner Client	`FGL_REC_N_SUM_PB.RASSC == T880.RCOMP` `FGL_REC_N_SUM_PB.MANDT == T880.MANDT`
Budget Period Client Fund Financial Management Area Budget Period	`FGL_REC_N_SUM_PB.MANDT == FMFUNDBPD.MANDT` `FGL_REC_N_SUM_PB.RFUND == FMFUNDBPD.FINCODE` `FGL_REC_N_SUM_PB.FIKRS == FMFUNDBPD.FIKRS` `FGL_REC_N_SUM_PB.RBUDGET_PD == FMFUNDBPD.BUDGET_PD`
Company Code Client Company Code	`FGL_REC_N_SUM_PB.MANDT == T001.MANDT` `FGL_REC_N_SUM_PB.RBUKRS == T001.BUKRS`
Business Area Business Area Client	`FGL_REC_N_SUM_PB.RBUSA == TGSB.GSBER` `FGL_REC_N_SUM_PB.MANDT == TGSB.MANDT`
Cost Center ? Client Controlling Area Cost Center	`FGL_REC_N_SUM_PB.[column in domain "DATBI"] == CSKS.DATBI` `FGL_REC_N_SUM_PB.MANDT == CSKS.MANDT` `FGL_REC_N_SUM_PB.KOKRS == CSKS.KOKRS` `FGL_REC_N_SUM_PB.RCNTR == CSKS.KOSTL`
Recovery Indicator ? Client Recovery Indicator	`FGL_REC_N_SUM_PB.[column in domain "BUKRS"] == T8JJ.BUKRS` `FGL_REC_N_SUM_PB.MANDT == T8JJ.MANDT` `FGL_REC_N_SUM_PB.RECID == T8JJ.RECID`
Cash Origin Account Client Cash Origin Account ?	`FGL_REC_N_SUM_PB.MANDT == SKA1.MANDT` `FGL_REC_N_SUM_PB.RE_ACCOUNT == SKA1.SAKNR` `FGL_REC_N_SUM_PB.[column in domain "KTOPL"] == SKA1.KTOPL`
Cash Origin Company Code Client Cash Origin Company Code	`FGL_REC_N_SUM_PB.MANDT == T001.MANDT` `FGL_REC_N_SUM_PB.RE_BUKRS == T001.BUKRS`
Functional Area Client Functional Area	`FGL_REC_N_SUM_PB.MANDT == TFKB.MANDT` `FGL_REC_N_SUM_PB.RFAREA == TFKB.FKBER`
Fund Client Fund Financial Management Area	`FGL_REC_N_SUM_PB.MANDT == FMFINCODE.MANDT` `FGL_REC_N_SUM_PB.RFUND == FMFINCODE.FINCODE` `FGL_REC_N_SUM_PB.FIKRS == FMFINCODE.FIKRS`
Ledger in General Ledger Accounting Ledger in General Ledger Accounting Client	`FGL_REC_N_SUM_PB.RLDNR == FINSC_LEDGER.RLDNR` `FGL_REC_N_SUM_PB.MANDT == FINSC_LEDGER.MANDT`
Transaction type Client Transaction type	`FGL_REC_N_SUM_PB.MANDT == T856.MANDT` `FGL_REC_N_SUM_PB.RMVCT == T856.TRTYP`
Balance Transaction Currency Client Balance Transaction Currency	`FGL_REC_N_SUM_PB.MANDT == TCURC.MANDT` `FGL_REC_N_SUM_PB.RTCUR == TCURC.WAERS`
Base Unit of Measure Client Base Unit of Measure	`FGL_REC_N_SUM_PB.MANDT == T006.MANDT` `FGL_REC_N_SUM_PB.RUNIT == T006.MSEHI`
FM: Partner Budget Period Client Partner Fund Financial Management Area FM: Partner Budget Period	`FGL_REC_N_SUM_PB.MANDT == FMFUNDBPD.MANDT` `FGL_REC_N_SUM_PB.SFUND == FMFUNDBPD.FINCODE` `FGL_REC_N_SUM_PB.FIKRS == FMFUNDBPD.FIKRS` `FGL_REC_N_SUM_PB.SBUDGET_PD == FMFUNDBPD.BUDGET_PD`
Trading partner's business area Client Trading partner's business area	`FGL_REC_N_SUM_PB.MANDT == TGSB.MANDT` `FGL_REC_N_SUM_PB.SBUSA == TGSB.GSBER`
Sender cost center ? Client Sender cost center Controlling Area	`FGL_REC_N_SUM_PB.[column in domain "DATBI"] == CSKS.DATBI` `FGL_REC_N_SUM_PB.MANDT == CSKS.MANDT` `FGL_REC_N_SUM_PB.SCNTR == CSKS.KOSTL` `FGL_REC_N_SUM_PB.KOKRS == CSKS.KOKRS`
Segment for Segmental Reporting Client Segment for Segmental Reporting	`FGL_REC_N_SUM_PB.MANDT == FAGL_SEGM.MANDT` `FGL_REC_N_SUM_PB.SEGMENT == FAGL_SEGM.SEGMENT`
Partner Functional Area Client Partner Functional Area	`FGL_REC_N_SUM_PB.MANDT == TFKB.MANDT` `FGL_REC_N_SUM_PB.SFAREA == TFKB.FKBER`
Partner Fund Client Partner Fund Financial Management Area	`FGL_REC_N_SUM_PB.MANDT == FMFINCODE.MANDT` `FGL_REC_N_SUM_PB.SFUND == FMFINCODE.FINCODE` `FGL_REC_N_SUM_PB.FIKRS == FMFINCODE.FIKRS`
Joint venture ? Client Joint venture	`FGL_REC_N_SUM_PB.[column in domain "BUKRS"] == T8JV.BUKRS` `FGL_REC_N_SUM_PB.MANDT == T8JV.MANDT` `FGL_REC_N_SUM_PB.VNAME == T8JV.VNAME`