SAP ABAP Table /SAPSRM/SC_PWL (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | /SAPSRM/SC_PWL | Table Relationship Diagram |
Short Description | Generated Table for View |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | ||
2 | SC_GUID | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
3 | OBJECT_ID | CRMT_OBJECT_ID_DB | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
4 | HEADER_DESCRIPTION | CRMT_PROCESS_DESCRIPTION | CRM_PROCESS_DESCRIPTION | CHAR | 40 | 0 | Transaction Description | ||
5 | CREATED_AT | COMT_CREATED_AT_USR | COM_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
6 | HEADER_CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | ||
7 | TOTAL_VALUE | BBP_TOTAL_VALUE | WERT8 | CURR | 15 | 2 | Total Value of Shopping Cart (Net Excluding Taxes) | ||
8 | LOGICAL_SYSTEM | CRMT_LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical System | ||
9 | POSTING_DATE | CRMT_POSTING_DATE | DATS | 8 | 0 | Posting Date for a Business Transaction | |||
10 | STATUS | CRM_J_STATUS | CRM_J_STATUS | CHAR | 5 | 0 | Object Status | ||
11 | INACTIVE | CRM_J_INACT | CRM_J_INACT | CHAR | 1 | 0 | Indicator: Status Is Inactive | ||
12 | ITEM_GUID | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
13 | ITEM_DESCRIPTION | CRMT_PRSHTEXTX_DB | CRM_PRSHTEXT40_DB | CHAR | 40 | 0 | Product Short Text | ||
14 | QUANTITY | BBP_MNG | MENG13 | QUAN | 13 | 3 | Quantity in Order Unit | ||
15 | UNIT | BBP_UNIT | MEINS | UNIT | 3 | 0 | Purchase Order Unit | ||
16 | VALUE | BBP_VALUE | WERT8 | CURR | 15 | 2 | Net Value | ||
17 | ITEM_CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | ||
18 | CHANGED_AT | COMT_CHANGED_AT_USR | COM_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
19 | CHANGED_BY | CRMT_CHANGED_BY | UNAME | CHAR | 12 | 0 | Transaction Last Changed By | ||
20 | CREATED_BY | CRMT_CREATED_BY | UNAME | CHAR | 12 | 0 | User that Created the Transaction | ||
21 | NUMBER_INT | CRMT_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item Number in Document | ||
22 | EXLIN | /SAPSRM/EXLIN | /SAPSRM/EXLIN | CHAR | 40 | 0 | Configurable Line Item Number | ||
23 | CATEGORY_ID | BBP_CATEGORY_ID | COM_CATEGORY_ID | CHAR | 20 | 0 | Product Category ID | ||
24 | PURCHTEAM | BBP_PURCHTEAM | BBP_PURCHTEAM | CHAR | 8 | 0 | Team Purchasing: Purchasing Team | ||
25 | BE_OBJECT_ID | BE_OBJECT_ID | BBP_BE_OBJECT_ID | CHAR | 20 | 0 | Follow-On Document Object ID in Backend | ||
26 | PARTNER_PROD | CRMT_ITEM_DESCR_PARTNER | PRSHTEXT40 | CHAR | 40 | 0 | Product Number of Business Partner | ||
27 | PARTNER_NO | CRMT_PARTNER_NO | CRM_PARTNER_NO | CHAR | 32 | 0 | Partner Number | ||
28 | PARTNER_FCT | CRMT_PARTNER_FCT | COM_PARTNER_FCT | CHAR | 8 | 0 | Partner Function | ||
29 | PURCH_ORG | BBP_PROC_ORG | HROBJEC_14 | CHAR | 14 | 0 | Responsible Purchasing Organization | ||
30 | PROC_GROUP | BBP_PROC_GROUP | HROBJEC_14 | CHAR | 14 | 0 | Responsible Purchasing Group | ||
31 | HEADER | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
32 | SOURCE_REL_IND | BBP_SOURCE_REL_IND | BBP_SOURCE_REL_IND | CHAR | 1 | 0 | Indicator - If the Document is Sourcing-Relevant | ||
33 | DOC_CLOSED | BBP_DOC_CLOSED | XFELD | CHAR | 1 | 0 | Indicator Document Closed | ||
34 | WF_STATUS | /SAPSRM/PDO_APPROVALSTATUS | /SAPSRM/PDO_APPROVALSTATUS | CHAR | 8 | 0 | Status of Item in Approval Process | ||
35 | AGENT | /SAPSRM/WF_AGENT_ID | HROBJID_12 | CHAR | 12 | 0 | Identification (PD-Org. ID) of Workflow Agent | ||
36 | SUBTYPE | BBP_H_SUBTYPE | BBP_H_SUBTYPE | CHAR | 2 | 0 | Specification of a Purchasing Doc.(e.g. Credit Memo/Invoice) | ||
37 | CATEGORY | BBP_CATEGORY_GUID_RAW | SYSUUID | RAW | 16 | 0 | Product Category GUID | ||
38 | PS_PARK_IND | /SAPPSSRM/_PARK_IND | XFELD | CHAR | 1 | 0 | Park Indicator | ||
39 | PS_US01 | /SAPPSSRM/_US_01 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 01 | ||
40 | PS_US02 | /SAPPSSRM/_US_02 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 02 | ||
41 | PS_US03 | /SAPPSSRM/_US_03 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 03 | ||
42 | PS_US04 | /SAPPSSRM/_US_04 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 04 | ||
43 | PS_US05 | /SAPPSSRM/_US_05 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 05 | ||
44 | PS_US06 | /SAPPSSRM/_US_06 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 06 | ||
45 | PS_US07 | /SAPPSSRM/_US_07 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 07 | ||
46 | PS_US08 | /SAPPSSRM/_US_08 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 08 | ||
47 | PS_US09 | /SAPPSSRM/_US_09 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 09 | ||
48 | PS_US10 | /SAPPSSRM/_US_10 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 10 | ||
49 | PS_PA_COMP_TYPE | /SAPPSSRM/_PA_COMP_TYPE | /SAPPSSRM/PA_COMP_TYPE | CHAR | 1 | 0 | Pricing Component Type | ||
50 | ISS_PS_US01 | /SAPPSSRM/_US_01 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 01 | ||
51 | ISS_PS_US02 | /SAPPSSRM/_US_02 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 02 | ||
52 | ISS_PS_US03 | /SAPPSSRM/_US_03 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 03 | ||
53 | ISS_PS_US04 | /SAPPSSRM/_US_04 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 04 | ||
54 | ISS_PS_US05 | /SAPPSSRM/_US_05 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 05 | ||
55 | ISS_PS_US06 | /SAPPSSRM/_US_06 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 06 | ||
56 | ISS_PS_US07 | /SAPPSSRM/_US_07 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 07 | ||
57 | ISS_PS_US08 | /SAPPSSRM/_US_08 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 08 | ||
58 | ISS_PS_US09 | /SAPPSSRM/_US_09 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 09 | ||
59 | ISS_PS_US10 | /SAPPSSRM/_US_10 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 10 | ||
60 | PS_US01_TXT | /SAPPSSRM/_US_TXT_01 | TEXT30 | CHAR | 30 | 0 | User-Specified Status 01 Description | ||
61 | PS_US02_TXT | /SAPPSSRM/_US_TXT_02 | TEXT30 | CHAR | 30 | 0 | User-Specified Status 02 Description | ||
62 | PS_US03_TXT | /SAPPSSRM/_US_TXT_03 | TEXT30 | CHAR | 30 | 0 | User-Specified Status 03 Description | ||
63 | PS_US04_TXT | /SAPPSSRM/_US_TXT_04 | TEXT30 | CHAR | 30 | 0 | User-Specified Status 04 Description | ||
64 | PS_US05_TXT | /SAPPSSRM/_US_TXT_05 | TEXT30 | CHAR | 30 | 0 | User-Specified Status 05 Description | ||
65 | PS_US06_TXT | /SAPPSSRM/_US_TXT_06 | TEXT30 | CHAR | 30 | 0 | User-Specified Status 06 Description | ||
66 | PS_US07_TXT | /SAPPSSRM/_US_TXT_07 | TEXT30 | CHAR | 30 | 0 | User-Specified Status 07 Description | ||
67 | PS_US08_TXT | /SAPPSSRM/_US_TXT_08 | TEXT30 | CHAR | 30 | 0 | User-Specified Status 08 Description | ||
68 | PS_US09_TXT | /SAPPSSRM/_US_TXT_09 | TEXT30 | CHAR | 30 | 0 | User-Specified Status 09 Description | ||
69 | PS_US10_TXT | /SAPPSSRM/_US_TXT_10 | TEXT30 | CHAR | 30 | 0 | User-Specified Status 10 Description | ||
70 | IGP_BE_QUANTITY | BBP_MNG | MENG13 | QUAN | 13 | 3 | Quantity in Order Unit | ||
71 | QUAN_CF_E | BBP_CF_QUANT_E | MENG15 | QUAN | 15 | 3 | Quantity of Entered Confirmation | ||
72 | QUAN_CF | BBP_CF_QUANT | MENG15 | QUAN | 15 | 3 | Quantity of Released Confirmations | ||
73 | QUAN_IV_E | BBP_IV_QUANT_E | MENG15 | QUAN | 15 | 3 | Entered Invoiced Quantity | ||
74 | QUAN_IV | BBP_IV_QUANT | MENG15 | QUAN | 15 | 3 | Released Invoiced Quantity | ||
75 | QUAN_PO_E | BBP_PO_QUANT_E | MENG15 | QUAN | 15 | 3 | Quantity of POs/Confirmations/Invoices Created for Contract | ||
76 | PO_STATUS | CRM_J_STATUS | CRM_J_STATUS | CHAR | 5 | 0 | Object Status | ||
77 | GR_IND | WEPOS | XFELD | CHAR | 1 | 0 | Goods Receipt Indicator | ||
78 | IR_IND | REPOS | XFELD | CHAR | 1 | 0 | Invoice receipt indicator | ||
79 | GR_BASEDIV | BBP_WEBRE | XFELD | CHAR | 1 | 0 | Indicator: GR-Based Invoice Verification | ||
80 | PARENT | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
81 | ITM_TYPE | CRMT_ITEM_TYPE_DB | CRM_ITEM_TYPE | CHAR | 4 | 0 | Item Category | ||
82 | DEDUCT_IND | BBP_DEDUCT_IND | XFELD | CHAR | 1 | 0 | Discount/Rejection Indicator at Item Level | ||
83 | ITEM_STATUS | CRM_J_STATUS | CRM_J_STATUS | CHAR | 5 | 0 | Object Status | ||
84 | PS_IPT | /SAPPSSRM/_IPT | /SAPPSSRM/_IPT | CHAR | 10 | 0 | Public Sector Item Type |
History
Last changed by/on | DDIC | 20150525 |
SAP Release Created in |