Purchase Requisition/Planned Records 
DataSource Transactional Data: 0DF_IS_DFS_32
This DataSource allows you to access the data for the planned records for purchase requisitions from the source system.
Technical Data
Application Component | ISDFPS BW Business Content (IS-DFS-BW) |
|---|---|
Available as of Release | SAP Defense Forces & Public Security 6.00 |
Shipment | NW 2004s BI Content Add-On 2 |
Content Versions | — |
RemoteCube-Capable | No |
Delta-Capable | No |
Extraction from Archives | No |
Verifiable | No |
Data Modeling
Fields in the Extract Structure | Description of the Field in the Extract Structure | Table of Origin | Field in the Table of Origin |
|---|---|---|---|
ADVCODE |
Advice Code |
EBAN |
ADVCODE |
ATTYP |
Material Category |
EBAN |
ATTYP |
BADAT |
Request Date |
EBAN |
BADAT |
BANFN_CS |
Cross-System PReq Number |
EBAN |
BANFN_CS |
BANPR |
PReq Processing Status |
EBAN |
BANPR |
BATCH |
Batch Number |
/ISDFPS/MATSPPLN |
BATCH |
BEDAT |
Purchase Order Date |
EBAN |
BEDAT |
BERID |
MRP area |
EBAN |
BERID |
BMEIN |
Order Unit |
EBAN |
BMEIN |
BNFPO_CS |
Cross-System PReq Item |
EBAN |
BNFPO_CS |
BSART |
Order Type |
/ISDFPS/MATSPPLN |
BSART |
BSMNG |
Ordered Quantity in Purchase Requisition |
EBAN |
BSMNG |
BSMNG_SND |
Sender Purchase Order Quantity |
EBAN |
BSMNG_SND |
BSTYP |
Purchasing Document Category |
EBAN |
BSTYP |
BUMNG |
Shortage Quantity |
EBAN |
BUMNG |
CHANGED_BY |
Name of Person who Changed the Object |
/ISDFPS/MATSPPLN |
CHANGED_BY |
CHANGED_ON |
Date of Last Change |
/ISDFPS/MATSPPLN |
CHANGED_ON |
COMNT |
Planning Comment |
HRP1985 |
COMNT |
CON_ID |
Contingent Key |
HRP1985 |
CON_ID |
CREATED_BY |
Person who Created the Record |
/ISDFPS/MATSPPLN |
CREATED_BY |
CREATED_ON |
Creation Date of Record |
/ISDFPS/MATSPPLN |
CREATED_ON |
DAT01 |
Confirmed Date |
EBAN |
DAT01 |
DAT_SP |
Collection Point Date |
/ISDFPS/MATSPPLN |
DAT_SP |
DELIVERY_DATE |
Delivery Date |
/ISDFPS/MATSPPLN |
DELIVERY_DATE |
DGUID |
Identifier of the Relationships for Distribution |
/ISDFPS/MATSPPLN |
DGUID |
DISPO |
MRP Controller |
EBAN |
DISPO |
EBAKZ |
PReq Is Completed |
EBAN |
EBANKZ |
EBELN |
Purchase Order Number |
EBAN |
EBELN |
EBELP |
Purchase Order Item Number |
EBAN |
EBELP |
EKGRP |
Purch. Group |
EBAN |
EKGRP |
EKORG |
Purchasing organization |
EBAN |
EKORG |
EMATN |
Material Number Corresponding to Manufacturer Part Number |
EBAN |
EMATN |
FBSTA |
Relocation: Subsequent Document Status |
/ISDFPS/MATSPPLN |
FBSTA |
FLAG_COMPLETED |
Completely Processed |
/ISDFPS/MATSPPLN |
FLAG_COMPLETED |
FLAG_DERIVED |
PReq Indicator Is Derived (Forwarding) |
/ISDFPS/MATSPPLN |
FLAG_DERIVED |
FLAG_EV |
Relocation: Initial Supply Indicator |
/ISDFPS_MATSPPLN |
FLAG_EV |
FLAG_FORWARDED |
PReq Indicator Was Forwarded |
/ISDFPS/MATSPPLN |
FLAG_FORWARDED |
FLAG_HISTORY |
Record Is Historical Indicator |
/ISDFPS/MATSPPLN |
FLAG_HISTORY |
FLAG_LOAN |
Loan Indicator |
/ISDFPS/MATSPPLN |
FLAG_LOAN |
FLAG_LOAN_RET |
Loan Return |
/ISDFPS/MATSPPLN |
FLAG_LOAN_RET |
FLAG_MAINTENANCE |
Relevant for Maintenance |
/ISDFPS/MATSPPLN |
FLAG_MAINTENANCE |
FLAG_PROV |
Provisions Indicator |
/ISDFPS/MATSPPLN |
FLAG_PROV |
FLAG_RETURN |
Return Delivery |
/ISDFPS/MATSPPLN |
FLAG_RETURN |
FLAG_SERNR_PREQ |
PReq Serial Numbers Indicator |
/ISDFPS/MATSPPLN |
FLAG_SERNR_PREQ |
FORCEM_CNT |
Internal (Version) Counter |
/ISDFPS/MATSPPLN |
FORCEM_CNT |
FORCEM_ASGN |
Object ID |
/ISDFPS/FORCE |
OBJID |
FORCEM_ASGN_ID |
Internal Key for Force Element |
/ISDFPS/MATSPPLN |
FORCE_ASGN_ID |
FORCE_PROV |
Object ID |
/ISDFPS/FORCE |
OBJID |
FORCE_PROV_ID |
Internal Key for a Force Element |
/ISDFPS/MATSPPLN |
FORCE_PROV_ID |
FORCE_REC |
Object ID |
/ISDFPS/FORCE |
FORCE_REC |
FORCE_REC_ID |
Internal Key for Force Element |
/ISDFPS/MATSPPLN |
FORCE_REC_ID |
FRGDT |
Release Date for a Purchase Requisition |
EBAN |
FRGDT |
GMMNG |
Quantity Ordered Against this Purchase Requisition in Purchase Orders on Hold |
EBAN |
GMMNG |
GRANT_NBR |
Grant |
EBAN |
GRANT_NBR |
GSFRG |
Overall Release of Purchase Requisitions |
EBAN |
GSFRG |
HU_EXID |
External Handling Unit ID |
/ISDFPS/MATSPPLN |
HU_EXID |
HU_LOC_PROV |
HU Storage Location |
/ISDFPS/MATSPPLN |
HU_LOC_PROV |
HU_LOC_REC |
HU Storage Location |
/ISDFPS/MATSPPLN |
HU_LOC_REC |
IDNLF |
Material Number Used by Vendor |
EBAN |
IDNLF |
ITEM_CS |
Cross-System Item Category |
EBAN |
ITEM_CS |
LFART |
Delivery Type |
/ISDFPS/MATSPPLN |
LFART |
LFDAT |
Item Delivery Date |
EBAN |
LFDAT |
LGORT |
Storage Location |
EBAN |
LGORT |
LOCATION_D_GUID |
ISDFPS: Location ID (GUID) |
/ISDFPS/MATSPPLN |
LOCATION_D_GUID |
LOCATION_S_GUID |
ISDFPS: Location ID (GUID) |
/ISDFPS/MATSPPLN |
LOCATION_S_GUID |
LOEKZ |
Deletion Indicator in Purchasing Document |
EBAN |
LOEKZ |
LPEIN |
Category of Delivery Date |
EBAN |
LPEIN |
MATKL |
Material Group |
EBAN |
MATKL |
MATNR |
Material number |
/ISDFPS/MATSPPLN |
MATNR |
MBDAT |
Material Availability Date |
/ISDFPS/MATSPPLN |
MBDAT |
MEINS |
Purchase Requisition Unit of Measure |
/ISDFPS/MATSPPLN |
MEINS |
MEMORY |
Purchase Requisition Not Yet Complete |
EBAN |
MEMORY |
MENGE |
Purchase Requisition Quantity |
EBAN |
MENGE |
MNG02 |
Confirmed Quantity |
EBAN |
MNG02 |
MPO |
Material Number |
/ISDFPS/MATSPPLN |
PNGUID |
OBJID_COM |
Object ID |
HRP1985 |
OBJID_COM |
OPERATION_ID |
Operation/Exercise ID |
HRP1985 |
OPERATION_ID |
PACK_MAT |
Packaging Material |
/ISDFPS/MATSPPLN |
PACK_MAT |
PEINH |
Price Unit |
EBAN |
PEINH |
PLANNING_GUID |
Planning GUID |
/ISDFPS/MATSPPLN |
PLANNING_GUID |
PLANT_PROV |
Plant |
/ISDFPS/MATSPPLN |
PLANT_PROV |
PLANT_REC |
Plant |
/ISDFPS/MATSPPLN |
PLANT_REC |
PLIFZ |
Planned Delivery Time in Days |
EBAN |
PLIFT |
PNGUID |
Internal Identification for PVS Objects |
— |
— |
PREIS |
Purchase Requisition Price |
EBAN |
PREIS |
PREQ_ITEM |
Item Number of Purchase Requisition |
/ISDFPS/MATSPPLN |
PREQ_ITEM |
PREQ_NO |
Purchase Requisition |
/ISDFPS/MATSPPLN |
PREQ_NO |
PRIO_REQ |
Requirement Priority |
EBAN |
PRIO_REQ |
PRIO_URG |
Requirement Urgency |
EBAN |
PRIO_URG |
PROVIDER_MAT |
Object ID |
HRP1985 |
PROVIDER_MAT |
PROVIDER_PER |
Object ID |
HRP1985 |
PROVIDER_PER |
PSPNR |
WBS element |
/ISDFPS/MATSPPLN |
PSPNR |
QUPLN |
Planned Quantity |
/ISDFPS/MATSPPLN |
QUPLN |
RECORD_INVISIBLE |
Single-Character Indicator |
/ISDFPS/MATSPPLN |
RECORD_INVISIBLE |
RECTYPE |
Record Type Planning |
/ISDFPS/MATSPPLN |
RECTYPE |
RELOC_ID |
Relocation ID |
/ISDFPS/MATSPPLN |
RELOC_ID |
RELOC_SEQ_ID |
Relocation Step ID |
/ISDFPS/MATSPPLN |
RELOC_SEQ_ID |
RELSEQ_TYPE |
The type of relocation step. |
/ISDFPS/MATSPPLN |
RELSEQ_TYPE |
RETURN_DATE |
Return Date of Loans |
/ISDFPS/MATSPPLN |
RETURN_DATE |
RIC |
Reportable Item Code |
/ISDFPS/PNMPO |
RIC |
ROUTE |
Route |
/ISDFPS/MATSPPLN |
ROUTE |
SERNR |
BOM Explosion Number |
/ISDFPS/MATSPPLN |
SERNR |
SERNR_PREQ |
Serial Number |
ISDFPS/MATSPPLN |
SERNR_PREQ |
STACODE |
Status Code |
EBAN |
STACODE |
STATU |
Processing Status of Purchase Requisition |
EBAN |
STATU |
STORAGE_LOC_PROV |
Storage Location |
/ISDFPS/MATSPPLN |
STORAGE_LOC_PROV |
STORAGE_LOC_REC |
Storage Location |
/ISDFPS/MATSPPLN |
STORAGE_LOC_REC |
TXZ01 |
Name |
EBAN |
TXZ01 |
UZEIT |
Delivery Date/Time |
EBAN |
UZEIT |
VBELN |
Delivery |
/ISDFPS/MATSPPLN |
VBELN |
VEPOS |
Handling Unit Item |
/ISDFPS/MATSPPLN |
VEPOS |
VRTYP |
Purchasing Document Category |
EBAN |
VRTYP |
VSBED |
Shipping Conditions |
/ISDFPS/MATSPPLN |
VSBED |
WAERS |
Currency Key |
EBAN |
WAERS |
WEBAZ |
Goods Receipt Processing Time in Days |
EBAN |
WEBAZ |
WEPOS |
Goods Receipt Indicator |
EBAN |
WEPOS |
WERKS |
Plant |
EBAN |
WERKS |