ASSIGN

14 Fields

ASSIGN is an SAP database table in S/4HANA. It contains 14 fields.

Fields (14)

KeyField CDS FieldsUsed in Views
KEY grref MatchingAssignmentNumber 1
KEY object_name object_name 2
KEY object_type object_type 2
KEY sub_object_name sub_object_name 2
KEY sub_object_type sub_object_type 2
comment_cnt MatchingAssignmentComment 1
method_id MatchingMethodID 1
poper FiscalPeriod 1
rcode MatchingReasonCode 2
rldnr ConsolidationLedger 1
rule_id MatchingRuleID 1
rvers ConsolidationVersion 1
ryear FiscalYear 1
unassigned MatchingIsUnassigned 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ASSIGN (
    GRREF,
    OBJECT_NAME,
    OBJECT_TYPE,
    SUB_OBJECT_NAME,
    SUB_OBJECT_TYPE,
    COMMENT_CNT,
    METHOD_ID,
    POPER,
    RCODE,
    RLDNR,
    RULE_ID,
    RVERS,
    RYEAR,
    UNASSIGNED,
    PRIMARY KEY (GRREF, OBJECT_NAME, OBJECT_TYPE, SUB_OBJECT_NAME, SUB_OBJECT_TYPE)
);

Learn More