FARR_D_FULFILLMT

Transparent Table Application Table
29 Fields 1 CDS Views

Fulfillments

FARR_D_FULFILLMT is an SAP database table in S/4HANA. Fulfillments. It contains 29 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RevnAcctgFulfillment view_entity from BASIC Revenue Accounting Fulfillment

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY guid FARR_FULFILL_GUID Fulfill GUID
company_code BUKRS Company Code
acct_principle ACCOUNTING_PRINCIPLE Accounting Principle
recon_key FARR_RECON_KEY Reconcil. Key
group_guid FARR_FULFILL_GUID Fulfill GUID
event_date FARR_FULFILL_DATE Fulfillment Date
event_time UZEIT Time
pob_id FARR_POB_ID POB
deferral_cat FARR_DEFERRAL_CATEGORY Deferral Cat.
event_type FARR_EVENT_TYPE Event Type
reported_qty FARR_RPT_QUANTITY Reported Quantity
reported_qty_unt FARR_QUANTITY_UNIT Unit of Measure
actual_qty FARR_ACT_QUANTITY Delivered Quantity
actual_qty_unt FARR_QUANTITY_UNIT Unit of Measure
reported_qty_diff FARR_RPT_QUANTITY_DIFF Reported Qty. Diff.
fulfill_status FARR_FULFILL_STATUS Fulfill. Pending
entry_category FARR_FULFILL_ENTRY_CATEGORY Fulfillment Item Cat
amount FARR_AMOUNT Amount
amount_curk WAERS Currency
qty_nominator FARR_QUANTITY_NOMINATOR Quantity Nominator
qty_denominator FARR_QUANTITY_DENOMINATOR Quantity Denominator
is_legacy FARR_IS_LEGACY Legacy Entry
compound_fulfill_group_guid FARR_COMPOUND_FULFILL_GRP_GUID Compound Fulfill Grp
manual_spreading FARR_MANUAL_SPREADING Manual Spreading
duration FARR_DURATION Duration
duration_unit FARR_DURATION_UNIT Duration Unit
created_by ERNAM Created By
created_ts TIMESTAMP Time Stamp

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.

-- Fulfillments
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FARR_D_FULFILLMT (
    CLIENT,                       -- Client [MANDT]
    GUID,                         -- Fulfill GUID [FARR_FULFILL_GUID]
    COMPANY_CODE,                 -- Company Code [BUKRS]
    ACCT_PRINCIPLE,               -- Accounting Principle [ACCOUNTING_PRINCIPLE]
    RECON_KEY,                    -- Reconcil. Key [FARR_RECON_KEY]
    GROUP_GUID,                   -- Fulfill GUID [FARR_FULFILL_GUID]
    EVENT_DATE,                   -- Fulfillment Date [FARR_FULFILL_DATE]
    EVENT_TIME,                   -- Time [UZEIT]
    POB_ID,                       -- POB [FARR_POB_ID]
    DEFERRAL_CAT,                 -- Deferral Cat. [FARR_DEFERRAL_CATEGORY]
    EVENT_TYPE,                   -- Event Type [FARR_EVENT_TYPE]
    REPORTED_QTY,                 -- Reported Quantity [FARR_RPT_QUANTITY]
    REPORTED_QTY_UNT,             -- Unit of Measure [FARR_QUANTITY_UNIT]
    ACTUAL_QTY,                   -- Delivered Quantity [FARR_ACT_QUANTITY]
    ACTUAL_QTY_UNT,               -- Unit of Measure [FARR_QUANTITY_UNIT]
    REPORTED_QTY_DIFF,            -- Reported Qty. Diff. [FARR_RPT_QUANTITY_DIFF]
    FULFILL_STATUS,               -- Fulfill. Pending [FARR_FULFILL_STATUS]
    ENTRY_CATEGORY,               -- Fulfillment Item Cat [FARR_FULFILL_ENTRY_CATEGORY]
    AMOUNT,                       -- Amount [FARR_AMOUNT]
    AMOUNT_CURK,                  -- Currency [WAERS]
    QTY_NOMINATOR,                -- Quantity Nominator [FARR_QUANTITY_NOMINATOR]
    QTY_DENOMINATOR,              -- Quantity Denominator [FARR_QUANTITY_DENOMINATOR]
    IS_LEGACY,                    -- Legacy Entry [FARR_IS_LEGACY]
    COMPOUND_FULFILL_GROUP_GUID,  -- Compound Fulfill Grp [FARR_COMPOUND_FULFILL_GRP_GUID]
    MANUAL_SPREADING,             -- Manual Spreading [FARR_MANUAL_SPREADING]
    DURATION,                     -- Duration [FARR_DURATION]
    DURATION_UNIT,                -- Duration Unit [FARR_DURATION_UNIT]
    CREATED_BY,                   -- Created By [ERNAM]
    CREATED_TS,                   -- Time Stamp [TIMESTAMP]
    PRIMARY KEY (CLIENT, GUID)
);

Learn More