AFSPREL

Transparent Table Application Table
24 Fields 1 CDS Views

Relation Between Orders in an Order Split

AFSPREL is an SAP database table in S/4HANA. Relation Between Orders in an Order Split. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MfgOrderSplitChildOrder view from BASIC Child Order of Manufacturing Order Split

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY c_aufnr split_caufnr Child Order
KEY byproduct coos_byproduct By-Product
KEY byproduct_batch coos_byproduct_batch Batch By-Product
splcnt splcnt Child Order Counter
p_aufnr split_paufnr ParentOrder
l_aufnr split_laufnr Leading Order
splq split_qty Split Quantity
qunit vorme Act/op UoM
sdate cats_ersda Created on
stime c_time Created At
suser uname User Name
byprod_mat_doc coos_material_doc_no_byproduct GR Document
byprod_mat_item coos_material_doc_po_byproduct Document Item
byprod_mat_year coos_material_doc_yy_byproduct Document Year
component_batch coos_component_batch Component Batch
wip_batch coos_wipbatch WIP Batch
canceled coos_canceled Split Cancelled
cancel_user coos_cancellation_user User
cancel_date coos_cancellation_date Cancellation Date
cancel_time coos_cancellation_time Time of Cancellation
weblnr weblnr Doc.gds mvt err
split_timestamp timestamp Time Stamp
order_split_uuid coos_order_split_uuid Order Split UUID

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.

-- Relation Between Orders in an Order Split
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AFSPREL (
    MANDT,             -- Client [mandt]
    C_AUFNR,           -- Child Order [split_caufnr]
    BYPRODUCT,         -- By-Product [coos_byproduct]
    BYPRODUCT_BATCH,   -- Batch By-Product [coos_byproduct_batch]
    SPLCNT,            -- Child Order Counter [splcnt]
    P_AUFNR,           -- ParentOrder [split_paufnr]
    L_AUFNR,           -- Leading Order [split_laufnr]
    SPLQ,              -- Split Quantity [split_qty]
    QUNIT,             -- Act/op UoM [vorme]
    SDATE,             -- Created on [cats_ersda]
    STIME,             -- Created At [c_time]
    SUSER,             -- User Name [uname]
    BYPROD_MAT_DOC,    -- GR Document [coos_material_doc_no_byproduct]
    BYPROD_MAT_ITEM,   -- Document Item [coos_material_doc_po_byproduct]
    BYPROD_MAT_YEAR,   -- Document Year [coos_material_doc_yy_byproduct]
    COMPONENT_BATCH,   -- Component Batch [coos_component_batch]
    WIP_BATCH,         -- WIP Batch [coos_wipbatch]
    CANCELED,          -- Split Cancelled [coos_canceled]
    CANCEL_USER,       -- User [coos_cancellation_user]
    CANCEL_DATE,       -- Cancellation Date [coos_cancellation_date]
    CANCEL_TIME,       -- Time of Cancellation [coos_cancellation_time]
    WEBLNR,            -- Doc.gds mvt err [weblnr]
    SPLIT_TIMESTAMP,   -- Time Stamp [timestamp]
    ORDER_SPLIT_UUID,  -- Order Split UUID [coos_order_split_uuid]
    PRIMARY KEY (MANDT, C_AUFNR, BYPRODUCT, BYPRODUCT_BATCH)
);

Learn More