SAP ABAP Table TXW_S_LFC1 (Retrieve archived Vendor master (transaction figures) data)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ CA-GTF-DRT (Application Component) Data Retention Tool
     ⤷ FTW1 (Package) Data Retention Tool

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TXW_S_LFC1	Table Relationship Diagram
Short Description	Retrieve archived Vendor master (transaction figures) data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	LIFNR	☑	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
3	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	LFB1
4	GJAHR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
5	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
6	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
7	UMSAV	☐	UMSAV	WRTV8	CURR	15	2	Balance Carried Forward in Local Currency
8	UM01S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
9	UM01H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
10	UM01U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
11	UM02S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
12	UM02H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
13	UM02U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
14	UM03S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
15	UM03H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
16	UM03U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
17	UM04S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
18	UM04H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
19	UM04U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
20	UM05S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
21	UM05H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
22	UM05U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
23	UM06S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
24	UM06H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
25	UM06U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
26	UM07S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
27	UM07H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
28	UM07U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
29	UM08S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
30	UM08H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
31	UM08U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
32	UM09S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
33	UM09H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
34	UM09U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
35	UM10S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
36	UM10H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
37	UM10U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
38	UM11S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
39	UM11H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
40	UM11U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
41	UM12S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
42	UM12H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
43	UM12U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
44	UM13S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
45	UM13H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
46	UM13U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
47	UM14S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
48	UM14H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
49	UM14U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
50	UM15S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
51	UM15H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
52	UM15U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period
53	UM16S	☐	UMXXS	WRTV8	CURR	15	2	Total of the Debit Postings for the Month
54	UM16H	☐	UMXXH	WRTV8	CURR	15	2	Total of the Credit Postings for the Month
55	UM16U	☐	UMXXU	UMXXX	CURR	15	2	Sales in the Posting Period

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TXW_S_LFC1	BUKRS	LFB1	BUKRS	KEY	1	CN
2	TXW_S_LFC1	LIFNR	LFA1	LIFNR	KEY	1	CN
3	TXW_S_LFC1	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in