FGL_GLSI_ACD

DDL source of the view FGLV_GLSI_ACD | view: FGLV_GLSI_ACD | Extraction: Not supported | Component: SAP Simple Finance data migration

Tables used: ACDOCA, FINSC_LD_CMP, FINSC_LEDGER_REP

🔑 Keys
💰 Amounts (8)
∑ Quantities (1)
📅 Dates (2)
☰ Categorical (5)
Other (16)
🔗 Relations (37)

Column Name	Description

Column Name	Description
💲 Balance Transaction Currency (rtcur):
tsl	Amount in Balance Transaction Currency
💲 Company Code Currency (rhcur):
hsl	Amount in Company Code Currency
ksl	Amount in Freely Defined Currency 8
osl	Amount in Freely Defined Currency 8
💲 Transaction Currency (rwcur):
wsl	Amount in Transaction Currency
💲 Freely Defined Currency 7 (rfcur):
fsl	Amount in Freely Defined Currency 7
💲 Freely Defined Currency 2 (rvcur):
vsl	Amount in Freely Defined Currency 2
💲 Functional Currency (rfccur):
fcsl	Amount in Functional Currency

Column Name	Description
📏 Base Unit of Measure (runit):
msl	Quantity

Column Name	Description
budat	Posting Date in the Document
_dataaging	Data Filter Value for Data Aging

Column Name	Description
rrcty	Record Type	Show values
drcrk	Debit/Credit Indicator	Show values
bstat	Document Status	Show values
xsplitmod	Item Changed by Document Splitting	Show values
mig_source	Source of a migrated journal entry item	Show values

Column Name	Description	Domain name
ryear	General Ledger Fiscal Year	GJAHR
docnr	Document Number of an Accounting Document	BELNR
docln	Six-Character Posting Item for Ledger	DOCLN6
activ	FI-SL Business Transaction	ACTIVITY
rvers	null
cost_elem	Account Number	SAKNR
poper	Posting period	POPER
gjahr	Fiscal Year	GJAHR
belnr	Document Number of an Accounting Document	BELNR
buzei	Number of Line Item Within Accounting Document	BUZEI
timestamp	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
rgrant_nbr	Grant	GM_GRANT_NBR
sgrant_nbr	Partner Grant	GM_GRANT_NBR
mig_docln	Item ID of migrated G/L line item	DOCLN6
rkcur	null
rocur	null

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