SAP ABAP View INVOICING (View for ERS Procedure in Case of Invoicing Plans)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ ML (Package) R/3 services management

Basic Data

View Type	D	Database View
Database View	INVOICING
Short Description	View for ERS Procedure in Case of Invoicing Plans
Root table	EKPO	Purchasing Document Item

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EKPO	EKPO
2	FPLT
3	EKKO

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EKPO	MANDT	JL	EQ				0	0
2	FPLT	MANDT	JR	EQ			AND	0	0
3	EKPO	FPLNR	JL	EQ				0	0
4	FPLT	FPLNR	JR	EQ			AND	0	0
5	EKPO	MANDT	JL	EQ				0	0
6	EKKO	MANDT	JR	EQ			AND	0	0
7	EKPO	EBELN	JL	EQ				0	0
8	EKKO	EBELN	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	EKPO	MANDT		☐	MANDT	☐	Client
2	EBELN	EKPO	EBELN		☐	EBELN	☐	Purchasing Document Number
3	EBELP	EKPO	EBELP		☐	EBELP	☐	Item Number of Purchasing Document
4	BUKRS	EKPO	BUKRS		☐	BUKRS	☐	Company Code
5	WERKS	EKPO	WERKS		☐	EWERK	☐	Plant
6	FPLNR	EKPO	FPLNR		☐	IPLNR	☐	Invoicing plan number
7	REPOS	EKPO	REPOS		☐	REPOS	☐	Invoice receipt indicator
8	LOEKZ	EKPO	LOEKZ		☐	ELOEK	☐	Deletion indicator in purchasing document
9	EREKZ	EKPO	EREKZ		☐	EREKZ	☐	Final Invoice Indicator
10	XERSY	EKPO	XERSY		☐	XERSY	☐	Evaluated Receipt Settlement (ERS)
11	MEMORY	EKKO	MEMORY		☐	MEMER	☐	Purchase order not yet complete
12	LIFNR	EKKO	LIFNR		☐	ELIFN	☐	Vendor's account number
13	TXZ01	EKPO	TXZ01		☐	TXZ01	☐	Short Text
14	MENGE	EKPO	MENGE		☐	BSTMG	☐	Purchase Order Quantity
15	MWSKZ	EKPO	MWSKZ		☐	MWSKZ	☐	Tax on sales/purchases code
16	PSTYP	EKPO	PSTYP		☐	PSTYP	☐	Item category in purchasing document
17	WEPOS	EKPO	WEPOS		☐	WEPOS	☐	Goods Receipt Indicator
18	WEUNB	EKPO	WEUNB		☐	WEUNB	☐	Goods Receipt, Non-Valuated
19	WEBRE	EKPO	WEBRE		☐	WEBRE	☐	Indicator: GR-Based Invoice Verification
20	TXJCD	EKPO	TXJCD		☐	TXJCD	☐	Tax Jurisdiction
21	RETPO	EKPO	RETPO		☐	RETPO	☐	Returns Item
22	FPLTR	FPLT	FPLTR		☐	FPLTR	☐	Item for billing plan/invoice plan/payment cards
23	FKDAT	FPLT	FKDAT		☐	BFDAT	☐	Settlement Date for Deadline
24	FAREG	FPLT	FAREG		☐	FAREG	☐	Rule in billing plan/invoice plan
25	FAKWR	FPLT	FAKWR		☐	FAKWR	☐	Value to be billed/calc. on date in billing/invoice plan
26	FAKSP	FPLT	FAKSP		☐	FAKSP_FP	☐	Billing block for billing plan/invoice plan dates
27	WAERS2	FPLT	WAERS		☐	WAERS_CP	☐	Currency Key of Credit Control Area
28	WAERS	EKKO	WAERS		☐	WAERS	☐	Currency Key
29	KUFIX	EKKO	KUFIX		☐	KUFIX	☐	Indicator: Fixing of Exchange Rate
30	WKURS	EKKO	WKURS		☐	WKURS	☐	Exchange Rate
31	ZTERM	EKKO	ZTERM		☐	DZTERM	☐	Terms of payment key
32	LIFRE	EKKO	LIFRE		☐	LIFRE	☐	Different Invoicing Party
33	MEINS	EKPO	MEINS		☐	BSTME	☐	Order unit
34	FRGRL	EKKO	FRGRL		☐	FRGRL	☐	Release Not Yet Completely Effected
35	AFDAT	FPLT	AFDAT		☐	FKDAT	☐	Billing date for billing index and printout

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