SAP ABAP View /SAPSRM/PO_POWL (Erzeugt aus Ddl Source /SAPSRM/PO_POWL)
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/PO_POWL  
Short Description Erzeugt aus Ddl Source /SAPSRM/PO_POWL    
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 CRMD_ORDERADM_I  
5 BBP_PDIGP  
6 BBP_PDISS  
7 BBP_PDPSET  
8 CRMD_PARTNER  
9 CRMD_LINK  
10 BBP_PDORG  
11 BBP_PDACC  
12 BBP_PDLIM  
13 CRM_JEST  
14 /SAPSRM/ST_INDEX  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 CRMD_ORDERADM_H GUID JL EQ 0 0
2 BBP_PDHGP GUID JR EQ AND 0 0
3 CRMD_ORDERADM_H CLIENT JL EQ 0 0
4 BBP_PDHGP CLIENT JR EQ AND 0 0
5 CRMD_ORDERADM_H OBJECT_TYPE JL EQ 0 0
6   JR EQ 'BUS2201' AND 0 0
7 CRMD_ORDERADM_H OBJECT_TYPE JL EQ 0 0
8   JR EQ 'BUS2230001' 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 BBP_PDHGP CLIENT JL EQ 0 0
18 CRMD_ORDERADM_I CLIENT JR EQ AND 0 0
19 BBP_PDHGP GUID JL EQ 0 0
20 CRMD_ORDERADM_I HEADER JR EQ AND 0 0
21 CRMD_ORDERADM_H CLIENT JL EQ 0 0
22 CRMD_ORDERADM_I CLIENT JR EQ AND 0 0
23 CRMD_ORDERADM_I CLIENT JL EQ 0 0
24 BBP_PDIGP CLIENT JR EQ AND 0 0
25 CRMD_ORDERADM_I GUID JL EQ 0 0
26 BBP_PDIGP GUID JR EQ AND 0 0
27 CRMD_ORDERADM_H CLIENT JL EQ 0 0
28 BBP_PDIGP CLIENT JR EQ AND 0 0
29 BBP_PDISS CLIENT JL EQ 0 0
30 BBP_PDIGP CLIENT JR EQ AND 0 0
31 BBP_PDISS GUID JL EQ 0 0
32 BBP_PDIGP GUID JR EQ AND 0 0
33 CRMD_ORDERADM_H CLIENT JL EQ 0 0
34 BBP_PDISS CLIENT JR EQ AND 0 0
35 BBP_PDIGP CLIENT JL EQ 0 0
36 BBP_PDPSET CLIENT JR EQ AND 0 0
37 BBP_PDIGP GUID JL EQ 0 0
38 BBP_PDPSET GUID JR EQ AND 0 0
39 CRMD_ORDERADM_H CLIENT JL EQ 0 0
40 BBP_PDPSET CLIENT JR EQ AND 0 0
41 CRMD_PARTNER CLIENT JL EQ 0 0
42 CRMD_LINK CLIENT JR EQ AND 0 0
43 CRMD_PARTNER GUID JL EQ 0 0
44 CRMD_LINK GUID_SET JR EQ AND 0 0
45 CRMD_PARTNER PARTNER_FCT JL EQ 0 0
46   JR EQ '00000019' AND 0 0
47 CRMD_PARTNER CLIENT JL EQ 0 0
48 CRMD_LINK CLIENT JR EQ AND 0 0
49 CRMD_ORDERADM_H CLIENT JL EQ 0 0
50 CRMD_LINK CLIENT JR EQ AND 0 0
51 CRMD_ORDERADM_H GUID JL EQ 0 0
52 CRMD_LINK GUID_HI JR EQ AND 0 0
53 CRMD_ORDERADM_H CLIENT JL EQ 0 0
54 CRMD_PARTNER CLIENT JR EQ AND 0 0
55 CRMD_LINK CLIENT JL EQ 0 0
56 CRMD_PARTNER CLIENT JR EQ AND 0 0
57 CRMD_LINK GUID_SET JL EQ 0 0
58 CRMD_PARTNER GUID JR EQ AND 0 0
59 CRMD_PARTNER PARTNER_FCT JL EQ 0 0
60   JR EQ '00000039' AND 0 0
61 CRMD_PARTNER CLIENT JL EQ 0 0
62 CRMD_LINK CLIENT JR EQ AND 0 0
63 CRMD_ORDERADM_H CLIENT JL EQ 0 0
64 CRMD_LINK CLIENT JR EQ AND 0 0
65 CRMD_ORDERADM_H GUID JL EQ 0 0
66 CRMD_LINK GUID_HI JR EQ AND 0 0
67 CRMD_ORDERADM_H CLIENT JL EQ 0 0
68 CRMD_PARTNER CLIENT JR EQ AND 0 0
69 CRMD_PARTNER CLIENT JL EQ 0 0
70 CRMD_LINK CLIENT JR EQ AND 0 0
71 CRMD_PARTNER GUID JL EQ 0 0
72 CRMD_LINK GUID_SET JR EQ AND 0 0
73 CRMD_PARTNER PARTNER_FCT JL EQ 0 0
74   JR EQ '00000016' AND 0 0
75 CRMD_PARTNER CLIENT JL EQ 0 0
76 CRMD_LINK CLIENT JR EQ AND 0 0
77 CRMD_ORDERADM_I CLIENT JL EQ 0 0
78 CRMD_LINK CLIENT JR EQ AND 0 0
79 CRMD_ORDERADM_I GUID JL EQ 0 0
80 CRMD_LINK GUID_HI JR EQ AND 0 0
81 CRMD_ORDERADM_H CLIENT JL EQ 0 0
82 CRMD_PARTNER CLIENT JR EQ AND 0 0
83 CRMD_LINK CLIENT JL EQ 0 0
84 CRMD_PARTNER CLIENT JR EQ AND 0 0
85 CRMD_LINK GUID_SET JL EQ 0 0
86 CRMD_PARTNER GUID JR EQ AND 0 0
87 CRMD_PARTNER PARTNER_FCT JL EQ 0 0
88   JR EQ '00000020' AND 0 0
89 CRMD_PARTNER CLIENT JL EQ 0 0
90 CRMD_LINK CLIENT JR EQ AND 0 0
91 CRMD_ORDERADM_I CLIENT JL EQ 0 0
92 CRMD_LINK CLIENT JR EQ AND 0 0
93 CRMD_ORDERADM_I GUID JL EQ 0 0
94 CRMD_LINK GUID_HI JR EQ AND 0 0
95 CRMD_ORDERADM_H CLIENT JL EQ 0 0
96 CRMD_PARTNER CLIENT JR EQ AND 0 0
97 CRMD_LINK CLIENT JL EQ 0 0
98 CRMD_PARTNER CLIENT JR EQ AND 0 0
99 CRMD_LINK GUID_SET JL EQ 0 0
100 CRMD_PARTNER GUID JR EQ AND 0 0
101 CRMD_PARTNER PARTNER_FCT JL EQ 0 0
102   JR EQ '00000075' AND 0 0
103 CRMD_PARTNER CLIENT JL EQ 0 0
104 CRMD_LINK CLIENT JR EQ AND 0 0
105 CRMD_ORDERADM_I CLIENT JL EQ 0 0
106 CRMD_LINK CLIENT JR EQ AND 0 0
107 CRMD_ORDERADM_I GUID JL EQ 0 0
108 CRMD_LINK GUID_HI JR EQ AND 0 0
109 CRMD_ORDERADM_H CLIENT JL EQ 0 0
110 CRMD_PARTNER CLIENT JR EQ AND 0 0
111 CRMD_LINK CLIENT JL EQ 0 0
112 BBP_PDORG CLIENT JR EQ AND 0 0
113 CRMD_LINK GUID_SET JL EQ 0 0
114 BBP_PDORG SET_GUID JR EQ AND 0 0
115 CRMD_LINK OBJTYPE_SET JL EQ 0 0
116   JR EQ '21' AND 0 0
117 BBP_PDORG CLIENT JL EQ 0 0
118 CRMD_LINK CLIENT JR EQ AND 0 0
119 CRMD_ORDERADM_H CLIENT JL EQ 0 0
120 CRMD_LINK CLIENT JR EQ AND 0 0
121 CRMD_LINK GUID_HI JL EQ 0 0
122 CRMD_ORDERADM_H GUID JR EQ AND 0 0
123 CRMD_ORDERADM_H CLIENT JL EQ 0 0
124 BBP_PDORG CLIENT JR EQ AND 0 0
125 CRMD_LINK CLIENT JL EQ 0 0
126 BBP_PDACC CLIENT JR EQ AND 0 0
127 CRMD_LINK GUID_SET JL EQ 0 0
128 BBP_PDACC SET_GUID JR EQ AND 0 0
129 CRMD_LINK OBJTYPE_SET JL EQ 0 0
130   JR EQ '31' AND 0 0
131 BBP_PDACC CLIENT JL EQ 0 0
132 CRMD_LINK CLIENT JR EQ AND 0 0
133 CRMD_ORDERADM_I CLIENT JL EQ 0 0
134 CRMD_LINK CLIENT JR EQ AND 0 0
135 CRMD_ORDERADM_I GUID JL EQ 0 0
136 CRMD_LINK GUID_HI JR EQ AND 0 0
137 CRMD_ORDERADM_H CLIENT JL EQ 0 0
138 BBP_PDACC CLIENT JR EQ AND 0 0
139 CRMD_LINK CLIENT JL EQ 0 0
140 BBP_PDLIM CLIENT JR EQ AND 0 0
141 CRMD_LINK GUID_SET JL EQ 0 0
142 BBP_PDLIM SET_GUID JR EQ AND 0 0
143 BBP_PDLIM LIM_TYPE JL EQ 0 0
144   JR EQ 'G' AND 0 0
145 BBP_PDLIM CLIENT JL EQ 0 0
146 CRMD_LINK CLIENT JR EQ AND 0 0
147 CRMD_ORDERADM_I CLIENT JL EQ 0 0
148 CRMD_LINK CLIENT JR EQ AND 0 0
149 CRMD_ORDERADM_I GUID JL EQ 0 0
150 CRMD_LINK GUID_HI JR EQ AND 0 0
151 CRMD_ORDERADM_H CLIENT JL EQ 0 0
152 BBP_PDLIM CLIENT JR EQ AND 0 0
153 CRM_JEST STAT JL EQ 0 0
154 /SAPSRM/ST_INDEX STATUS_ID JR EQ AND 0 0
155 CRM_JEST INACT JL EQ 0 0
156   JR EQ ' ' AND 0 0
157 CRM_JEST STAT JL NE 0 0
158   JR NE 'I1021' AND 0 0
159 CRM_JEST STAT JL NE 0 0
160   JR NE 'I1038' AND 0 0
161 CRMD_ORDERADM_H CLIENT JL EQ 0 0
162 CRM_JEST MANDT JR EQ AND 0 0
163 CRMD_ORDERADM_H GUID JL EQ 0 0
164 CRM_JEST OBJNR JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT CRMD_ORDERADM_H CLIENT   MANDT Client
2 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 OBJECT_TYPE CRMD_ORDERADM_H OBJECT_TYPE   CRMT_SUBOBJECT_CATEGORY_DB Business Trans. Cat.
5 DESCRIPTION_UC CRMD_ORDERADM_H DESCRIPTION_UC   CRMT_PROCESS_DESCRIPTION_UC Transaction Description (Upper Case)
6 CREATED_AT CRMD_ORDERADM_H CREATED_AT   COMT_CREATED_AT_USR Created At (Output in User Time Zone)
7 ITEM_GUID CRMD_ORDERADM_I GUID   CRMT_OBJECT_GUID GUID of a CRM Order Object
8 DESCRIPTION_ITEM CRMD_ORDERADM_I DESCRIPTION_UC   CRMT_PRSHTEXTG_DB Product Short Text in Upper Case for F4 Help
9 CURRENCY BBP_PDHGP CURRENCY   WAERS Currency Key
10 LOGSYS_FI BBP_PDHGP LOGSYS_FI   BBP_LOGSYS_FI Logical System of FI System
11 EXLIN BBP_PDIGP EXLIN   /SAPSRM/EXLIN Configurable Line Item Number
12 QUANTITY BBP_PDIGP QUANTITY   BBP_MNG Quantity in Order Unit
13 UNIT BBP_PDIGP UNIT   BBP_UNIT Purchase Order Unit
14 TOTAL_VALUE BBP_PDHGP TOTAL_VALUE   BBP_TOTAL_VALUE Total Value of Shopping Cart (Net Excluding Taxes)
15 NET_VALUE BBP_PDIGP VALUE   BBP_VALUE Net Value
16 ITEM_CURR BBP_PDIGP CURRENCY   WAERS Currency Key
17 NUMBER_INT CRMD_ORDERADM_I NUMBER_INT   CRMT_ITEM_NO Item Number in Document
18 CATEGORY BBP_PDIGP CATEGORY   BBP_CATEGORY_GUID_RAW Product Category GUID
19 CATEGORY_ID BBP_PDIGP CATEGORY_ID   BBP_CATEGORY_ID Product Category ID
20 CO_CODE BBP_PDHGP CO_CODE   BBP_CO_CODE Company Code in FI System
21 CREATED_BY CRMD_ORDERADM_H CREATED_BY   CRMT_CREATED_BY User that Created the Transaction
22 POSTING_DATE CRMD_ORDERADM_H POSTING_DATE   CRMT_POSTING_DATE Posting Date for a Business Transaction
23 PROCESS_TYPE CRMD_ORDERADM_H PROCESS_TYPE   CRMT_PROCESS_TYPE_DB Business Transaction Type
24 ORDERED_PROD CRMD_ORDERADM_I ORDERED_PROD   CRMT_ORDERED_PROD_DB Product Name Entered
25 DELIV_DATE BBP_PDIGP DELIV_DATE   EINDT Item delivery date
26 VPER_START BBP_PDIGP VPER_START   BBP_VPER_START Validity Period From
27 VPER_END BBP_PDIGP VPER_END   BBP_VPER_END Validity period
28 REF_OBJECT_ID BBP_PDHGP REF_OBJECT_ID   BBP_REF_OBJECT_ID Reference Transaction Number
29 VERSION_TYPE BBP_PDHGP VERSION_TYPE   BBP_VERSION_TYPE Version Type (Active Document, 'Normal', Work Version)
30 PARTNER_PROD CRMD_ORDERADM_I PARTNER_PROD   CRMT_ITEM_DESCR_PARTNER Product Number of Business Partner
31 DOC_CLOSED BBP_PDHGP DOC_CLOSED   BBP_DOC_CLOSED Indicator Document Closed
32 ACTIVE_ITEM BBP_PDIGP ACTIVE_ITEM   BBP_GUID Globally Unique identifier
33 ACTIVE_HEADER BBP_PDHGP ACTIVE_HEADER   BBP_GUID Globally Unique identifier
34 CTR_HDR_NUMBER BBP_PDIGP CTR_HDR_NUMBER   BBP_CTR_ID Contract Number
35 DOC_FLOW_CTRL BBP_PDIGP DOC_FLOW_CTRL   BBP_DOC_FLOW_CTRL Indicator of Possible Subsequent Processes
36 FINAL_ENTRY BBP_PDIGP FINAL_ENTRY   BBP_FINAL_ENTRY Final Entry Indicator (Goods/Services)
37 DOC_INCOMPLETE BBP_PDHGP DOC_INCOMPLETE   BBP_DOC_INCOMPLETE Indicator Document Incomplete
38 ITM_TYPE CRMD_ORDERADM_I ITM_TYPE   CRMT_ITEM_TYPE_DB Item Category
39 FINAL_INV BBP_PDIGP FINAL_INV   BBP_EREKZ Final invoice indicator
40 GR_BASEDIV BBP_PDPSET GR_BASEDIV   BBP_WEBRE Indicator: GR-Based Invoice Verification
41 GR_IND BBP_PDPSET GR_IND   WEPOS Goods Receipt Indicator
42 DEL_IND_ITM BBP_PDIGP DEL_IND   BBP_DEL_IND Deletion Indicator EBP Purchasing Document
43 SUBTYPE BBP_PDIGP SUBTYPE   BBP_I_SUBTYPE Specification Purchase Item (e.g. Direct Material/Hierarch.)
44 QUAN_CF_E BBP_PDIGP QUAN_CF_E   BBP_CF_QUANT_E Quantity of Entered Confirmation
45 QUAN_CF BBP_PDIGP QUAN_CF   BBP_CF_QUANT Quantity of Released Confirmations
46 QUAN_IV_E BBP_PDIGP QUAN_IV_E   BBP_IV_QUANT_E Entered Invoiced Quantity
47 QUAN_IV BBP_PDIGP QUAN_IV   BBP_IV_QUANT Released Invoiced Quantity
48 QUAN_ASN BBP_PDIGP QUAN_ASN   BBP_ASN_QUANT Ship Note Quantity Releas'd
49 PARTNER_FCT CRMD_PARTNER PARTNER_FCT   CRMT_PARTNER_FCT Partner Function
50 PARTNER_NO CRMD_PARTNER PARTNER_NO   CRMT_PARTNER_NO Partner Number
51 PREF_SUPP_FCT CRMD_PARTNER PARTNER_FCT   CRMT_PARTNER_FCT Partner Function
52 PREF_SUPP_NO CRMD_PARTNER PARTNER_NO   CRMT_PARTNER_NO Partner Number
53 REQ_FCT CRMD_PARTNER PARTNER_FCT   CRMT_PARTNER_FCT Partner Function
54 REQ_NO CRMD_PARTNER PARTNER_NO   CRMT_PARTNER_NO Partner Number
55 GOOD_REC_FCT CRMD_PARTNER PARTNER_FCT   CRMT_PARTNER_FCT Partner Function
56 GOOD_REC_NO CRMD_PARTNER PARTNER_NO   CRMT_PARTNER_NO Partner Number
57 LOCATION_FCT CRMD_PARTNER PARTNER_FCT   CRMT_PARTNER_FCT Partner Function
58 LOCATION_NO CRMD_PARTNER PARTNER_NO   CRMT_PARTNER_NO Partner Number
59 PROC_ORG BBP_PDORG PROC_ORG   BBP_PROC_ORG Responsible Purchasing Organization
60 PROC_GROUP BBP_PDORG PROC_GROUP   BBP_PROC_GROUP Responsible Purchasing Group
61 ACC_CAT BBP_PDACC ACC_CAT   BBP_ACC_CAT Account Assignment Category in Enterprise Buyer
62 G_L_ACCT BBP_PDACC G_L_ACCT   SAKNR G/L Account Number
63 COST_CTR BBP_PDACC COST_CTR   KOSTL Cost Center
64 SDOC_ITEM BBP_PDACC SDOC_ITEM   BBP_POSNR_VA Sales Document Item
65 SD_DOC BBP_PDACC SD_DOC   BBP_VBELN Sales and Distribution Document Number
66 SCHED_LINE BBP_PDACC SCHED_LINE   BBP_ETENR Schedule Line Number
67 CMMT_ITEM BBP_PDACC CMMT_ITEM   FM_FIPEX Commitment item
68 FUNDS_CTR BBP_PDACC FUNDS_CTR   FISTL Funds Center
69 FUND BBP_PDACC FUND   BP_GEBER Fund
70 FUNC_AREA BBP_PDACC FUNC_AREA   FKBER Functional Area
71 NETWORK BBP_PDACC NETWORK   NPLNR Network Number for Account Assignment
72 ACTIVITY BBP_PDACC ACTIVITY   VORNR Operation/Activity Number
73 ASSET_NO BBP_PDACC ASSET_NO   ANLN1 Main Asset Number
74 SUB_NUMBER BBP_PDACC SUB_NUMBER   ANLN2 Asset Subnumber
75 ORDER_NO BBP_PDACC ORDER_NO   AUFNR Order Number
76 WBS_ELEM_E BBP_PDACC WBS_ELEM_E   BBP_WBS_ELEM Work Breakdown Structure Element (WBS element)
77 STAT CRM_JEST STAT   CRM_J_STATUS Object Status
78 PRIO_INDEX /SAPSRM/ST_INDEX PRIO_INDEX   INT4 Natural number
79 LIM_TYPE BBP_PDLIM LIM_TYPE   BBP_LIM_TYPE Type of the (Partial) Limit
80 VAL_CF_E BBP_PDLIM VAL_CF_E   BBP_CF_VALUE_E Value of Entered Confirmations
81 VAL_IV_E BBP_PDLIM VAL_IV_E   BBP_IV_VALUE_E Entered Invoice Value
82 UNLIMITED BBP_PDLIM UNLIMITED   BBP_UNLIMITED Undefined Limit
83 LIMIT BBP_PDLIM LIMIT   BBP_LIMIT Overall Limit
84 VAL_CF BBP_PDLIM VAL_CF   BBP_CF_VALUE Value of Confirmations Released
85 PS_CANCEL_IND BBP_PDHSS PS_CANCEL_IND   /SAPPSSRM/_PO_CNCL_IND Cancel at Header Level
                 
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