SAP ABAP Table FAGL_S_AR_ITEM_UI (Customer Lines)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ FI-GL-GL (Application Component) Basic Functions
     ⤷ FAGL_DOCUMENT_MAC (Package) Interface for CRM-BSP Framework

Basic Data

Table Category	INTTAB	Structure
Structure	FAGL_S_AR_ITEM_UI	Table Relationship Diagram
Short Description	Customer Lines

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	OBJECT_KEY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
2	NEW_LINE	☐	FLAG	FLAG	CHAR	1	0	General Flag
3	POS_ID_UI	☐	FAGL_POS_ID_UI	CHAR6	CHAR	6	0	Item Number
4	CURR_NO	☐			INT1	3	0
5	ACCOUNT	☐	FAGL_ACCOUNT	CHAR10	CHAR	10	0	Customer or Vendor
6	LINETYPE	☐	KOART	KOART	CHAR	1	0	Account type
7	CUSTOMER	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
8	VENDOR_NO	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
9	GL_ACCOUNT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
10	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
11	CURR_TYPE	☐	CURTP	CURTP	CHAR	2	0	Currency type and valuation view
12	CURRENCY_ISO	☐	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
13	AMT_DOCCUR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
14	EXCH_RATE	☐	KURSF	KURSF	DEC	9	5	Exchange rate
15	EXCH_RATE_V	☐	ACPI_UKURSM	KURSF	DEC	9	5	Indirect quoted exchange rate
16	AMT_BASE	☐	BAPIFWBAS	BAPICURR	DEC	23	4	Tax Base Amount in Document Currency
17	DISC_BASE	☐	ACPI_SKFBT	BAPICURR	DEC	23	4	Amount eligible for cash discount in document currency
18	DISC_AMT	☐	ACPI_ACSKT	BAPICURR	DEC	23	4	Cash discount amount in the currency of the currency types
19	REF_KEY_1	☐	XREF1	CHAR12	CHAR	12	0	Business partner reference key
20	REF_KEY_2	☐	XREF2	CHAR12	CHAR	12	0	Business partner reference key
21	REF_KEY_3	☐	XREF3	CHAR20	CHAR	20	0	Reference key for line item
22	COMP_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
23	BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
24	PMNTTRMS	☐	ACPI_ZTERM	CHAR4	CHAR	4	0	Terms of Payment Key
25	BLINE_DATE	☐	ACPI_ZFBDT	DATUM	DATS	8	0	Baseline Date For Due Date Calculation
26	DSCT_DAYS1	☐	ACPI_ZBD1T	ZBDXT	DEC	3	0	Days for first cash discount
27	DSCT_DAYS2	☐	ACPI_ZBD2T	ZBDXT	DEC	3	0	Days for second cash discount
28	DSCT_DAYS3	☐	ACPI_ZBD3T	ZBDXT	DEC	3	0	Deadline for net conditions
29	DSCT_PCT1	☐	ACPI_ZBD1P	PRZ23	DEC	5	3	Percentage for First Cash Discount
30	DSCT_PCT2	☐	ACPI_ZBD2P	PRZ23	DEC	5	3	Percentage for Second Cash Discount
31	PYMT_METH	☐	ACPI_ZLSCH	ZLSCH	CHAR	1	0	Payment method	*
32	PMTMTHSUPL	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	*
33	PMNT_BLOCK	☐	ACPI_ZLSPR	CHAR1	CHAR	1	0	Payment block key
34	SCBANK_IND	☐	LZBKZ	LZBKZ	CHAR	3	0	State central bank indicator	*
35	SUPCOUNTRY	☐	LANDL	LAND1	CHAR	3	0	Supplying Country	*
36	SUPCOUNTRY_ISO	☐	LANDL_ISO	INTCA	CHAR	2	0	Supplier country ISO code
37	BLLSRV_IND	☐	DIEKZ	DIEKZ	CHAR	1	0	Service indicator (foreign payment)
38	ALLOC_NMBR	☐	ACPI_ZUONR	ZUONR	CHAR	18	0	Assignment Number
39	ITEM_TEXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
40	PO_SUB_NO	☐	ESRNR	ESRNR	CHAR	11	0	POR subscriber number
41	PO_CHECKDG	☐	ESRPZ	CHAR2	CHAR	2	0	POR check digit
42	PO_REF_NO	☐	ESRRE	ESRRE	CHAR	27	0	POR reference number
43	W_TAX_CODE	☐	ACPI_QSSKZ	CHAR02	CHAR	2	0	Withholding tax code
44	BUSINESSPLACE	☐	ACPI_BRANCH	CHAR4	CHAR	4	0	Stores
45	SECTIONCODE	☐	ACPI_SECCO1	CHAR4	CHAR	4	0	Section Code
46	INSTR1	☐	DTAT16	DTWSX	NUMC	2	0	Instruction key 1	*
47	INSTR2	☐	DTAT17	DTWSX	NUMC	2	0	Instruction key 2	*
48	INSTR3	☐	DTAT18	DTWSX	NUMC	2	0	Instruction key 3	*
49	INSTR4	☐	DTAT19	DTWSX	NUMC	2	0	Instruction key 4	*
50	BRANCH	☐	ACPI_FILKD	LIFNR	CHAR	10	0	Account number of the branch	*
51	PYMT_CUR	☐	ACPI_PYCUR	WAERS	CUKY	5	0	Currency for automatic payment	*
52	PYMT_AMT	☐	ACPI_PYAMT	BAPICURR	DEC	23	4	Amount in Payment Currency
53	PYMT_CUR_ISO	☐	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
54	SP_GL_IND	☐	ACPI_UMSKZ	CHAR1	CHAR	1	0	Special G/L Indicator
55	TAX_CODE	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
56	TAX_DATE	☐	ACPI_TXDAT	DATUM	DATS	8	0	Date Relevant for Determining the Tax Rate
57	TAXJURCODE	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
58	ALT_PAYEE	☐	VVABWZE	KUNNR	CHAR	10	0	Alternative payee	*
59	ALT_PAYEE_BANK	☐	VVBVTYPABW	BVTYP	CHAR	4	0	Bank type of alternative payer
60	PARTNER_BK	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
61	BANK_ID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	*
62	PARTNER_GUID	☐	ACPI_GC_PARTNEG	CHAR32	CHAR	32	0	Com. Interface: Business Partner GUID
63	ZBFIX	☐	DZBFIX	ZBFIX	CHAR	1	0	Fixed Payment Terms
64	PAYMT_REF	☐	KIDNO	CHAR30	CHAR	30	0	Payment Reference
65	XINVE	☐	XINVE	XFELD	CHAR	1	0	Indicator: Capital Goods Affected?
66	PENRC	☐	PENRC	CHAR2	CHAR	2	0	Reason for Late Payment
67	ERLKZ	☐	ERLKZ	ERLKZ	CHAR	1	0	Completed Indicator for Open Items
68	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FAGL_S_AR_ITEM_UI	CUSTOMER	KNA1	KUNNR

History

Last changed by/on	SAP	20130529
SAP Release Created in	500