JEST

Transparent Table Application Table
6 Fields 65 CDS Views

Individual Object Status

JEST is an SAP database table in S/4HANA. Individual Object Status. It contains 6 fields. 65 CDS views read from this table.

CDS Views using this table (65)

ViewTypeJoinVDMDescription
/MERP/PP_PO_STATUS view from Object Status. Converted
Arberp_V_Int_Ord_View view left_outer Fieldglass: Relevant Internal Orders
FINOC_RT_REC_FILL view_entity left_outer OrglChg: Fill RT for Real Estate Contr.
FINOC_RT_SOI_OBJ_STATUS view left_outer Orgl Chg: SDocItms with object status
FINOC_RULE_NWA_BASE view left_outer O/C Rule: Network Activity Base
FINOC_RULE_ORD_BASE view left_outer Orgl Change-Rule: Order Base
FINOC_RULE_ORD_DEFAULT view left_outer Orgl Change-Rule: Order Default Implmt.
FINOC_RULE_PRO_BASE view left_outer Organizational Change: Base Rule Project
finoc_rule_soi_base view left_outer Orgl Change-Rule: Sales Order Item Base
FINOC_RULE_SOX_BASE view left_outer Organizational Changes: Base Rle IC SOI
FINOC_RULE_WBS_BASE view left_outer Orgl Change-Rule: WBS Elements Base
I_ACMApplicationDocumentStatus view_entity from BASIC Application Document Status
I_ACMApplObjSts view_entity from BASIC ACM Application Object Status
I_ACMApplRetObjSts view_entity from BASIC ACM Application Return Object Status
I_ACMObjectStatus view from BASIC System status from JEST
I_ACMObjectStatusCostRevCkpt view_entity from COMPOSITE Interface Entity for Object Status of CRC
I_ACMSettlementStatus view_entity from BASIC Application document settlement status
I_ACMSettlmtObjSts view_entity from BASIC ACM Settlement Object Status
I_ACMStorageStatus view_entity from BASIC Storage statuses for ACM
I_ACMSystemStatus view from BASIC ACM Specific Status
I_ApplicationDocumentItem view inner BASIC ACM Basic View For CA Application Document Item
I_DFS_RelocationProjectStatus view_entity from BASIC Basic for Relocation Project status
I_IsltnCertificateItemStatus view_entity from BASIC Isolation Certificate Item Status
I_ObjectStatus view from BASIC Status Object Status Basic
I_ObjectStatusSettlement view from BASIC ACM:Settlement Object Status
I_ProcessOrderStatus view_entity from BASIC Process Orders Status Management
I_RSHOperationStatusObject view from BASIC Status Object and Codes for PM Operations
I_SafetyCertificateStatus view from BASIC Safety Certificate Status
I_StatusObjectStatusBasic view from BASIC Status Object Status Basic
I_WorkPermitStatus view from BASIC Work Permit Status
ISU_C4C_NTFST_SY_V view inner Notification system status
ISU_C4C_NTFST_V view inner Notification status
P_ACCGO_APPDOC_DTLS view inner BASIC
P_ACCGO_STL_DOC_DETAILS view inner BASIC
P_ACCGO_STOR_DTLS view inner BASIC
P_ACMApplStlActvStatusCode view from BASIC
P_ACMLDCEventStatus view_entity from BASIC LDC Event status details
P_ACMSettlementStatus view_entity from BASIC Application document settlement status
P_ACMStorageStatus view_entity from BASIC Storage statuses for ACM
P_COPCCObjectMaxStatus view from BASIC
P_EBWObjectStatus view from BASIC
P_LDC_W_STATUS view inner BASIC
P_ObjectStatus view left_outer BASIC
P_RSHUserStatusBasic view from BASIC
P_SDControllingObjectStatus1 view inner BASIC
P_SDDocControllingObjectSts1 view inner BASIC
P_StatusInfluenceOnBusTran1 view from BASIC
P_StatusInfluenceOnBusTran1 view union_all BASIC
P_STOR_STL_DETAILS view inner BASIC
PPH_DDL_MDQM_EWM_1 view left_outer
PPH_DDL_QM_IL_EWM_1 view left_outer
PPH_E_MDQM view inner
PPH_E_MDQM view left_outer
vfco_dll_cj8g_l1 view inner
vfco_dll_cj8g_l4 view inner
vfco_dll_cjb1_l1 view inner
vfco_dll_cjb1_l7 view inner
vfco_dll_co88_with_op_l1 view inner
vfco_dll_co88_with_op_l4 view inner
vfco_dll_co88_wo_op_l1 view inner
vfco_dll_co88_wo_op_l4 view inner
vfco_dll_ko8g_l1 view inner
vfco_dll_ko8g_l4 view inner
vfco_dll_va88_l1 view inner
vfco_dll_va88_l4 view inner

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY objnr J_OBJNR Object number
KEY stat J_STATUS Status
inact J_INACT Status Inact.
chgnr J_CHGNR Change number
_dataaging DATA_TEMPERATURE Data Aging

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Individual Object Status
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE JEST (
    MANDT,       -- Client [MANDT]
    OBJNR,       -- Object number [J_OBJNR]
    STAT,        -- Status [J_STATUS]
    INACT,       -- Status Inact. [J_INACT]
    CHGNR,       -- Change number [J_CHGNR]
    _DATAAGING,  -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, OBJNR, STAT)
);

Learn More