SAP ABAP Table FDM_INVHISTORY_BKPFX (Invoice History: Enhanced Structure BKPF)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FIN-FSCM-COL-AR (Application Component) Accounts Receivable Accounting Process Integration
     ⤷ FDM_AR_INVHISTORY (Package) FSCM Collections Management: Invoice History - FI-AR

Basic Data

Table Category	INTTAB	Structure
Structure	FDM_INVHISTORY_BKPFX	Table Relationship Diagram
Short Description	Invoice History: Enhanced Structure BKPF

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Accounting Document Header
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
5	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
6	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
7	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
8	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
9	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
10	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
11	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
12	AEDAT	☐	AEDAT_BKPF	DATUM	DATS	8	0	Date of the Last Document Change by Transaction
13	UPDDT	☐	UPDDT	DATUM	DATS	8	0	Date of the Last Document Update
14	WWERT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
15	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
16	TCODE	☐	TCODE	TCODE	CHAR	20	0	Transaction Code	*
17	BVORG	☐	BVORG	BVORG	CHAR	16	0	Number of Cross-Company Code Posting Transaction
18	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
19	DBBLG	☐	DBBLG	BELNR	CHAR	10	0	Recurring Entry Document Number
20	STBLG	☐	STBLG	BELNR	CHAR	10	0	Reverse Document Number
21	STJAH	☐	STJAH	GJAHR	NUMC	4	0	Reverse document fiscal year
22	BKTXT	☐	BKTXT	TEXT25	CHAR	25	0	Document Header Text
23	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
24	KURSF	☐	KURSF	KURSF	DEC	9	5	Exchange rate
25	KZWRS	☐	KZWRS	WAERS	CUKY	5	0	Currency Key for the Group Currency	TCURC
26	KZKRS	☐	KZKRS	KURSF	DEC	9	5	Group Currency Exchange Rate
27	BSTAT	☐	BSTAT_D	BSTAT	CHAR	1	0	Document Status
28	XNETB	☐	XNETB	XFELD	CHAR	1	0	Indicator: Document posted net ?
29	FRATH	☐	FRATH	WERT7	CURR	13	2	Unplanned Delivery Costs
30	XRUEB	☐	XRUEB	XFELD	CHAR	1	0	Indicator: Document is posted to a previous period
31	GLVOR	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
32	GRPID	☐	GRPID_BKPF	CHAR12	CHAR	12	0	Batch Input Session Name
33	DOKID	☐	DOKID_BKPF	CHAR40	CHAR	40	0	Document Name in the Archive System
34	ARCID	☐	EXTID_BKPF	CHAR10	CHAR	10	0	Extract ID Document Header
35	IBLAR	☐	IBLAR	IBLAR	CHAR	2	0	Internal Document Type for Document Control
36	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
37	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
38	FIKRS	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
39	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
40	HWAE2	☐	HWAE2	WAERS	CUKY	5	0	Currency Key of Second Local Currency	*
41	HWAE3	☐	HWAE3	WAERS	CUKY	5	0	Currency Key of Third Local Currency	*
42	KURS2	☐	KURS2	KURSF	DEC	9	5	Exchange Rate for the Second Local Currency
43	KURS3	☐	KURS3	KURSF	DEC	9	5	Exchange Rate for the Third Local Currency
44	BASW2	☐	CURSR	CURSR	CHAR	1	0	Source Currency for Currency Translation
45	BASW3	☐	CURSR	CURSR	CHAR	1	0	Source Currency for Currency Translation
46	UMRD2	☐	UMRD2	CURDT	CHAR	1	0	Translation Date Type for Second Local Currency
47	UMRD3	☐	UMRD3	CURDT	CHAR	1	0	Translation Date Type for Third Local Currency
48	XSTOV	☐	XSTOV	XFELD	CHAR	1	0	Indicator: Document is flagged for reversal
49	STODT	☐	STODT	DATUM	DATS	8	0	Planned Date for the Reverse Posting
50	XMWST	☐	XMWST	XFELD	CHAR	1	0	Calculate tax automatically
51	CURT2	☐	CURT2	CURTP	CHAR	2	0	Currency Type of Second Local Currency
52	CURT3	☐	CURT3	CURTP	CHAR	2	0	Currency Type of Third Local Currency
53	KUTY2	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
54	KUTY3	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
55	XSNET	☐	XSNET	XFELD	CHAR	1	0	G/L account amounts entered exclude tax
56	AUSBK	☐	AUSBK	BUKRS	CHAR	4	0	Source Company Code	T001
57	XUSVR	☐	XUSVR_BKPF	XFELD	CHAR	1	0	Indicator: US taxes changed at detail level ?
58	DUEFL	☐	DUEFL_BKPF	DUEFL_BKPF	CHAR	1	0	Status of Data Transfer into Subsequent Release
59	AWSYS	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
60	TXKRS	☐	TXKRS_BKPF	KURSF	DEC	9	5	Exchange Rate for Taxes
61	LOTKZ	☐	PSO_LOTKZ	LOTKZ	CHAR	10	0	Lot Number for Requests
62	XWVOF	☐	XWVOF	XFELD	CHAR	1	0	Indicator: Customer bill of exchange payment before due date
63	STGRD	☐	STGRD	STGRD	CHAR	2	0	Reason for Reversal	T041C
64	PPNAM	☐	PPNAM	XUBNAME	CHAR	12	0	Name of User Who Parked this Document	*
65	BRNCH	☐	J_1ABRNCH	J_1BBRANCH	CHAR	4	0	Branch number	J_1BBRANCH
66	NUMPG	☐	J_1ANOPG	J_1ANOPG	NUMC	3	0	Number of pages of invoice
67	ADISC	☐	J_1ADISC	ADISC	CHAR	1	0	Indicator: entry represents a discount document
68	XREF1_HD	☐	XREF1_HD	CHAR20	CHAR	20	0	Reference Key 1 Internal for Document Header
69	XREF2_HD	☐	XREF2_HD	CHAR20	CHAR	20	0	Reference Key 2 Internal for Document Header
70	XREVERSAL	☐	XREVERSAL	XREVERSAL	CHAR	1	0	Specifies whether doc. is reversal doc. or reversed doc.
71	REINDAT	☐	REINDAT	DATUM	DATS	8	0	Invoice Receipt Date
72	RLDNR	☐	FAGL_RLDNR	RLDNR	CHAR	2	0	Ledger in General Ledger Accounting	T882G
73	LDGRP	☐	FAGL_LDGRP	FAGL_LDGRP	CHAR	4	0	Ledger Group	FAGL_TLDGRP
74	PROPMANO	☐	RE_MANDAT	RE_MANDAT	CHAR	13	0	Real Estate Management Mandate
75	XBLNR_ALT	☐	XBLNR_ALT	XBLNR_ALT	CHAR	26	0	Alternative Reference Number
76	VATDATE	☐	VATDATE	DATUM	DATS	8	0	Tax Reporting Date
77	DOCCAT	☐	DOCUMENT_CATEGORY	DOCUMENT_CATEGORY	CHAR	6	0	Classification of an FI Document
78	XSPLIT	☐	SPLIT_POSTING	XFELD	CHAR	1	0	FI Document Originates from Split Posting (Indicator)
79	CASH_ALLOC	☐	FAGL_CASH_ALLOC	BOOLE	CHAR	1	0	Cash-Relevant Document
80	FOLLOW_ON	☐	FAGL_FOLLOW_ON	FAGL_FOLLOW_ON	CHAR	1	0	Follow-on document indicator
81	XREORG	☐	FAGL_R_XDOC_REORG	FLAG	CHAR	1	0	Doc. Contains Open Item that Was Transferred During Reorg.
82	SUBSET	☐	ACC_SUBSET	ACC_SUBSET	CHAR	4	0	Defines subset of components for the FI/CO interface
83	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
84	KURSX	☐	GLE_FXR_DTE_RATEX28	GLE_FXR_RATEX28	DEC	28	14	Market Data Exchange Rate
85	KUR2X	☐	GLE_FXR_DTE_RATE2X28	GLE_FXR_RATEX28	DEC	28	14	Market Data Exchange Rate 2
86	KUR3X	☐	GLE_FXR_DTE_RATE3X28	GLE_FXR_RATEX28	DEC	28	14	Market Data Exchange Rate 3
87	XMCA	☐	GLE_DTE_MCA_XMCA	XFELD	CHAR	1	0	Document Originates from Multi Currency Accounting
88	.INCLU--AP	☐				0	0	F15 Append BKPF
89	/SAPF15/STATUS	☐	/SAPF15/STATUS	/SAPF15/STATUS	CHAR	1	0	Document Status
90	.INCLU--AP	☐				0	0	IS-PS: BKPF Append Structure for Payment Requests
91	.INCLUDE	☐				0	0	IS-PS: Include Structure BKPF Payment Request Doc.Header
92	.INCLUDE	☐				0	0	IS-PS: Include for Append Parked Payment Request Doc.Header
93	PSOTY	☐	PSOTY_D	PSOTY	CHAR	2	0	Document category payment requests	PSOTP
94	PSOAK	☐	PSOAK	PSOAK	CHAR	10	0	Reason	PSO12
95	PSOKS	☐	PSOKS	PSOKS	CHAR	10	0	Region	*
96	PSOSG	☐	PSOSG	PSOSG	CHAR	1	0	Reason for reversal - IS-PS requests
97	PSOFN	☐	PSOFN	CHAR30	CHAR	30	0	IS-PS: File number
98	INTFORM	☐	FM_INTFORM	CHAR4	CHAR	4	0	Interest Formula
99	INTDATE	☐	FM_INTDATE	DATUM	DATS	8	0	Interest Calc. Date
100	PSOBT	☐	PSOBT	DATUM	DATS	8	0	Posting Day
101	PSOZL	☐	PSOZL	XFELD	CHAR	1	0	Actual posting
102	PSODT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
103	PSOTM	☐	PSOTM	UZEIT	TIMS	6	0	Last changed at
104	.INCLU--AP	☐				0	0	IS-PS: Append Structure for Transfer Transaction FMITPO
105	FM_UMART	☐	FM_UMART	FM_UMART	CHAR	1	0	Type of Payment Transfer
106	.INCLU--AP	☐				0	0	Credit Card: Append for BKPF
107	.INCLUDE	☐				0	0	Credit Card: Include for Appends for BKPF, VBKPF
108	CCINS	☐	CCINS_30F	CCINS_30F	CHAR	4	0	Payment cards: Card type	TCRIN
109	CCNUM	☐	CCNUM_30F	CCNUM_30F	CHAR	25	0	Payment cards: Card number
110	.INCLU--AP	☐				0	0	Append structure for US federal government
111	SSBLK	☐	SSBLK	SSBLK	CHAR	1	0	Payment Statistical Sampling Block
112	BATCH	☐	LOTKZ	LOTKZ	CHAR	10	0	Lot Number for Documents
113	SNAME	☐	UNAME	UNAME	CHAR	12	0	User Name
114	SAMPLED	☐	SAMPLED	SSBLK	CHAR	1	0	Sampled Invoice by Payment Certification
115	EXCLUDE_FLAG	☐	EXCLUDE_FLG	XFELD	CHAR	1	0	PPA Exclude Indicator
116	BLIND	☐	FM_BLIND	FM_BLIND	CHAR	1	0	Budgetary Ledger Indicator
117	OFFSET_STATUS	☐	FMFG_OFFSET_STATUS	FMFG_OFFSET_STATUS	CHAR	2	0	Treasury Offset Status
118	OFFSET_REFER_DAT	☐	FMFG_REFERRED_OFFSET_DAT	DATUM	DATS	8	0	Date Record Referred to Treasury
119	PENRC	☐	PENRC	CHAR2	CHAR	2	0	Reason for Late Payment
120	.INCLU--AP	☐				0	0	Joint Venture fields
121	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FDM_INVHISTORY_BKPFX	AUSBK	T001	BUKRS	REF	C	CN
2	FDM_INVHISTORY_BKPFX	BLART	T003	BLART	REF	1	CN
3	FDM_INVHISTORY_BKPFX	BRNCH	J_1BBRANCH	BRANCH	REF	1	CN
4	FDM_INVHISTORY_BKPFX	BUKRS	T001	BUKRS	KEY	1	CN
5	FDM_INVHISTORY_BKPFX	CCINS	TCRIN	CCINS
6	FDM_INVHISTORY_BKPFX	KURST	TCURV	KURST	REF	C	CN
7	FDM_INVHISTORY_BKPFX	KUTY2	TCURV	KURST	REF	C	CN
8	FDM_INVHISTORY_BKPFX	KUTY3	TCURV	KURST	REF	C	CN
9	FDM_INVHISTORY_BKPFX	KZWRS	TCURC	WAERS	REF	1	CN
10	FDM_INVHISTORY_BKPFX	LDGRP	FAGL_TLDGRP	LDGRP
11	FDM_INVHISTORY_BKPFX	MANDT	T000	MANDT	KEY	1	CN
12	FDM_INVHISTORY_BKPFX	PSOAK	PSO12	PSOAK
13	FDM_INVHISTORY_BKPFX	PSOTY	PSOTP	PSOTYP
14	FDM_INVHISTORY_BKPFX	RLDNR	T882G	RLDNR
15	FDM_INVHISTORY_BKPFX	STGRD	T041C	STGRD		1	CN
16	FDM_INVHISTORY_BKPFX	WAERS	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in	2004_1_470