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