SAP ABAP Table DTFIAP_3 (Data Transfer: Customer Items to BW (New))

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI (Application Component) Financial Accounting
     ⤷ FBW4 (Package) Data Transfer from FI to BW (from Release 4)

Basic Data

Table Category	INTTAB	Structure
Structure	DTFIAP_3	Table Relationship Diagram
Short Description	Data Transfer: Customer Items to BW (New)

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	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	*
2	FISCPER	☑	RSFISCPER	RSFISCPER	NUMC	7	0	Fiscal year / period
3	BELNR	☑	BELNR_BIW	BELNR	CHAR	10	0	Accounting Document Number
4	BUZEI	☑	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
5	UPOSZ	☑	UPOSZ	SPOSN	CHAR	4	0	Subitem Number
6	STATUSPS	☐	STATUSPS	STATUSPS	CHAR	1	0	Status of FI Item
7	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
8	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area	*
9	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	*
10	KOART	☐	KOART	KOART	CHAR	1	0	Account type
11	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	*
12	BLART	☐	BLART	BLART	CHAR	2	0	Document type	*
13	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
14	FISCVAR	☐	RSFISCVAR	RSFISCVAR	CHAR	2	0	Fiscal year variant
15	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
16	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
17	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
18	AUGDT	☐	AUGDT	DATUM	DATS	8	0	Clearing Date
19	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
20	NETDT	☐	NETDT	DATUM	DATS	8	0	Due Date for Net Payment
21	SK1DT	☐	SK1DT_BIW	DATUM	DATS	8	0	Due date according to cash discount terms 1
22	SK2DT	☐	SK2DT_BIW	DATUM	DATS	8	0	Due date according to cash discount terms 2
23	ZFBDT	☐	DZFBDT_BIW	DATUM	DATS	8	0	Baseline Date for Due Date Calculation
24	ZBD1T	☐	DZBD1T_BIW	ZBDXT	DEC	3	0	Days for First Cash Discount
25	ZBD2T	☐	DZBD2T_BIW	ZBDXT	DEC	3	0	Days for Second Cash Discount
26	ZBD3T	☐	DZBD3T_BIW	ZBDXT	DEC	3	0	Net Payment Terms Period
27	ZBD1P	☐	DZBD1P_BIW	PRZ23	DEC	5	3	Cash Discount Percentage 1
28	ZBD2P	☐	DZBD2P_BIW	PRZ23	DEC	5	3	Cash Discount Percentage 2
29	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
30	ZLSCH	☐	DZLSCH_BIW	ZLSCH	CHAR	1	0	Payment Method	*
31	ZTERM	☐	DZTERM_BIW	ZTERM	CHAR	4	0	Terms of Payment Key
32	ZLSPR	☐	DZLSPR_BIW	ZAHLS	CHAR	1	0	Payment Block Key	*
33	RSTGR	☐	RSTGR	RSTGR	CHAR	3	0	Reason Code for Payments	*
34	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	*
35	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	*
36	MANST	☐	MANST_BIW	MAHNS	NUMC	1	0	Dunning Level
37	LCURR	☐	LCURR	WAERS	CUKY	5	0	Currency key of the local currency	*
38	DMSOL	☐	DMSOL	WERT7	CURR	13	2	Debit Amount in Local Currency
39	DMHAB	☐	DMHAB	WERT7	CURR	13	2	Credit Amount in Local Currency
40	DMSHB	☐	DMSHB	WRTV7	CURR	13	2	Amount in Local Currency with +/- Signs
41	SKNTO	☐	SKNTO	WERT7	CURR	13	2	Cash discount amount in local currency
42	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
43	WRSOL	☐	WRSOL	WERT7	CURR	13	2	Debit Amount in Document Currency
44	WRHAB	☐	WRHAB	WERT7	CURR	13	2	Credit Amount in Document Currency
45	WRSHB	☐	WRSHB	WRTV7	CURR	13	2	Foreign Currency Amount with Signs (+/-)
46	SKFBT	☐	SKFBT	WERT7	CURR	13	2	Amount Eligible for Cash Discount in Document Currency
47	WSKTO	☐	WSKTO	WERT7	CURR	13	2	Cash Discount Amount in Document Currency
48	KTOPL	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	*
49	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
50	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
51	FILKD	☐	FILKD	MAXKK	CHAR	10	0	Account Number of the Branch
52	AUGBL	☐	AUGBL	BELNR	CHAR	10	0	Document Number of the Clearing Document
53	XBLNR	☐	XBLNR	XBLNR	CHAR	16	0	Reference Document Number
54	REBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
55	REBZJ	☐	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
56	REBZZ	☐	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
57	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
58	XREF1	☐	XREF1	CHAR12	CHAR	12	0	Business partner reference key
59	XREF2	☐	XREF2	CHAR12	CHAR	12	0	Business partner reference key
60	XREF3	☐	XREF3	CHAR20	CHAR	20	0	Reference key for line item
61	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
62	XNEGP	☐	XNEGP	XFELD	CHAR	1	0	Indicator: Negative posting
63	XARCH	☐	XARCH	XFELD	CHAR	1	0	Indicator: Document already archived ?
64	UMSKS	☐	UMSKS	UMSKS	CHAR	1	0	Special G/L Transaction Type
65	UPDMOD	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
66	ZUONR	☐	DZUONR_AO	ZUONR	CHAR	18	0	Assignment number
67	.INCLUDE	☐				0	0	Extract Structure: CI Help Fields
68	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
69	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
70	BSTAT	☐	BSTAT_D	BSTAT	CHAR	1	0	Document Status
71	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
72	DMBE2	☐	DMBE2	WERT7	CURR	13	2	Amount in Second Local Currency
73	DMBE3	☐	DMBE3	WERT7	CURR	13	2	Amount in Third Local Currency
74	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
75	HWAE2	☐	HWAE2	WAERS	CUKY	5	0	Currency Key of Second Local Currency	*
76	HWAE3	☐	HWAE3	WAERS	CUKY	5	0	Currency Key of Third Local Currency	*
77	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
78	PROJK	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
79	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
80	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
81	.INCLUDE	☐				0	0

History

Last changed by/on	SAP	20130529
SAP Release Created in