ARO_ASSIGNMENTS

Transparent Table Application Table
27 Fields 3 CDS Views

Table for Object Assignments

ARO_ASSIGNMENTS is an SAP database table in S/4HANA. Table for Object Assignments. It contains 27 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
ARO_DDL_latest_Assignment view from ARO latest Assignment
ARO_DDL_OBL_current_data view left_outer Current data of one Obligation
ARO_DDL_SortedListProvPlan view inner ARO SortedListProvision On KeyDate(Plan)

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY obj_uuid aro_obj_uuid Object UUID
KEY validto datbi Valid To
validfrom datab Valid From
source_object aro_object Object
obj_type aro_objtype Object Type
comp_code bukrs Company Code
bus_area gsber Business Area
costcenter kostl Cost Center
resp_costcenter aro_kostlv Resp. Cost Ctr
orderid aufnr Order
wbs_elem ps_psp_pnr WBS Element
acttype lstar Activity Type
plant werks_d Plant
location stort Location
room raumnr Room
func_area fkber Functional Area
segment fb_segment Segment
profit_ctr prctr Profit Center
prof_segm rkeobjnr Profit. segment
rl_est_key imkey Real Estate Key
taxjurcode txjcd Tax Jur.
external_id aro_external_id External ID
createdtmps tzntstmps Time Stamp
createdby crnam Created By
lastchgdtmps tzntstmps Time Stamp
lastchgdby upnam Changed By

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.

-- Table for Object Assignments
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ARO_ASSIGNMENTS (
    CLIENT,           -- Client [mandt]
    OBJ_UUID,         -- Object UUID [aro_obj_uuid]
    VALIDTO,          -- Valid To [datbi]
    VALIDFROM,        -- Valid From [datab]
    SOURCE_OBJECT,    -- Object [aro_object]
    OBJ_TYPE,         -- Object Type [aro_objtype]
    COMP_CODE,        -- Company Code [bukrs]
    BUS_AREA,         -- Business Area [gsber]
    COSTCENTER,       -- Cost Center [kostl]
    RESP_COSTCENTER,  -- Resp. Cost Ctr [aro_kostlv]
    ORDERID,          -- Order [aufnr]
    WBS_ELEM,         -- WBS Element [ps_psp_pnr]
    ACTTYPE,          -- Activity Type [lstar]
    PLANT,            -- Plant [werks_d]
    LOCATION,         -- Location [stort]
    ROOM,             -- Room [raumnr]
    FUNC_AREA,        -- Functional Area [fkber]
    SEGMENT,          -- Segment [fb_segment]
    PROFIT_CTR,       -- Profit Center [prctr]
    PROF_SEGM,        -- Profit. segment [rkeobjnr]
    RL_EST_KEY,       -- Real Estate Key [imkey]
    TAXJURCODE,       -- Tax Jur. [txjcd]
    EXTERNAL_ID,      -- External ID [aro_external_id]
    CREATEDTMPS,      -- Time Stamp [tzntstmps]
    CREATEDBY,        -- Created By [crnam]
    LASTCHGDTMPS,     -- Time Stamp [tzntstmps]
    LASTCHGDBY,       -- Changed By [upnam]
    PRIMARY KEY (CLIENT, OBJ_UUID, VALIDTO)
);

Learn More