SAP ABAP View EPIC_V_CUSTOMER (EPIC: View of vendor, table BSIK and FPRL_ITEM)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ ID-FI-EPIC-GEN-UI (Package) Globalization: E-Payment Integration User Interface Objects

Basic Data

View Type	D	Database View
Database View	EPIC_V_CUSTOMER
Short Description	EPIC: View of vendor, table BSIK and FPRL_ITEM
Root table	BSID	Accounting: Secondary Index for Customers

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	BSID	BSID
2	FPRL_ITEM

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	BSID	BUKRS	JL	EQ				0	0
2	FPRL_ITEM	BUKRS	JR	EQ			AND	0	0
3	BSID	BELNR	JL	EQ				0	0
4	FPRL_ITEM	BELNR	JR	EQ			AND	0	0
5	BSID	GJAHR	JL	EQ				0	0
6	FPRL_ITEM	GJAHR	JR	EQ			AND	0	0
7	BSID	BUZEI	JL	EQ				0	0
8	FPRL_ITEM	BUZEI	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	BSID	MANDT		☐	MANDT	☐	Client
2	BUKRS	BSID	BUKRS		☐	BUKRS	☐	Company Code
3	KUNNR	BSID	KUNNR		☐	KUNNR	☐	Customer Number
4	UMSKS	BSID	UMSKS		☐	UMSKS	☐	Special G/L Transaction Type
5	UMSKZ	BSID	UMSKZ		☐	UMSKZ	☐	Special G/L Indicator
6	AUGDT	BSID	AUGDT		☐	AUGDT	☐	Clearing Date
7	AUGBL	BSID	AUGBL		☐	AUGBL	☐	Document Number of the Clearing Document
8	ZUONR	BSID	ZUONR		☐	DZUONR	☐	Assignment number
9	GJAHR	BSID	GJAHR		☐	GJAHR	☐	Fiscal Year
10	BELNR	BSID	BELNR		☐	BELNR_D	☐	Accounting Document Number
11	BUZEI	BSID	BUZEI		☐	BUZEI	☐	Number of Line Item Within Accounting Document
12	WAERS	BSID	WAERS		☐	WAERS	☐	Currency Key
13	SHKZG	BSID	SHKZG		☐	SHKZG	☐	Debit/Credit Indicator
14	GSBER	BSID	GSBER		☐	GSBER	☐	Business Area
15	WRBTR	BSID	WRBTR		☐	WRBTR	☐	Amount in document currency
16	SKNTO	BSID	SKNTO		☐	SKNTO	☐	Cash discount amount in local currency
17	WSKTO	BSID	WSKTO		☐	WSKTO	☐	Cash Discount Amount in Document Currency
18	ZLSCH	BSID	ZLSCH		☐	DZLSCH	☐	Payment method
19	ZLSPR	BSID	ZLSPR		☐	DZLSPR	☐	Payment Block Key
20	HBKID	BSID	HBKID		☐	HBKID	☐	Short key for a house bank
21	REBZG	BSID	REBZG		☐	REBZG	☐	Number of the Invoice the Transaction Belongs to
22	REBZJ	BSID	REBZJ		☐	REBZJ	☐	Fiscal Year of the Relevant Invoice (for Credit Memo)
23	REBZZ	BSID	REBZZ		☐	REBZZ	☐	Line Item in the Relevant Invoice
24	HKTID	BSID	REBZZ		☐	REBZZ	☐	Line Item in the Relevant Invoice
25	GUID	FPRL_ITEM	GUID		☐	SYSUUID_X	☐	UUID in X form (binary)
26	LIST_ID	FPRL_ITEM	LIST_ID		☐	FPRL_LIST_ID	☐	Payment Release List ID
27	STATUS	FPRL_ITEM	STATUS		☐	FPRL_ITEM_STATUS	☐	Item Status ID
28	EPIC_PROCESSOR	FPRL_ITEM	EPIC_PROCESSOR		☐	EPIC_PROCESSOR	☐	Processor
29	EPIC_STATUS	FPRL_ITEM	EPIC_STATUS		☐	EPIC_ITEM_STATUS	☐	Item Status

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20140121
SAP Release Created in