FDM_INVOICE_MEM

Transparent Table Application Table
25 Fields 1 CDS Views

Invoice Information Provided

FDM_INVOICE_MEM is an SAP database table in S/4HANA. Invoice Information Provided. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CollectionsInvoiceMemory view from BASIC Invoice Memory

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY comp_code BUKRS Company Code
KEY invoice_no BELNR_D Document Number
KEY fiscal_year GJAHR Fiscal Year
KEY doc_item BUZEI Item
customer KUNNR Customer
billing_doc VBELN_VF Billing Doc.
posting_date BUDAT Posting Date
inv_date BLDAT Document Date
due_date FAEDT_FPOS Net Due Date
inv_due_date FAEDT_FPOS Net Due Date
discount_date SK1DT Cash Discount 1
payment_date FDM_LAST_PAYMENT_DATE Last Payment
dunning_date FDM_LAST_DUNNING_DATE Last Dun. Not.
currency WAERS Currency
invoice_amount FDM_INVOICE_AMOUNT Amount
paid_amount BDM_PAID_AMOUNT Paid
open_amount FDM_OPEN_AMOUNT Open
credited_amount FDM_CREDIT_AMOUNT Credited
dunning_amount FDM_DUNNING_AMOUNT Dunned
payment_arranged FDM_PAYMENT_ARRANGED Arranged
discount_amount WSKTO_CS CD Amount
coll_debitor KUNNR Customer
timestamp TIMESTAMPL Time Stamp
object_key SWO_TYPEID Key

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.

-- Invoice Information Provided
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FDM_INVOICE_MEM (
    MANDT,             -- Client [MANDT]
    COMP_CODE,         -- Company Code [BUKRS]
    INVOICE_NO,        -- Document Number [BELNR_D]
    FISCAL_YEAR,       -- Fiscal Year [GJAHR]
    DOC_ITEM,          -- Item [BUZEI]
    CUSTOMER,          -- Customer [KUNNR]
    BILLING_DOC,       -- Billing Doc. [VBELN_VF]
    POSTING_DATE,      -- Posting Date [BUDAT]
    INV_DATE,          -- Document Date [BLDAT]
    DUE_DATE,          -- Net Due Date [FAEDT_FPOS]
    INV_DUE_DATE,      -- Net Due Date [FAEDT_FPOS]
    DISCOUNT_DATE,     -- Cash Discount 1 [SK1DT]
    PAYMENT_DATE,      -- Last Payment [FDM_LAST_PAYMENT_DATE]
    DUNNING_DATE,      -- Last Dun. Not. [FDM_LAST_DUNNING_DATE]
    CURRENCY,          -- Currency [WAERS]
    INVOICE_AMOUNT,    -- Amount [FDM_INVOICE_AMOUNT]
    PAID_AMOUNT,       -- Paid [BDM_PAID_AMOUNT]
    OPEN_AMOUNT,       -- Open [FDM_OPEN_AMOUNT]
    CREDITED_AMOUNT,   -- Credited [FDM_CREDIT_AMOUNT]
    DUNNING_AMOUNT,    -- Dunned [FDM_DUNNING_AMOUNT]
    PAYMENT_ARRANGED,  -- Arranged [FDM_PAYMENT_ARRANGED]
    DISCOUNT_AMOUNT,   -- CD Amount [WSKTO_CS]
    COLL_DEBITOR,      -- Customer [KUNNR]
    TIMESTAMP,         -- Time Stamp [TIMESTAMPL]
    OBJECT_KEY,        -- Key [SWO_TYPEID]
    PRIMARY KEY (MANDT, COMP_CODE, INVOICE_NO, FISCAL_YEAR, DOC_ITEM)
);

Learn More