SAP ABAP View ERDB_ERDK (View of ERDB and ERDK)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-IN (Application Component) Invoicing
     ⤷ EE22 (Package) IS-U: Bill Printout

Basic Data

View Type	D	Database View
Database View	ERDB_ERDK
Short Description	View of ERDB and ERDK
Root table	ERDB	Documents for Print Document (ERDK)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ERDB	ERDB
2	ERDK

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ERDB	MANDT	JL	EQ				0	0
2	ERDK	MANDT	JR	EQ			AND	0	0
3	ERDB	OPBEL	JL	EQ				0	0
4	ERDB	OPBEL	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	ERDB	MANDT		☐	MANDT	☐	Client
2	OPBEL	ERDB	OPBEL		☐	E_PRINTDOC	☐	Number of print document
3	LFDNR	ERDB	LFDNR		☐	E_DOCLFDNR	☐	Internal Consecutive Numbers of Documents in Invoicing
4	INVOPBEL	ERDB	INVOPBEL		☐	OPBEL_KK	☐	Number of Contract Accts Rec. & Payable Doc.
5	INVOPUPW	ERDB	INVOPUPW		☐	OPUPW_KK	☐	Repetition Item in Contract Account Document
6	INVOPUPK	ERDB	INVOPUPK		☐	OPUPK_KK	☐	Item number in contract account document
7	DOC_ID	ERDB	DOC_ID		☐	E_DOCID	☐	Type of Contract Accounting Document in Invoicing
8	AWTYP	ERDB	AWTYP		☐	AWTYP	☐	Reference procedure
9	AWKEY	ERDB	AWKEY		☐	AWKEY	☐	Object key
10	OPBEL_M	ERDB	OPBEL_M		☐	OPBEL_KK	☐	Number of Contract Accts Rec. & Payable Doc.
11	DRUCKDAT	ERDK	DRUCKDAT		☐	DRUCKDAT	☐	Print Date
12	FAEDN	ERDK	FAEDN		☐	FAEDN_KK	☐	Due date for net payment
13	FAEDS	ERDK	FAEDS		☐	FAEDS_KK	☐	Due Date for Cash Discount
14	SKTPZ	ERDK	SKTPZ		☐	SKTPZ_KK	☐	Cash discount rate
15	BUDAT	ERDK	BUDAT		☐	BUDAT	☐	Posting Date in the Document
16	BLDAT	ERDK	BLDAT		☐	BLDAT	☐	Document Date in Document
17	STOKZ	ERDK	STOKZ		☐	STOKZ	☐	Document Has Been Reversed
18	INTOPBEL	ERDK	INTOPBEL		☐	INTOPBEL	☐	Number of Print Document Used to Reverse Document
19	ERDZ_V	ERDK	ERDZ_V		☐	ERDZ_V	☐	ERDZ/ERDL exists for ERDK
20	ERDR_V	ERDK	ERDR_V		☐	ERDR_V	☐	ERDR exists for ERDK
21	ERDO_V	ERDK	ERDO_V		☐	ERDO_V	☐	ERDO exists for ERDK
22	ERDB_V	ERDK	ERDB_V		☐	ERDB_V	☐	ERDB exists for ERDK
23	ERDU_V	ERDK	ERDU_V		☐	ERDU_V	☐	ERDU exists for ERDK
24	ERDTS_V	ERDK	ERDTS_V		☐	ERDTS_V	☐	ERDTS exists for ERDK
25	FICA_V	ERDK	FICA_V		☐	FICA_V	☐	FI-CA Document Posted
26	TOTAL_AMNT	ERDK	TOTAL_AMNT		☐	BETRW_KK	☐	Amount in Transaction Currency with +/- Sign
27	TOTAL_WAER	ERDK	TOTAL_WAER		☐	BLWAE_KK	☐	Transaction Currency
28	TOTAL_AMNT_USE	ERDK	TOTAL_AMNT_USE		☐	TOTAL_AMNT_USE	☐	Indicator: Use of bill sum total
29	PYMET	ERDK	PYMET		☐	PYMET_KK	☐	Payment Method
30	ZLSCH	ERDK	ZLSCH		☐	FIDZT	☐	Form ID for Attached Payment Medium
31	NRZAS	ERDK	NRZAS		☐	NRZAS_KK	☐	Payment Form Number
32	PARTNER	ERDK	PARTNER		☐	BU_PARTNER	☐	Business Partner Number
33	VKONT	ERDK	VKONT		☐	VKONT_KK	☐	Contract Account Number
34	PORTION	ERDK	PORTION		☐	PORTION	☐	Portion
35	ABRVORG	ERDK	ABRVORG		☐	ABRVORG	☐	Billing Transaction
36	FORMKEY	ERDK	FORMKEY		☐	FORMKEY	☐	Application form
37	FIKEY	ERDK	FIKEY		☐	FIKEY_KK	☐	Reconciliation Key for General Ledger
38	TOBRELEASD	ERDK	TOBRELEASD		☐	TOBRELEASD	☐	Indicator: document not released yet
39	SIMULATED	ERDK	SIMULATED		☐	SIMULATED	☐	Indicator: invoicing generates a simulated document
40	INVOICED	ERDK	INVOICED		☐	INVOICED	☐	Indicator: document posted
41	ABWVK	ERDK	ABWVK		☐	ABWVK_KK	☐	Alternative contract account for collective bills
42	ABWBL	ERDK	ABWBL		☐	ABWBL_KK	☐	Number of the substitute FI-CA document
43	ERGRD	ERDK	ERGRD		☐	ERGRD	☐	Reason for creating print document
44	LANGU	ERDK	LANGU		☐	LANGU_ACC	☐	Language in connection with the contract account
45	ERDAT	ERDK	ERDAT		☐	ERDAT	☐	Date on which the record was created
46	ERNAM	ERDK	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
47	AEDAT	ERDK	AEDAT		☐	AEDAT	☐	Last Changed On
48	AENAM	ERDK	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
49	BEGRU	ERDK	BEGRU		☐	BEGRU	☐	Authorization Group
50	LOEVM	ERDK	LOEVM		☐	LOEVM	☐	Deletion Indicator
51	VERART	ERDK	VERART		☐	VERART_KK	☐	Clearing Type For Clearing Postings
52	STO_BUDAT	ERDK	STO_BUDAT		☐	STO_BUDAT	☐	Reversal Date of Original Document (Reversal Only)
53	STO_OPBEL	ERDK	STO_OPBEL		☐	STO_OPBEL	☐	Document Number of Original Document (Only for Reversal)
54	ICREASON	ERDK	ICREASON		☐	BCREASON	☐	Reason for Reversal
55	MAZAE	ERDK	MAZAE		☐	MAZAE_KK	☐	Counter for several dunning notices to a business partner
56	ITEMS_ARCHIVED	ERDK	ITEMS_ARCHIVED		☐	ITEMS_ARCHIVED	☐	Line items are archived
57	EXKID	ERDK	EXKID		☐	EXKID_KK	☐	Key Identification
58	EXBEL	ERDK	EXBEL		☐	EXBEL_KK	☐	Official Document Number
59	MAZAE_ABS	ERDK	MAZAE_ABS		☐	MAZAE_KK	☐	Counter for several dunning notices to a business partner
60	PRINTLOCK	ERDK	PRINTLOCK		☐	E_PRINTLOCK	☐	Document is Blocked for Printing
61	EDIDISPATCH	ERDK	EDIDISPATCH		☐	E_EDIDISPATCH	☐	Transmit Print Document Via EDI
62	EDISENDDATE	ERDK	EDISENDDATE		☐	EDISENDDAT	☐	Generation Date of EDI for Print Document
63	TAXDATE	ERDK	TAXDATE		☐	E_TAXDATE	☐	Tax Determination Date
64	CREATION_TIME	ERDK	CREATION_TIME		☐	E_CREATION_TIME	☐	Time of Print Document Creation

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	20131127
SAP Release Created in	471