UPOT_UDM_ALLOCV

Transparent Table Application Table
26 Fields 1 CDS Views

Version Table for Alloc. Results Header Details

UPOT_UDM_ALLOCV is an SAP database table in S/4HANA. Version Table for Alloc. Results Header Details. It contains 26 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_GHOAllocationRunCount view_entity from COMPOSITE Allocation run Count

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY alloc_run_id GHO_ALLOC_RUN_ID Allocation Run ID
netid GHO_NETOBJ_ID Netw Object ID
medium GHO_PRODUCT Medium ID
alloc_type GHO_ALLOC_TYPE Allocation Type
frequency GHO_ALLOC_FREQUENCY Frequency ID
prod_date GHO_START_DATE_ALLOC Prod. Start Dt
prod_time GHO_START_TIME_ALLOC Prod St Tme
alloc_purpose GHO_ALLOC_PURPOSE Allocation Purpose
final_ind GHO_FINAL_IND Final Ind Alloc Rest
alloc_status GHO_ALLOC_STATUS Alloc Run Status
last_process_ts TIMESTAMP Time Stamp
batch_run_id GUID GUID
log_handle_trace BALLOGHNDL Handle
created_by GHO_CREATED_BY Record Created By
created_tst GHO_DE_CREATED_ON Created On
changed_by GHO_CHANGED_BY Changed By
changed_tst GHO_DE_CHANGED_ON Changed On
ppn_indicator GHO_PPN_INDICATOR Pending PPN
ppn_log_handle BALLOGHNDL Handle
business_status GHO_ALLOC_BUSINESS_STATUS Business Status
status_object_number GHO_DE_OBJECT_NUMBER Object Number
last_action GHO_DE_ACTION Status Mgmt Action
doc_num UPO_UDM_VER_DOC_NUM Document No.
doc_year GJAHR Fiscal Year
conv_grp OIB_UMRSL Conv. Group

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.

-- Version Table for Alloc. Results Header Details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE UPOT_UDM_ALLOCV (
    MANDT,                 -- Client [MANDT]
    ALLOC_RUN_ID,          -- Allocation Run ID [GHO_ALLOC_RUN_ID]
    NETID,                 -- Netw Object ID [GHO_NETOBJ_ID]
    MEDIUM,                -- Medium ID [GHO_PRODUCT]
    ALLOC_TYPE,            -- Allocation Type [GHO_ALLOC_TYPE]
    FREQUENCY,             -- Frequency ID [GHO_ALLOC_FREQUENCY]
    PROD_DATE,             -- Prod. Start Dt [GHO_START_DATE_ALLOC]
    PROD_TIME,             -- Prod St Tme [GHO_START_TIME_ALLOC]
    ALLOC_PURPOSE,         -- Allocation Purpose [GHO_ALLOC_PURPOSE]
    FINAL_IND,             -- Final Ind Alloc Rest [GHO_FINAL_IND]
    ALLOC_STATUS,          -- Alloc Run Status [GHO_ALLOC_STATUS]
    LAST_PROCESS_TS,       -- Time Stamp [TIMESTAMP]
    BATCH_RUN_ID,          -- GUID [GUID]
    LOG_HANDLE_TRACE,      -- Handle [BALLOGHNDL]
    CREATED_BY,            -- Record Created By [GHO_CREATED_BY]
    CREATED_TST,           -- Created On [GHO_DE_CREATED_ON]
    CHANGED_BY,            -- Changed By [GHO_CHANGED_BY]
    CHANGED_TST,           -- Changed On [GHO_DE_CHANGED_ON]
    PPN_INDICATOR,         -- Pending PPN [GHO_PPN_INDICATOR]
    PPN_LOG_HANDLE,        -- Handle [BALLOGHNDL]
    BUSINESS_STATUS,       -- Business Status [GHO_ALLOC_BUSINESS_STATUS]
    STATUS_OBJECT_NUMBER,  -- Object Number [GHO_DE_OBJECT_NUMBER]
    LAST_ACTION,           -- Status Mgmt Action [GHO_DE_ACTION]
    DOC_NUM,               -- Document No. [UPO_UDM_VER_DOC_NUM]
    DOC_YEAR,              -- Fiscal Year [GJAHR]
    CONV_GRP,              -- Conv. Group [OIB_UMRSL]
    PRIMARY KEY (MANDT, ALLOC_RUN_ID)
);

Learn More