SAP ABAP View V_EKKONA (View for Outputting of Purchasing Documents)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ SRM-EBP (Application Component) Enterprise Buyer
     ⤷ BBP_APPLICATION (Package) Structure Package EBP
       ⤷ ME (Package) Application development R/3 Purchasing

Basic Data

View Type	D	Database View
Database View	V_EKKONA
Short Description	View for Outputting of Purchasing Documents
Root table	EKKO	Purchasing Document Header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EKKO	EKKO
2	NAST

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EKKO	MANDT	JL	EQ				0	0
2	NAST	MANDT	JR	EQ			AND	0	0
3	EKKO	EBELN	JL	EQ				0	0
4	NAST	OBJKY	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	EKKO	MANDT		☐	MANDT	☐	Client
2	EBELN	EKKO	EBELN		☐	EBELN	☐	Purchasing Document Number
3	BUKRS	EKKO	BUKRS		☐	BUKRS	☐	Company Code
4	BSTYP	EKKO	BSTYP		☐	EBSTYP	☐	Purchasing Document Category
5	BSART	EKKO	BSART		☐	ESART	☐	Purchasing Document Type
6	BSAKZ	EKKO	BSAKZ		☐	BSAKZ	☐	Control indicator for purchasing document type
7	LOEKZ	EKKO	LOEKZ		☐	ELOEK	☐	Deletion indicator in purchasing document
8	LIFNR	EKKO	LIFNR		☐	ELIFN	☐	Vendor's account number
9	EKSPRAS	EKKO	SPRAS		☐	SPRAS	☐	Language Key
10	EKORG	EKKO	EKORG		☐	EKORG	☐	Purchasing organization
11	EKGRP	EKKO	EKGRP		☐	BKGRP	☐	Purchasing Group
12	BEDAT	EKKO	BEDAT		☐	EBDAT	☐	Purchasing Document Date
13	EKADRNR	EKKO	ADRNR		☐	AD_ADDRNUM	☐	Address number
14	KUNNR	EKKO	KUNNR		☐	KUNNR	☐	Customer Number
15	RESWK	EKKO	RESWK		☐	RESWK	☐	Supplying (issuing) plant in case of stock transport order
16	*	NAST	*		☐		☐
17	-	NAST	MANDT		☐	MANDT	☐	Client
18	KAPPL	NAST	KAPPL		☐	SNA_KAPPL	☐	Application for message conditions
19	OBJKY	NAST	OBJKY		☐	NA_OBJKEY	☐	Object key
20	KSCHL	NAST	KSCHL		☐	SNA_KSCHL	☐	Message type
21	SPRAS	NAST	SPRAS		☐	NA_SPRAS	☐	Message language
22	PARNR	NAST	PARNR		☐	NA_PARNR	☐	Message partner
23	PARVW	NAST	PARVW		☐	SNA_PARVW	☐	Partner function (for example SH for ship-to party)
24	ERDAT	NAST	ERDAT		☐	NA_ERDAT	☐	Date on which status record was created
25	ERUHR	NAST	ERUHR		☐	NA_ERUHR	☐	Time at which status record was created
26	ADRNR	NAST	ADRNR		☐	AD_ADDRNUM	☐	Address number
27	NACHA	NAST	NACHA		☐	NA_NACHA	☐	Message transmission medium
28	ANZAL	NAST	ANZAL		☐	NA_ANZAL	☐	Number of messages (original + copies)
29	VSZTP	NAST	VSZTP		☐	NA_VSZTP	☐	Dispatch time
30	VSDAT	NAST	VSDAT		☐	NA_VSDAT	☐	Requested date for sending message
31	VSURA	NAST	VSURA		☐	NA_VSURA	☐	Requested time for sending message (from)
32	VSURB	NAST	VSURB		☐	NA_VSURB	☐	Requested time for sending message (to)
33	MANUE	NAST	MANUE		☐	NA_MANUE	☐	Message processed manually
34	DATVR	NAST	DATVR		☐	NA_DATVR	☐	Processing date
35	UHRVR	NAST	UHRVR		☐	NA_UHRVR	☐	Processing time
36	DATRE	NAST	DATRE		☐	NA_DATRE	☐	Date of the expected response to a message
37	USNAM	NAST	USNAM		☐	USNAM	☐	User name
38	VSTAT	NAST	VSTAT		☐	NA_VSTAT	☐	Processing status of message
39	AKTIV	NAST	AKTIV		☐	NA_AKTIV	☐	Active
40	TCODE	NAST	TCODE		☐	CSTRATEGY	☐	Communication strategy
41	LDEST	NAST	LDEST		☐	RSPOPNAME	☐	Spool: Output device
42	DSNAM	NAST	DSNAM		☐	RSPO0NAME	☐	Spool request: Name
43	DSUF1	NAST	DSUF1		☐	RSPO1NAME	☐	Spool request: Suffix 1
44	DSUF2	NAST	DSUF2		☐	RSPO2NAME	☐	Spool request: Suffix 2
45	DIMME	NAST	DIMME		☐	TDIMMED	☐	Print immediately
46	DELET	NAST	DELET		☐	TDDELETE	☐	Release after output
47	TELFX	NAST	TELFX		☐	NA_TELFX	☐	Fax number
48	TELX1	NAST	TELX1		☐	TELX1	☐	Telex number
49	TELTX	NAST	TELTX		☐	TELTX	☐	Teletex number
50	AENDE	NAST	AENDE		☐	NA_AENDE	☐	Change message flag
51	REPET	NAST	REPET		☐	NA_REPET	☐	Repeatability of message
52	REPID	NAST	REPID		☐	NA_OBS008	☐	Unused field
53	PFLD1	NAST	PFLD1		☐	NA_OBS030	☐	Unused field
54	PFLD2	NAST	PFLD2		☐	NA_OBS030	☐	Unused field
55	PFLD3	NAST	PFLD3		☐	NA_OBS030	☐	Unused field
56	PFLD4	NAST	PFLD4		☐	NA_TDFORM	☐	WFMC: SAPscript form in 30-character field
57	PFLD5	NAST	PFLD5		☐	NA_LABEL	☐	WFMC: Function module for print formatting
58	PMID1	NAST	PMID1		☐	NA_OBS003	☐	Unused field
59	PMID2	NAST	PMID2		☐	NA_OBS003	☐	Unused field
60	PMID3	NAST	PMID3		☐	NA_OBS003	☐	Unused field
61	PMID4	NAST	PMID4		☐	NA_OBS003	☐	Unused field
62	PMID5	NAST	PMID5		☐	NA_OBS003	☐	Unused field
63	TDNAME	NAST	TDNAME		☐	NA_OBJKY_L	☐	Object key (long)
64	TDID	NAST	TDID		☐	TDID	☐	Text ID
65	TDSPRAS	NAST	TDSPRAS		☐	SPRAS	☐	Language Key
66	EDIKEY	NAST	EDIKEY		☐	NA_DUNNING_DATE	☐	Dunning Date (Used in Retail)
67	EDITRANS	NAST	EDITRANS		☐	NA_DUNNING_TIME	☐	Dunning Time (Used in Retail)
68	SNDDR	NAST	SNDDR		☐	SO_SND_DR	☐	Send: As disregard
69	SNDEX	NAST	SNDEX		☐	NA_OBS001	☐	Unused field
70	SNDCP	NAST	SNDCP		☐	NA_OBS001	☐	Unused field
71	SNDBC	NAST	SNDBC		☐	AD_ADRTYPE	☐	Address type (1=Organization, 2=Person, 3=Contact person)
72	FORFB	NAST	FORFB		☐	BCS_RQST	☐	Requested Status
73	PRIFB	NAST	PRIFB		☐	BCS_STML	☐	Setting for Which Statuses Are Reported by Mail
74	ACALL	NAST	ACALL		☐	NA_OBS001	☐	Unused field
75	OBJAC	NAST	OBJAC		☐	NA_OBS001	☐	Unused field
76	OBJRR	NAST	OBJRR		☐	NA_OBS001	☐	Unused field
77	OBJRN	NAST	OBJRN		☐	NA_OBS001	☐	Unused field
78	OUTFL	NAST	OUTFL		☐	NA_OBS001	☐	Unused field
79	OBJSNS	NAST	OBJSNS		☐	NA_OBS001	☐	Unused field
80	OBJPRI	NAST	OBJPRI		☐	NA_OBS001	☐	Unused field
81	OBJCP	NAST	OBJCP		☐	NA_OBS001	☐	Unused field
82	NAUTO	NAST	NAUTO		☐	NA_NAUTO	☐	Message determined via conditions
83	TDRECEIVER	NAST	TDRECEIVER		☐	SYPRREC	☐	Spool Recipient Name
84	TDDIVISION	NAST	TDDIVISION		☐	SYPRABT	☐	Spool Department Name
85	TDOCOVER	NAST	TDOCOVER		☐	SYPRSAP	☐	Print SAP Cover Page
86	TDCOVTITLE	NAST	TDCOVTITLE		☐	SYPRTXT	☐	Spool Description
87	TDAUTORITY	NAST	TDAUTORITY		☐	SYPRBER	☐	Print: Authorization
88	TDARMOD	NAST	TDARMOD		☐	SYARMOD	☐	Print Archive Mode
89	OPTARCNR	NAST	OPTARCNR		☐	NA_OPTAR	☐	Archive number for optical archives
90	CMFPNR	NAST	CMFPNR		☐	NA_CMF_NR	☐	Error management number
91	USRNAM	NAST	USRNAM		☐	NA_PERS_12	☐	WFMC: Address number, 12 characters
92	EVENT	NAST	EVENT		☐	SWO_EVENT	☐	Event
93	SORT1	NAST	SORT1		☐	NAST_SORTK	☐	Sort criteria for message status records
94	SORT2	NAST	SORT2		☐	NAST_SORTK	☐	Sort criteria for message status records
95	SORT3	NAST	SORT3		☐	NAST_SORTK	☐	Sort criteria for message status records
96	OBJTYPE	NAST	OBJTYPE		☐	OJ_NAME	☐	Object type
97	TDSCHEDULE	NAST	TDSCHEDULE		☐	SKSCHEDULE	☐	Send time request
98	TLAND	NAST	TLAND		☐	LAND1	☐	Country Key

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