SAP ABAP View /SAPSRM/RFXPWL_I (Erzeugt aus Ddl Source /SAPSRM/RFXPWL_I)
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
⤷ 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/RFXPWL_I | |
Short Description | Erzeugt aus Ddl Source /SAPSRM/RFXPWL_I | |
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_PDHSB | |||
3 | CRM_JEST | |||
4 | /SAPSRM/ST_INDEX | |||
5 | BBP_PDHGP | |||
6 | CRMD_LINK | |||
7 | CRMD_PARTNER | |||
8 | BBP_PDORG | |||
9 | CRMD_ORDERADM_I | |||
10 | BBP_PDISS |
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_PDHSB | GUID | JR | EQ | AND | 0 | 0 | |||
3 | CRMD_ORDERADM_H | CLIENT | JL | EQ | 0 | 0 | ||||
4 | BBP_PDHSB | CLIENT | JR | EQ | AND | 0 | 0 | |||
5 | CRMD_ORDERADM_H | OBJECT_TYPE | JL | EQ | 0 | 0 | ||||
6 | JR | EQ | 'BUS2200' | AND | 0 | 0 | ||||
7 | CRMD_ORDERADM_H | CLIENT | JL | EQ | 0 | 0 | ||||
8 | BBP_PDHSB | CLIENT | JR | EQ | AND | 0 | 0 | |||
9 | CRM_JEST | MANDT | JL | EQ | 0 | 0 | ||||
10 | CRMD_ORDERADM_H | CLIENT | JR | EQ | AND | 0 | 0 | |||
11 | CRM_JEST | OBJNR | JL | EQ | 0 | 0 | ||||
12 | CRMD_ORDERADM_H | GUID | JR | EQ | AND | 0 | 0 | |||
13 | CRM_JEST | INACT | JL | NE | 0 | 0 | ||||
14 | JR | NE | 'X' | AND | 0 | 0 | ||||
15 | CRM_JEST | STAT | JL | NE | 0 | 0 | ||||
16 | JR | NE | 'I1021' | AND | 0 | 0 | ||||
17 | CRM_JEST | STAT | JL | NE | 0 | 0 | ||||
18 | JR | NE | 'I1038' | AND | 0 | 0 | ||||
19 | CRMD_ORDERADM_H | CLIENT | JL | EQ | 0 | 0 | ||||
20 | CRM_JEST | MANDT | JR | EQ | AND | 0 | 0 | |||
21 | CRM_JEST | STAT | JL | EQ | 0 | 0 | ||||
22 | /SAPSRM/ST_INDEX | STATUS_ID | JR | EQ | AND | 0 | 0 | |||
23 | BBP_PDHGP | CLIENT | JL | EQ | 0 | 0 | ||||
24 | CRMD_ORDERADM_H | CLIENT | JR | EQ | AND | 0 | 0 | |||
25 | BBP_PDHGP | GUID | JL | EQ | 0 | 0 | ||||
26 | CRMD_ORDERADM_H | GUID | JR | EQ | AND | 0 | 0 | |||
27 | BBP_PDHGP | VERSION_TYPE | JL | NE | 0 | 0 | ||||
28 | JR | NE | 'H' | AND | 0 | 0 | ||||
29 | CRMD_ORDERADM_H | CLIENT | JL | EQ | 0 | 0 | ||||
30 | BBP_PDHGP | CLIENT | JR | EQ | AND | 0 | 0 | |||
31 | CRMD_LINK | CLIENT | JL | EQ | 0 | 0 | ||||
32 | CRMD_ORDERADM_H | CLIENT | JR | EQ | AND | 0 | 0 | |||
33 | CRMD_LINK | GUID_HI | JL | EQ | 0 | 0 | ||||
34 | CRMD_ORDERADM_H | GUID | JR | EQ | AND | 0 | 0 | |||
35 | CRMD_LINK | OBJTYPE_HI | JL | EQ | 0 | 0 | ||||
36 | JR | EQ | '05' | AND | 0 | 0 | ||||
37 | CRMD_LINK | OBJTYPE_SET | JL | EQ | 0 | 0 | ||||
38 | JR | EQ | '07' | AND | 0 | 0 | ||||
39 | CRMD_ORDERADM_H | CLIENT | JL | EQ | 0 | 0 | ||||
40 | CRMD_LINK | CLIENT | JR | EQ | AND | 0 | 0 | |||
41 | CRMD_LINK | CLIENT | JL | EQ | 0 | 0 | ||||
42 | CRMD_PARTNER | CLIENT | JR | EQ | AND | 0 | 0 | |||
43 | CRMD_LINK | GUID_SET | JL | EQ | 0 | 0 | ||||
44 | CRMD_PARTNER | GUID | JR | EQ | AND | 0 | 0 | |||
45 | CRMD_PARTNER | PARTNER_FCT | JL | EQ | 0 | 0 | ||||
46 | JR | EQ | '00000018' | AND | 0 | 0 | ||||
47 | CRMD_PARTNER | DISABLED | JL | NE | 0 | 0 | ||||
48 | JR | NE | 'X' | AND | 0 | 0 | ||||
49 | CRMD_ORDERADM_H | CLIENT | JL | EQ | 0 | 0 | ||||
50 | CRMD_PARTNER | CLIENT | JR | EQ | AND | 0 | 0 | |||
51 | BBP_PDHGP | CLIENT | JL | EQ | 0 | 0 | ||||
52 | CRMD_LINK | CLIENT | JR | EQ | AND | 0 | 0 | |||
53 | BBP_PDHGP | GUID | JL | EQ | 0 | 0 | ||||
54 | CRMD_LINK | GUID_HI | JR | EQ | AND | 0 | 0 | |||
55 | CRMD_LINK | OBJTYPE_HI | JL | EQ | 0 | 0 | ||||
56 | JR | EQ | '05' | AND | 0 | 0 | ||||
57 | CRMD_LINK | OBJTYPE_SET | JL | EQ | 0 | 0 | ||||
58 | JR | EQ | '21' | AND | 0 | 0 | ||||
59 | CRMD_ORDERADM_H | CLIENT | JL | EQ | 0 | 0 | ||||
60 | CRMD_LINK | CLIENT | JR | EQ | AND | 0 | 0 | |||
61 | CRMD_LINK | CLIENT | JL | EQ | 0 | 0 | ||||
62 | BBP_PDORG | CLIENT | JR | EQ | AND | 0 | 0 | |||
63 | CRMD_LINK | GUID_SET | JL | EQ | 0 | 0 | ||||
64 | BBP_PDORG | SET_GUID | JR | EQ | AND | 0 | 0 | |||
65 | CRMD_ORDERADM_H | CLIENT | JL | EQ | 0 | 0 | ||||
66 | BBP_PDORG | CLIENT | JR | EQ | AND | 0 | 0 | |||
67 | CRMD_ORDERADM_H | CLIENT | JL | EQ | 0 | 0 | ||||
68 | CRMD_ORDERADM_I | CLIENT | JR | EQ | AND | 0 | 0 | |||
69 | CRMD_ORDERADM_H | GUID | JL | EQ | 0 | 0 | ||||
70 | CRMD_ORDERADM_I | HEADER | JR | EQ | AND | 0 | 0 | |||
71 | CRMD_ORDERADM_H | CLIENT | JL | EQ | 0 | 0 | ||||
72 | CRMD_ORDERADM_I | CLIENT | JR | EQ | AND | 0 | 0 | |||
73 | CRMD_ORDERADM_I | CLIENT | JL | EQ | 0 | 0 | ||||
74 | BBP_PDISS | CLIENT | JR | EQ | AND | 0 | 0 | |||
75 | CRMD_ORDERADM_I | GUID | JL | EQ | 0 | 0 | ||||
76 | BBP_PDISS | GUID | JR | EQ | AND | 0 | 0 | |||
77 | CRMD_ORDERADM_H | CLIENT | JL | EQ | 0 | 0 | ||||
78 | BBP_PDISS | 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 | 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 | PROCESS_TYPE | CRMD_ORDERADM_H | PROCESS_TYPE | CRMT_PROCESS_TYPE_DB | Business Transaction Type | |||
5 | DESCRIPTION | CRMD_ORDERADM_H | DESCRIPTION | CRMT_PROCESS_DESCRIPTION | Transaction Description | |||
6 | HEADER_DESCRIPTION | CRMD_ORDERADM_H | DESCRIPTION_UC | CRMT_PROCESS_DESCRIPTION_UC | Transaction Description (Upper Case) | |||
7 | TEMPLATE_TYPE | CRMD_ORDERADM_H | TEMPLATE_TYPE | CRMT_TEMPLATE_TYPE_DB | Template Type of CRM Transaction | |||
8 | CREATED_BY | CRMD_ORDERADM_H | CREATED_BY | CRMT_CREATED_BY | User that Created the Transaction | |||
9 | SUBMISSION_DEADLINE | BBP_PDHSB | QUOT_DEAD | BBP_ANGAB | Submission Deadline for the Bid | |||
10 | QUOT_DEAD_TIME | BBP_PDHSB | QUOT_DEAD_TIME | BBP_QUOT_DEAD_TIME | Time of Bid Submission Deadline | |||
11 | CATEGORY | BBP_PDHSB | CATEGORY | BBP_CATEGORY_GUID_RAW | Product Category GUID | |||
12 | STATUS | CRM_JEST | STAT | CRM_J_STATUS | Object Status | |||
13 | PRIO_INDEX | /SAPSRM/ST_INDEX | PRIO_INDEX | INT4 | Natural number | |||
14 | PARTNER_NO | CRMD_PARTNER | PARTNER_NO | CRMT_PARTNER_NO | Partner Number | |||
15 | DOC_CLOSED | BBP_PDHGP | DOC_CLOSED | BBP_DOC_CLOSED | Indicator Document Closed | |||
16 | VERSION_TYPE | BBP_PDHGP | VERSION_TYPE | BBP_VERSION_TYPE | Version Type (Active Document, 'Normal', Work Version) | |||
17 | PROC_ORG | BBP_PDORG | PROC_ORG | BBP_PROC_ORG | Responsible Purchasing Organization | |||
18 | PROC_GROUP | BBP_PDORG | PROC_GROUP | BBP_PROC_GROUP | Responsible Purchasing Group | |||
19 | ORDERED_PROD | CRMD_ORDERADM_I | ORDERED_PROD | CRMT_ORDERED_PROD_DB | Product Name Entered | |||
20 | CREATED_AT | CRMD_ORDERADM_H | CREATED_AT | COMT_CREATED_AT_USR | Created At (Output in User Time Zone) | |||
21 | CHANGED_AT | CRMD_ORDERADM_H | CHANGED_AT | COMT_CHANGED_AT_USR | Changed At (Output in User Time Zone) | |||
22 | CATEGORY_ID | BBP_PDHSB | CATEGORY_ID | BBP_CATEGORY_ID | Product Category ID | |||
23 | ACTIVE_HEADER | BBP_PDHGP | ACTIVE_HEADER | BBP_GUID | Globally Unique identifier | |||
24 | TZONE | BBP_PDHGP | TZONE | BBP_TZONE | Time Zone for Date and Time Fields of Procurement Document | |||
25 | PS_IPT | BBP_PDISS | PS_IPT | /SAPPSSRM/_IPT | Public Sector Item Type | |||
Maintenance Status
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 |