SAP ABAP Table FIEUD_SDINV_H (SAFT: Invoices from SD module(Header))

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ ID-FI-SAFT (Package) SAF-T Reporting (generic parts)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FIEUD_SDINV_H	Table Relationship Diagram
Short Description	SAFT: Invoices from SD module(Header)

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	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	INV_YEAR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
4	INV_PERIOD	☑	MONAT	MONAT	NUMC	2	0	Fiscal period
5	INV_DATE	☑	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
6	INVOICE_NO	☑	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
7	INVOICE_SOURCE	☑	FIEU_INVSOURCE		CHAR	2	0	SAFT: Source Module for Invoices
8	EXT_UUID	☑	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
9	SALES_OFFICE	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
10	SALES_ORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
11	DIVISION	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
12	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
13	NUMBERING_SERIES	☐	SIPT_SERIES	CHAR4	CHAR	4	0	Signature Portugal: Series
14	INV_DOCTYPE	☐	FKART	FKART	CHAR	4	0	Billing Type	*
15	INV_TYPE	☐	FIEU_INVTYPE	CHAR2	CHAR	2	0	SAFT: Invoice Type
16	INV_CATEGORY	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
17	INV_STATUS	☐	FIEU_INVSTATUS		CHAR	1	0	SAFT: Invoice Status
18	INV_STATUS_DATE	☐	FIPT_STATDATE		CHAR	19	0	SAFT: Invoice Status Date
19	INV_STAT_USER	☐	FIPT_USNAM		CHAR	30	0	SAFT PT: Source ID (User Name)
20	INV_STAT_REASON	☐	FIPT_REASON		CHAR	50	0	SAFT PT: Reason for Status Change
21	HASH	☐	FIPT_HASH		CHAR	200	0	SAFT_PT: Signature Associated with Invoice
22	HASHCONTROL	☐	FIPT_HASHCTRL		CHAR	40	0	SAFT PT: Private Key Version
23	INVOICE_TYPE	☐	FIPT_INVTYPE		CHAR	2	0	SAFT: Invoice Type
24	IND_SELFBILLNG	☐	FIEU_SBIND		CHAR	1	0	SAFT: Self Billing Indicator
25	SOURCE_ID	☐	FIPT_USNAM		CHAR	30	0	SAFT PT: Source ID (User Name)
26	SYS_ENTRY_DATE	☐	FIEU_GLPOSTDATE		CHAR	19	0	SAFT: G/L Posting Date
27	TRANSACTIONID	☐	PTTRANSID	PTTRANSID	CHAR	70	0	SAFT_PT: Transaction ID (G/L)
28	CUSTOMERID	☐	FIEU_KUNNR		CHAR	30	0	SAFT: Customer ID
29	ONETIME_IND	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
30	CUSTOMER	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
31	ST_DELIVERYID	☐	FIPT_DELIVERY		CHAR	30	0	SAFT: Delivery ID
32	ST_DELIVERYDATE	☐	FIEU_DELIVERYDATE		DATS	8	0	Delivery Date
33	SF_WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
34	CANCELLED_IND	☐	FKSTO	XFELD	CHAR	1	0	Billing document is cancelled
35	CANCEL_DOC	☐	SFAKN	VBELN	CHAR	10	0	Cancelled billing document number	*
36	CANCEL_DOCDATE	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
37	SF_ADDRESS	☐	FIEU_ADDRESS	TEXT100	CHAR	100	0	SAFT: Address Details
38	SF_CITY	☐	FIEU_CITY	TEXT50	CHAR	50	0	SAFT: City
39	SF_POSTAL	☐	FIEU_POSTAL	TEXT20	CHAR	20	0	SAFT PT: Postal Code
40	SF_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
41	ST_ADDRESS	☐	FIEU_ADDRESS	TEXT100	CHAR	100	0	SAFT: Address Details
42	ST_CITY	☐	FIEU_CITY	TEXT50	CHAR	50	0	SAFT: City
43	ST_POSTAL	☐	FIEU_POSTAL	TEXT20	CHAR	20	0	SAFT PT: Postal Code
44	ST_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
45	SF_STCEG	☐	FIEU_CUSTSTCEG	STCEG	CHAR	20	0	SAFT: VAT Registration Number
46	MOVE_ETIME	☐	FIPT_MENDTIME		CHAR	20	0	SAFT PT: Movement End Time
47	MOVE_STIME	☐	FIPT_MSTARTTIME		CHAR	20	0	SAFT PT: Goods Movement StartTime
48	ATDOCCODEID	☐	FIPT_ATDOCCODEID		CHAR	200	0	SAFT PT: Delivery Identification code
49	DOC_TOTAL_GROSS	☐	WERTV9	WERTV9	CURR	17	2	9(17)-character value field with 2 decimal places
50	DOC_TOTAL_NET	☐	WERTV9	WERTV9	CURR	17	2	9(17)-character value field with 2 decimal places
51	DOC_TOTAL_TAX	☐	WERTV9	WERTV9	CURR	17	2	9(17)-character value field with 2 decimal places
52	SB_BELNR	☐	RE_BELNR	BELNR	CHAR	10	0	Document Number of an Invoice Document
53	SB_IVTYP	☐	IVTYP	IVTYP	CHAR	1	0	Origin of a Logistics Invoice Verification Document
54	SB_QSFBT	☐	QSFBT	WERT7	CURR	13	2	Withholding Tax-Exempt Amount (in Document Currency)
55	INV_ARCHIVE	☐	FIEU_ARCIND	XFELD	CHAR	1	0	SAFT: Document Already Archived
56	EACCODE	☐	FIEU_CAECODE		CHAR	5	0	SAFT PT : CAE code of Company
57	SOURCEBILLING	☐	FIPT_SRCINV	FIPT_SRCINV	CHAR	1	0	SAFT : Invoice Source
58	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
59	EXCHANGE_RATE	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FIEUD_SDINV_H	BUKRS	T001	BUKRS
2	FIEUD_SDINV_H	MANDT	T000	MANDT

History

Last changed by/on	SAP	20140121
SAP Release Created in	617