Data
Every column of this log, and what is actually in it. Tick values to filter the log to the cases that carry them.
Events
14,671
Cases
1,598
Columns
5
plus Statistics and Variant
Object types
7
31 attributes between them
Columns
This log
Case id
varchar - 1,598 distinct
Activity
varchar - 10 distinct
Activity time
timestamp with time zone
Statistics
statistics
Variant
variant
Case attributes
lifecycle
varchar - 1 distinct
Event attributes
resource
varchar - 6 distinct
goods receipt object
goods receipt
object type - 1,941 objects
Invoice Receipt (MSEG-WEAHR)
attribute
Movement Type (MSEG-BWART)
attribute
new_value
attribute
Posting Date (MKPF-BLDAT)
attribute
invoice receipt object
invoice receipt
object type - 927 objects
new_value
attribute
Credit Amount (BSEG-WRBTR)
attribute
Debit Amount (BSEG-DMBTR)
attribute
Payment Block (RSEG-ZLSPR)
attribute
material object
material
object type - 2,296 objects
Net Price (EKPO-NETPR)
attribute
Quantity (EKPO-MENGE)
attribute
Delivery Date (EKPO-BEDAT)
attribute
Plant (EKPO-WERKS)
attribute
Material (EKPO-MATNR)
attribute
Storage Location (EKPO-LGORT)
attribute
payment object
payment
object type - 927 objects
new_value
attribute
Payment Method (ZLSCH)
attribute
Amount (DMBTR)
attribute
purchase_order object
purchase_order
object type - 1,598 objects
new_value
attribute
Purchasing Group (EKKO-EKGRP)
attribute
Purchasing Organization (EKKO-EKORG)
attribute
Document Type (EKKO-BSART)
attribute
Release Status (EKKO-FRGZU)
attribute
Vendor (EKKO-LIFNR)
attribute
purchase_requisition object
purchase_requisition
object type - 927 objects
new_value
attribute
Purchasing Group (EBAN-EKGRP)
attribute
Release Indicator (EBAN-FRGZU)
attribute
quotation object
quotation
object type - 927 objects
new_value
attribute
Purchasing Group (EBAN-EKGRP)
attribute
RFQ Type (EBAN-BSART)
attribute
Purchasing Organization (EBAN-EKORG)
attribute
Vendor (EBAN-LIFNR)
attribute
Quantity (EKPO-MENGE)
material object
the objects of this type, how they reach events, and what they carry
| Objects | 2,296 | Touched by an event in view | 1,807 |
How this type reaches events
| Qualifier | Relations | Events | Objects |
|---|---|---|---|
| material | 3,614 | 1,458 | 1,807 |
A relation is one link between an event and an object. Where Relations exceeds Events, some event links to more than one material; where it exceeds Objects, some material takes part in more than one event. These counts are of the whole log - a relation is not a case and a filter cannot divide one.
What a
material carries - pick one on the left to see its values
| Attribute | Type | Distinct | Missing | Example |
|---|---|---|---|---|
| Net Price (EKPO-NETPR) | DOUBLE | 25 | - | 100.0 |
| Quantity (EKPO-MENGE) open | DOUBLE | 100 | - | 1.0 |
| Delivery Date (EKPO-BEDAT) | VARCHAR | 2,296 | - | 2023-10-03 09:30:10.235467 |
| Plant (EKPO-WERKS) | VARCHAR | 5 | - | 1000 |
| Material (EKPO-MATNR) | VARCHAR | 50 | - | BIKE_BELL |
| Storage Location (EKPO-LGORT) | VARCHAR | 5 | - | 0001 |
Only the attributes this type actually uses are listed. Objects is one wide table across every type, so the columns belonging to the others are empty here and saying so for each of them would be noise, not a finding.
Quantity (EKPO-MENGE)
- every value, and the log each carries