SAP ABAP View /SPE/V_CRM_CP (SPE CP Inbound -View for download CP into CRM)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-SPM-INB (Application Component) Goods Receipt Process
     ⤷ /SPE/ID_HANDLING (Package) Inbound delivery handling

Basic Data

View Type	D	Database View
Database View	/SPE/V_CRM_CP
Short Description	SPE CP Inbound -View for download CP into CRM
Root table	MDLV	Customizing MRP Area

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MDLV	MDLV
2	TWLAD
3	ADRC

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	MDLV	MANDT	JL	EQ				0	0
2	TWLAD	MANDT	JR	EQ			AND	0	0
3	MDLV	MANDT	JL	EQ				0	0
4	ADRC	CLIENT	JR	EQ			AND	0	0
5	MDLV	WERZG	JL	EQ				0	0
6	TWLAD	WERKS	JR	EQ			AND	0	0
7	MDLV	ORTZG	JL	EQ				0	0
8	TWLAD	LGORT	JR	EQ			AND	0	0
9	TWLAD	ADRNR	JL	EQ				0	0
10	ADRC	ADDRNUMBER	JR	EQ			AND	0	0
11	MDLV	BERTY		EQ	'02'		AND	0	0
12	MDLV	SPE_BNTYP		EQ	'1'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	MDLV	MANDT		☐	MANDT	☐	Client
2	BERID	MDLV	BERID		☐	BERID	☐	MRP Area
3	BERTX	MDLV	BERTX		☐	BERTX	☐	MRP area text
4	WERZG	MDLV	WERZG		☐	WERKS_D	☐	Plant
5	ORTZG	MDLV	ORTZG		☐	ORTZG	☐	Receiving storage location
6	ADDRNUMBER	ADRC	ADDRNUMBER		☐	AD_ADDRNUM	☐	Address number
7	NAME1	ADRC	NAME1		☐	AD_NAME1	☐	Name 1
8	NAME2	ADRC	NAME2		☐	AD_NAME2	☐	Name 2
9	NAME3	ADRC	NAME3		☐	AD_NAME3	☐	Name 3
10	NAME4	ADRC	NAME4		☐	AD_NAME4	☐	Name 4
11	NAME_CO	ADRC	NAME_CO		☐	AD_NAME_CO	☐	c/o name
12	CITY1	ADRC	CITY1		☐	AD_CITY1	☐	City
13	CITY2	ADRC	CITY2		☐	AD_CITY2	☐	District
14	POST_CODE1	ADRC	POST_CODE1		☐	AD_PSTCD1	☐	City postal code
15	POST_CODE2	ADRC	POST_CODE2		☐	AD_PSTCD2	☐	PO Box postal code
16	POST_CODE3	ADRC	POST_CODE3		☐	AD_PSTCD3	☐	Company postal code (for large customers)
17	PO_BOX	ADRC	PO_BOX		☐	AD_POBX	☐	PO Box
18	PO_BOX_LOC	ADRC	PO_BOX_LOC		☐	AD_POBXLOC	☐	PO Box city
19	POSTALAREA	ADRC	POSTALAREA		☐	AD_PSTLAR	☐	(Not Supported) Post Delivery District
20	STREET	ADRC	STREET		☐	AD_STREET	☐	Street
21	STREETCODE	ADRC	STREETCODE		☐	AD_STRNUM	☐	Street Number for City/Street File
22	STREETABBR	ADRC	STREETABBR		☐	AD_STRABBR	☐	(Not Supported) Abbreviation of Street Name
23	HOUSE_NUM1	ADRC	HOUSE_NUM1		☐	AD_HSNM1	☐	House Number
24	HOUSE_NUM3	ADRC	HOUSE_NUM3		☐	AD_HSNM3	☐	(Not supported) House Number Range
25	LOCATION	ADRC	LOCATION		☐	AD_LCTN	☐	Street 5
26	BUILDING	ADRC	BUILDING		☐	AD_BLDNG	☐	Building (Number or Code)
27	FLOOR	ADRC	FLOOR		☐	AD_FLOOR	☐	Floor in building
28	ROOMNUMBER	ADRC	ROOMNUMBER		☐	AD_ROOMNUM	☐	Room or Appartment Number
29	COUNTRY	ADRC	COUNTRY		☐	LAND1	☐	Country Key
30	LANGU	ADRC	LANGU		☐	SPRAS	☐	Language Key
31	REGION	ADRC	REGION		☐	REGIO	☐	Region (State, Province, County)
32	TEL_NUMBER	ADRC	TEL_NUMBER		☐	AD_TLNMBR1	☐	First telephone no.: dialling code+number
33	TEL_EXTENS	ADRC	TEL_EXTENS		☐	AD_TLXTNS1	☐	First Telephone No.: Extension
34	FAX_NUMBER	ADRC	FAX_NUMBER		☐	AD_FXNMBR1	☐	First fax no.: dialling code+number
35	TAXJURCODE	ADRC	TAXJURCODE		☐	AD_TXJCD	☐	Tax Jurisdiction

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