SAP ABAP View /SAPSRM/CTRD_PWL (Erzeugt aus Ddl Source /SAPSRM/CTRD_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
⤷ 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/CTRD_PWL | |
Short Description | Erzeugt aus Ddl Source /SAPSRM/CTRD_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 | CRM_JEST | |||
4 | BBP_PDHSS | |||
5 | BBP_PDHIER | |||
6 | CRMD_LINK | |||
7 | CRMD_PARTNER | |||
8 | ADRC | |||
9 | BBP_PDORG |
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 | CRM_JEST | MANDT | JR | EQ | AND | 0 | 0 | |||
7 | CRMD_ORDERADM_H | GUID | JL | EQ | 0 | 0 | ||||
8 | CRM_JEST | OBJNR | 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_PDHIER | CLIENT | JR | EQ | AND | 0 | 0 | |||
15 | CRMD_ORDERADM_H | GUID | JL | EQ | 0 | 0 | ||||
16 | BBP_PDHIER | GUID | JR | EQ | AND | 0 | 0 | |||
17 | CRMD_ORDERADM_H | GUID | JL | EQ | 0 | 0 | ||||
18 | CRMD_LINK | GUID_HI | JR | EQ | AND | 0 | 0 | |||
19 | CRMD_LINK | OBJTYPE_HI | JL | EQ | 0 | 0 | ||||
20 | JR | EQ | '05' | AND | 0 | 0 | ||||
21 | CRMD_LINK | OBJTYPE_SET | JL | EQ | 0 | 0 | ||||
22 | JR | EQ | '07' | AND | 0 | 0 | ||||
23 | CRMD_ORDERADM_H | CLIENT | JL | EQ | 0 | 0 | ||||
24 | CRMD_LINK | CLIENT | JR | EQ | AND | 0 | 0 | |||
25 | CRMD_LINK | GUID_SET | JL | EQ | 0 | 0 | ||||
26 | CRMD_PARTNER | GUID | JR | EQ | AND | 0 | 0 | |||
27 | CRMD_PARTNER | PARTNER_FCT | JL | EQ | 0 | 0 | ||||
28 | JR | EQ | '00000019' | AND | 0 | 0 | ||||
29 | CRMD_ORDERADM_H | CLIENT | JL | EQ | 0 | 0 | ||||
30 | CRMD_PARTNER | CLIENT | JR | EQ | AND | 0 | 0 | |||
31 | CRMD_ORDERADM_H | CLIENT | JL | EQ | 0 | 0 | ||||
32 | ADRC | CLIENT | JR | EQ | AND | 0 | 0 | |||
33 | CRMD_PARTNER | ADDR_NR | JL | EQ | 0 | 0 | ||||
34 | ADRC | ADDRNUMBER | JR | EQ | AND | 0 | 0 | |||
35 | CRMD_ORDERADM_H | GUID | JL | EQ | 0 | 0 | ||||
36 | CRMD_LINK | GUID_HI | JR | EQ | AND | 0 | 0 | |||
37 | CRMD_LINK | OBJTYPE_HI | JL | EQ | 0 | 0 | ||||
38 | JR | EQ | '05' | AND | 0 | 0 | ||||
39 | CRMD_LINK | OBJTYPE_SET | JL | EQ | 0 | 0 | ||||
40 | JR | EQ | '21' | AND | 0 | 0 | ||||
41 | CRMD_ORDERADM_H | CLIENT | JL | EQ | 0 | 0 | ||||
42 | CRMD_LINK | CLIENT | JR | EQ | AND | 0 | 0 | |||
43 | CRMD_ORDERADM_H | CLIENT | JL | EQ | 0 | 0 | ||||
44 | BBP_PDORG | CLIENT | JR | EQ | AND | 0 | 0 | |||
45 | CRMD_LINK | GUID_SET | JL | EQ | 0 | 0 | ||||
46 | BBP_PDORG | SET_GUID | JR | EQ | AND | 0 | 0 | |||
47 | CRMD_ORDERADM_H | OBJECT_TYPE | EQ | 'BUS2000113' | 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 | POSTING_DATE | CRMD_ORDERADM_H | POSTING_DATE | CRMT_POSTING_DATE | Posting Date for a Business Transaction | |||
6 | DESCRIPTION | CRMD_ORDERADM_H | DESCRIPTION | CRMT_PROCESS_DESCRIPTION | Transaction Description | |||
7 | TEMPLATE_TYPE | CRMD_ORDERADM_H | TEMPLATE_TYPE | CRMT_TEMPLATE_TYPE_DB | Template Type of CRM Transaction | |||
8 | CREATED_AT | CRMD_ORDERADM_H | CREATED_AT | COMT_CREATED_AT_USR | Created At (Output in User Time Zone) | |||
9 | CREATED_BY | CRMD_ORDERADM_H | CREATED_BY | CRMT_CREATED_BY | User that Created the Transaction | |||
10 | CHANGED_AT | CRMD_ORDERADM_H | CHANGED_AT | COMT_CHANGED_AT_USR | Changed At (Output in User Time Zone) | |||
11 | CHANGED_BY | CRMD_ORDERADM_H | CHANGED_BY | CRMT_CHANGED_BY | Transaction Last Changed By | |||
12 | OBJECT_TYPE | CRMD_ORDERADM_H | OBJECT_TYPE | CRMT_SUBOBJECT_CATEGORY_DB | Business Trans. Cat. | |||
13 | TOTAL_VALUE | BBP_PDHGP | TOTAL_VALUE | BBP_TOTAL_VALUE | Total Value of Shopping Cart (Net Excluding Taxes) | |||
14 | VPER_END | BBP_PDHGP | VPER_END | BBP_VPER_END | Validity period | |||
15 | VPER_START | BBP_PDHGP | VPER_START | BBP_VPER_START | Validity Period From | |||
16 | DOC_CLOSED | BBP_PDHGP | DOC_CLOSED | BBP_DOC_CLOSED | Indicator Document Closed | |||
17 | VERSION_TYPE | BBP_PDHGP | VERSION_TYPE | BBP_VERSION_TYPE | Version Type (Active Document, 'Normal', Work Version) | |||
18 | VAL_PO_E | BBP_PDHGP | VAL_PO_E | BBP_PO_VALUE_E | Value of POs/Confirmations/Invoices Created for Contract | |||
19 | ROOT_IND | BBP_PDHGP | ROOT_IND | BBP_ROOT_IND | is Root of a Hierarchy | |||
20 | DIST_IND | BBP_PDHGP | DIST_IND | BBP_DIST_FLAG | Distribution Flag | |||
21 | STAT | CRM_JEST | STAT | CRM_J_STATUS | Object Status | |||
22 | INACT | CRM_JEST | INACT | CRM_J_INACT | Indicator: Status Is Inactive | |||
23 | PS_NUMVRS | BBP_PDHSS | PS_NUMVRS | /SAPPSSRM/_VERSNO | Version number for item numbering | |||
24 | PARENT_GUID | BBP_PDHIER | PARENT_GUID | BBP_HIER_PARENT_GUID | Header GUID of the Parent Node | |||
25 | PARTNER_FCT | CRMD_PARTNER | PARTNER_FCT | CRMT_PARTNER_FCT | Partner Function | |||
26 | PARTNER_NO | CRMD_PARTNER | PARTNER_NO | CRMT_PARTNER_NO | Partner Number | |||
27 | DISPLAY_TYPE | CRMD_PARTNER | DISPLAY_TYPE | CRMT_PARTNER_DISPLAY_TYPE | Object Type, for Which Partner Number is to be Shown | |||
28 | MAINPARTNER | CRMD_PARTNER | MAINPARTNER | CRMT_PARTNER_MAIN | Main Partner (For Ambiguous Partner Functions) | |||
29 | ADDR_NR | CRMD_PARTNER | ADDR_NR | AD_ADDRNUM | Address number | |||
30 | ADDR_TYPE | CRMD_PARTNER | ADDR_TYPE | AD_ADRTYPE | Address type (1=Organization, 2=Person, 3=Contact person) | |||
31 | ADDR_ORIGIN | CRMD_PARTNER | ADDR_ORIGIN | CRMT_ADDR_ORIGIN_MD | Origin of a Partner Address | |||
32 | NAME1 | ADRC | NAME1 | AD_NAME1 | Name 1 | |||
33 | PROC_GROUP | BBP_PDORG | PROC_GROUP | BBP_PROC_GROUP | Responsible Purchasing Group | |||
34 | PROC_ORG | BBP_PDORG | PROC_ORG | BBP_PROC_ORG | Responsible Purchasing Organization | |||
35 | PROC_ORG_RESP | BBP_PDORG | PROC_ORG_RESP | BBP_PROG_ORG_RESP | Responsible Organizational Unit (purchasing) | |||
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 |