SAP ABAP Table VIAFVC_SML (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VIAFVC_SML	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
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	AUFPL	☑	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
3	APLZL	☑	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order
4	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
5	STEUS	☐	STEUS	STEUS	CHAR	4	0	Control key	T430
6	ARBID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	CRID
7	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
8	KTSCH	☐	KTSCH	KTSCH	CHAR	7	0	Standard text key	T435
9	LTXA1	☐	LTXA1	TEXT40	CHAR	40	0	Operation short text
10	LOANZ	☐	LOHNANZ	LOHNANZ	DEC	3	0	Number of Time Tickets
11	LOART	☐	LOHNART	LOART	CHAR	4	0	Wage type
12	RSANZ	☐	CR_RS_ANZ	NUM03	NUMC	3	0	Number of confirmation slips
13	QUALF	☐	QUALF	QUALF	CHAR	2	0	Suitability	T423
14	ANZMA	☐	ANZMS	ANZMA	DEC	5	2	Number of employees
15	LOGRP	☐	LOHNGRP	LOHNGRP	CHAR	3	0	Wage group	T421
16	SUMNR	☐	SUMKNTNR	KNTNR	NUMC	8	0	Node number of the superior operation
17	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
18	PREIS	☐	PREIS	WERT11	CURR	11	2	Price
19	PEINH	☐	PEINH	PACK3	DEC	5	0	Price unit
20	SAKTO	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKA
21	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
22	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
23	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
24	EKGRP	☐	VG_EKGRP	EKGRP	CHAR	3	0	Purchasing group for external processing	T024
25	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
26	ANZZL	☐	ANZKAP	INT1	INT1	3	0	Number of capacities required
27	PRZNT	☐	APROZENT	INT1	INT1	3	0	Work percentage
28	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
29	INDET	☐	INDET	INDET	CHAR	1	0	Calculation key
30	LARNT	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type
31	RUECK	☐	CO_RUECK	CO_RUECK	NUMC	10	0	Completion confirmation number for the operation
32	RMZHL	☐	CO_RMZHL	CIM_COUNT	NUMC	8	0	Confirmation counter
33	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
34	BANFN	☐	CO_BANFN	BANFN	CHAR	10	0	Purchase requisition number
35	BNFPO	☐	CO_BNFPO	BNFPO	NUMC	5	0	Item number of the purchase requisition in the order	EBAN
36	SELKZ	☐	CO_SELKZ	CK_SELKZ	CHAR	1	0	Selection indicator for costing line items	TCK08
37	ANLZU	☐	ANLZU	ANLZU	CHAR	1	0	Syst.Condition	T357M
38	ISTRU	☐	ISTRU	MATNR	CHAR	18	0	Assembly	MARA
39	EBORT	☐	EBORT	TEXT20	CHAR	20	0	Installation Point for Subitem
40	MEINH	☐	VORME	MEINS	UNIT	3	0	Unit of measure for activity	T006
41	DAUNO	☐	DAUNOR	DAUER_4_1	QUAN	5	1	Normal duration of the activity
42	DAUNE	☐	DAUNORE	MEINS	UNIT	3	0	Normal duration/unit	T006
43	DAUMI	☐	DAUMIN	DAUER_4_1	QUAN	5	1	Minimum activity duration
44	DAUME	☐	DAUMINE	MEINS	UNIT	3	0	Unit for the minimum duration	T006
45	EINSA	☐	EINSCHRA	RESTRIKSTR	CHAR	1	0	Constraint on the basic start date for the activity
46	EINSE	☐	EINSCHRE	RESTRIKEND	CHAR	1	0	Constraint on the finish date of the activity
47	ARBEI	☐	ARBEIT	ARBEIT	QUAN	7	1	Work involved in the activity
48	ARBEH	☐	ARBEITE	MEINS	UNIT	3	0	Unit for work	T006
49	FSAVD	☐	FSAVD	DATUM	DATS	8	0	Earliest scheduled start: Execution (date)
50	FSAVZ	☐	FSAVZ	ATIME	TIMS	6	0	Earliest scheduled start: Execution (time)
51	FSEDD	☐	FSEDD	DATUM	DATS	8	0	Earliest scheduled finish: Execution (date)
52	FSEDZ	☐	FSEDZ	ATIME	TIMS	6	0	Earliest scheduled finish: Execution (time)
53	SSAVD	☐	SSAVD	DATUM	DATS	8	0	Latest scheduled start: Execution (date)
54	SSAVZ	☐	SSAVZ	ATIME	TIMS	6	0	Latest scheduled start: Execution (time)
55	SSEDD	☐	SSEDD	DATUM	DATS	8	0	Latest scheduled finish: Execution (date)
56	SSEDZ	☐	SSEDZ	ATIME	TIMS	6	0	Latest scheduled finish: Execution (time)
57	ISDD	☐	ISDD	DATUM	DATS	8	0	Actual start: Execution (date)
58	ISDZ	☐	ISDZ	ATIME	TIMS	6	0	Actual start: Execution/setup (time)
59	IEDD	☐	IEDD	DATUM	DATS	8	0	Actual finish: Execution (date)
60	IEDZ	☐	IEDZ	ATIME	TIMS	6	0	Actual finish: Execution (time)
61	PUFFR	☐	PUFFR_FREI	PUFFER	DEC	3	0	Free float
62	PUFGS	☐	PUFFR_GESM	PUFFER	DEC	3	0	Total float
63	NTANF	☐	VORGABESTD	VORGABESTR	DATS	8	0	Constraint for activity start (Basic)
64	NTANZ	☐	VORGABESTZ	ATIME	TIMS	6	0	Constraint for activity start time (Basic)
65	NTEND	☐	VORGABEEND2	VORGABEEND	DATS	8	0	Constraint for Finish of Activity (Basic)
66	NTENZ	☐	VORGABEENZ	ATIME	TIMS	6	0	Basic finish time of the activity
67	ISMNW	☐	CO_ISMNW	MENG13	QUAN	13	3	Actual work
68	AUFKT	☐	AFAKT	AFAKT	DEC	3	0	Execution Factor
69	PERNR	☐	CO_PERNR	PERNR	NUMC	8	0	Personnel number
70	TXTSP	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIAFVC_SML	ANLZU	T357M	ANLZU
2	VIAFVC_SML	ARBEH	T006	MSEHI
3	VIAFVC_SML	ARBID	CRID	OBJID
4	VIAFVC_SML	BNFPO	EBAN	BNFPO
5	VIAFVC_SML	BUKRS	T001	BUKRS
6	VIAFVC_SML	DAUME	T006	MSEHI
7	VIAFVC_SML	DAUNE	T006	MSEHI
8	VIAFVC_SML	EKGRP	T024	EKGRP
9	VIAFVC_SML	EKORG	T024E	EKORG
10	VIAFVC_SML	INFNR	EINA	INFNR
11	VIAFVC_SML	ISTRU	MARA	MATNR
12	VIAFVC_SML	KTSCH	T435	VLSCH
13	VIAFVC_SML	LIFNR	LFA1	LIFNR
14	VIAFVC_SML	LOGRP	T421	LOGRP
15	VIAFVC_SML	MANDT	T000	MANDT
16	VIAFVC_SML	MATKL	T023	MATKL
17	VIAFVC_SML	MEINH	T006	MSEHI
18	VIAFVC_SML	OBJNR	ONR00	OBJNR
19	VIAFVC_SML	QUALF	T423	QUALF
20	VIAFVC_SML	SAKTO	CSKA	KSTAR
21	VIAFVC_SML	SELKZ	TCK08	SELKZ
22	VIAFVC_SML	STEUS	T430	STEUS
23	VIAFVC_SML	TXTSP	T002	SPRAS
24	VIAFVC_SML	WAERS	TCURC	WAERS
25	VIAFVC_SML	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in