SAP ABAP View V_MAFU (Preference: Alternative Commodity Code)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ VEI (Package) Application development R/3 foreign trade

Basic Data

View Type	C	Maintenance View
Maintenance View	V_MAFU
Short Description	Preference: Alternative Commodity Code
Root table	MAFU	Foreign Trade: Additional Information for Material/Code No.

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MAFU	MAFU
2	MARC	MAFU	MATNR	E
3	T001W	MAFU	WERKS	E
4	T005	T001W	LAND1	E
5	T005T	T005	LAND1	I
6	MARA	MARC	MATNR	E
7	MAKT	MARA	MATNR	I

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	MAFU	MANDT		☐	MANDT	☐	Client
2	MATNR	MAFU	MATNR		☐	MATNR	☐	Material Number
3	WERKS	MAFU	WERKS		☐	WERKS_D	☐	Plant
4	QUALF	MAFU	QUALF		☐	QUREF	☐	Foreign Trade: Qualifier for code numbers in reference table
5	LFDNR	MAFU	LFDNR		☐	LFDNR	☐	Sequence Number
6	STAWN	MARC	STAWN	R	☐	STAWN	☐	Commodity Code/Import Code Number for Foreign Trade
7	NAME1	T001W	NAME1	R	☐	NAME1	☐	Name
8	STRAS	T001W	STRAS	R	☐	STRAS	☐	House number and street
9	PSTLZ	T001W	PSTLZ	R	☐	PSTLZ	☐	Postal Code
10	ORT01	T001W	ORT01	R	☐	ORT01	☐	City
11	LAND1	T001W	LAND1	R	☐	LAND1	☐	Country Key
12	LANDX	T005T	LANDX	R	☐	LANDX	☐	Country Name
13	MAKTX	MAKT	MAKTX	R	☐	MAKTX	☐	Material description
14	STAWN_PRE	MAFU	STAWN		☐	STAWN	☐	Commodity Code/Import Code Number for Foreign Trade

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	X	Display/Maintenance Allowed

History

Last changed by/on	SAP	20140121
SAP Release Created in