SAP ABAP Table EKBE (History per Purchasing Document)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ SRM-EBP (Application Component) Enterprise Buyer
⤷ BBP_APPLICATION (Package) Structure Package EBP
⤷ ME (Package) Application development R/3 Purchasing
⤷ SRM-EBP (Application Component) Enterprise Buyer
⤷ BBP_APPLICATION (Package) Structure Package EBP
⤷ ME (Package) Application development R/3 Purchasing
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | EKBE | Table Relationship Diagram |
Short Description | History per Purchasing Document |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | EBELN | EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | EKKO | |
3 | EBELP | EBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | EKPO | |
4 | ZEKKN | DZEKKN | NUM02 | NUMC | 2 | 0 | Sequential Number of Account Assignment | ||
5 | VGABE | VGABE | VGABE | CHAR | 1 | 0 | Transaction/event type, purchase order history | ||
6 | GJAHR | MJAHR | GJAHR | NUMC | 4 | 0 | Year of material document | ||
7 | BELNR | MBLNR | BELNR | CHAR | 10 | 0 | Number of Material Document | ||
8 | BUZEI | MBLPO | MBLPO | NUMC | 4 | 0 | Item in material document | ||
9 | .INCLUDE | 0 | 0 | History per Purchasing Document | |||||
10 | BEWTP | BEWTP | BEWTP | CHAR | 1 | 0 | Purchase Order History Category | T163B | |
11 | BWART | BWART | BWART | CHAR | 3 | 0 | Movement type (inventory management) | T156 | |
12 | BUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
13 | MENGE | MENGE_D | MENG13 | QUAN | 13 | 3 | Quantity | ||
14 | BPMNG | MENGE_BPR | MENG13 | QUAN | 13 | 3 | Quantity in purchase order price unit | ||
15 | DMBTR | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
16 | WRBTR | WRBTR | WERT7 | CURR | 13 | 2 | Amount in document currency | ||
17 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
18 | AREWR | AREWR | WERT7 | CURR | 13 | 2 | GR/IR account clearing value in local currency | ||
19 | WESBS | WESBS | MENG13 | QUAN | 13 | 3 | Goods receipt blocked stock in order unit | ||
20 | BPWES | BPWES | MENG13 | QUAN | 13 | 3 | Quantity in GR blocked stock in order price unit | ||
21 | SHKZG | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
22 | BWTAR | BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | T149D | |
23 | ELIKZ | ELIKZ | XFELD | CHAR | 1 | 0 | "Delivery Completed" Indicator | ||
24 | XBLNR | XBLNR1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
25 | LFGJA | LFBJA | GJAHR | NUMC | 4 | 0 | Fiscal Year of a Reference Document | ||
26 | LFBNR | LFBNR | BELNR | CHAR | 10 | 0 | Document number of a reference document | ||
27 | LFPOS | LFPOS | MBLPO | NUMC | 4 | 0 | Item of a reference document | ||
28 | GRUND | MB_GRBEW | MB_GRBEW | NUMC | 4 | 0 | Reason for movement | T157D | |
29 | CPUDT | CPUDT | DATUM | DATS | 8 | 0 | Accounting document entry date | ||
30 | CPUTM | CPUTM | UZEIT | TIMS | 6 | 0 | Time of data entry | ||
31 | REEWR | REEWR | WRTV7 | CURR | 13 | 2 | Invoice Value Entered (in Local Currency) | ||
32 | EVERE | EVERE | EVERE | CHAR | 2 | 0 | Compliance with Shipping Instructions | T027C | |
33 | REFWR | REFWR | WRTV7 | CURR | 13 | 2 | Invoice Value in Foreign Currency | ||
34 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
35 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
36 | XWSBR | XWSBR | XFELD | CHAR | 1 | 0 | Reversal of GR allowed for GR-based IV despite invoice | ||
37 | ETENS | ETENS | NUM04 | NUMC | 4 | 0 | Sequential Number of Vendor Confirmation | ||
38 | KNUMV | KNUMV | KNUMV | CHAR | 10 | 0 | Number of the document condition | ||
39 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
40 | LSMNG | LSMNG | MENG13 | QUAN | 13 | 3 | Quantity in Unit of Measure from Delivery Note | ||
41 | LSMEH | LSMEH | MEINS | UNIT | 3 | 0 | Unit of Measure From Delivery Note | T006 | |
42 | EMATN | EMATNR | MATNR | CHAR | 18 | 0 | Material number | MARA | |
43 | AREWW | AREWW | WERT7 | CURR | 13 | 2 | Clearing value on GR/IR clearing account (transac. currency) | ||
44 | HSWAE | HSWAE | WAERS | CUKY | 5 | 0 | Local currency key | TCURC | |
45 | BAMNG | MENGE_D | MENG13 | QUAN | 13 | 3 | Quantity | ||
46 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
47 | BLDAT | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
48 | XWOFF | XWOFF | XFELD | CHAR | 1 | 0 | Calculation of val. open | ||
49 | XUNPL | XUNPL | XFELD | CHAR | 1 | 0 | Unplanned Account Assignment from Invoice Verification | ||
50 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
51 | SRVPOS | SRVPOS | ASNUM | CHAR | 18 | 0 | Service number | * | |
52 | PACKNO | PACKNO_EKBE | PACKNO | NUMC | 10 | 0 | Package Number of Service | * | |
53 | INTROW | INTROW_EKBE | INTROW | NUMC | 10 | 0 | Line Number of Service | ||
54 | BEKKN | BEKKN | NUM02 | NUMC | 2 | 0 | Number of PO Account Assignment | ||
55 | LEMIN | SRVRET | XFELD | CHAR | 1 | 0 | Returns Indicator | ||
56 | AREWB | AREWB | WERT7 | CURR | 13 | 2 | Clearing Value on GR/IR Account in PO Currency | ||
57 | REWRB | REWRB | WERT7 | CURR | 13 | 2 | Invoice Amount in PO Currency | ||
58 | SAPRL | SAPRL | SAPRL | CHAR | 4 | 0 | SAP Release | ||
59 | MENGE_POP | MENGE_D | MENG13 | QUAN | 13 | 3 | Quantity | ||
60 | BPMNG_POP | MENGE_BPR | MENG13 | QUAN | 13 | 3 | Quantity in purchase order price unit | ||
61 | DMBTR_POP | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
62 | WRBTR_POP | WRBTR | WERT7 | CURR | 13 | 2 | Amount in document currency | ||
63 | WESBB | WESBB | MENG13 | QUAN | 13 | 3 | Valuated Goods Receipt Blocked Stock in Order Unit | ||
64 | BPWEB | BPWEB | MENG13 | QUAN | 13 | 3 | Quantity in Valuated GR Blocked Stock in Order Price Unit | ||
65 | WEORA | WEORA | XFELD | CHAR | 1 | 0 | Acceptance At Origin | ||
66 | AREWR_POP | AREWR | WERT7 | CURR | 13 | 2 | GR/IR account clearing value in local currency | ||
67 | KUDIF | KUDIF | WERT7 | CURR | 13 | 2 | Exchange Rate Difference Amount | ||
68 | RETAMT_FC | RET_AMT_FC | WERT7 | CURR | 13 | 2 | Retention Amount in Document Currency | ||
69 | RETAMT_LC | RET_AMT_LC | WERT7 | CURR | 13 | 2 | Retention Amount in Company Code Currency | ||
70 | RETAMTP_FC | RET_AMT_POST_FC | WERT7 | CURR | 13 | 2 | Posted Retention Amount in Document Currency | ||
71 | RETAMTP_LC | RET_AMT_POST_LC | WERT7 | CURR | 13 | 2 | Posted Security Retention Amount in Company Code Currency | ||
72 | XMACC | XMACC | CHAR1 | CHAR | 1 | 0 | Multiple Account Assignment | ||
73 | WKURS | WKURS | KURSP | DEC | 9 | 5 | Exchange Rate | ||
74 | INV_ITEM_ORIGIN | INV_ITM_ORIGIN | INV_ITM_ORIGIN | CHAR | 1 | 0 | Origin of an Invoice Item | ||
75 | VBELN_ST | VBELN_VL | VBELN | CHAR | 10 | 0 | Delivery | * | |
76 | VBELP_ST | POSNR_VL | POSNR | NUMC | 6 | 0 | Delivery Item | * | |
77 | .INCLUDE | 0 | 0 | Return Delivery/Handling of Quantity Differences | |||||
78 | ET_UPD | ET_UPD1 | ET_UPD1 | CHAR | 1 | 0 | Procedure for Updating the Schedule Line Quantity | ||
79 | .INCLU--AP | 0 | 0 | Subcontracting Management | |||||
80 | J_SC_DIE_COMP_F | /SAPNEA/J_SC_DIE_COMP_F | /SAPNEA/J_SC_DIE_COMP_F | CHAR | 1 | 0 | Depreciation completion flag |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | EKBE | BEWTP | T163B | BEWTP | REF | 1 | N |
2 | EKBE | BWART | T156 | BWART | REF | 1 | N |
3 | EKBE | BWTAR | T149D | BWTAR | REF | 1 | N |
4 | EKBE | EBELN | EKKO | EBELN | KEY | 1 | N |
5 | EKBE | EBELP | EKPO | EBELP | KEY | 1 | N |
6 | EKBE | EMATN | MARA | MATNR | |||
7 | EKBE | EVERE | T027C | EVERE | REF | 1 | N |
8 | EKBE | GRUND | T157D | GRUND | |||
9 | EKBE | HSWAE | TCURC | WAERS | REF | 1 | N |
10 | EKBE | LSMEH | T006 | MSEHI | REF | 1 | N |
11 | EKBE | MANDT | T000 | MANDT | KEY | 1 | N |
12 | EKBE | MATNR | MARA | MATNR | REF | 1 | N |
13 | EKBE | WAERS | TCURC | WAERS | REF | 1 | N |
14 | EKBE | WERKS | T001W | WERKS | REF | 1 | N |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |