SAP ABAP View /SAPSRM/SC_PWL (Erzeugt aus Ddl Source /SAPSRM/SC_PWL)
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/SC_PWL  
Short Description Erzeugt aus Ddl Source /SAPSRM/SC_PWL    
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 BBP_PDHSS  
4 CRM_JEST  
5 CRMD_ORDERADM_I  
6 CRMD_LINK  
7 CRMD_PARTNER  
8 BBP_PDORG  
9 BBP_PDIGP  
10 BBP_PDISS  
11 BBP_PDBEI  
12 /SAPSRM/D_WF_006  
13 /SAPSRM/D_WF_013  
14 BBP_PDPSET  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 BBP_PDHGP CLIENT JL EQ 0 0
2 CRMD_ORDERADM_H CLIENT JR EQ AND 0 0
3 BBP_PDHGP GUID JL EQ 0 0
4 CRMD_ORDERADM_H GUID JR EQ AND 0 0
5 BBP_PDHGP VERSION_TYPE JL NE 0 0
6   JR NE 'H' AND 0 0
7 CRMD_ORDERADM_H OBJECT_TYPE JL EQ 0 0
8   JR EQ 'BUS2121' AND 0 0
9 CRMD_ORDERADM_H CLIENT JL EQ 0 0
10 BBP_PDHGP CLIENT JR EQ AND 0 0
11 BBP_PDHSS CLIENT JL EQ 0 0
12 BBP_PDHGP CLIENT JR EQ AND 0 0
13 BBP_PDHSS GUID JL EQ 0 0
14 BBP_PDHGP GUID JR EQ AND 0 0
15 CRMD_ORDERADM_H CLIENT JL EQ 0 0
16 BBP_PDHSS CLIENT JR EQ AND 0 0
17 CRM_JEST MANDT JL EQ 0 0
18 CRMD_ORDERADM_H CLIENT JR EQ AND 0 0
19 CRM_JEST OBJNR JL EQ 0 0
20 CRMD_ORDERADM_H GUID JR EQ AND 0 0
21 CRM_JEST STAT JL NE 0 0
22   JR NE 'I1021' AND 0 0
23 CRM_JEST STAT JL NE 0 0
24   JR NE 'I1039' AND 0 0
25 CRM_JEST STAT JL NE 0 0
26   JR NE 'I1038' AND 0 0
27 CRM_JEST INACT JL NE 0 0
28   JR NE 'X' AND 0 0
29 CRMD_ORDERADM_H CLIENT JL EQ 0 0
30 CRM_JEST MANDT JR EQ AND 0 0
31 CRMD_ORDERADM_I CLIENT JL EQ 0 0
32 CRMD_ORDERADM_H CLIENT JR EQ AND 0 0
33 CRMD_ORDERADM_I HEADER JL EQ 0 0
34 CRMD_ORDERADM_H GUID JR EQ AND 0 0
35 CRMD_ORDERADM_H CLIENT JL EQ 0 0
36 CRMD_ORDERADM_I CLIENT JR EQ AND 0 0
37 CRM_JEST MANDT JL EQ 0 0
38 CRMD_ORDERADM_I CLIENT JR EQ AND 0 0
39 CRM_JEST OBJNR JL EQ 0 0
40 CRMD_ORDERADM_I GUID JR EQ AND 0 0
41 CRM_JEST STAT JL EQ 0 0
42   JR EQ 'I1112' AND 0 0
43 CRM_JEST INACT JL NE 0 0
44   JR NE 'X' AND 0 0
45 CRMD_ORDERADM_H CLIENT JL EQ 0 0
46 CRM_JEST MANDT JR EQ AND 0 0
47 CRMD_LINK CLIENT JL EQ 0 0
48 CRMD_ORDERADM_I CLIENT JR EQ AND 0 0
49 CRMD_LINK GUID_HI JL EQ 0 0
50 CRMD_ORDERADM_I GUID JR EQ AND 0 0
51 CRMD_LINK OBJTYPE_SET JL EQ 0 0
52   JR EQ '07' AND 0 0
53 CRMD_LINK OBJTYPE_HI JL EQ 0 0
54   JR EQ '06' AND 0 0
55 CRMD_ORDERADM_H CLIENT JL EQ 0 0
56 CRMD_LINK CLIENT JR EQ AND 0 0
57 CRMD_LINK CLIENT JL EQ 0 0
58 CRMD_PARTNER CLIENT JR EQ AND 0 0
59 CRMD_LINK GUID_SET JL EQ 0 0
60 CRMD_PARTNER GUID JR EQ AND 0 0
61 CRMD_PARTNER DISABLED JL NE 0 0
62   JR NE 'X' AND 0 0
63 CRMD_PARTNER PARTNER_FCT JL EQ 0 0
64   JR EQ '00000016' AND 0 0
65 CRMD_PARTNER PARTNER_FCT JL EQ 0 0
66   JR EQ '00000020' AND 0 0
67 CRMD_ORDERADM_H CLIENT JL EQ 0 0
68 CRMD_PARTNER CLIENT JR EQ AND 0 0
69 CRMD_LINK CLIENT JL EQ 0 0
70 CRMD_ORDERADM_I CLIENT JR EQ AND 0 0
71 CRMD_LINK GUID_HI JL EQ 0 0
72 CRMD_ORDERADM_I GUID JR EQ AND 0 0
73 CRMD_LINK OBJTYPE_SET JL EQ 0 0
74   JR EQ '21' AND 0 0
75 CRMD_ORDERADM_H CLIENT JL EQ 0 0
76 CRMD_LINK CLIENT JR EQ AND 0 0
77 CRMD_LINK CLIENT JL EQ 0 0
78 BBP_PDORG CLIENT JR EQ AND 0 0
79 CRMD_LINK GUID_SET JL EQ 0 0
80 BBP_PDORG SET_GUID JR EQ AND 0 0
81 CRMD_ORDERADM_H CLIENT JL EQ 0 0
82 BBP_PDORG CLIENT JR EQ AND 0 0
83 BBP_PDIGP CLIENT JL EQ 0 0
84 CRMD_ORDERADM_I CLIENT JR EQ AND 0 0
85 BBP_PDIGP GUID JL EQ 0 0
86 CRMD_ORDERADM_I GUID JR EQ AND 0 0
87 BBP_PDIGP DEL_IND JL NE 0 0
88   JR NE 'X' AND 0 0
89 CRMD_ORDERADM_H CLIENT JL EQ 0 0
90 BBP_PDIGP CLIENT JR EQ AND 0 0
91 BBP_PDISS CLIENT JL EQ 0 0
92 BBP_PDIGP CLIENT JR EQ AND 0 0
93 BBP_PDISS GUID JL EQ 0 0
94 BBP_PDIGP GUID JR EQ AND 0 0
95 CRMD_ORDERADM_H CLIENT JL EQ 0 0
96 BBP_PDISS CLIENT JR EQ AND 0 0
97 BBP_PDBEI CLIENT JL EQ 0 0
98 BBP_PDIGP CLIENT JR EQ AND 0 0
99 BBP_PDBEI GUID JL EQ 0 0
100 BBP_PDIGP GUID JR EQ AND 0 0
101 BBP_PDBEI BE_OBJECT_TYPE JL EQ 0 0
102   JR EQ 'BUS2201' AND 0 0
103 BBP_PDBEI BE_OBJECT_TYPE JL EQ 0 0
104   JR EQ 'BUS2012' AND 0 0
105 CRMD_ORDERADM_H CLIENT JL EQ 0 0
106 BBP_PDBEI CLIENT JR EQ AND 0 0
107 /SAPSRM/D_WF_006 CLIENT JL EQ 0 0
108 BBP_PDIGP CLIENT JR EQ AND 0 0
109 /SAPSRM/D_WF_006 ITEM_GUID JL EQ 0 0
110 BBP_PDIGP GUID JR EQ AND 0 0
111 CRMD_ORDERADM_H CLIENT JL EQ 0 0
112 /SAPSRM/D_WF_006 CLIENT JR EQ AND 0 0
113 /SAPSRM/D_WF_013 CLIENT JL EQ 0 0
114 /SAPSRM/D_WF_006 CLIENT JR EQ AND 0 0
115 /SAPSRM/D_WF_013 LEADING_OBJ_GUID JL EQ 0 0
116 /SAPSRM/D_WF_006 DECISION_SET_ID JR EQ AND 0 0
117 CRMD_ORDERADM_H CLIENT JL EQ 0 0
118 /SAPSRM/D_WF_013 CLIENT JR EQ AND 0 0
119 CRMD_ORDERADM_H CLIENT JL EQ 0 0
120 BBP_PDBEI CLIENT JR EQ AND 0 0
121 CRMD_ORDERADM_H OBJECT_ID JL EQ 0 0
122 BBP_PDBEI BE_OBJECT_ID JR EQ AND 0 0
123 CRMD_ORDERADM_H OBJECT_TYPE JL EQ 0 0
124   JR EQ 'BUS2201' AND 0 0
125 CRMD_ORDERADM_H CLIENT JL EQ 0 0
126 CRMD_ORDERADM_H CLIENT JR EQ AND 0 0
127 CRM_JEST MANDT JL EQ 0 0
128 CRMD_ORDERADM_H CLIENT JR EQ AND 0 0
129 CRM_JEST OBJNR JL EQ 0 0
130 CRMD_ORDERADM_H GUID JR EQ AND 0 0
131 CRM_JEST STAT JL NE 0 0
132   JR NE 'I1021' AND 0 0
133 CRM_JEST STAT JL NE 0 0
134   JR NE 'I1039' AND 0 0
135 CRM_JEST STAT JL NE 0 0
136   JR NE 'I1038' AND 0 0
137 CRM_JEST INACT JL NE 0 0
138   JR NE 'X' AND 0 0
139 CRMD_ORDERADM_H CLIENT JL EQ 0 0
140 CRM_JEST MANDT JR EQ AND 0 0
141 CRMD_ORDERADM_I CLIENT JL EQ 0 0
142 CRMD_ORDERADM_H CLIENT JR EQ AND 0 0
143 CRMD_ORDERADM_I HEADER JL EQ 0 0
144 CRMD_ORDERADM_H GUID JR EQ AND 0 0
145 CRMD_ORDERADM_H CLIENT JL EQ 0 0
146 CRMD_ORDERADM_I CLIENT JR EQ AND 0 0
147 BBP_PDIGP CLIENT JL EQ 0 0
148 CRMD_ORDERADM_I CLIENT JR EQ AND 0 0
149 BBP_PDIGP GUID JL EQ 0 0
150 CRMD_ORDERADM_I GUID JR EQ AND 0 0
151 BBP_PDIGP DEL_IND JL NE 0 0
152   JR NE 'X' AND 0 0
153 CRMD_ORDERADM_H CLIENT JL EQ 0 0
154 BBP_PDIGP CLIENT JR EQ AND 0 0
155 BBP_PDPSET CLIENT JL EQ 0 0
156 CRMD_ORDERADM_I CLIENT JR EQ AND 0 0
157 BBP_PDPSET GUID JL EQ 0 0
158 CRMD_ORDERADM_I GUID JR EQ AND 0 0
159 CRMD_ORDERADM_H CLIENT JL EQ 0 0
160 BBP_PDPSET CLIENT JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 CLIENT CRMD_ORDERADM_H CLIENT   MANDT Client
2 SC_GUID CRMD_ORDERADM_H GUID   CRMT_OBJECT_GUID GUID of a CRM Order Object
3 OBJECT_ID CRMD_ORDERADM_H OBJECT_ID   CRMT_OBJECT_ID_DB Transaction ID
4 HEADER_DESCRIPTION CRMD_ORDERADM_H DESCRIPTION   CRMT_PROCESS_DESCRIPTION Transaction Description
5 CREATED_AT CRMD_ORDERADM_H CREATED_AT   COMT_CREATED_AT_USR Created At (Output in User Time Zone)
6 HEADER_CURRENCY BBP_PDHGP CURRENCY   WAERS Currency Key
7 TOTAL_VALUE BBP_PDHGP TOTAL_VALUE   BBP_TOTAL_VALUE Total Value of Shopping Cart (Net Excluding Taxes)
8 LOGICAL_SYSTEM CRMD_ORDERADM_H LOGICAL_SYSTEM   CRMT_LOGSYS Logical System
9 POSTING_DATE CRMD_ORDERADM_H POSTING_DATE   CRMT_POSTING_DATE Posting Date for a Business Transaction
10 STATUS CRM_JEST STAT   CRM_J_STATUS Object Status
11 INACTIVE CRM_JEST INACT   CRM_J_INACT Indicator: Status Is Inactive
12 ITEM_GUID CRMD_ORDERADM_I GUID   CRMT_OBJECT_GUID GUID of a CRM Order Object
13 ITEM_DESCRIPTION CRMD_ORDERADM_I DESCRIPTION   CRMT_PRSHTEXTX_DB Product Short Text
14 QUANTITY BBP_PDIGP QUANTITY   BBP_MNG Quantity in Order Unit
15 UNIT BBP_PDIGP UNIT   BBP_UNIT Purchase Order Unit
16 VALUE BBP_PDIGP VALUE   BBP_VALUE Net Value
17 ITEM_CURRENCY BBP_PDIGP CURRENCY   WAERS Currency Key
18 CHANGED_AT CRMD_ORDERADM_I CHANGED_AT   COMT_CHANGED_AT_USR Changed At (Output in User Time Zone)
19 CHANGED_BY CRMD_ORDERADM_I CHANGED_BY   CRMT_CHANGED_BY Transaction Last Changed By
20 CREATED_BY CRMD_ORDERADM_I CREATED_BY   CRMT_CREATED_BY User that Created the Transaction
21 NUMBER_INT CRMD_ORDERADM_I NUMBER_INT   CRMT_ITEM_NO Item Number in Document
22 EXLIN BBP_PDIGP EXLIN   /SAPSRM/EXLIN Configurable Line Item Number
23 CATEGORY_ID BBP_PDIGP CATEGORY_ID   BBP_CATEGORY_ID Product Category ID
24 PURCHTEAM BBP_PDHGP PURCHTEAM   BBP_PURCHTEAM Team Purchasing: Purchasing Team
25 BE_OBJECT_ID BBP_PDBEI BE_OBJECT_ID   BE_OBJECT_ID Follow-On Document Object ID in Backend
26 PARTNER_PROD CRMD_ORDERADM_I PARTNER_PROD   CRMT_ITEM_DESCR_PARTNER Product Number of Business Partner
27 PARTNER_NO CRMD_PARTNER PARTNER_NO   CRMT_PARTNER_NO Partner Number
28 PARTNER_FCT CRMD_PARTNER PARTNER_FCT   CRMT_PARTNER_FCT Partner Function
29 PURCH_ORG BBP_PDORG PROC_ORG   BBP_PROC_ORG Responsible Purchasing Organization
30 PROC_GROUP BBP_PDORG PROC_GROUP   BBP_PROC_GROUP Responsible Purchasing Group
31 HEADER CRMD_ORDERADM_I HEADER   CRMT_OBJECT_GUID GUID of a CRM Order Object
32 SOURCE_REL_IND BBP_PDIGP SOURCE_REL_IND   BBP_SOURCE_REL_IND Indicator - If the Document is Sourcing-Relevant
33 DOC_CLOSED BBP_PDHGP DOC_CLOSED   BBP_DOC_CLOSED Indicator Document Closed
34 WF_STATUS /SAPSRM/D_WF_006 STATUS   /SAPSRM/PDO_APPROVALSTATUS Status of Item in Approval Process
35 AGENT /SAPSRM/D_WF_013 AGENT   /SAPSRM/WF_AGENT_ID Identification (PD-Org. ID) of Workflow Agent
36 SUBTYPE BBP_PDHGP SUBTYPE   BBP_H_SUBTYPE Specification of a Purchasing Doc.(e.g. Credit Memo/Invoice)
37 CATEGORY BBP_PDIGP CATEGORY   BBP_CATEGORY_GUID_RAW Product Category GUID
38 PS_PARK_IND BBP_PDHSS PS_PARK_IND   /SAPPSSRM/_PARK_IND Park Indicator
39 PS_US01 BBP_PDHSS PS_US01   /SAPPSSRM/_US_01 User-Specified Status 01
40 PS_US02 BBP_PDHSS PS_US02   /SAPPSSRM/_US_02 User-Specified Status 02
41 PS_US03 BBP_PDHSS PS_US03   /SAPPSSRM/_US_03 User-Specified Status 03
42 PS_US04 BBP_PDHSS PS_US04   /SAPPSSRM/_US_04 User-Specified Status 04
43 PS_US05 BBP_PDHSS PS_US05   /SAPPSSRM/_US_05 User-Specified Status 05
44 PS_US06 BBP_PDHSS PS_US06   /SAPPSSRM/_US_06 User-Specified Status 06
45 PS_US07 BBP_PDHSS PS_US07   /SAPPSSRM/_US_07 User-Specified Status 07
46 PS_US08 BBP_PDHSS PS_US08   /SAPPSSRM/_US_08 User-Specified Status 08
47 PS_US09 BBP_PDHSS PS_US09   /SAPPSSRM/_US_09 User-Specified Status 09
48 PS_US10 BBP_PDHSS PS_US10   /SAPPSSRM/_US_10 User-Specified Status 10
49 PS_PA_COMP_TYPE BBP_PDISS PS_PA_COMP_TYPE   /SAPPSSRM/_PA_COMP_TYPE Pricing Component Type
50 ISS_PS_US01 BBP_PDISS PS_US01   /SAPPSSRM/_US_01 User-Specified Status 01
51 ISS_PS_US02 BBP_PDISS PS_US02   /SAPPSSRM/_US_02 User-Specified Status 02
52 ISS_PS_US03 BBP_PDISS PS_US03   /SAPPSSRM/_US_03 User-Specified Status 03
53 ISS_PS_US04 BBP_PDISS PS_US04   /SAPPSSRM/_US_04 User-Specified Status 04
54 ISS_PS_US05 BBP_PDISS PS_US05   /SAPPSSRM/_US_05 User-Specified Status 05
55 ISS_PS_US06 BBP_PDISS PS_US06   /SAPPSSRM/_US_06 User-Specified Status 06
56 ISS_PS_US07 BBP_PDISS PS_US07   /SAPPSSRM/_US_07 User-Specified Status 07
57 ISS_PS_US08 BBP_PDISS PS_US08   /SAPPSSRM/_US_08 User-Specified Status 08
58 ISS_PS_US09 BBP_PDISS PS_US09   /SAPPSSRM/_US_09 User-Specified Status 09
59 ISS_PS_US10 BBP_PDISS PS_US10   /SAPPSSRM/_US_10 User-Specified Status 10
60 PS_US01_TXT BBP_PDISS PS_US01_TXT   /SAPPSSRM/_US_TXT_01 User-Specified Status 01 Description
61 PS_US02_TXT BBP_PDISS PS_US02_TXT   /SAPPSSRM/_US_TXT_02 User-Specified Status 02 Description
62 PS_US03_TXT BBP_PDISS PS_US03_TXT   /SAPPSSRM/_US_TXT_03 User-Specified Status 03 Description
63 PS_US04_TXT BBP_PDISS PS_US04_TXT   /SAPPSSRM/_US_TXT_04 User-Specified Status 04 Description
64 PS_US05_TXT BBP_PDISS PS_US05_TXT   /SAPPSSRM/_US_TXT_05 User-Specified Status 05 Description
65 PS_US06_TXT BBP_PDISS PS_US06_TXT   /SAPPSSRM/_US_TXT_06 User-Specified Status 06 Description
66 PS_US07_TXT BBP_PDISS PS_US07_TXT   /SAPPSSRM/_US_TXT_07 User-Specified Status 07 Description
67 PS_US08_TXT BBP_PDISS PS_US08_TXT   /SAPPSSRM/_US_TXT_08 User-Specified Status 08 Description
68 PS_US09_TXT BBP_PDISS PS_US09_TXT   /SAPPSSRM/_US_TXT_09 User-Specified Status 09 Description
69 PS_US10_TXT BBP_PDISS PS_US10_TXT   /SAPPSSRM/_US_TXT_10 User-Specified Status 10 Description
70 IGP_BE_QUANTITY BBP_PDIGP QUANTITY   BBP_MNG Quantity in Order Unit
71 QUAN_CF_E BBP_PDIGP QUAN_CF_E   BBP_CF_QUANT_E Quantity of Entered Confirmation
72 QUAN_CF BBP_PDIGP QUAN_CF   BBP_CF_QUANT Quantity of Released Confirmations
73 QUAN_IV_E BBP_PDIGP QUAN_IV_E   BBP_IV_QUANT_E Entered Invoiced Quantity
74 QUAN_IV BBP_PDIGP QUAN_IV   BBP_IV_QUANT Released Invoiced Quantity
75 QUAN_PO_E BBP_PDIGP QUAN_PO_E   BBP_PO_QUANT_E Quantity of POs/Confirmations/Invoices Created for Contract
76 PO_STATUS CRM_JEST STAT   CRM_J_STATUS Object Status
77 GR_IND BBP_PDPSET GR_IND   WEPOS Goods Receipt Indicator
78 IR_IND BBP_PDPSET IR_IND   REPOS Invoice receipt indicator
79 GR_BASEDIV BBP_PDPSET GR_BASEDIV   BBP_WEBRE Indicator: GR-Based Invoice Verification
80 PARENT CRMD_ORDERADM_I PARENT   CRMT_OBJECT_GUID GUID of a CRM Order Object
81 ITM_TYPE CRMD_ORDERADM_I ITM_TYPE   CRMT_ITEM_TYPE_DB Item Category
82 DEDUCT_IND BBP_PDIGP DEDUCT_IND   BBP_DEDUCT_IND Discount/Rejection Indicator at Item Level
83 ITEM_STATUS CRM_JEST STAT   CRM_J_STATUS Object Status
84 PS_IPT BBP_PDISS PS_IPT   /SAPPSSRM/_IPT Public Sector Item Type
                 
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