SAP ABAP Table /SAPSRM/S_SEARCH_RESULT_PR (Line of the search result for Purchase Requisitions)
Hierarchy
☛
SRM_SERVER (Software Component) SRM_SERVER
⤷ SRM-EBP-SOC (Application Component) Sourcing
⤷ /SAPSRM/PDO_AO_SOCO (Package) Sub-Package for AO Sourcing Cockpit
⤷ SRM-EBP-SOC (Application Component) Sourcing
⤷ /SAPSRM/PDO_AO_SOCO (Package) Sub-Package for AO Sourcing Cockpit
Basic Data
Table Category | INTTAB | Structure |
Structure | /SAPSRM/S_SEARCH_RESULT_PR | Table Relationship Diagram |
Short Description | Line of the search result for Purchase Requisitions |
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 | .INCLUDE | 0 | 0 | Item List in the Sourcing Cockpit | |||||
2 | PARENT | BBP_GUID | SYSUUID | RAW | 16 | 0 | Globally Unique identifier | ||
3 | HDR_GUID | BBP_GUID | SYSUUID | RAW | 16 | 0 | Globally Unique identifier | ||
4 | OBJECT_ID | CRMT_OBJECT_ID_DB | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
5 | ITM_GUID | BBP_GUID | SYSUUID | RAW | 16 | 0 | Globally Unique identifier | ||
6 | NUMBER_INT | CRMT_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item Number in Document | ||
7 | QUANTITY | BBP_MNG | MENG13 | QUAN | 13 | 3 | Quantity in Order Unit | ||
8 | QUAN_PO_E | BBP_PO_QUANT_E | MENG15 | QUAN | 15 | 3 | Quantity of POs/Confirmations/Invoices Created for Contract | ||
9 | UNIT | BBP_UNIT | MEINS | UNIT | 3 | 0 | Purchase Order Unit | * | |
10 | UNIT_TEXT | MSEHL | TEXT30 | CHAR | 30 | 0 | Unit of Measurement Text (Maximum 30 Characters) | ||
11 | ITM_TYPE | CRMT_ITEM_TYPE_DB | CRM_ITEM_TYPE | CHAR | 4 | 0 | Item Category | * | |
12 | DESCRIPTION | COMT_PRSHTEXTX | PRSHTEXT40 | CHAR | 40 | 0 | Product Description | ||
13 | ORDERED_PROD | CRMT_ORDERED_PROD_DB | CRM_ORDERED_PROD | CHAR | 54 | 0 | Product Name Entered | ||
14 | PRODUCT_SRC_SYS | BBP_LOGSYS | CHAR10 | CHAR | 10 | 0 | Business Document Service: ID of Logical System | ||
15 | MANU_PROD | BBP_MFRPN | CHAR40 | CHAR | 40 | 0 | Manufacturer Part Number | ||
16 | MFR_NO_EXT | EMNFR | CHAR10 | CHAR | 10 | 0 | External manufacturer code name or number | ||
17 | CATEGORY | BBP_CATEGORY_GUID_RAW | SYSUUID | RAW | 16 | 0 | Product Category GUID | ||
18 | CATEGORY_ID | BBP_CATEGORY_ID | COM_CATEGORY_ID | CHAR | 20 | 0 | Product Category ID | ||
19 | CATEGORY_TEXT | COMT_CATEGORY_TEXT | TEXT80 | CHAR | 80 | 0 | Category Description | ||
20 | CATALOGID | CATALOG | BBP_WS_SERVICE_ID | CHAR | 20 | 0 | Catalog ID from which the line was selected | ||
21 | CATALOGITEM | BBP_CATALOGITEM | CATALOGITEM | CHAR | 40 | 0 | Catalog Item (Unique Key) | ||
22 | VENDOR_NO | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
23 | VENDOR_GUID | CRMT_PARTNER_NO | CRM_PARTNER_NO | CHAR | 32 | 0 | Partner Number | ||
24 | VENDOR_NAME | AD_NAME1 | TEXT40 | CHAR | 40 | 0 | Name 1 | ||
25 | PROP_VENDOR_NO | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
26 | PROP_VENDOR_GUID | CRMT_PARTNER_NO | CRM_PARTNER_NO | CHAR | 32 | 0 | Partner Number | ||
27 | PROP_VENDOR_NAME | AD_NAME1 | TEXT40 | CHAR | 40 | 0 | Name 1 | ||
28 | REQ_NAME_LAST | AD_NAMELAS | TEXT40 | CHAR | 40 | 0 | Last name | ||
29 | REQ_NAME_FIRST | AD_NAMEFIR | TEXT40 | CHAR | 40 | 0 | First name | ||
30 | REQ_NAME_TEXT | AD_NAMTEXT | TEXT80 | CHAR | 80 | 0 | Full Name of Person | ||
31 | REQ_TITLE_ACA1 | AD_TITLE1 | AD_TITLE1 | CHAR | 4 | 0 | Academic Title: Key | * | |
32 | REQ_TITLE_ACA2 | AD_TITLE2 | AD_TITLE1 | CHAR | 4 | 0 | Second academic title (key) | * | |
33 | REQ_DEPARTMENT | AD_DPRTMNT | TEXT40 | CHAR | 40 | 0 | Department | ||
34 | REQ_TELNR_LONG | AD_TELNRLG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
35 | CTR_ITEM_NUMBER | BBP_CTR_ITEM | CRM_ITEM_NO | NUMC | 10 | 0 | Number of Contract Item | ||
36 | CTR_HDR_NUMBER | BBP_CTR_ID | CRM_OBJECT_ID | CHAR | 10 | 0 | Contract Number | ||
37 | CTR_GUID | BBP_CTR_I_GUID | SYSUUID | RAW | 16 | 0 | Contract Template Item GUID | ||
38 | CTR_HDR_GUID | BBP_CTR_H_GUID | SYSUUID | RAW | 16 | 0 | GUID Contract | ||
39 | CTR_DESCRIPTION | CRMT_PROCESS_DESCRIPTION | CRM_PROCESS_DESCRIPTION | CHAR | 40 | 0 | Transaction Description | ||
40 | PROC_ORG | BBP_PROC_ORG | HROBJEC_14 | CHAR | 14 | 0 | Responsible Purchasing Organization | ||
41 | PROC_GROUP | BBP_PROC_GROUP | HROBJEC_14 | CHAR | 14 | 0 | Responsible Purchasing Group | ||
42 | DPE_OBJECT_ID | BE_OBJECT_ID | BBP_BE_OBJECT_ID | CHAR | 20 | 0 | Follow-On Document Object ID in Backend | ||
43 | DPE_OBJ_ITEM | BE_OBJ_ITEM | BBP_REF_ITEM | CHAR | 10 | 0 | Follow-On Object Item in Backend System | ||
44 | DPE_OBJ_TYPE | SWO_OBJTYP | OJ_NAME | CHAR | 10 | 0 | Object Type | * | |
45 | DPE_HDR_GUID | BBP_GUID | SYSUUID | RAW | 16 | 0 | Globally Unique identifier | ||
46 | DPE_DESCRIPTION | CRMT_PROCESS_DESCRIPTION | CRM_PROCESS_DESCRIPTION | CHAR | 40 | 0 | Transaction Description | ||
47 | EXT_DEMID | BBP_EXT_DEMID | CHAR32 | CHAR | 32 | 0 | External Requirement Tracking Number | ||
48 | EXT_DEM_POSID | BBP_EXT_DEM_POSID | CHAR32 | CHAR | 32 | 0 | External Requirement Tracking Number | ||
49 | BE_INFO_REC | INFNR | INFNR | CHAR | 10 | 0 | Number of purchasing info record | * | |
50 | GROUPING_LEVEL | BBP_GROUPING_LEVEL | BBP_GROUPING_LEVEL | CHAR | 1 | 0 | Specifies How Hierarchy Positions are to be Managed | ||
51 | AUC_OBJECT_ID | CRMT_OBJECT_ID_DB | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
52 | AUC_OBJ_ITEM | BBP_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item number | ||
53 | AUC_HDR_GUID | BBP_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | Globally Unique Identifier in 32-Character Display | ||
54 | AUC_ITEM_GUID | BBP_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | Globally Unique Identifier in 32-Character Display | ||
55 | AUC_DESCRIPTION | CRMT_PROCESS_DESCRIPTION | CRM_PROCESS_DESCRIPTION | CHAR | 40 | 0 | Transaction Description | ||
56 | .INCLUDE | 0 | 0 | Country Include | |||||
57 | .INCLUDE | 0 | 0 | SC-Item Include Brazil | |||||
58 | .INCLUDE | 0 | 0 | Brazilian Fields in SC/PO Item | |||||
59 | ICC_BR_STEUC | ITL_NCM | CHAR16 | CHAR | 16 | 0 | Brazilian NCM Code | CRMC_TAX_TCODE | |
60 | ICC_BR_MATUSE | ITL_MAT_USAGE | ITL_MAT_USAGE | CHAR | 1 | 0 | Material Usage | ||
61 | ICC_BR_MATORG | ITL_NF_MATORG | ITL_NF_MATORG | CHAR | 1 | 0 | Origin of the material | ||
62 | ICC_BR_OWNPRO | ITL_OWNPRO | XFELD | CHAR | 1 | 0 | Produced in-house | ||
63 | ICC_BR_INDUST | ITL_NF_INDUS3 | ITL_NF_INDUS3 | CHAR | 2 | 0 | Material CFOP category | ||
64 | .INCLUDE | 0 | 0 | Country Include | |||||
65 | .INCLUDE | 0 | 0 | SC-Item Include India | |||||
66 | .INCLUDE | 0 | 0 | Indian Fields in SC/PO Item | |||||
67 | ICC_IN_TXJCD | CRMT_TAX_TARIFF_CODE | CHAR16 | CHAR | 16 | 0 | Tax Tariff Code | ||
68 | .INCLUDE | 0 | 0 | ||||||
69 | .INCLUDE | 0 | 0 | Item Ext. for SAP Internal Enhancements (IBUs and so on) | |||||
70 | .INCLUDE | 0 | 0 | SAP Internal Enhancements (IBUs, and so on) for Item | |||||
71 | DUMMY_EEW_PDISS | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
72 | .INCLUDE | 0 | 0 | IBU-PS: Fields for Item Hierarchies | |||||
73 | PS_HL_ITEM | /SAPPSSRM/_HL_ITEM | SYSUUID | RAW | 16 | 0 | Higher-Level Item GUID | ||
74 | PS_HANDLE_ITM | BBP_GUID | SYSUUID | RAW | 16 | 0 | Globally Unique identifier | ||
75 | PS_EXSNR | /SAPPSSRM/_EXSNR | NUMC5 | NUMC | 5 | 0 | External Sort Number | ||
76 | PS_CTRL_KEY | /SAPPSSRM/_PS_CTRL_KEY | /SAPPSSRM/_PS_CTRL_KEY | CHAR | 4 | 0 | Item Process Type Control Key | * | |
77 | PS_IPT | /SAPPSSRM/_IPT | /SAPPSSRM/_IPT | CHAR | 10 | 0 | Public Sector Item Type | * | |
78 | PS_VALUE_RU | BBP_VALUE | WERT8 | CURR | 15 | 2 | Net Value | ||
79 | PS_EXLIN_IND | /SAPPSSRM/_EXLIN_IND | /SAPPSSRM/_EXLIN_IND | CHAR | 1 | 0 | EXLIN Indicator | ||
80 | PS_EXT_IND_STATE | /SAPPSSRM/_EXT_IND_UI_STATE | /SAPPSSRM/_PS_EXT_IND_UI_STATE | CHAR | 1 | 0 | Checkbox Status on the UI | ||
81 | .INCLU--AP | 0 | 0 | IL Localization: Annexing Data for Purchasing in Item | |||||
82 | .INCLUDE | 0 | 0 | Israeli Localization: Annexing Data for Purchasing | |||||
83 | APCGK | /LOCSRM/TAPCGK_IL | /LOCSRM/TAPCGK_IL | NUMC | 4 | 0 | Annexing Package Key | ||
84 | APCGK_EXTEND | /LOCSRM/TAPCGK_EXT_IL | NUMC10 | NUMC | 10 | 0 | Extended key for annexing package | ||
85 | BAS_DATE | /LOCSRM/TBASDATE_IL | DATUM | DATS | 8 | 0 | Base Date | ||
86 | ADATTYP | /LOCSRM/TADATTYP_IL | /LOCSRM/TDATETYP_IL | CHAR | 1 | 0 | Annexing Date Type | ||
87 | START_DAT | /LOCSRM/TASDAT_IL | DATUM | DATS | 8 | 0 | Annexing Start Date | ||
88 | DEV | /LOCSRM/TMPERC_IL | /LOCSRM/TDEC6_3_IL | DEC | 6 | 3 | Deviation Percentage | ||
89 | INDANX | /LOCSRM/TMANIND_IL | XFELD | CHAR | 1 | 0 | Order Type Annexed | ||
90 | LIMIT_DAT | /LOCSRM/TALDAT_IL | DATUM | DATS | 8 | 0 | Annexing Limit Date | ||
91 | NUMERATOR | CHAR20 | CHAR20 | CHAR | 20 | 0 | Char 20 | ||
92 | .INCLU--AP | 0 | 0 | Accpetance Period Item | |||||
93 | PS_FP_EXCPE | /SAPPSSRM/EXCPE | NUM02 | NUMC | 2 | 0 | Acceptance Period | ||
94 | .INCLU--AP | 0 | 0 | IBU-PS: Append for Item Data for Contract Amts Display | |||||
95 | .INCLUDE | 0 | 0 | IBU-PS: INCLUDE for CTR Item Data for Contract Amts Display | |||||
96 | PS_TAX_CODE | BBP_MWSKZ | BBP_MWSKZ | CHAR | 2 | 0 | Tax Code | BBP_TAX | |
97 | .INCLU--AP | 0 | 0 | Append Structure for Cancel BO | |||||
98 | .INCLUDE | 0 | 0 | cancel bo at hdr level flag | |||||
99 | PS_CNCL_BO_HDR | FLAG | FLAG | CHAR | 1 | 0 | General Flag | ||
100 | .INCLU--AP | 0 | 0 | Closeout Item | |||||
101 | PS_CLOSEOUT | /SAPPSSRM/_US_CLOSE | /SAPPSSRM/_US_CLOSE | CHAR | 1 | 0 | Close-Out Status | ||
102 | .INCLU--AP | 0 | 0 | Gov Proc: Down payment item fields | |||||
103 | .INCLUDE | 0 | 0 | Gov Proc: Down payment item fields | |||||
104 | PS_DP_TYPE | /SAPPSSRM/_DP_TYPE | /SAPPSSRM/_DP_TYPE | CHAR | 4 | 0 | Down Payment Indicator | * | |
105 | PS_DP_AMOUNT | /SAPPSSRM/_DP_AMOUNT | WERT11 | CURR | 11 | 2 | Down Payment | ||
106 | PS_DP_PERCENT | /SAPPSSRM/_DP_PERCENT | /SAPPSSRM/_DP_PERCENT | DEC | 5 | 2 | Down Payment Percentage | ||
107 | PS_DP_DUE_DATE | /SAPPSSRM/_DP_DUE_DATE | DATS | DATS | 8 | 0 | Down Payment Due Date | ||
108 | .INCLU--AP | 0 | 0 | Guaranteed Minimum Item | |||||
109 | .INCLUDE | 0 | 0 | IBU PS: Guar. Min. Structure for Fields in Item | |||||
110 | PS_GUAR_MIN_BID | /SAPPSSRM/_GUAR_MIN | WERT8 | CURR | 15 | 2 | Guaranteed Minimum Amount | ||
111 | PS_GUAR_MIN_QUOT | /SAPPSSRM/_GUAR_MIN | WERT8 | CURR | 15 | 2 | Guaranteed Minimum Amount | ||
112 | .INCLUDE | 0 | 0 | Guar. Min. Additional fields on item level. | |||||
113 | PS_GM_NO_EMF | /SAPPSSRM/_NO_EMF | BOOLE | CHAR | 1 | 0 | Guar. Min.: Suppress earmarked funds creation at save | ||
114 | PS_GM_CLOSED | /SAPPSSRM/_CLOSE_CMT | BOOLE | CHAR | 1 | 0 | Close Indicator for Earmarked funds | ||
115 | .INCLU--AP | 0 | 0 | Append for GP IDC Type | |||||
116 | .INCLUDE | 0 | 0 | Include Structure Gov. Proc. IDC | |||||
117 | PS_IDC_TYPE | /SAPPSSRM/IDC_TYPE | /SAPPSSRM/IDC_TYPE | CHAR | 10 | 0 | Order Type Line Item | * | |
118 | .INCLUDE | 0 | 0 | Include Structure Gov. Proc. IDC Minimum Fields | |||||
119 | PS_IDC_MIN_VAL | /SAPPSSRM/IDC_MIN_VALUE | WERT8 | CURR | 15 | 2 | Minimum Value Procurement Documents | ||
120 | PS_IDC_MIN_QTY | /SAPPSSRM/IDC_MIN_QTY | MENG13 | QUAN | 13 | 3 | Minimum Quantity for Procurement Documents | ||
121 | .INCLUDE | 0 | 0 | Include Structure Gov. Proc. Guaranteed Minimum for PO | |||||
122 | PS_GUARANT_MIN | BBP_GUARANTEED_MIN | WERT8 | CURR | 15 | 2 | Guaranteed Purchase Value (Public Sector ONLY!!) | ||
123 | .INCLUDE | 0 | 0 | Include Structure Gov. Proc. IDC Fields for PO | |||||
124 | PS_IDC_VALUE | BBP_ITEM_TARGET_VALUE | WERT8 | CURR | 15 | 2 | Target Value | ||
125 | .INCLU--AP | 0 | 0 | Incremental Funding fields on document item level | |||||
126 | .INCLUDE | 0 | 0 | Incremental Funding fields on document item level | |||||
127 | PS_INFU_IND | /SAPPSSRM/_INFU_ACTIVE | XFELD | CHAR | 1 | 0 | Incremental Funding Active | ||
128 | .INCLU--AP | 0 | 0 | Links for SC | |||||
129 | .INCLUDE | 0 | 0 | Links for the SC | |||||
130 | PS_SC_AC03 | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
131 | PS_SC_MK03 | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
132 | .INCLU--AP | 0 | 0 | Max. Quantity per Period Item Fields | |||||
133 | .INCLUDE | 0 | 0 | IBU-PS: Max. Quantity per Period Screen Fields | |||||
134 | PS_MQP_I_DAYS | /SAPPSSRM/_MQP_I_DAYS | NUM05 | NUMC | 5 | 0 | Duration of Initial Period in Days | ||
135 | PS_MQP_I_QUAN | /SAPPSSRM/_MQP_I_QUAN | MENG13 | QUAN | 13 | 3 | Maximum Quantity for Initial Period | ||
136 | PS_MQP_F_DAYS | /SAPPSSRM/_MQP_F_DAYS | NUM05 | NUMC | 5 | 0 | Duration of Follow-On Period in Days | ||
137 | PS_MQP_F_QUAN | /SAPPSSRM/_MQP_F_QUAN | MENG13 | QUAN | 13 | 3 | Maximum Quantity for Follow-On Periods | ||
138 | .INCLUDE | 0 | 0 | IBU-PS: Max. Quantity per Period Screen Fields - Bid Invit. | |||||
139 | PS_MQP_I_DAY_BID | /SAPPSSRM/_MQP_I_DAYS | NUM05 | NUMC | 5 | 0 | Duration of Initial Period in Days | ||
140 | PS_MQP_I_QUA_BID | /SAPPSSRM/_MQP_I_QUAN | MENG13 | QUAN | 13 | 3 | Maximum Quantity for Initial Period | ||
141 | PS_MQP_F_DAY_BID | /SAPPSSRM/_MQP_F_DAYS | NUM05 | NUMC | 5 | 0 | Duration of Follow-On Period in Days | ||
142 | PS_MQP_F_QUA_BID | /SAPPSSRM/_MQP_F_QUAN | MENG13 | QUAN | 13 | 3 | Maximum Quantity for Follow-On Periods | ||
143 | .INCLU--AP | 0 | 0 | Acceptance at Origin Fields Item | |||||
144 | PS_ORIG_ACCEPT | /SAPPSSRM/_ORIG_ACCEPT | XFELD | CHAR | 1 | 0 | Indicator: Acceptance at Origin | ||
145 | PS_ORIG_ACC_BID | /SAPPSSRM/_ORIG_ACCEPT | XFELD | CHAR | 1 | 0 | Indicator: Acceptance at Origin | ||
146 | .INCLU--AP | 0 | 0 | Option 1st Version Item Fields | |||||
147 | .INCLUDE | 0 | 0 | Option fields on line item level | |||||
148 | PS_POP | /SAPPSSRM/_OPT_PERIOD | NUMC | 3 | 0 | Period of Performance | |||
149 | PS_POP_STATUS | /SAPPSSRM/_OPT_STATUS | /SAPPSSRM/_OPT_STATUS | CHAR | 1 | 0 | Status of Period of Performance | ||
150 | PS_REF_GUID | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
151 | PS_POP_SET | INT4 | 10 | 0 | |||||
152 | .INCLU--AP | 0 | 0 | Append Option Fields for Item Level | |||||
153 | .INCLUDE | 0 | 0 | Options Fields for Government Procurement Phase 2 | |||||
154 | OPT_IND | BBP_OPT_IND | BBP_OPT_IND | CHAR | 1 | 0 | Option Type | ||
155 | OPT_STATUS | BBP_OPT_STATUS | BBP_OPT_STATUS | CHAR | 1 | 0 | Option Status | ||
156 | OPT_XPER_START | BBP_OPT_XPER_START | DATS | DATS | 8 | 0 | Exercise Period Start Date | ||
157 | OPT_XPER_END | BBP_OPT_XPER_END | DATS | DATS | 8 | 0 | Exercise Period End Date | ||
158 | OPT_REF_GUID | BBP_OPT_REF_GUID | SYSUUID | RAW | 16 | 0 | Option Reference GUID | ||
159 | .INCLUDE | 0 | 0 | (P)ublic (S)ector/'Options'-project - Quantity & References | |||||
160 | PS_PO_HDR_GUID | /SAPPSSRM/_PO_HDR_GUID | SYSUUID | RAW | 16 | 0 | Purchaser Order Header GUID | ||
161 | PS_PO_HDR_NUM | /SAPPSSRM/_PO_HDR_NUM | CRM_OBJECT_ID | CHAR | 10 | 0 | Purchase Order Number | ||
162 | PS_PO_ITM_GUID | /SAPPSSRM/_PO_ITM_GUID | SYSUUID | RAW | 16 | 0 | Purchaser Order Item GUID | ||
163 | PS_PO_ITM_NUM | /SAPPSSRM/_PO_ITM_NUM | CRM_ITEM_NO | NUMC | 10 | 0 | Purchaser Order Item Number | ||
164 | PS_PO_OPEN_QUAN | /SAPPSSRM/_PO_OPEN_QUAN | MENG15 | QUAN | 15 | 3 | Open Quantity of a Purchase Order | ||
165 | .INCLU--AP | 0 | 0 | Append for GP Pricing Arrangements | |||||
166 | .INCLUDE | 0 | 0 | Pricing Arrangements Item Fields | |||||
167 | .INCLUDE | 0 | 0 | Pricing Arrangements Main Fields | |||||
168 | PS_PA_ID | /SAPPSSRM/_PA_STRUC_ID | /SAPPSSRM/PA_STRUC_ID | CHAR | 4 | 0 | Pricing Arrangement Identifier | ||
169 | PS_PA_MIN_FEE | /SAPPSSRM/_PA_MINIMUM_FEE | WERT7 | CURR | 13 | 2 | Minimum Fee | ||
170 | PS_PA_MAX_FEE | /SAPPSSRM/_PA_MAXIMUM_FEE | WERT7 | CURR | 13 | 2 | Maximum Fee | ||
171 | PS_PA_GS_BLW | /SAPPSSRM/_PA_GOV_SHARE_BELOW | /SAPPSSRM/PA_PERCENTAGE | DEC | 5 | 2 | Government Share Below | ||
172 | PS_PA_GS_ABV | /SAPPSSRM/_PA_GOV_SHARE_ABOVE | /SAPPSSRM/PA_PERCENTAGE | DEC | 5 | 2 | Government Share Above | ||
173 | PS_PA_CLNG_AMT | /SAPPSSRM/_PA_CEILING_AMOUNT | WERT8 | CURR | 15 | 2 | Ceiling Amount | ||
174 | PS_PA_TOTL_AMT | /SAPPSSRM/_PA_TOTAL_AMOUNT | WERT8 | CURR | 15 | 2 | Total Amount of Master Item | ||
175 | .INCLUDE | 0 | 0 | Pricing Arrangements Cost Constraints | |||||
176 | PS_PA_NTE_IND | /SAPPSSRM/_NTE_IND | XFELD | CHAR | 1 | 0 | Not to Exceed | ||
177 | PS_PA_NSP_IND | /SAPPSSRM/_NSP_IND | XFELD | CHAR | 1 | 0 | Not Separately Priced | ||
178 | .INCLUDE | 0 | 0 | Pricing Arrangements: Auxiliary, technical fields | |||||
179 | PS_PA_COMP_KEY | /SAPPSSRM/_PA_COMP_KEY | CHAR | 4 | 0 | Component Key | |||
180 | PS_PA_COMP_TYPE | /SAPPSSRM/_PA_COMP_TYPE | /SAPPSSRM/PA_COMP_TYPE | CHAR | 1 | 0 | Pricing Component Type | * | |
181 | PS_PA_CLOSE_CMMT | /SAPPSSRM/_PA_CLOSE_COMMITMENT | BOOLE | CHAR | 1 | 0 | Close FM Commitment | ||
182 | .INCLU--AP | 0 | 0 | Append Structure for Periodic Payment Plan | |||||
183 | .INCLUDE | 0 | 0 | Header Structure for Periodic Payment Plan | |||||
184 | PS_DOC_ITEM | EBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | * | |
185 | PS_IV_PLAN_NUM | FPLNR | FPLNR | CHAR | 10 | 0 | Billing plan number / invoicing plan number | * | |
186 | PS_IP_TYPE | /SAPPSSRM/_PP_TYPE | CHAR2 | CHAR | 2 | 0 | Payment Plan Type | ||
187 | PS_IP_TYPE_DESC | /SAPPSSRM/_PP_DESCRIPTION | CHAR | 30 | 0 | Payment Plan Date Description | |||
188 | PS_PERIO | /SAPPSSRM/_PP_ORGN_NEXT_DATE | CHAR2 | CHAR | 2 | 0 | Rule for Setting Next Date | ||
189 | PS_PERIO_DESC | /SAPPSSRM/_PP_DESCR | TEXT40 | CHAR | 40 | 0 | Description | ||
190 | PS_IN_ADVANCE | /SAPPSSRM/_PP_IN_ADVANCE | XFELD | CHAR | 1 | 0 | Invoice Creation in Advance | ||
191 | PS_DEV_BILL_DAT | /SAPPSSRM/_PP_DEV_BILL_DATE | CHAR2 | CHAR | 2 | 0 | Rule for Setting Different Invoice Date | ||
192 | PS_DEV_DAT_DESC | /SAPPSSRM/_PP_DESCR | TEXT40 | CHAR | 40 | 0 | Description | ||
193 | PS_START_DATE | BBP_VPER_START | DATUM | DATS | 8 | 0 | Validity Period From | ||
194 | PS_ORGN_ST_DAT | /SAPPSSRM/_PP_ORGN_START_DATE | CHAR2 | CHAR | 2 | 0 | Rule for Setting Start Date | ||
195 | PS_ST_DAT_DES | /SAPPSSRM/_PP_DESCR | TEXT40 | CHAR | 40 | 0 | Description | ||
196 | PS_DATES_FROM | BBP_VPER_START | DATUM | DATS | 8 | 0 | Validity Period From | ||
197 | PS_ORGN_FROM_DAT | /SAPPSSRM/_PP_ORGN_START_DATE | CHAR2 | CHAR | 2 | 0 | Rule for Setting Start Date | ||
198 | PS_FROM_DAT_DES | /SAPPSSRM/_PP_DESCR | TEXT40 | CHAR | 40 | 0 | Description | ||
199 | PS_END_DATE | BBP_VPER_END | DATUM | DATS | 8 | 0 | Validity period | ||
200 | PS_ORGN_END_DAT | /SAPPSSRM/_PP_ORGN_END_DATE | CHAR2 | CHAR | 2 | 0 | Rule for Setting End Date | ||
201 | PS_END_DAT_DES | /SAPPSSRM/_PP_DESCR | TEXT40 | CHAR | 40 | 0 | Description | ||
202 | PS_DATES_TO | FKDAT | DATUM | DATS | 8 | 0 | Billing date for billing index and printout | ||
203 | PS_UNTIL_DAT | /SAPPSSRM/_PP_ORGN_END_DATE | CHAR2 | CHAR | 2 | 0 | Rule for Setting End Date | ||
204 | PS_UNTIL_DAT_DES | /SAPPSSRM/_PP_DESCR | TEXT40 | CHAR | 40 | 0 | Description | ||
205 | PS_HORIZON_DATE | FKDAT | DATUM | DATS | 8 | 0 | Billing date for billing index and printout | ||
206 | PS_HORIZON | /SAPPSSRM/_PP_HORIZON | CHAR2 | CHAR | 2 | 0 | Rule for Determining Horizon | ||
207 | PS_HORIZON_DESC | /SAPPSSRM/_PP_DESCR | TEXT40 | CHAR | 40 | 0 | Description | ||
208 | PS_CALENDER_ID | CALID | WFCID | CHAR | 2 | 0 | Calendar ID | * | |
209 | PS_IS_PP | /SAPPSSRM/_PP_TYPE | CHAR2 | CHAR | 2 | 0 | Payment Plan Type | ||
210 | .INCLU--AP | 0 | 0 | Phased Delivery Item | |||||
211 | PS_PHASED_DEL | /SAPPSSRM/PHASED_DEL | XFELD | CHAR | 1 | 0 | Phased Delivery | ||
212 | .INCLU--AP | 0 | 0 | append period of performance fields for Options and JFMIP | |||||
213 | .INCLUDE | 0 | 0 | Period of Performance Fields for Options and JFMIP | |||||
214 | OPT_POP_START | BBP_OPT_POP_START | DATS | DATS | 8 | 0 | Option Period of Performance Start Date | ||
215 | OPT_POP_END | BBP_OPT_POP_END | DATS | DATS | 8 | 0 | Option Period of Performance End Date | ||
216 | .INCLU--AP | 0 | 0 | Priority Fields Item | |||||
217 | PS_DLV_PRIO | /SAPPSSRM/_DLV_PRIO | /SAPPSSRM/_PRIO_CODE | NUMC | 2 | 0 | Delivery Priority | * | |
218 | PS_PRIO_CODE | /SAPPSSRM/_PRIO_CODE | /SAPPSSRM/_PRIO_CODE | NUMC | 2 | 0 | Delivery Priority | * | |
219 | .INCLU--AP | 0 | 0 | Prompt Payment Item Fields | |||||
220 | .INCLUDE | 0 | 0 | Prompt Payment Fields | |||||
221 | PS_FAST_PAY | /SAPPSSRM/_FAST_PAY | XFELD | CHAR | 1 | 0 | Fast Pay | ||
222 | PS_PPA_EXCL | /SAPPSSRM/_PPA_EXCLUDE | XFELD | CHAR | 1 | 0 | Exclude from Prompt Payment Act | ||
223 | .INCLU--AP | 0 | 0 | Append Structure PR Enhancements | |||||
224 | .INCLUDE | 0 | 0 | Structure for PR Enhancement addition to SOCO | |||||
225 | PS_O_BO_OBJ_ID | CRMT_OBJECT_ID_DB | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
226 | PS_O_BO_OBJ_TY | SWO_OBJTYP | OJ_NAME | CHAR | 10 | 0 | Object Type | * | |
227 | PS_O_BO_DESC | BBP_DOCNAME | TEXT40 | CHAR | 40 | 0 | Name of BBP Document | ||
228 | PS_O_BO_GUID | BBP_GUID | SYSUUID | RAW | 16 | 0 | Globally Unique identifier | ||
229 | PS_O_BO_ITM_NO | CRMT_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item Number in Document | ||
230 | PS_O_BO_DRAFT | CHAR5 | CHAR5 | CHAR | 5 | 0 | R/2 table | ||
231 | PS_O_BO_DOC_TY | CHAR32 | CHAR32 | CHAR | 32 | 0 | Character field, length 32 | ||
232 | .INCLU--AP | 0 | 0 | Reason Code Item | |||||
233 | PS_REASON_CODE | /SAPPSSRM/_GR_REASON_CODE | /SAPPSSRM/_GR_REASON_CODE | CHAR | 4 | 0 | Reason Code | ||
234 | .INCLU--AP | 0 | 0 | Smart Number Item Fields | |||||
235 | PS_EXTERNAL_ITEM | /SAPPSSRM/_EXTERNAL_ITEM_FLAG | /SAPPSSRM/_EXTERNAL_ITEM_FLAG | CHAR | 1 | 0 | External Origin of Smart Number | ||
236 | .INCLU--AP | 0 | 0 | Sourcing Rules Fields Item | |||||
237 | .INCLUDE | 0 | 0 | Sourcing Rules Fields | |||||
238 | PS_MAX_QTY | /SAPPSSRM/_MAX_QTY | MENG13 | QUAN | 13 | 3 | Maximum Quantity in order unit | ||
239 | PS_MAX_VALUE | /SAPPSSRM/_MAX_VAL | WERT8 | CURR | 15 | 2 | Maximum Order Value in Item Currency | ||
240 | PS_VENDOR_MLTPL | /SAPPSSRM/_VEND_MULT | MENG13 | QUAN | 13 | 3 | Supplier Multiple in Order Unit | ||
241 | .INCLU--AP | 0 | 0 | Append Gov. Proc. Subcontracting Fields in PD Item | |||||
242 | .INCLUDE | 0 | 0 | Structure Gov. Proc. Subcontracting Fields on item | |||||
243 | PS_SUBCON_ITEM | /SAPPSSRM/_SUBCON_ITEM | XFELD | CHAR | 1 | 0 | X-field item is subcontracting item | ||
244 | .INCLU--AP | 0 | 0 | Threshold fields for use with the line item detail structure | |||||
245 | .INCLUDE | 0 | 0 | Threshold fields for use with item and accounting structures | |||||
246 | PS_TH_NOT_REL | /SAPPSSRM/_TH_NOT_RELEVANT | XFELD | CHAR | 1 | 0 | Threshold not Relevant | ||
247 | PS_TH_TYPE | /SAPPSSRM/_TH_TYPE | /SAPPSSRM/_TH_TYPE | CHAR | 10 | 0 | Threshold Type | * | |
248 | PS_TH_NUMBER | /SAPPSSRM/_TH_NUM | NUMC10 | NUMC | 10 | 0 | Threshold Number | ||
249 | PS_TH_AVAIL_AMT | /SAPPSSRM/_TH_RM_AMNT | /SAPPSSRM/_TH_RM_AMNT | CURR | 20 | 2 | Remaining Threshold Amount | ||
250 | PS_TH_CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
251 | .INCLU--AP | 0 | 0 | User Status Item Fields | |||||
252 | .INCLUDE | 0 | 0 | User-Specified Status on Purchase Document (Header / Item) | |||||
253 | PS_US01 | /SAPPSSRM/_US_01 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 01 | * | |
254 | PS_US02 | /SAPPSSRM/_US_02 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 02 | * | |
255 | PS_US03 | /SAPPSSRM/_US_03 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 03 | * | |
256 | PS_US04 | /SAPPSSRM/_US_04 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 04 | * | |
257 | PS_US05 | /SAPPSSRM/_US_05 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 05 | * | |
258 | PS_US06 | /SAPPSSRM/_US_06 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 06 | * | |
259 | PS_US07 | /SAPPSSRM/_US_07 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 07 | * | |
260 | PS_US08 | /SAPPSSRM/_US_08 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 08 | * | |
261 | PS_US09 | /SAPPSSRM/_US_09 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 09 | * | |
262 | PS_US10 | /SAPPSSRM/_US_10 | J_ESTAT | CHAR | 5 | 0 | User-Specified Status 10 | * | |
263 | .INCLUDE | 0 | 0 | User-Specified Sts Date on Purchase Document (Header / Item) | |||||
264 | PS_US01_DATE | /SAPPSSRM/_US01_DATE | DATUM | DATS | 8 | 0 | Date of User-Specified Status 01 | ||
265 | PS_US02_DATE | /SAPPSSRM/_US02_DATE | DATUM | DATS | 8 | 0 | Date of User-Specified Status 02 | ||
266 | PS_US03_DATE | /SAPPSSRM/_US03_DATE | DATUM | DATS | 8 | 0 | Date of User-Specified Status 03 | ||
267 | PS_US04_DATE | /SAPPSSRM/_US04_DATE | DATUM | DATS | 8 | 0 | Date of User-Specified Status 04 | ||
268 | PS_US05_DATE | /SAPPSSRM/_US05_DATE | DATUM | DATS | 8 | 0 | Date of User-Specified Status 05 | ||
269 | PS_US06_DATE | /SAPPSSRM/_US06_DATE | DATUM | DATS | 8 | 0 | Date of User-Specified Status 06 | ||
270 | PS_US07_DATE | /SAPPSSRM/_US07_DATE | DATUM | DATS | 8 | 0 | Date of User-Specified Status 07 | ||
271 | PS_US08_DATE | /SAPPSSRM/_US08_DATE | DATUM | DATS | 8 | 0 | Date of User-Specified Status 08 | ||
272 | PS_US09_DATE | /SAPPSSRM/_US09_DATE | DATUM | DATS | 8 | 0 | Date of User-Specified Status 09 | ||
273 | PS_US10_DATE | /SAPPSSRM/_US10_DATE | DATUM | DATS | 8 | 0 | Date of User-Specified Status 10 | ||
274 | .INCLUDE | 0 | 0 | User Status text on purchase document (header / item) | |||||
275 | PS_US01_TXT | /SAPPSSRM/_US_TXT_01 | TEXT30 | CHAR | 30 | 0 | User-Specified Status 01 Description | ||
276 | PS_US02_TXT | /SAPPSSRM/_US_TXT_02 | TEXT30 | CHAR | 30 | 0 | User-Specified Status 02 Description | ||
277 | PS_US03_TXT | /SAPPSSRM/_US_TXT_03 | TEXT30 | CHAR | 30 | 0 | User-Specified Status 03 Description | ||
278 | PS_US04_TXT | /SAPPSSRM/_US_TXT_04 | TEXT30 | CHAR | 30 | 0 | User-Specified Status 04 Description | ||
279 | PS_US05_TXT | /SAPPSSRM/_US_TXT_05 | TEXT30 | CHAR | 30 | 0 | User-Specified Status 05 Description | ||
280 | PS_US06_TXT | /SAPPSSRM/_US_TXT_06 | TEXT30 | CHAR | 30 | 0 | User-Specified Status 06 Description | ||
281 | PS_US07_TXT | /SAPPSSRM/_US_TXT_07 | TEXT30 | CHAR | 30 | 0 | User-Specified Status 07 Description | ||
282 | PS_US08_TXT | /SAPPSSRM/_US_TXT_08 | TEXT30 | CHAR | 30 | 0 | User-Specified Status 08 Description | ||
283 | PS_US09_TXT | /SAPPSSRM/_US_TXT_09 | TEXT30 | CHAR | 30 | 0 | User-Specified Status 09 Description | ||
284 | PS_US10_TXT | /SAPPSSRM/_US_TXT_10 | TEXT30 | CHAR | 30 | 0 | User-Specified Status 10 Description | ||
285 | .INCLU--AP | 0 | 0 | Append for GP Withholds: Item Fields | |||||
286 | .INCLUDE | 0 | 0 | GP Withholds: Item Fields | |||||
287 | PS_WH_PRCNT | /SAPPSSRM/_WH_PERCENT | /SAPPSSRM/_WH_PRZ32 | DEC | 5 | 2 | Retention Value as Percentage | ||
288 | PS_WH_IND_PA | /SAPPSSRM/_WH_IND_PA | /SAPPSSRM/_WH_IND_PA | CHAR | 1 | 0 | Retention Indicator for Pricing Arrangments | ||
289 | .INCLU--AP | 0 | 0 | Leasing | |||||
290 | .INCLUDE | 0 | 0 | Scenario-Specific Header Fields for Leasing | |||||
291 | .INCLUDE | 0 | 0 | Scenario-Specific Item Fields for Leasing | |||||
292 | LAM_QUO_ID | LAM_QUO_ID | CRM_OBJECT_ID | CHAR | 10 | 0 | Leasing Quotation Number | ||
293 | LAM_QUO_ITMNO | CRMT_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item Number in Document | ||
294 | LAM_CTR_ID | LAM_CTR_ID | CRM_OBJECT_ID | CHAR | 10 | 0 | Leasing Contract Number | ||
295 | LAM_CTR_ITMNO | CRMT_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item Number in Document | ||
296 | LAM_GAID | LAM_ALLOCATION_ID | CHAR16 | CHAR | 16 | 0 | External Allocation Number | ||
297 | LAM_ASS_PO_ID | LAM_ASS_PO_ID | TEXT35 | CHAR | 35 | 0 | Leasing PO Assumption ID | ||
298 | LAM_EXT_REF1 | LAM_EXT_REF1 | TEXT35 | CHAR | 35 | 0 | Leasing External Reference 1 | ||
299 | LAM_EXT_REF2 | LAM_EXT_REF2 | TEXT35 | CHAR | 35 | 0 | Leasing External Reference 2 | ||
300 | LAM_TEXT | LAM_TEXT | TEXT35 | CHAR | 35 | 0 | Leasing Text | ||
301 | .INCLU--AP | 0 | 0 | Extended Invoice | |||||
302 | .INCLUDE | 0 | 0 | Additional Fields for Extended Inv.Verif. | |||||
303 | NO_DISCOUNT_EXI | NO_DISCOUNT_EXI | XFELD | CHAR | 1 | 0 | Not Relevant for Cash Discount | ||
304 | .INCLU--AP | 0 | 0 | GLO : Tax information relevant for Brazil. | |||||
305 | .INCLUDE | 0 | 0 | Tax Fields for Brazil. | |||||
306 | ICC_BR_TAXCODE | ITL_TCODE | CHAR2 | CHAR | 2 | 0 | Tax Code for Brazil | ||
307 | ICC_BR_TAXAMT | BBP_TAX_AMOUNT | WERT8 | CURR | 15 | 2 | Tax Amount | ||
308 | ICC_BR_TAXDES | BBPTAX_DES | TEXT50 | CHAR | 50 | 0 | Enterprise Buyer: Tax Code Description | ||
309 | .INCLUDE | 0 | 0 | Item Extension for Customer Fields | |||||
310 | .INCLUDE | 0 | 0 | Customer Enhancements for Item | |||||
311 | DUMMY_EEW_PDISC | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
312 | DOC_PRIORITY | BBP_DOC_PRIORITY | BBP_DOC_PRIORITY | CHAR | 4 | 0 | Document Priority | ||
313 | PROCESS_TYPE | CRMT_PROCESS_TYPE_DB | CRM_PROCESS_TYPE | CHAR | 4 | 0 | Business Transaction Type | * | |
314 | DELIV_DATE | EINDT | DATUM | DATS | 8 | 0 | Item delivery date | ||
315 | SOURCE_REL_IND | BBP_SOURCE_REL_IND | BBP_SOURCE_REL_IND | CHAR | 1 | 0 | Indicator - If the Document is Sourcing-Relevant | ||
316 | EXLIN | /SAPSRM/EXLIN | /SAPSRM/EXLIN | CHAR | 40 | 0 | Configurable Line Item Number | ||
317 | EXT_DEM_EXLIN | /SAPSRM/EXLIN | /SAPSRM/EXLIN | CHAR | 40 | 0 | Configurable Line Item Number | ||
318 | VPER_START | BBP_VPER_START | DATUM | DATS | 8 | 0 | Validity Period From | ||
319 | VPER_END | BBP_VPER_END | DATUM | DATS | 8 | 0 | Validity period | ||
320 | HIER_TYPE | HIER_TYPE | HIER_TYPE | CHAR | 1 | 0 | Hierarchy Type | ||
321 | HAS_SUBITEMS | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
322 | HIER_TOP_ITEM_GUID | BBP_GUID | SYSUUID | RAW | 16 | 0 | Globally Unique identifier |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | /SAPSRM/S_SEARCH_RESULT_PR | ICC_BR_STEUC | CRMC_TAX_TCODE | TAX_TARIFF_CODE | |||
2 | /SAPSRM/S_SEARCH_RESULT_PR | PS_TAX_CODE | BBP_TAX | TAX_CODE | KEY |
History
Last changed by/on | SAP | 20141013 |
SAP Release Created in | 600 |