FCOV_ACC_DOC

Accounting Document | view: FCOV_ACCDOC | Extraction: Not supported | Component: Controlling

Tables used: BKPF, BSEG, COEP

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

Column Name	Description

Column Name	Description
wrbtr	Amount in document currency
dmbtr	Amount in local currency
💲 Transaction Currency (twaer):
wtgbtr	Total Value in Transaction Currency
💲 Currency Key (owaer):
wogbtr	Total Value in Object Currency

Column Name	Description
menge	Quantity
📏 Unit of Measure (meinh):
megbtr	Total Quantity

Column Name	Description
budat	Posting Date in the Document

Column Name	Description
koart	Account type	Show values
beknz	Debit/credit indicator	Show values

Column Name	Description	Domain name
BELNR_FI	Document Number of an Accounting Document	BELNR
BUZEI_FI	Number of Line Item Within Accounting Document	BUZEI
BUZEI_CO	Posting Row	BUZEI
gjahr	Fiscal Year	GJAHR
bktxt	Document Header Text	TEXT25
usnam	User Name	XUBNAME
awtyp	Reference procedure	AWTYP
awsys	Logical System	LOGSYS
awkey	Reference Key	AWKEY
fkber	Functional Area	FKBER_SHORT
segment	Segment for Segmental Reporting	FB_SEGMENT
geber	Fund	BP_GEBER
grant_nbr	Grant	GM_GRANT_NBR
budget_pd	Budget Period	FM_BUDGET_PERIOD
perio	Period	PERBL
paobjnr	Profitability Segment Number (CO-PA)	RKEOBJNR
kostl	Cost Center	KOSTL
lstar	Activity Type	LSTAR
projk	Work Breakdown Structure Element (WBS Element)	PS_POSNR
hrkft	Origin Group as Subdivision of Cost Element	HRKFT

Master Data Relations	Join Conditions
Order Number Order Number Client	`FCOV_ACC_DOC.AUFNR == AUFK.AUFNR` `FCOV_ACC_DOC.MANDT == AUFK.MANDT`
Company Code Company Code Client	`FCOV_ACC_DOC.BUKRS == T001.BUKRS` `FCOV_ACC_DOC.MANDT == T001.MANDT`
Business Area Business Area Client	`FCOV_ACC_DOC.GSBER == TGSB.GSBER` `FCOV_ACC_DOC.MANDT == TGSB.MANDT`
General Ledger Account General Ledger Account Company Code Client	`FCOV_ACC_DOC.HKONT == SKB1.SAKNR` `FCOV_ACC_DOC.BUKRS == SKB1.BUKRS` `FCOV_ACC_DOC.MANDT == SKB1.MANDT`
Controlling area Controlling Area Client	`FCOV_ACC_DOC.KOKRS == TKA01.KOKRS` `FCOV_ACC_DOC.MANDT == TKA01.MANDT`
Cost Element Cost Element ? Client	`FCOV_ACC_DOC.KSTAR == CSKA.KSTAR` `FCOV_ACC_DOC.[column in domain "KTOPL"] == CSKA.KTOPL` `FCOV_ACC_DOC.MANDT == CSKA.MANDT`
Customer Number Customer Number Client	`FCOV_ACC_DOC.KUNNR == KNA1.KUNNR` `FCOV_ACC_DOC.MANDT == KNA1.MANDT`
Account Number of Supplier Account Number of Supplier Client	`FCOV_ACC_DOC.LIFNR == LFA1.LIFNR` `FCOV_ACC_DOC.MANDT == LFA1.MANDT`
Unit of measure for the totals record Unit of Measure Unit of Measure Client	`FCOV_ACC_DOC.MEINH_CO == T006.MSEHI` `FCOV_ACC_DOC.MEINH == T006.MSEHI` `FCOV_ACC_DOC.MANDT == T006.MANDT`
Unit of measure for the totals record Unit of Measure Unit of Measure Client	`FCOV_ACC_DOC.MEINH_CO == T006.MSEHI` `FCOV_ACC_DOC.MEINH == T006.MSEHI` `FCOV_ACC_DOC.MANDT == T006.MANDT`
Tax on sales/purchases code ? Client Tax on sales/purchases code	`FCOV_ACC_DOC.[column in domain "KALSM_D"] == T007A.KALSM` `FCOV_ACC_DOC.MANDT == T007A.MANDT` `FCOV_ACC_DOC.MWSKZ == T007A.MWSKZ`
Currency Key Currency Key Client	`FCOV_ACC_DOC.OWAER == TCURC.WAERS` `FCOV_ACC_DOC.MANDT == TCURC.MANDT`
Trading partner's business area Client Trading partner's business area	`FCOV_ACC_DOC.MANDT == TGSB.MANDT` `FCOV_ACC_DOC.PARGB == TGSB.GSBER`
G/L Account Number G/L Account Number Company Code Client	`FCOV_ACC_DOC.SAKNR == SKB1.SAKNR` `FCOV_ACC_DOC.BUKRS == SKB1.BUKRS` `FCOV_ACC_DOC.MANDT == SKB1.MANDT`
Transaction currency Transaction Currency Client	`FCOV_ACC_DOC.TWAER == TCURC.WAERS` `FCOV_ACC_DOC.MANDT == TCURC.MANDT`
Company ID of Trading Partner Company ID of Trading Partner Client	`FCOV_ACC_DOC.VBUND == T880.RCOMP` `FCOV_ACC_DOC.MANDT == T880.MANDT`
Version Controlling Area Version Client	`FCOV_ACC_DOC.KOKRS == TKA09.KOKRS` `FCOV_ACC_DOC.VERSN == TKA09.VERSN` `FCOV_ACC_DOC.MANDT == TKA09.MANDT`
Currency Key Currency Key Client	`FCOV_ACC_DOC.WAERS == TCURC.WAERS` `FCOV_ACC_DOC.MANDT == TCURC.MANDT`