SAP ABAP Table AFFWRM (Generated Table for View)

Basic Data

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

Delivery and Maintenance

Pool/cluster	AFFW
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client
2	WEBLNR	☑	WEBLNR	BELNR	CHAR	10	0	Number of a document from a goods movement with errors
3	WEBLPOS	☑	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
4	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
5	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
6	LAEDA	☐	LAEDA	DATUM	DATS	8	0	Date of Last Change
7	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
8	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
9	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
10	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
11	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
12	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
13	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
14	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
15	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
16	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
17	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
18	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
19	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
20	ERFMG	☐	ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry
21	ERFME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	T006
22	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
23	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements
24	RSPOS	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
25	KZBEW	☐	KZBEW	KZBEW	CHAR	1	0	Movement Indicator
26	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	T300
27	LGTYP	☐	LGTYP	LGTYP	CHAR	3	0	Storage Type	T301
28	LGPLA	☐	LGPLA	LGPLA	CHAR	10	0	Storage Bin	LAGP
29	AUFPS	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
30	MSGID	☐	ARBGB	ARBGB	CHAR	20	0	Application Area	T100A
31	MSGNO	☐	MSGNO	MSGNR	CHAR	3	0	System Message Number	T100
32	MSGTY	☐	MSGTY	MSGAR	CHAR	1	0	Message Type
33	MSGV1	☐	MSGV1	CHAR50	CHAR	50	0	Message variable 01
34	MSGV2	☐	MSGV2	CHAR50	CHAR	50	0	Message variable 02
35	MSGV3	☐	MSGV3	CHAR50	CHAR	50	0	Message variable 03
36	MSGV4	☐	MSGV4	CHAR50	CHAR	50	0	Message variable 04
37	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
38	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
39	INSMK	☐	INSMK	INSMK	CHAR	1	0	Stock Type
40	FEVOR	☐	FEVOR	FEVOR	CHAR	3	0	Production Supervisor	T024F
41	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	T024D
42	FWDAT	☐	CO_FWDAT	DATUM	DATS	8	0	Date when the error first arose
43	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
44	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
45	MHDAT	☐	TMHHD	DATUM	DATS	8	0	SLED/Best-Before Date or Date of Production
46	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)
47	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
48	FWZET	☐	CO_FWZET	UZEIT	TIMS	6	0	Time when the error first arose
49	PRVBE	☐	PRVBE	PRVBE	CHAR	10	0	Production Supply Area
50	PRTNR	☐	PRTNR	PRTNR	NUMC	10	0	Confirmation number
51	GRUND	☐	MB_GRBEW	MB_GRBEW	NUMC	4	0	Reason for movement

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AFFWRM	AUFNR	AUFK	AUFNR		C	CN
2	AFFWRM	BWART	T156	BWART		C	CN
3	AFFWRM	CHARG	MCH1	CHARG
4	AFFWRM	DISPO	T024D	DISPO		C	CN
5	AFFWRM	ERFME	T006	MSEHI
6	AFFWRM	FEVOR	T024F	FEVOR		C	CN
7	AFFWRM	KDAUF	VBUK	VBELN
8	AFFWRM	LGNUM	T300	LGNUM
9	AFFWRM	LGORT	T001L	LGORT		C	CN
10	AFFWRM	LGPLA	LAGP	LGPLA
11	AFFWRM	LGTYP	T301	LGTYP
12	AFFWRM	LIFNR	LFA1	LIFNR
13	AFFWRM	MATNR	MARA	MATNR
14	AFFWRM	MSGID	T100A	ARBGB		C	CN
15	AFFWRM	MSGNO	T100	MSGNR		C	CN
16	AFFWRM	SOBKZ	T148	SOBKZ
17	AFFWRM	WAERS	TCURC	WAERS
18	AFFWRM	WERKS	T001W	WERKS		C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in