SAP ABAP Table /SAPPSPRO/V_FRE2 (Generated Table for View)
Basic Data
| Table Category | VIEW | General view structure |
| General view structure | /SAPPSPRO/V_FRE2 |
|
| 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 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | |
EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | ||
| 3 | |
EBSTYP | EBSTYP | CHAR | 1 | 0 | Purchasing Document Category | ||
| 4 | |
ESART | BSART | CHAR | 4 | 0 | Purchasing Document Type | T161 | |
| 5 | |
ELOEK | ELOEK | CHAR | 1 | 0 | Deletion indicator in purchasing document | ||
| 6 | |
ELIFN | LIFNR | CHAR | 10 | 0 | Vendor's account number | LFA1 | |
| 7 | |
EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | T024E | |
| 8 | |
BKGRP | EKGRP | CHAR | 3 | 0 | Purchasing Group | T024 | |
| 9 | |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
| 10 | |
EBDAT | DATUM | DATS | 8 | 0 | Purchasing Document Date | ||
| 11 | |
EVERK | TEXT30 | CHAR | 30 | 0 | Responsible Salesperson at Vendor's Office | ||
| 12 | |
TELF0 | TEXT16 | CHAR | 16 | 0 | Vendor's Telephone Number | ||
| 13 | |
KNUMV | KNUMV | CHAR | 10 | 0 | Number of the document condition | ||
| 14 | |
KALSM_D | KALSM | CHAR | 6 | 0 | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | T683 | |
| 15 | |
LIFRE | LIFNR | CHAR | 10 | 0 | Different Invoicing Party | LFA1 | |
| 16 | |
FRGRL | XFELD | CHAR | 1 | 0 | Release Not Yet Completely Effected | ||
| 17 | |
MEMER | XFELD | CHAR | 1 | 0 | Purchase order not yet complete | ||
| 18 | |
EBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | ||
| 19 | |
ELOEK | ELOEK | CHAR | 1 | 0 | Deletion indicator in purchasing document | ||
| 20 | |
TXZ01 | TEXT40 | CHAR | 40 | 0 | Short Text | ||
| 21 | |
BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
| 22 | |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
| 23 | |
BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | T149D | |
| 24 | |
EWERK | WERKS | CHAR | 4 | 0 | Plant | T001W | |
| 25 | |
SOBKZ | SOBKZ | CHAR | 1 | 0 | Special Stock Indicator | T148 | |
| 26 | |
KZBWS | KZBWS | CHAR | 1 | 0 | Valuation of Special Stock | ||
| 27 | |
EPEIN | DEC5 | DEC | 5 | 0 | Price unit | ||
| 28 | |
BSTME | MEINS | UNIT | 3 | 0 | Order unit | T006 | |
| 29 | |
BBPRM | MEINS | UNIT | 3 | 0 | Order Price Unit (purchasing) | T006 | |
| 30 | |
BPUMZ | UMBSZ | DEC | 5 | 0 | Numerator for Conversion of Order Price Unit into Order Unit | ||
| 31 | |
BPUMN | UMBSN | DEC | 5 | 0 | Denominator for Conv. of Order Price Unit into Order Unit | ||
| 32 | |
UMBSZ | UMBSZ | DEC | 5 | 0 | Numerator for Conversion of Order Unit to Base Unit | ||
| 33 | |
UMBSN | UMBSN | DEC | 5 | 0 | Denominator for Conversion of Order Unit to Base Unit | ||
| 34 | |
PSTYP | PSTYP | CHAR | 1 | 0 | Item category in purchasing document | T163 | |
| 35 | |
KNTTP | KNTTP | CHAR | 1 | 0 | Account assignment category | T163K | |
| 36 | |
VRTKZ | VRTKZ | CHAR | 1 | 0 | Distribution indicator for multiple account assignment | ||
| 37 | |
WEPOS | XFELD | CHAR | 1 | 0 | Goods Receipt Indicator | ||
| 38 | |
WEUNB | XFELD | CHAR | 1 | 0 | Goods Receipt, Non-Valuated | ||
| 39 | |
REPOS | XFELD | CHAR | 1 | 0 | Invoice receipt indicator | ||
| 40 | |
WEBRE | XFELD | CHAR | 1 | 0 | Indicator: GR-Based Invoice Verification | ||
| 41 | |
LEBRE | XFELD | CHAR | 1 | 0 | Indicator for Service-Based Invoice Verification | ||
| 42 | |
BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | ||
| 43 | |
FISTL | FISTL | CHAR | 16 | 0 | Funds Center | ||
| 44 | |
FIPOS | FIPOS | CHAR | 14 | 0 | Commitment Item | ||
| 45 | |
FKBER | FKBER | CHAR | 16 | 0 | Functional Area | ||
| 46 | |
GM_GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Grant | ||
| 47 | |
GSBER_GP | GSBER | CHAR | 4 | 0 | Business area reported to the partner | ||
| 48 | |
PARGB_GP | GSBER | CHAR | 4 | 0 | assumed business area of the business partner | ||
| 49 | |
PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | CEPC | |
| 50 | |
PPRCTR | PRCTR | CHAR | 10 | 0 | Partner Profit Center | CEPC | |
| 51 | |
MEPRF | MEPRF | CHAR | 1 | 0 | Price Determination (Pricing) Date Control | ||
| 52 | |
XERSY | XFELD | CHAR | 1 | 0 | Evaluated Receipt Settlement (ERS) | ||
| 53 | |
RETPO | XFELD | CHAR | 1 | 0 | Returns Item | ||
| 54 | |
STUNR | STUNR | NUMC | 3 | 0 | Level Number | ||
| 55 | |
DZAEHK | ZAEHK | NUMC | 2 | 0 | Condition counter | ||
| 56 | |
VGABE | VGABE | CHAR | 1 | 0 | Transaction/event type, purchase order history | ||
| 57 | |
GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
| 58 | |
BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
| 59 | |
MBLPO | MBLPO | NUMC | 4 | 0 | Item in material document | ||
| 60 | |
BEWTP | BEWTP | CHAR | 1 | 0 | Purchase Order History Category | ||
| 61 | |
BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
| 62 | |
MENGE_D | MENG13 | QUAN | 13 | 3 | Quantity | ||
| 63 | |
DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
| 64 | |
AREWR | WERT7 | CURR | 13 | 2 | GR/IR account clearing value in local currency | ||
| 65 | |
SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
| 66 | |
LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | ||
| 67 | |
KSCHL | KSCHL | CHAR | 4 | 0 | Condition Type | ||
| 68 | |
BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | ||
| 69 | |
BPMNG | MENG13 | QUAN | 13 | 3 | Quantity in order price quantity unit | ||
| 70 | |
WRBTR | WERT7 | CURR | 13 | 2 | Amount in document currency | ||
| 71 | |
AREWB | WERT7 | CURR | 13 | 2 | Clearing Value on GR/IR Account in PO Currency | ||
| 72 | |
REWRB | WERT7 | CURR | 13 | 2 | Invoice Amount in PO Currency | ||
| 73 | |
SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
| 74 | |
EXLIN | EXLIN | CHAR | 40 | 0 | Item Number Length | ||
| 75 | |
CPUDT | DATUM | DATS | 8 | 0 | Accounting document entry date | ||
| 76 | |
CPUTM | UZEIT | TIMS | 6 | 0 | Time of data entry | ||
| 77 | |
DIFF_INVOICE | DIFF_INVOICE | CHAR | 2 | 0 | Differential Invoicing |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | /SAPPSPRO/V_FRE2 | BPRME | |
|
REF | 1 | N |
| 2 | /SAPPSPRO/V_FRE2 | BSART | |
|
REF | 1 | N |
| 3 | /SAPPSPRO/V_FRE2 | BUKRS | |
|
REF | 1 | N |
| 4 | /SAPPSPRO/V_FRE2 | BWTAR | |
|
REF | 1 | N |
| 5 | /SAPPSPRO/V_FRE2 | EKGRP | |
|
REF | 1 | N |
| 6 | /SAPPSPRO/V_FRE2 | EKORG | |
|
REF | 1 | N |
| 7 | /SAPPSPRO/V_FRE2 | KALSM | |
|
REF | 1 | N |
| 8 | /SAPPSPRO/V_FRE2 | KNTTP | |
|
REF | 1 | N |
| 9 | /SAPPSPRO/V_FRE2 | KO_PPRCTR | |
|
REF | 1 | CN |
| 10 | /SAPPSPRO/V_FRE2 | KO_PRCTR | |
|
REF | 1 | CN |
| 11 | /SAPPSPRO/V_FRE2 | LIFNR | |
|
REF | 1 | N |
| 12 | /SAPPSPRO/V_FRE2 | LIFRE | |
|
REF | 1 | N |
| 13 | /SAPPSPRO/V_FRE2 | MANDT | |
|
KEY | 1 | N |
| 14 | /SAPPSPRO/V_FRE2 | MATNR | |
|
REF | 1 | N |
| 15 | /SAPPSPRO/V_FRE2 | MEINS | |
|
REF | 1 | N |
| 16 | /SAPPSPRO/V_FRE2 | PSTYP | |
|
REF | 1 | N |
| 17 | /SAPPSPRO/V_FRE2 | SOBKZ | |
|
REF | 1 | N |
| 18 | /SAPPSPRO/V_FRE2 | WAERS | |
|
REF | 1 | N |
| 19 | /SAPPSPRO/V_FRE2 | WERKS | |
|
REF | 1 | N |
History
| Last changed by/on | SAP | 20140121 |
| SAP Release Created in |