SAP ABAP Table /SAPPSPRO/V_FRE1 (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | /SAPPSPRO/V_FRE1 |
![]() |
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 | ![]() |
/SAPPSPRO/LONGNUM | /SAPPSPRO/LONGNUM | CHAR | 40 | 0 | Smart Number | ||
75 | ![]() |
EXLIN | EXLIN | CHAR | 40 | 0 | Item Number Length | ||
76 | ![]() |
CPUDT | DATUM | DATS | 8 | 0 | Accounting document entry date | ||
77 | ![]() |
CPUTM | UZEIT | TIMS | 6 | 0 | Time of data entry | ||
78 | ![]() |
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_FRE1 | BPRME | ![]() |
![]() |
REF | 1 | N |
2 | /SAPPSPRO/V_FRE1 | BSART | ![]() |
![]() |
REF | 1 | N |
3 | /SAPPSPRO/V_FRE1 | BUKRS | ![]() |
![]() |
REF | 1 | N |
4 | /SAPPSPRO/V_FRE1 | BWTAR | ![]() |
![]() |
REF | 1 | N |
5 | /SAPPSPRO/V_FRE1 | EKGRP | ![]() |
![]() |
REF | 1 | N |
6 | /SAPPSPRO/V_FRE1 | EKORG | ![]() |
![]() |
REF | 1 | N |
7 | /SAPPSPRO/V_FRE1 | KALSM | ![]() |
![]() |
REF | 1 | N |
8 | /SAPPSPRO/V_FRE1 | KNTTP | ![]() |
![]() |
REF | 1 | N |
9 | /SAPPSPRO/V_FRE1 | KO_PPRCTR | ![]() |
![]() |
REF | 1 | CN |
10 | /SAPPSPRO/V_FRE1 | KO_PRCTR | ![]() |
![]() |
REF | 1 | CN |
11 | /SAPPSPRO/V_FRE1 | LIFNR | ![]() |
![]() |
REF | 1 | N |
12 | /SAPPSPRO/V_FRE1 | LIFRE | ![]() |
![]() |
REF | 1 | N |
13 | /SAPPSPRO/V_FRE1 | MANDT | ![]() |
![]() |
KEY | 1 | N |
14 | /SAPPSPRO/V_FRE1 | MATNR | ![]() |
![]() |
REF | 1 | N |
15 | /SAPPSPRO/V_FRE1 | MEINS | ![]() |
![]() |
REF | 1 | N |
16 | /SAPPSPRO/V_FRE1 | PSTYP | ![]() |
![]() |
REF | 1 | N |
17 | /SAPPSPRO/V_FRE1 | SOBKZ | ![]() |
![]() |
REF | 1 | N |
18 | /SAPPSPRO/V_FRE1 | WAERS | ![]() |
![]() |
REF | 1 | N |
19 | /SAPPSPRO/V_FRE1 | WERKS | ![]() |
![]() |
REF | 1 | N |
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in |