SAP PPRSSPITEMEXT Table in S/4 HANA - Generated Table for View
PPRSSPITEMEXT is a standard SAP Table which is used to store Generated Table for View data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP PPRSSPITEMEXT table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Not classified
Dictionary Type: Table view
Database Table: PPRSSPITEMEXT
PPRSSPITEMEXT table structure field list
Below is the full PPRSSPITEMEXT field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
MANDT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
PURCHASEREQUISITION | Purchase requisition number | VDM_PURCHASEREQUISITION | CHAR | 10(0) | ALPHA | BANFN | BAN | MBAN_C | BANFN | |
PURCHASEREQUISITIONITEM | Item number of purchase requisition | VDM_PURCHASEREQUISITIONITEM | NUMC | 5(0) | BNFPO | BAP | ||||
PURCHASINGDOCUMENT | Purchase order number | BSTNR | CHAR | 10(0) | EKKO | ALPHA | EBELN | BES | ||
PURCHASINGDOCUMENTITEM | Purchase order item number | BSTPO | NUMC | 5(0) | EKPO | EBELP | ||||
PURREQNRELEASESTATUS | Requisition Processing State | BANPR | CHAR | 2(0) | BANPR | |||||
PURCHASEREQUISITIONTYPE | Purchase Requisition Document Type | BBSRT | CHAR | 4(0) | T161 | BSART | BBA | |||
PURCHASINGDOCUMENTITEMCATEGORY | Item category in purchasing document | PSTYP | CHAR | 1(0) | T163 | PSTYP | ||||
PURCHASEREQUISITIONITEMTEXT | Short Text | TXZ01 | CHAR | 40(0) | TEXT40 | |||||
ACCOUNTASSIGNMENTCATEGORY | Account Assignment Category | KNTTP | CHAR | 1(0) | T163K | KNTTP | KNT | |||
MATERIAL | Material Number | MATNR | CHAR | 40(0) | MARA | MATN1 | MATNR | MAT | S_MAT1 | MATNR |
MATERIALGROUP | Material Group | MATKL | CHAR | 9(0) | T023 | MATKL | MKL | S_WBWG | MATKL | |
PURCHASINGDOCUMENTCATEGORY | Purchasing Document Category | BSTYP | CHAR | 1(0) | BSTYP | |||||
REQUESTEDQUANTITY | Purchase requisition quantity | BAMNG | QUAN | 13(3) | MENG13 | |||||
BASEUNIT | Purchase requisition unit of measure | BAMEI | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
PURCHASEREQUISITIONPRICE | Price in Purchase Requisition | BAPRE | CURR | 11(2) | WERT11 | |||||
PURREQNPRICEQUANTITY | Price unit | EPEIN | DEC | 5(0) | DEC5 | |||||
MATERIALGOODSRECEIPTDURATION | Goods receipt processing time in days | WEBAZ | DEC | 3(0) | DEC3 | |||||
RELEASECODE | Release Indicator | FRGKZ | CHAR | 1(0) | T161S | FRGKZ | ||||
PURCHASEREQUISITIONRELEASEDATE | Purchase Requisition Release Date | FRGDT | DATS | 8(0) | DATUM | |||||
PURCHASINGORGANIZATION | Purchasing organization | EKORG | CHAR | 4(0) | T024E | EKORG | EKO | |||
PURCHASINGGROUP | Purchasing Group | EKGRP | CHAR | 3(0) | T024 | EKGRP | EKG | |||
PLANT | Plant | EWERK | CHAR | 4(0) | T001W | WERKS | WRK | |||
SOURCEOFSUPPLYISASSIGNED | Assigned Source of Supply | DZUGBA | CHAR | 1(0) | XFELD | |||||
SUPPLYINGPLANT | Supplying (issuing) plant in case of stock transport order | RESWK | CHAR | 4(0) | WERKS | |||||
ORDEREDQUANTITY | Quantity ordered against this purchase requisition | BSMNG | QUAN | 13(3) | MENG13 | |||||
DELIVERYDATE | Item delivery date | EINDT | DATS | 8(0) | DATUM | |||||
CREATIONDATE | Requisition (request) date | BADAT | DATS | 8(0) | DATUM | |||||
PROCESSINGSTATUS | Processing status of purchase requisition | BANST | CHAR | 1(0) | BANST | |||||
PURCHASINGINFORECORD | Number of purchasing info record | INFNR | CHAR | 10(0) | EINA | ALPHA | INFNR | INF | MEIN_C | INFNR |
SUPPLIER | Desired Vendor | WLIEF | CHAR | 10(0) | LFA1 | ALPHA | LIFNR | |||
ISDELETED | Deletion indicator in purchasing document | ELOEK | CHAR | 1(0) | ELOEK | |||||
FIXEDSUPPLIER | Fixed vendor | FLIEF | CHAR | 10(0) | LFA1 | ALPHA | LIFNR | |||
REQUISITIONERNAME | Name of requisitioner/requester | AFNAM | CHAR | 12(0) | AFNAM | |||||
CREATEDBYUSER | Name of Person who Created the Object | ERNAM | CHAR | 12(0) | USNAM | |||||
PURREQCREATIONDATE | Requisition (request) date | BADAT | DATS | 8(0) | DATUM | |||||
MANUALDELIVERYADDRESSID | Address | ADRNR | CHAR | 10(0) | ALPHA | ADRNR | ||||
PURREQNITEMCURRENCY | Currency Key | WAERS | CUKY | 5(0) | TCURC | WAERS | FWS | |||
MATERIALPLANNEDDELIVERYDURN | Planned Delivery Time in Days | PLIFZ | DEC | 3(0) | DEC3 | |||||
DELIVDATECATEGORY | Category of delivery date | LPEIN | CHAR | 1(0) | TPRG | PRGBZ | ||||
MULTIPLEACCTASSGMTDISTRIBUTION | Distribution Indicator for Multiple Account Assignment | VRTKZ | CHAR | 1(0) | VRTKZ | |||||
STORAGELOCATION | Storage location | LGORT_D | CHAR | 4(0) | T001L | LGORT | LAG | |||
PURREQNSSPREQUESTOR | Requestor | MMPUR_REQ_D_REQUESTOR | CHAR | 60(0) | ||||||
PURREQNSSPAUTHOR | Author of Requisition | MMPUR_REQ_D_AUTHOR | CHAR | 12(0) | UNAME | |||||
PURCHASECONTRACT | Number of principal purchase agreement | KONNR | CHAR | 10(0) | EKKO | ALPHA | EBELN | KTR | ||
PURREQNSOURCEOFSUPPLYTYPE | Purchasing Document Category | BSTYP | CHAR | 1(0) | BSTYP | |||||
PURCHASECONTRACTITEM | Item number of principal purchase agreement | KTPNR | NUMC | 5(0) | EKPO | EBELP | ||||
CONSUMPTIONPOSTING | Consumption posting | KZVBR | CHAR | 1(0) | KZVBR | |||||
PURREQNORIGIN | Creation indicator (purchase requisition/schedule lines) | ESTKZ | CHAR | 1(0) | ESTKZ | |||||
PURREQNSSPCATALOG | Technical Key of a Web Service (for Example - a Catalog) | BBP_WS_SERVICE_ID | CHAR | 20(0) | BBP_WS_SERVICE_ID | |||||
PURREQNSSPCATALOGITEM | Catalog Item Id | MMPUR_REQ_D_CATALOGITEM | CHAR | 40(0) | ||||||
PURREQNSSPCROSSCATALOGITEM | Catalog Item Key | MMPUR_CAT_D_ITM_KEY | INT4 | 10(0) | ||||||
ISPURREQNBLOCKED | Purchase Requisition Blocked | BLCKD | CHAR | 1(0) | BLCKD | |||||
ITEMDELIVERYADDRESSID | Number of delivery address | ADRN2 | CHAR | 10(0) | ADRC | ALPHA | AD_ADDRNUM | |||
LANGUAGE | Language Key | SPRAS | LANG | 1(0) | T002 | ISOLA | SPRAS | SPR | H_T002 | SPRAS |
ISCLOSED | Purchase requisition closed | EBAKZ | CHAR | 1(0) | XFELD | |||||
RELEASEISNOTCOMPLETED | Release Not Yet Completely Effected | FRGRL | CHAR | 1(0) | XFELD | |||||
SERVICEPERFORMER | Service Performer | SERVICEPERFORMER | CHAR | 10(0) | ALPHA | BU_PARTNER | ||||
PRODUCTTYPE | Product Type Group | PRODUCT_TYPE | CHAR | 2(0) | CHAR2 | |||||
PURCHASEREQUISITIONSTATUS | Release State | FRGZU | CHAR | 8(0) | FRGZU | |||||
RELEASESTRATEGY | Release strategy in the purchase requisition | FRGST | CHAR | 2(0) | FRGST | |||||
PERFORMANCEPERIODSTARTDATE | Start Date for Period of Performance | MMPUR_SERVPROC_PERIOD_START | DATS | 8(0) | DATS | |||||
PERFORMANCEPERIODENDDATE | End Date for Period of Performance | MMPUR_SERVPROC_PERIOD_END | DATS | 8(0) | DATS | |||||
COMPANYCODE | Company Code | BUKRS | CHAR | 4(0) | T001 | BUKRS | BUK | C_T001 | BUKRS | |
SUPPLIERMATERIALNUMBER | Material Number Used by Supplier | IDNLF | CHAR | 35(0) | IDNEX | |||||
BATCH | Batch Number | CHARG_D | CHAR | 10(0) | CHARG | CHA | ||||
MATERIALREVISIONLEVEL | Revision level | REVLV | CHAR | 2(0) | NUMCV | REVLV | RVS | |||
MINREMAININGSHELFLIFE | Minimum Remaining Shelf Life | MHDRZ | DEC | 4(0) | DEC4 | |||||
ITEMNETAMOUNT | Total value at time of release | RLWRT | CURR | 15(2) | WERT15 | |||||
GOODSRECEIPTISEXPECTED | Goods Receipt Indicator | WEPOS | CHAR | 1(0) | XFELD | |||||
INVOICEISEXPECTED | Invoice receipt indicator | REPOS | CHAR | 1(0) | XFELD | |||||
GOODSRECEIPTISNONVALUATED | Goods Receipt, Non-Valuated | WEUNB | CHAR | 1(0) | XFELD | |||||
REQUIREMENTTRACKING | Requirement Tracking Number | BEDNR | CHAR | 10(0) | CHAR10 | |||||
MRPCONTROLLER | MRP Controller | DISPO | CHAR | 3(0) | T024D | DISPO | DGR | HS_T024D | DISPO | |
PURCHASEREQUISITIONISFIXED | Purchase requisition is fixed | BAFIX | CHAR | 1(0) | XFELD | |||||
ISPURREQNCMPLT | Purchase Requisition not yet Complete | MEMBF | CHAR | 1(0) | XFELD | |||||
PURREQNCMPLTNSCAT | Category of Incompleteness | MEMORYTYPE | CHAR | 1(0) | MM_MEMORYTYPE | |||||
RESERVATION | Number of reservation/dependent requirements | RSNUM | NUMC | 10(0) | RSNUM | RES | ||||
EXTMATERIALFORPURG | Material of External System | MM_PUR_HUB_MATNR | CHAR | 40(0) | MATN1 | MATNR | ||||
EXTFIXEDSUPPLIERFORPURG | Fixed Supplier of External System | MM_PUR_HUB_FLIEF | CHAR | 10(0) | ALPHA | LIFNR | ||||
EXTDESIREDSUPPLIERFORPURG | Desired Supplier of External System | MM_PUR_HUB_WLIEF | CHAR | 10(0) | ALPHA | LIFNR | ||||
EXTCONTRACTFORPURG | Contract of External System | MM_PUR_HUB_KONNR | CHAR | 10(0) | ALPHA | EBELN | ||||
EXTCONTRACTITEMFORPURG | Contract Item of External System | MM_PUR_HUB_KTPNR | NUMC | 5(0) | EBELP | |||||
EXTINFORECORDFORPURG | Info Record of External System | MM_PUR_HUB_INFNR | CHAR | 10(0) | ALPHA | INFNR | ||||
EXTPLANTFORPURG | Plant of External System | MM_PUR_HUB_WERKS | CHAR | 4(0) | WERKS | |||||
EXTCOMPANYCODEFORPURG | Company Code of External System | MM_PUR_HUB_BUKRS | CHAR | 4(0) | BUKRS | |||||
EXTPURGORGFORPURG | Purchasing Organization | MM_PUR_HUB_EKORG | CHAR | 4(0) | EKORG | |||||
EXTSOURCESYSTEM | Communication System ID | MMPUR_D_COMM_SYS | CHAR | 60(0) | ||||||
EXTERNALAPPROVALSTATUS | External Processing Status | MMPUR_REQ_EXTAPPRVLSTS | CHAR | 1(0) | MMPUR_REQ_EXTAPPRVLSTS | |||||
EXTPURCHASEREQUISITIONTYPE | PR Document Type of Connected System | MM_PUR_HUB_REQ_DOC_TYPE | CHAR | 4(0) | BSART | |||||
PROCUREMENTHUBSOURCESYSTEM | Connected System ID | MMPUR_D_SOURCE_SYS | CHAR | 10(0) | MMPUR_REQ_SH_BE_SYS | BE_SOURCE_SYS | ||||
BUSINESSUSER | User ID | VDM_USERID | CHAR | 12(0) | USR02 | XUBNAME | ||||
ISACTIVEENTITY | Draft - Indicator - Is active document | SDRAFT_IS_ACTIVE | CHAR | 1(0) | BOOLE | |||||
PURREQNISVALDINCNTRLREQNPROCG | Is PR relevant for Central PR Processing | MMPUR_PR_CEN_PURREQN_PROC_MODE | CHAR | 1(0) | BOOLEAN | |||||
COMMITMENTITEM | Commitment Item | FIPOS | CHAR | 14(0) | FMCIS | FIPOS | FIP | |||
FUNDSCENTER | Funds Center | FISTL | CHAR | 16(0) | FISTL | FIS | ||||
FUND | Fund | BP_GEBER | CHAR | 10(0) | BP_GEBER | FIC | ||||
GRANTID | Grant | GM_GRANT_NBR | CHAR | 20(0) | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | GRANT_NUMBER | |
FUNCTIONALAREA | Functional Area | FKBER | CHAR | 16(0) | FKBER | FBE | ||||
EARMARKEDFUNDSDOCUMENT | Document Number for Earmarked Funds | KBLNR | CHAR | 10(0) | ALPHA | KBLNR | KBL | |||
EARMARKEDFUNDSDOCUMENTITEM | Earmarked Funds: Document Item | KBLPOS | NUMC | 3(0) | KBLPOS | KBP | ||||
BUDGETPERIOD | Budget Period | FM_BUDGET_PERIOD | CHAR | 10(0) | FM_BUDGET_PERIOD | BUDPER | ||||
COSTCENTER | Cost Center | KOSTL | CHAR | 10(0) | ALPHA | KOSTL | KOS | |||
GLACCOUNT | G/L Account Number | SAKNR | CHAR | 10(0) | ALPHA | SAKNR | SAK | C_SAKNR | SAKNR |
Search for further information about these or an SAP related objects