FICA_BOP_REP_LOG

Transparent Table Application Table
37 Fields 1 CDS Views

Balance of Payments - Reported Items Log Contract Accounting

FICA_BOP_REP_LOG is an SAP database table in S/4HANA. Balance of Payments - Reported Items Log Contract Accounting. It contains 37 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BOPRptdItmsLgCA view_entity from BASIC Information for documents selected per report run

Fields (37)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY statryrptgentity srf_reporting_entity Reporting Entity
KEY statryrptcategory srf_rep_cat_id Report ID
KEY statryrptrunid srf_report_run_id Report Run ID
KEY companycode bukrs Company Code
KEY cadocumentnumber fica_opbel CA Document No.
KEY fiscalyear fis_gjahr_no_conv Fiscal Year
KEY casubitemnumber fica_opupz CA Subitem No.
KEY carepetitionitemnumber opupw_kk Repetition Item
KEY cabpitemnumber fica_opupk CA BP Item Number
KEY boprptgcntry glo_bopcountry Reporting Ctry/Reg.
KEY bopform glo_bopform Form
KEY bopformitem glo_bopitem Form Item
KEY caitemisoffsetting ca_isoffsetting CA Item Offset.
KEY caitemisdoubtful ca_isdoubtful CA Item Doubt.
KEY postingdate budat_kk Posting Date
careconciliationkey fikey_kk Reconcil. Key
accountingdocument belnr_d Document Number
companycodecountry land1 Country/Reg.
boppartnercntry land1 Country/Reg.
financialaccounttype farp_koart Account Type
chartofaccounts ktopl Chart of Accts
glaccount hkont_kk G/L Account
taxcode fis_mwskz Tax Code
cadocumenttype fica_blart CA Document Type
accountingdocumenttype blart Document Type
specialglcode umskz Special G/L Ind
debitcreditcode char1 Single-Character Flag
transactioncurrency blwae_kk Currency
amountintransactioncurrency betrw_kk Amount
companycodecurrency waers Currency
amountincompanycodecurrency betrh_kk Local Crcy Amt
clearingdate augdt_kk Clearing
caclearingaccountingdocument augbl_kk Clearing Doc.
businesspartner bu_partner Busn. Partner
offsettingaccounttype farp_koart Account Type
partnercompany fis_rassc Trading Partner

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.

-- Balance of Payments - Reported Items Log Contract Accounting
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FICA_BOP_REP_LOG (
    MANDT,                         -- Client [mandt]
    STATRYRPTGENTITY,              -- Reporting Entity [srf_reporting_entity]
    STATRYRPTCATEGORY,             -- Report ID [srf_rep_cat_id]
    STATRYRPTRUNID,                -- Report Run ID [srf_report_run_id]
    COMPANYCODE,                   -- Company Code [bukrs]
    CADOCUMENTNUMBER,              -- CA Document No. [fica_opbel]
    FISCALYEAR,                    -- Fiscal Year [fis_gjahr_no_conv]
    CASUBITEMNUMBER,               -- CA Subitem No. [fica_opupz]
    CAREPETITIONITEMNUMBER,        -- Repetition Item [opupw_kk]
    CABPITEMNUMBER,                -- CA BP Item Number [fica_opupk]
    BOPRPTGCNTRY,                  -- Reporting Ctry/Reg. [glo_bopcountry]
    BOPFORM,                       -- Form [glo_bopform]
    BOPFORMITEM,                   -- Form Item [glo_bopitem]
    CAITEMISOFFSETTING,            -- CA Item Offset. [ca_isoffsetting]
    CAITEMISDOUBTFUL,              -- CA Item Doubt. [ca_isdoubtful]
    POSTINGDATE,                   -- Posting Date [budat_kk]
    CARECONCILIATIONKEY,           -- Reconcil. Key [fikey_kk]
    ACCOUNTINGDOCUMENT,            -- Document Number [belnr_d]
    COMPANYCODECOUNTRY,            -- Country/Reg. [land1]
    BOPPARTNERCNTRY,               -- Country/Reg. [land1]
    FINANCIALACCOUNTTYPE,          -- Account Type [farp_koart]
    CHARTOFACCOUNTS,               -- Chart of Accts [ktopl]
    GLACCOUNT,                     -- G/L Account [hkont_kk]
    TAXCODE,                       -- Tax Code [fis_mwskz]
    CADOCUMENTTYPE,                -- CA Document Type [fica_blart]
    ACCOUNTINGDOCUMENTTYPE,        -- Document Type [blart]
    SPECIALGLCODE,                 -- Special G/L Ind [umskz]
    DEBITCREDITCODE,               -- Single-Character Flag [char1]
    TRANSACTIONCURRENCY,           -- Currency [blwae_kk]
    AMOUNTINTRANSACTIONCURRENCY,   -- Amount [betrw_kk]
    COMPANYCODECURRENCY,           -- Currency [waers]
    AMOUNTINCOMPANYCODECURRENCY,   -- Local Crcy Amt [betrh_kk]
    CLEARINGDATE,                  -- Clearing [augdt_kk]
    CACLEARINGACCOUNTINGDOCUMENT,  -- Clearing Doc. [augbl_kk]
    BUSINESSPARTNER,               -- Busn. Partner [bu_partner]
    OFFSETTINGACCOUNTTYPE,         -- Account Type [farp_koart]
    PARTNERCOMPANY,                -- Trading Partner [fis_rassc]
    PRIMARY KEY (MANDT, STATRYRPTGENTITY, STATRYRPTCATEGORY, STATRYRPTRUNID, COMPANYCODE, CADOCUMENTNUMBER, FISCALYEAR, CASUBITEMNUMBER, CAREPETITIONITEMNUMBER, CABPITEMNUMBER, BOPRPTGCNTRY, BOPFORM, BOPFORMITEM, CAITEMISOFFSETTING, CAITEMISDOUBTFUL, POSTINGDATE)
);

Learn More