SAP ABAP Table MMPUR_SPPR_ITEM_STY (SPPR Item Data)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ MM-PUR (Application Component) Purchasing
⤷ MEREQ (Package) Purchasing: Purchase Requisition
⤷ MM-PUR (Application Component) Purchasing
⤷ MEREQ (Package) Purchasing: Purchase Requisition
Basic Data
Table Category | INTTAB | Structure |
Structure | MMPUR_SPPR_ITEM_STY | Table Relationship Diagram |
Short Description | SPPR Item Data |
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 | SPPR Document Item | |||||
2 | DOC_NUMBER | BANFN | BANFN | CHAR | 10 | 0 | Purchase requisition number | ||
3 | DOC_ITEM | BNFPO | BNFPO | NUMC | 5 | 0 | Item number of purchase requisition | * | |
4 | .INCLUDE | 0 | 0 | OO Purchase Requisition: Item Status | |||||
5 | BNFPO | BNFPO | BNFPO | NUMC | 5 | 0 | Item number of purchase requisition | * | |
6 | BSART | BBSRT | BSART | CHAR | 4 | 0 | Purchase Requisition Document Type | * | |
7 | BSTYP | BSTYP | BSTYP | CHAR | 1 | 0 | Purchasing document category | ||
8 | BSAKZ | BSAKZ | BSAKZ | CHAR | 1 | 0 | Control indicator for purchasing document type | ||
9 | LOEKZ | ELOEK | ELOEK | CHAR | 1 | 0 | Deletion indicator in purchasing document | ||
10 | STATU | BANST | BANST | CHAR | 1 | 0 | Processing status of purchase requisition | ||
11 | ESTKZ | ESTKZ | ESTKZ | CHAR | 1 | 0 | Creation indicator (purchase requisition/schedule lines) | ||
12 | FRGKZ | FRGKZ | FRGKZ | CHAR | 1 | 0 | Release Indicator | * | |
13 | FRGZU | FRGZU | FRGZU | CHAR | 8 | 0 | Release status | ||
14 | FRGST | FRGST | FRGST | CHAR | 2 | 0 | Release strategy in the purchase requisition | ||
15 | EKGRP | EKGRP | EKGRP | CHAR | 3 | 0 | Purchasing group | * | |
16 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
17 | ERDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
18 | AFNAM | AFNAM | AFNAM | CHAR | 12 | 0 | Name of requisitioner/requester | ||
19 | TXZ01 | TXZ01 | TEXT40 | CHAR | 40 | 0 | Short Text | ||
20 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
21 | EMATN | EMATN | MATNR | CHAR | 18 | 0 | Material number corresponding to manufacturer part number | * | |
22 | WERKS | EWERK | WERKS | CHAR | 4 | 0 | Plant | * | |
23 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | * | |
24 | BEDNR | BEDNR | CHAR10 | CHAR | 10 | 0 | Requirement Tracking Number | ||
25 | MATKL | MATKL | MATKL | CHAR | 9 | 0 | Material Group | * | |
26 | RESWK | RESWK | WERKS | CHAR | 4 | 0 | Supplying (issuing) plant in case of stock transport order | * | |
27 | MENGE | BAMNG | MENG13 | QUAN | 13 | 3 | Purchase requisition quantity | ||
28 | MEINS | BAMEI | MEINS | UNIT | 3 | 0 | Purchase requisition unit of measure | * | |
29 | BUMNG | BUMNG | MENG13 | QUAN | 13 | 3 | Shortage (stock undercoverage) quantity | ||
30 | BADAT | BADAT | DATUM | DATS | 8 | 0 | Requisition (request) date | ||
31 | LPEIN | LPEIN | PRGBZ | CHAR | 1 | 0 | Category of delivery date | * | |
32 | LFDAT | EINDT | DATUM | DATS | 8 | 0 | Item delivery date | ||
33 | FRGDT | FRGDT | DATUM | DATS | 8 | 0 | Purchase Requisition Release Date | ||
34 | WEBAZ | WEBAZ | DEC3 | DEC | 3 | 0 | Goods receipt processing time in days | ||
35 | PREIS | BAPRE | WERT11 | CURR | 11 | 2 | Price in Purchase Requisition | ||
36 | PEINH | EPEIN | DEC5 | DEC | 5 | 0 | Price unit | ||
37 | PSTYP | PSTYP | PSTYP | CHAR | 1 | 0 | Item category in purchasing document | * | |
38 | KNTTP | KNTTP | KNTTP | CHAR | 1 | 0 | Account assignment category | * | |
39 | KZVBR | KZVBR | KZVBR | CHAR | 1 | 0 | Consumption posting | ||
40 | KFLAG | KFLAG | XFELD | CHAR | 1 | 0 | Acct.asst.changeable | ||
41 | VRTKZ | VRTKZ | VRTKZ | CHAR | 1 | 0 | Distribution indicator for multiple account assignment | ||
42 | TWRKZ | TWRKZ | TWRKZ | CHAR | 1 | 0 | Partial invoice indicator | ||
43 | WEPOS | WEPOS | XFELD | CHAR | 1 | 0 | Goods Receipt Indicator | ||
44 | WEUNB | WEUNB | XFELD | CHAR | 1 | 0 | Goods Receipt, Non-Valuated | ||
45 | REPOS | REPOS | XFELD | CHAR | 1 | 0 | Invoice receipt indicator | ||
46 | LIFNR | WLIEF | LIFNR | CHAR | 10 | 0 | Desired vendor | * | |
47 | FLIEF | FLIEF | LIFNR | CHAR | 10 | 0 | Fixed vendor | * | |
48 | EKORG | EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | * | |
49 | VRTYP | BSTYP | BSTYP | CHAR | 1 | 0 | Purchasing document category | ||
50 | KONNR | KONNR | EBELN | CHAR | 10 | 0 | Number of principal purchase agreement | * | |
51 | KTPNR | KTPNR | EBELP | NUMC | 5 | 0 | Item number of principal purchase agreement | * | |
52 | INFNR | INFNR | INFNR | CHAR | 10 | 0 | Number of purchasing info record | * | |
53 | ZUGBA | DZUGBA | XFELD | CHAR | 1 | 0 | Assigned Source of Supply | ||
54 | QUNUM | QUNUM | QUNUM | CHAR | 10 | 0 | Number of quota arrangement | ||
55 | QUPOS | QUPOS | NUM03 | NUMC | 3 | 0 | Quota arrangement item | ||
56 | DISPO | DISPO | DISPO | CHAR | 3 | 0 | MRP controller | * | |
57 | SERNR | SERNR | SERNR | CHAR | 8 | 0 | BOM explosion number | * | |
58 | BVDAT | BVDAT | DATUM | DATS | 8 | 0 | Date of last resubmission | ||
59 | BATOL | BATOL | BATOL | DEC | 3 | 0 | Resubmission interval of purchase requisition | ||
60 | BVDRK | BVDRK | ZAEHL | DEC | 7 | 0 | Number of resubmissions | ||
61 | EBELN | BSTNR | EBELN | CHAR | 10 | 0 | Purchase order number | * | |
62 | EBELP | BSTPO | EBELP | NUMC | 5 | 0 | Purchase order item number | * | |
63 | BEDAT | BEDAT | DATUM | DATS | 8 | 0 | Purchase Order Date | ||
64 | BSMNG | BSMNG | MENG13 | QUAN | 13 | 3 | Quantity ordered against this purchase requisition | ||
65 | LBLNI | LBLNI | LBLNI | CHAR | 10 | 0 | Entry Sheet Number | * | |
66 | BWTAR | BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | * | |
67 | XOBLR | XOBLR | XFELD | CHAR | 1 | 0 | Item affects commitments | ||
68 | EBAKZ | EBAKZ | XFELD | CHAR | 1 | 0 | Purchase requisition closed | ||
69 | RSNUM | RSNUM | RSNUM | NUMC | 10 | 0 | Number of reservation/dependent requirements | * | |
70 | SOBKZ | SOBKZ | SOBKZ | CHAR | 1 | 0 | Special Stock Indicator | * | |
71 | ARSNR | ARSNR | MDNUM | NUMC | 10 | 0 | Settlement reservation number | ||
72 | ARSPS | ARSPS | RSPOS | NUMC | 4 | 0 | Item number of the settlement reservation | ||
73 | FIXKZ | BAFIX | XFELD | CHAR | 1 | 0 | Purchase requisition is fixed | ||
74 | BMEIN | BSTME | MEINS | UNIT | 3 | 0 | Order unit | * | |
75 | REVLV | REVLV | REVLV | CHAR | 2 | 0 | Revision level | ||
76 | VORAB | VORAB | XFELD | CHAR | 1 | 0 | Advance procurement: project stock | ||
77 | PACKNO | PACKNO | PACKNO | NUMC | 10 | 0 | Package number | * | |
78 | KANBA | KBNKZ | KBNKZ | CHAR | 1 | 0 | Kanban Indicator | ||
79 | BPUEB | BPUEB | BPUEB | CHAR | 1 | 0 | Adopt requisition price in purchase order | ||
80 | CUOBJ | CUOBJ | CUOBJ | NUMC | 18 | 0 | Configuration (internal object number) | ||
81 | FRGGR | FRGGR | FRGGR | CHAR | 2 | 0 | Release group | * | |
82 | FRGRL | FRGRL | XFELD | CHAR | 1 | 0 | Release Not Yet Completely Effected | ||
83 | AKTNR | WAKTION | WAKTION | CHAR | 10 | 0 | Promotion | * | |
84 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
85 | UMSOK | UMSOK | SOBKZ | CHAR | 1 | 0 | Special stock indicator for physical stock transfer | * | |
86 | VERID | VERID | VERID | CHAR | 4 | 0 | Production Version | * | |
87 | FIPOS | FIPOS | FIPOS | CHAR | 14 | 0 | Commitment Item | * | |
88 | FISTL | FISTL | FISTL | CHAR | 16 | 0 | Funds Center | * | |
89 | GEBER | BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | * | |
90 | KZKFG | KZCUH | KZCUH | CHAR | 1 | 0 | Origin of Configuration | ||
91 | SATNR | SATNR | MATNR | CHAR | 18 | 0 | Cross-Plant Configurable Material | * | |
92 | MNG02 | MNG06 | MENGV13 | QUAN | 13 | 3 | Committed quantity | ||
93 | DAT01 | DAT05 | DATUM | DATS | 8 | 0 | Committed date | ||
94 | ATTYP | ATTYP | ATTYP | CHAR | 2 | 0 | Material Category | ||
95 | ADRNR | ADRNR_MM | AD_ADDRNUM | CHAR | 10 | 0 | Manual address number in purchasing document item | * | |
96 | ADRN2 | ADRN2 | AD_ADDRNUM | CHAR | 10 | 0 | Number of delivery address | * | |
97 | KUNNR | EKUNNR | KUNNR | CHAR | 10 | 0 | Customer | * | |
98 | EMLIF | EMLIF | LIFNR | CHAR | 10 | 0 | Vendor to be supplied/who is to receive delivery | * | |
99 | LBLKZ | LBLKZ | XFELD | CHAR | 1 | 0 | Subcontracting vendor | ||
100 | KZBWS | KZBWS | KZBWS | CHAR | 1 | 0 | Valuation of Special Stock | ||
101 | GSWRT | GSWRT | WERT7 | CURR | 13 | 2 | Total Value of Item | ||
102 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
103 | IDNLF | IDNLF | IDNEX | CHAR | 35 | 0 | Material Number Used by Vendor | ||
104 | GSFRG | GSFRG | XFELD | CHAR | 1 | 0 | Overall release of purchase requisitions | ||
105 | MPROF | MPROF | MPROF | CHAR | 4 | 0 | Mfr part profile | * | |
106 | KZFME | KZWSO | KZWSO | CHAR | 1 | 0 | Units of measure usage | ||
107 | SPRAS | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | * | |
108 | TECHS | TECHS | TECHS | CHAR | 12 | 0 | Parameter Variant/Standard Variant | ||
109 | MFRPN | MFRPN | CHAR40 | CHAR | 40 | 0 | Manufacturer Part Number | ||
110 | MFRNR | MFRNR | LIFNR | CHAR | 10 | 0 | Manufacturer number | * | |
111 | EMNFR | EMNFR | CHAR10 | CHAR | 10 | 0 | External manufacturer code name or number | ||
112 | FORDN | SFORDN | EBELN | CHAR | 10 | 0 | Framework Order | * | |
113 | FORDP | FORDP | EBELP | NUMC | 5 | 0 | Item of framework order | * | |
114 | PLIFZ | PLIFZ | DEC3 | DEC | 3 | 0 | Planned delivery time in days | ||
115 | BERID | BERID | BERID | CHAR | 10 | 0 | MRP Area | * | |
116 | UZEIT | LZEIT | UZEIT | TIMS | 6 | 0 | Delivery Date Time-Spot | ||
117 | REF_BANFN | REFBN | BANFN | CHAR | 10 | 0 | Number of Reference Purchase Requisition | ||
118 | REF_BNFPO | RFBPS | BNFPO | NUMC | 5 | 0 | Item of Reference Purchase Requisition | * | |
119 | GRANT_NBR | GM_GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Grant | ||
120 | FKBER | FKBER | FKBER | CHAR | 16 | 0 | Functional Area | * | |
121 | MEMORY | MEMBF | XFELD | CHAR | 1 | 0 | Purchase Requisition not yet Complete | ||
122 | BANPR | BANPR | BANPR | CHAR | 2 | 0 | Requisition Processing State | ||
123 | RLWRT | RLWRT | WERT15 | CURR | 15 | 2 | Total value at time of release | ||
124 | BLCKD | BLCKD | BLCKD | CHAR | 1 | 0 | Purchase Requisition Blocked | ||
125 | BLCKT | BLCKT | CHAR60K | CHAR | 60 | 0 | Reason for Item Block | ||
126 | REVNO | REVNO | REVNO | CHAR | 8 | 0 | Version number in Purchasing | ||
127 | BESWK | BESWK | WERKS | CHAR | 4 | 0 | Procuring Plant | * | |
128 | EPROFILE | MEPROFILE | EPROFILE | CHAR | 2 | 0 | External Procurement Profile | ||
129 | EPREFDOC | EPREFDOC | EPREFDOC | CHAR | 10 | 0 | External Procurement Reference Document | ||
130 | EPREFITM | EPREFITM | EPREFITM | NUMC | 5 | 0 | External Procurement Reference Item | ||
131 | GMMNG | GMMNG | MENG13 | QUAN | 13 | 3 | PO Quantity of Purchase Requisition in POs on Hold | ||
132 | WRTKZ | WRTKZ | XFELD | CHAR | 1 | 0 | Value-Based Commitment Reduction for Service Purchase Reqs | ||
133 | RESLO | RESLO | LGORT | CHAR | 4 | 0 | Issuing Storage Location for Stock Transport Order | * | |
134 | KBLNR | KBLNR | KBLNR | CHAR | 10 | 0 | Document Number for Earmarked Funds | * | |
135 | KBLPOS | KBLPOS | KBLPOS | NUMC | 3 | 0 | Earmarked Funds: Document Item | * | |
136 | PRIO_URG | PRIO_URG | PRIO_URG | NUMC | 2 | 0 | Requirement Urgency | PURG | |
137 | PRIO_REQ | PRIO_REQ | PRIO_REQ | NUMC | 3 | 0 | Requirement Priority | PREQ | |
138 | ANZSN | ANZSN | INT4 | INT4 | 10 | 0 | Number of serial numbers | ||
139 | SERNP | SERAIL | SERAIL | CHAR | 4 | 0 | Serial Number Profile | * | |
140 | MHDRZ | MHDRZ | DEC4 | DEC | 4 | 0 | Minimum Remaining Shelf Life | ||
141 | IPRKZ | DATTP | DATTP | CHAR | 1 | 0 | Period Indicator for Shelf Life Expiration Date | ||
142 | MEMORYTYPE | MEMORYTYPE | MM_MEMORYTYPE | CHAR | 1 | 0 | Category of Incompleteness | ||
143 | EXT_PROC_STATUS | MEREQ_PROC_STATUS | PROC_STAT | CHAR | 1 | 0 | Processing State | ||
144 | EXT_PROC_DATE | MMPUR_UTC | TIMESTAMP | CHAR | 14 | 0 | Timestamp | ||
145 | PROC_STATUS | MEREQ_PROC_TYPE | PROC_TYPE | CHAR | 1 | 0 | Processing State | ||
146 | PROC_DATE | MMPUR_UTC | TIMESTAMP | CHAR | 14 | 0 | Timestamp | ||
147 | EXT_DOC_NUMBER | ME_PUR_EXT_DOC_ID | ME_EXT_DOC_ID | CHAR | 35 | 0 | Document Number of External Document | ||
148 | EXT_DOC_ITEM | ME_PUR_EXT_DOC_ITEM_ID | ME_EXT_DOC_ITEM_ID | CHAR | 10 | 0 | Item Number of External Document | ||
149 | EXT_DOC_TYPE | ME_PUR_EXT_DOC_TYPE | ME_EXT_DOC_TYPE | CHAR | 4 | 0 | External Document Type | ||
150 | NODISP | NODISP | XFELD | CHAR | 1 | 0 | Ind: Reserv. not applicable to MRP;Purc. req. not created | ||
151 | SRM_CONTRACT_ID | SRM_CONTRACT_ID | BBP_BAPI_EBELN | CHAR | 10 | 0 | Central Contract | ||
152 | SRM_CONTRACT_ITM | SRM_CONTRACT_ITEM | BBP_ITEMNO | NUMC | 10 | 0 | Central Contract Item Number | ||
153 | SC_OBJECT_ID | /SRMERP/OBJECT_ID | /SRMERP/OBJECT_ID | CHAR | 10 | 0 | Object ID - Document Number | ||
154 | SC_ITM_NO | /SRMERP/SC_ITM_NO | INT4 | INT4 | 10 | 0 | Internal Shopping Cart Item Number | ||
155 | .INCLUDE | 0 | 0 | Structure with Persistent and Transient Customer Data | |||||
156 | .INCLUDE | 0 | 0 | ||||||
157 | .INCLUDE | 0 | 0 | ||||||
158 | MEREQITEMDUMMY | XFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
159 | .INCLUDE | 0 | 0 | Erweiterungsfelder zur Bestellanforderung (kein Schlüssel) | |||||
160 | DUMMY1 | XFELD1 | XFELD | CHAR | 1 | 0 | Type of consolidation of investments method | ||
161 | .INCLUDE | 0 | 0 | Material Extention Structure for Brazil Localization fields | |||||
162 | J_1BMATUSE | J_1BMATUSE | J_1BMATUSE | CHAR | 1 | 0 | Usage of the material | ||
163 | J_1BOWNPRO | J_1BOWNPRO | XFELD | CHAR | 1 | 0 | Produced in-house | ||
164 | J_1BMATORG | J_1BMATORG | J_1BMATORG | CHAR | 1 | 0 | Origin of the material | ||
165 | J_1BINDUST | J_1BINDUS3 | J_1BINDUS3 | CHAR | 2 | 0 | Material CFOP category | ||
166 | J_1BNBM | J_1BNBMCO1 | STEUC | CHAR | 16 | 0 | Brazilian NCM Code | * | |
167 | J_1AINDXP | J_1AINDXP | J_1AINDXP | CHAR | 5 | 0 | Inflation Index | * | |
168 | J_1AIDATEP | J_1AIDATEP | J_1AUDATEP | DATS | 8 | 0 | Last day of the time period where the index value is valid | ||
169 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
170 | BUDGET_PD | FM_BUDGET_PERIOD | FM_BUDGET_PERIOD | CHAR | 10 | 0 | FM: Budget Period | * | |
171 | .INCLU--AP | 0 | 0 | DFPS: Additional Fields for Purchase Requisition Items | |||||
172 | .INCLUDE | 0 | 0 | Additional DFPS Fields: Advice and Status Code | |||||
173 | ADVCODE | /ISDFPS/ADVCODE | /ISDFPS/ADVCODE | CHAR | 2 | 0 | Advice Code | /ISDFPS/ADVCODE2 | |
174 | STACODE | /ISDFPS/STACODE | /ISDFPS/STACODE | CHAR | 2 | 0 | Status Code | /ISDFPS/CSTACODE | |
175 | .INCLUDE | 0 | 0 | DFPS: EBAN Enhancement (Cross System), Append Structure | |||||
176 | BANFN_CS | /ISDFPS/BANFN_CS | BANFN | CHAR | 10 | 0 | Cross-System PReq Number | ||
177 | BNFPO_CS | /ISDFPS/BNFPO_CS | BNFPO | NUMC | 5 | 0 | Cross-System PReq Item | * | |
178 | ITEM_CS | /ISDFPS/ITEM_CS | /ISDFPS/ITEM_CS | CHAR | 1 | 0 | Cross-System Item Category | ||
179 | BSMNG_SND | /ISDFPS/BSMNG_SND | MENG13 | QUAN | 13 | 3 | PO Quantity Sender | ||
180 | .INCLU--AP | 0 | 0 | Append IUID | |||||
181 | IUID_RELEVANT | IUID_RELEVANT | UID_RELEVANT | CHAR | 1 | 0 | IUID-Relevant | ||
182 | PLANT_NAME | NAME1 | TEXT30 | CHAR | 30 | 0 | Name | ||
183 | MATKL_NAME | WGBEZ | TEXT20 | CHAR | 20 | 0 | Material Group Description | ||
184 | LGORT_NAME | LGOBE | TEXT16 | CHAR | 16 | 0 | Description of Storage Location | ||
185 | EKGRP_NAME | EKNAM | TEXT18 | CHAR | 18 | 0 | Description of purchasing group | ||
186 | EKORG_NAME | EKOTX | TEXT20 | CHAR | 20 | 0 | Description of purchasing organization | ||
187 | EXTPROCSTAT_NAME | CHAR50 | TEXT50 | CHAR | 50 | 0 | Comment | ||
188 | ATTYP_NAME | DDTEXT | DDTEXT | CHAR | 60 | 0 | Explanatory short text | ||
189 | ERNAM_NAME | CHAR50 | TEXT50 | CHAR | 50 | 0 | Comment | ||
190 | KUNNR_NAME | CHAR50 | TEXT50 | CHAR | 50 | 0 | Comment | ||
191 | ELPEI | LPEIN | PRGBZ | CHAR | 1 | 0 | Category of delivery date | * | |
192 | EEIND | EEIND | CHAR10 | CHAR | 10 | 0 | Delivery Date |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | MMPUR_SPPR_ITEM_STY | ADVCODE | /ISDFPS/ADVCODE2 | ADVCODE | |||
2 | MMPUR_SPPR_ITEM_STY | PRIO_REQ | PREQ | PRIO_REQ | REF | 1 | CN |
3 | MMPUR_SPPR_ITEM_STY | PRIO_URG | PURG | PRIO_URG | REF | 1 | CN |
4 | MMPUR_SPPR_ITEM_STY | STACODE | /ISDFPS/CSTACODE | STACODE |
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in | 605 |