FRPAC_PRPSL_ITM

Transparent Table Application Table
16 Fields 1 CDS Views

AP/AR Clearing Proposal Item

FRPAC_PRPSL_ITM is an SAP database table in S/4HANA. AP/AR Clearing Proposal Item. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FinAPARClearingProposalItm view_entity from BASIC APAR Clearing Proposal Item

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
doc_type blart Document Type
doc_date bldat Document Date
posting_date budat Posting Date
customer kunnr Customer
supplier lifnr Supplier
account_type fis_koart Fin. Account Type
item_text sgtxt Text
assignment_ref dzuonr Assignment
transaction_currency fis_rwcur Transaction Currency
amount_tc fis_wsl Amount in Transaction Currency
inv_ref rebzg Invoice Ref.
inv_ref_fiscal_year fis_rebzj_no_conv Invoice Reference Fiscal Year
inv_item_ref fis_rebzz Invoice Item Reference
follow_on_doc_type rebzt Follow-On Doc. Type
special_gl_ind fis_umskz Special G/L Ind

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.

-- AP/AR Clearing Proposal Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FRPAC_PRPSL_ITM (
    MANDT,                 -- Client [mandt]
    DOC_TYPE,              -- Document Type [blart]
    DOC_DATE,              -- Document Date [bldat]
    POSTING_DATE,          -- Posting Date [budat]
    CUSTOMER,              -- Customer [kunnr]
    SUPPLIER,              -- Supplier [lifnr]
    ACCOUNT_TYPE,          -- Fin. Account Type [fis_koart]
    ITEM_TEXT,             -- Text [sgtxt]
    ASSIGNMENT_REF,        -- Assignment [dzuonr]
    TRANSACTION_CURRENCY,  -- Transaction Currency [fis_rwcur]
    AMOUNT_TC,             -- Amount in Transaction Currency [fis_wsl]
    INV_REF,               -- Invoice Ref. [rebzg]
    INV_REF_FISCAL_YEAR,   -- Invoice Reference Fiscal Year [fis_rebzj_no_conv]
    INV_ITEM_REF,          -- Invoice Item Reference [fis_rebzz]
    FOLLOW_ON_DOC_TYPE,    -- Follow-On Doc. Type [rebzt]
    SPECIAL_GL_IND,        -- Special G/L Ind [fis_umskz]
    PRIMARY KEY (MANDT)
);

Learn More