SAP ABAP View /SAPSRM/SOCO_SRH (Erzeugt aus Ddl Source /SAPSRM/SOCO_SRH)

Hierarchy

☛ SRM_SERVER (Software Component) SRM_SERVER
   ⤷ SRM-EBP-CA-SRH (Application Component) Schnellsuche und erweiterte Suche
     ⤷ /SAPSRM/PDO_SO_SEARCH (Package) Sub-Package for SO Document Search

Basic Data

View Type	D	Database View
Database View	/SAPSRM/SOCO_SRH
Short Description	Erzeugt aus Ddl Source /SAPSRM/SOCO_SRH
Root table	CRMD_ORDERADM_H	Business Transaction

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMD_ORDERADM_H	CRMD_ORDERADM_H
2	BBP_PDHGP
3	CRMD_ORDERADM_I
4	BBP_PDHSS
5	BBP_PDIGP
6	CRM_JEST
7	CRMD_LINK
8	BBP_PDORG
9	CRMD_PARTNER
10	ADRC
11	BBP_PDACC
12	BUT000
13	BBP_PDBEI
14	BBP_PDISS

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRMD_ORDERADM_H	CLIENT	JL	EQ				0	0
2	BBP_PDHGP	CLIENT	JR	EQ			AND	0	0
3	CRMD_ORDERADM_H	GUID	JL	EQ				0	0
4	BBP_PDHGP	GUID	JR	EQ			AND	0	0
5	CRMD_ORDERADM_H	CLIENT	JL	EQ				0	0
6	CRMD_ORDERADM_I	CLIENT	JR	EQ			AND	0	0
7	CRMD_ORDERADM_H	GUID	JL	EQ				0	0
8	CRMD_ORDERADM_I	HEADER	JR	EQ			AND	0	0
9	CRMD_ORDERADM_H	CLIENT	JL	EQ				0	0
10	BBP_PDHSS	CLIENT	JR	EQ			AND	0	0
11	CRMD_ORDERADM_H	GUID	JL	EQ				0	0
12	BBP_PDHSS	GUID	JR	EQ			AND	0	0
13	CRMD_ORDERADM_H	CLIENT	JL	EQ				0	0
14	BBP_PDIGP	CLIENT	JR	EQ			AND	0	0
15	CRMD_ORDERADM_I	GUID	JL	EQ				0	0
16	BBP_PDIGP	GUID	JR	EQ			AND	0	0
17	CRMD_ORDERADM_H	CLIENT	JL	EQ				0	0
18	CRM_JEST	MANDT	JR	EQ			AND	0	0
19	CRMD_ORDERADM_H	GUID	JL	EQ				0	0
20	CRM_JEST	OBJNR	JR	EQ			AND	0	0
21	CRMD_ORDERADM_I	GUID	JL	EQ				0	0
22	CRM_JEST	OBJNR	JR	EQ			AND	0	0
23	CRMD_ORDERADM_I	GUID	JL	EQ				0	0
24	CRMD_LINK	GUID_HI	JR	EQ			AND	0	0
25	CRMD_LINK	OBJTYPE_SET	JL	EQ				0	0
26			JR	EQ	'21'		AND	0	0
27	CRMD_ORDERADM_H	CLIENT	JL	EQ				0	0
28	CRMD_LINK	CLIENT	JR	EQ			AND	0	0
29	CRMD_ORDERADM_H	CLIENT	JL	EQ				0	0
30	BBP_PDORG	CLIENT	JR	EQ			AND	0	0
31	CRMD_LINK	GUID_SET	JL	EQ				0	0
32	BBP_PDORG	SET_GUID	JR	EQ			AND	0	0
33	CRMD_ORDERADM_I	GUID	JL	EQ				0	0
34	CRMD_LINK	GUID_HI	JR	EQ			AND	0	0
35	CRMD_LINK	OBJTYPE_SET	JL	EQ				0	0
36			JR	EQ	'07'		AND	0	0
37	CRMD_ORDERADM_H	CLIENT	JL	EQ				0	0
38	CRMD_LINK	CLIENT	JR	EQ			AND	0	0
39	CRMD_LINK	GUID_SET	JL	EQ				0	0
40	CRMD_PARTNER	GUID	JR	EQ			AND	0	0
41	CRMD_PARTNER	PARTNER_FCT	JL	EQ				0	0
42			JR	EQ	'00000019'		AND	0	0
43	CRMD_ORDERADM_H	CLIENT	JL	EQ				0	0
44	CRMD_PARTNER	CLIENT	JR	EQ			AND	0	0
45	CRMD_ORDERADM_H	CLIENT	JL	EQ				0	0
46	ADRC	CLIENT	JR	EQ			AND	0	0
47	CRMD_PARTNER	ADDR_NR	JL	EQ				0	0
48	ADRC	ADDRNUMBER	JR	EQ			AND	0	0
49	CRMD_ORDERADM_I	GUID	JL	EQ				0	0
50	CRMD_LINK	GUID_HI	JR	EQ			AND	0	0
51	CRMD_LINK	OBJTYPE_SET	JL	EQ				0	0
52			JR	EQ	'31'		AND	0	0
53	CRMD_ORDERADM_H	CLIENT	JL	EQ				0	0
54	CRMD_LINK	CLIENT	JR	EQ			AND	0	0
55	CRMD_ORDERADM_H	CLIENT	JL	EQ				0	0
56	BBP_PDACC	CLIENT	JR	EQ			AND	0	0
57	CRMD_LINK	GUID_SET	JL	EQ				0	0
58	BBP_PDACC	SET_GUID	JR	EQ			AND	0	0
59	CRMD_ORDERADM_I	GUID	JL	EQ				0	0
60	CRMD_LINK	GUID_HI	JR	EQ			AND	0	0
61	CRMD_LINK	OBJTYPE_SET	JL	EQ				0	0
62			JR	EQ	'07'		AND	0	0
63	CRMD_ORDERADM_H	CLIENT	JL	EQ				0	0
64	CRMD_LINK	CLIENT	JR	EQ			AND	0	0
65	CRMD_LINK	GUID_SET	JL	EQ				0	0
66	CRMD_PARTNER	GUID	JR	EQ			AND	0	0
67	CRMD_PARTNER	PARTNER_FCT	JL	EQ				0	0
68			JR	EQ	'00000016'		AND	0	0
69	CRMD_ORDERADM_H	CLIENT	JL	EQ				0	0
70	CRMD_PARTNER	CLIENT	JR	EQ			AND	0	0
71	CRMD_ORDERADM_H	CLIENT	JL	EQ				0	0
72	BUT000	CLIENT	JR	EQ			AND	0	0
73	BUT000	PERSNUMBER	JL	EQ				0	0
74	CRMD_PARTNER	ADDR_NP	JR	EQ			AND	0	0
75	CRMD_ORDERADM_H	CLIENT	JL	EQ				0	0
76	BBP_PDBEI	CLIENT	JR	EQ			AND	0	0
77	CRMD_ORDERADM_I	GUID	JL	EQ				0	0
78	BBP_PDBEI	GUID	JR	EQ			AND	0	0
79	CRMD_ORDERADM_H	CLIENT	JL	EQ				0	0
80	BBP_PDISS	CLIENT	JR	EQ			AND	0	0
81	CRMD_ORDERADM_I	GUID	JL	EQ				0	0
82	BBP_PDISS	GUID	JR	EQ			AND	0	0
83	BBP_PDIGP	GROUPING_LEVEL		NE	' '		OR	0	0
84	BBP_PDIGP	SOURCE_REL_IND		EQ	'X'		OR	0	0
85	BBP_PDIGP	SOURCE_REL_IND		EQ	'M'		OR	0	0
86	BBP_PDIGP	SOURCE_REL_IND		EQ	'U'		OR	0	0
87	BBP_PDIGP	SOURCE_REL_IND		EQ	'C'		OR	0	0
88	BBP_PDIGP	SOURCE_REL_IND		EQ	'A'		OR	0	0
89	BBP_PDIGP	DEL_IND		NE	'X'		AND	0	0
90	BBP_PDHGP	DOC_CLOSED		EQ	' '		AND	0	0
91	BBP_PDHGP	VERSION_TYPE		EQ	' '		AND	0	0
92	CRMD_ORDERADM_H	OBJECT_TYPE		EQ	'BUS2121'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	CRMD_ORDERADM_I	CLIENT		☐	MANDT	☐	Client
2	GUID	CRMD_ORDERADM_I	GUID		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
3	PARENT	CRMD_ORDERADM_I	PARENT		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
4	OBJECT_ID	CRMD_ORDERADM_H	OBJECT_ID		☐	CRMT_OBJECT_ID_DB	☐	Transaction ID
5	PS_COMPLEX_IND	BBP_PDHSS	PS_COMPLEX_IND		☐	/SAPPSSRM/PS_COMPLEX_INDICATOR	☐	Complex Documents Indicator
6	CREATED_BY	CRMD_ORDERADM_I	CREATED_BY		☐	CRMT_CREATED_BY	☐	User that Created the Transaction
7	ORDERED_PROD	CRMD_ORDERADM_I	ORDERED_PROD		☐	CRMT_ORDERED_PROD_DB	☐	Product Name Entered
8	DESCRIPTION	CRMD_ORDERADM_I	DESCRIPTION		☐	CRMT_PRSHTEXTX_DB	☐	Product Short Text
9	DESCRIPTION_UC	CRMD_ORDERADM_I	DESCRIPTION_UC		☐	CRMT_PRSHTEXTG_DB	☐	Product Short Text in Upper Case for F4 Help
10	NUMBER_INT	CRMD_ORDERADM_I	NUMBER_INT		☐	CRMT_ITEM_NO	☐	Item Number in Document
11	NUMBER_EXT	CRMD_ORDERADM_I	NUMBER_EXT		☐	CRMT_ITEM_NO_EXT	☐	External Item Number
12	PRODUCT_SRC_SYS	CRMD_ORDERADM_I	PRODUCT_SRC_SYS		☐	CRMT_PRODUCT_SRC_SYS	☐	Logical System from Which Product Originates
13	ITM_TYPE	CRMD_ORDERADM_I	ITM_TYPE		☐	CRMT_ITEM_TYPE_DB	☐	Item Category
14	CATEGORY_ID	BBP_PDIGP	CATEGORY_ID		☐	BBP_CATEGORY_ID	☐	Product Category ID
15	MANU_PROD	BBP_PDIGP	MANU_PROD		☐	BBP_MFRPN	☐	Manufacturer Part Number
16	MFR_NO_EXT	BBP_PDIGP	MFR_NO_EXT		☐	EMNFR	☐	External manufacturer code name or number
17	CATALOGITEM	BBP_PDIGP	CATALOGITEM		☐	BBP_CATALOGITEM	☐	Catalog Item (Unique Key)
18	CATALOGID	BBP_PDIGP	CATALOGID		☐	BBP_WS_SERVICE_ID	☐	Technical Key of a Web Service (for Example - a Catalog)
19	HIER_CHECK_IND	BBP_PDIGP	HIER_CHECK_IND		☐	BBP_HIER_CHECK_IND	☐	Check Indicator at Hierarchy Level (error in subitem)
20	DELIV_DATE	BBP_PDIGP	DELIV_DATE		☐	EINDT	☐	Item delivery date
21	DELIV_TIME	BBP_PDIGP	DELIV_TIME		☐	BBP_DELIV_TIME	☐	Delivery Time of the Item
22	DELIV_DAYS	BBP_PDIGP	DELIV_DAYS		☐	BBP_DELIV_DAYS	☐	Delivery Time in Days
23	QUANTITY	BBP_PDIGP	QUANTITY		☐	BBP_MNG	☐	Quantity in Order Unit
24	UNIT	BBP_PDIGP	UNIT		☐	BBP_UNIT	☐	Purchase Order Unit
25	VALUE	BBP_PDIGP	VALUE		☐	BBP_VALUE	☐	Net Value
26	CURRENCY	BBP_PDIGP	CURRENCY		☐	WAERS	☐	Currency Key
27	EXT_DEMID	BBP_PDIGP	EXT_DEMID		☐	BBP_EXT_DEMID	☐	External Requirement Tracking Number
28	EXT_DEM_LOGSYS	BBP_PDIGP	EXT_DEM_LOGSYS		☐	BBP_EXT_DEM_LOGSYS	☐	Logical System from where an External Requirement Comes
29	SOURCE_REL_IND	BBP_PDIGP	SOURCE_REL_IND		☐	BBP_SOURCE_REL_IND	☐	Indicator - If the Document is Sourcing-Relevant
30	DOC_PRIORITY	BBP_PDIGP	DOC_PRIORITY		☐	BBP_DOC_PRIORITY	☐	Document Priority
31	GROUPING_LEVEL	BBP_PDIGP	GROUPING_LEVEL		☐	BBP_GROUPING_LEVEL	☐	Specifies How Hierarchy Positions are to be Managed
32	VPER_END	BBP_PDIGP	VPER_END		☐	BBP_VPER_END	☐	Validity period
33	VPER_START	BBP_PDIGP	VPER_START		☐	BBP_VPER_START	☐	Validity Period From
34	CATEGORY	BBP_PDIGP	CATEGORY		☐	BBP_CATEGORY_GUID_RAW	☐	Product Category GUID
35	REQUISITION_NAME	CRMD_ORDERADM_H	DESCRIPTION		☐	CRMT_PROCESS_DESCRIPTION	☐	Transaction Description
36	REQUISITION_NAME_UC	CRMD_ORDERADM_H	DESCRIPTION_UC		☐	CRMT_PROCESS_DESCRIPTION_UC	☐	Transaction Description (Upper Case)
37	HEADER_GUID	CRMD_ORDERADM_H	GUID		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
38	STAT	CRM_JEST	STAT		☐	CRM_J_STATUS	☐	Object Status
39	INACT	CRM_JEST	INACT		☐	CRM_J_INACT	☐	Indicator: Status Is Inactive
40	PROC_ORG	BBP_PDORG	PROC_ORG		☐	BBP_PROC_ORG	☐	Responsible Purchasing Organization
41	PROC_GROUP	BBP_PDORG	PROC_GROUP		☐	BBP_PROC_GROUP	☐	Responsible Purchasing Group
42	PARTNER_NO	CRMD_PARTNER	PARTNER_NO		☐	CRMT_PARTNER_NO	☐	Partner Number
43	PARTNER_FCT	CRMD_PARTNER	PARTNER_FCT		☐	CRMT_PARTNER_FCT	☐	Partner Function
44	ACC_CAT	BBP_PDACC	ACC_CAT		☐	BBP_ACC_CAT	☐	Account Assignment Category in Enterprise Buyer
45	COST_CTR	BBP_PDACC	COST_CTR		☐	KOSTL	☐	Cost Center
46	ASSET_NO	BBP_PDACC	ASSET_NO		☐	ANLN1	☐	Main Asset Number
47	WBS_ELEM_E	BBP_PDACC	WBS_ELEM_E		☐	BBP_WBS_ELEM	☐	Work Breakdown Structure Element (WBS element)
48	ORDER_NO	BBP_PDACC	ORDER_NO		☐	AUFNR	☐	Order Number
49	NETWORK	BBP_PDACC	NETWORK		☐	NPLNR	☐	Network Number for Account Assignment
50	GRANT_NBR	BBP_PDACC	GRANT_NBR		☐	GM_GRANT_NBR	☐	Grant
51	CMMT_ITEM	BBP_PDACC	CMMT_ITEM		☐	FM_FIPEX	☐	Commitment item
52	FUNDS_CTR	BBP_PDACC	FUNDS_CTR		☐	FISTL	☐	Funds Center
53	FUND	BBP_PDACC	FUND		☐	BP_GEBER	☐	Fund
54	NAME1	ADRC	NAME1		☐	AD_NAME1	☐	Name 1
55	REQ_PARTNER_NO	CRMD_PARTNER	PARTNER_NO		☐	CRMT_PARTNER_NO	☐	Partner Number
56	REQ_PARTNER_FCT	CRMD_PARTNER	PARTNER_FCT		☐	CRMT_PARTNER_FCT	☐	Partner Function
57	PARTNER	BUT000	PARTNER		☐	BU_PARTNER	☐	Business Partner Number
58	NAME_FIRST	BUT000	NAME_FIRST		☐	BU_NAMEP_F	☐	First name of business partner (person)
59	NAME_LAST	BUT000	NAME_LAST		☐	BU_NAMEP_L	☐	Last name of business partner (person)
60	BE_INFO_REC	BBP_PDBEI	BE_INFO_REC		☐	INFNR	☐	Number of purchasing info record
61	PS_HL_ITEM	BBP_PDISS	PS_HL_ITEM		☐	/SAPPSSRM/_HL_ITEM	☐	Higher-Level Item GUID
62	PS_HANDLE_ITM	BBP_PDISS	PS_HANDLE_ITM		☐	BBP_GUID	☐	Globally Unique identifier
63	PS_CTRL_KEY	BBP_PDISS	PS_CTRL_KEY		☐	/SAPPSSRM/_PS_CTRL_KEY	☐	Item Process Type Control Key
64	DOC_CLOSED	BBP_PDHGP	DOC_CLOSED		☐	BBP_DOC_CLOSED	☐	Indicator Document Closed
65	VERSION_TYPE	BBP_PDHGP	VERSION_TYPE		☐	BBP_VERSION_TYPE	☐	Version Type (Active Document, 'Normal', Work Version)
66	DEL_IND	BBP_PDIGP	DEL_IND		☐	BBP_DEL_IND	☐	Deletion Indicator EBP Purchasing Document

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	DDIC	20150525
SAP Release Created in	713