FRPAC_PRPSL_SET

Transparent Table Application Table

AP/AR Clearing Proposal Set

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FinAPARClearingProposalSet view_entity from BASIC APAR Clearing Proposal Set

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
company_code bukrs Company Code
customer kunnr Customer
supplier lifnr Supplier
account_type fis_koart Fin. Account Type
transaction_currency fis_rwcur Transaction Currency
open_amount_tc frpac_openamounttc
number_of_proposals frpac_number_of_proposals
number_of_open_items farp_number_of_open_items Number of Open Items
status frpac_proposal_set_status
created_on abp_creation_date Created On
created_by abp_creation_user Created By
created_at abp_creation_tstmpl Created On

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 Set
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FRPAC_PRPSL_SET (
    MANDT,                 -- Client [mandt]
    COMPANY_CODE,          -- Company Code [bukrs]
    CUSTOMER,              -- Customer [kunnr]
    SUPPLIER,              -- Supplier [lifnr]
    ACCOUNT_TYPE,          -- Fin. Account Type [fis_koart]
    TRANSACTION_CURRENCY,  -- Transaction Currency [fis_rwcur]
    OPEN_AMOUNT_TC,        -- frpac_openamounttc
    NUMBER_OF_PROPOSALS,   -- frpac_number_of_proposals
    NUMBER_OF_OPEN_ITEMS,  -- Number of Open Items [farp_number_of_open_items]
    STATUS,                -- frpac_proposal_set_status
    CREATED_ON,            -- Created On [abp_creation_date]
    CREATED_BY,            -- Created By [abp_creation_user]
    CREATED_AT,            -- Created On [abp_creation_tstmpl]
    PRIMARY KEY (MANDT)
);