BKPF
Accounting Document Header
BKPF is an SAP database table in S/4HANA. Accounting Document Header. It contains 176 fields. 106 CDS views read from this table.
CDS Views using this table (106)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| bsad_rec_view | view | left_outer | ||
| bsad_view | view | left_outer | Acctg: Index for Customers (Clrd Items) | |
| bsak_rec_view | view | left_outer | Accounting: Secondary Index for Vendors (Cleared Items) - Generated | |
| bsak_view | view | left_outer | Acctg: Index for Suppliers (Clrd Items) | |
| bsas_rec_view | view | left_outer | Accounting: Secondary Index for G/L Accounts (Cleared Items) | |
| bsas_view | view | left_outer | Buchhaltung: Sekundärindex für Sachkonten (ausgegl. Posten) | |
| bsid_rec_view | view | left_outer | Accounting: Secondary Index for Customers - Generated | |
| bsid_view | view | left_outer | Acctg: Secondary Index for Customers | |
| bsik_rec_view | view | left_outer | Accounting: Secondary Index for Vendors - Generated | |
| bsik_view | view | left_outer | Acctg: Secondary Index for Suppliers | |
| bsis_rec_view | view | left_outer | Accounting: Secondary Index for G/L Accounts | |
| bsis_view | view | left_outer | Buchhaltung: Sekundärindex für Sachkonten | |
| CLOSING_OPERATIONS_GR_IR_ITEMS | view | inner | GR/IR Items in BSEG Format | |
| ESH_N_ACCOUNTING_DOC_BKPF | view | from | Accounting Document | |
| Faa_Anek | view | left_outer | Kompatibilitaets-View fuer Tabelle ANEK | |
| FAA_LINEITEMS | view | left_outer | Union über ACDOCA und FAAT_DOC_IT | |
| Faa_Sil_Doc | view | inner | Belege, die über FI-AA nachgebucht werden | |
| Faa_Sil_Doc_Int | view | inner | Belege, die über FI-AA integriert nachzubuchen sind | |
| Fac_Cds_Bkpf_Fdp | view | from | QueryNode for JE Form Data Provider | |
| FACVD_GLCASHMC_WLI_03 | view | left_outer | Cash account clearing worklist item | |
| FACVD_GLLGMC_WLI_03 | view | inner | OPEN ITEMS | |
| FACVD_GLMC_OIT_04 | view | inner | GL Open Items to be cleared | |
| FACVD_GLMC_WLI_03 | view | left_outer | OPEN ITEMS | |
| FACVD_RJET_WLI_03 | view | left_outer | Recurring entries acdoca- posted items part | |
| FACVD_RJET_WLI_04 | view | from | retrieve posted recurring entries for a specific gl account | |
| FACVD_RJET_WLI_04 | view | inner | retrieve posted recurring entries for a specific gl account | |
| FACVD_RJET_WLI_05 | view | from | Retrieve Tax for recurring entries | |
| FACVD_RJET_WLI_09 | view | from | Creating sums of amounts from acdoca group by recurring | |
| Facvd_Upld_Accdoc | view | from | Accounting Document Created by Uploading | |
| FAP_TSI_INVC_entry | view | inner | ||
| FARMLVD_BSITM_CLRTYP_IC | view | left_outer | Select from ... | |
| Fclm_Bkpf_Basic | view | from | Basic BKPF | |
| Fclm_Bkpf_Prjk | view | from | BKPF Projection | |
| FCOV_ACC_DOC | view | inner | ||
| FDM_FLTP_INVOICES | view | inner | Invoices with floating point numbers | |
| fgl_lib_c | view_entity | inner | LIB Base View | |
| FGL_LIB_P_DOC_HEADER | view | left_outer | Parked Items: Document Header | |
| fgl_sil_oi | view | inner | SIL: Work List of Open Items, non-ledger-group-specific | |
| Fgl_Sil_Rp_Base | view | inner | SIL: Reposting Work List, Base | |
| finoc_naoi_1 | view | inner | OrgChange: Non-Assigned Open Items 1 | |
| finoc_spl_ccode | view | inner | Split reconstruction: company codes | |
| FINOC_SPL_DC_CLR | view | inner | OrgChange: Documents to be reconstructed | |
| FINOC_SPL_DC_OI | view | inner | OrgChg: Document chains to reconstruct | |
| finoc_spl_dockey | view | inner | Split reconstruction: document keys | |
| FINS_IC_CONV_DATE | view | left_outer | IC: Conversion dates for ACDOCA entries | |
| Fins_Rev_Rec_Acdoca_View | view | left_outer | View on ACDOCA | |
| FINS_REV_REC_CH_FLOW | view | left_outer | Flow of documents for contract header | |
| Fins_Rev_Rec_Flow | view | left_outer | Flow of documents | |
| fins_rev_rec_sd_status | view | left_outer | Status of sales order/return/contract items | |
| fins_sif_bkpf_missing_ledger | view | from | Document posted specific to ledger group with missing Ledger | |
| fiscds_evlit_01 | view | inner | Line Item Browser: DDL Source | |
| fiscds_evlit_04 | view | inner | Line Item Browser: DDL Source | |
| fiscds_evlit_04a | view | inner | Line Item Browser: DDL Source | |
| fiscds_litb_ev_01 | view | left_outer | Line Item Browser: DDL Source | |
| fiscds_litb_ev_03 | view | left_outer | Line Item Browser: DDL Source | |
| fiscds_litb_gl_02 | view | left_outer | Line Item Browser: DDL Source | |
| fiscds_mref_doc_01 | view | inner | Document with Multi-Referenced Invoice | |
| fiscds_mref_doc_07 | view | from | Document with Referenced Invoice | |
| fiscds_mref_invoice | view | from | Multiple Referenced Invoice | |
| FISCDS_TRK_DOC_03 | view | left_outer | Change History for Ledger View | |
| FISCDS_TRK_DOC_04 | view | left_outer | Journal Entry History 04 | |
| FISCDS_TRK_DOC_05 | view | from | Change History from non-leading Ledger | |
| FISCDS_TRK_DOC_07 | view | from | JE Change History only exist in BKPF | |
| FISVD_DOCNR_GAP_PARK_Changed | view | from | Changed ID Park Document | |
| FISVD_DOCNR_GAP_PARK_DEL | view | from | Deleted Park Document Data | |
| FISVD_ETXMISSFROMBSET | view | inner | External tax tables missing from BSET | |
| FISVD_GL_DOCNR_GAP_BASE | view | inner | Base Data from ACDOCA | |
| Fisvid_Docnr_Gap_Base | view | from | Base Data from BKPF | |
| I_AccountingDocument | view | from | BASIC | Accounting Document |
| I_AcctgDocHdrForChgDoc | view | from | BASIC | Accounting Document Header for binding to Change Document |
| I_BillgDocForCorrespncHistory | view | inner | BASIC | Billing Document for Correspondence History |
| I_DocWithWorkflowStatus | view | from | BASIC | document with work flow status |
| I_DocWithWorkflowStatus | view | union_all | BASIC | document with work flow status |
| I_EDCAccountingDocument | view_entity | from | BASIC | EDC Accounting Document |
| I_ElectronicDocAccountingDoc | view | from | BASIC | Electronic Document: Journal Entry |
| I_FinSGLDocumentReference | view_entity | inner | BASIC | Document Reference table for Reversal |
| I_PostedMCAJournalEntry | view | inner | BASIC | Posted MCA Journal Entry details |
| I_PPS_AccountingDocument | view | inner | BASIC | Accounting Doc For Extended PO History |
| I_PPS_JournalEntryProcessFlow | view | from | BASIC | Journal Entry Documents |
| I_RecrrgAcctgDocHdrForChgDoc | view | left_outer | BASIC | Recurring Accounting Doc. Header for binding to Change Doc. |
| I_SAFTControllingDocument | view | from | BASIC | SAFT Controlling Document |
| ICA_BSEG_ENTRY_VIEW | view | inner | ICA: Entry View Based on BSEG | |
| ICA_MatchingOplAcctgDocItem | view_entity | inner | Match Opl Accounting Document Item | |
| JV_JVSO1_COMB_DOC_BALANCE | view | inner | Doc. bal. for 4A/4C view on JVSO1 | |
| P_ACMTrdgContrFinDoc | view | inner | BASIC | |
| P_ARBSITMCLRITEM01 | view | from | BASIC | |
| P_AROAccDocHdrData | view | from | BASIC | |
| P_BKPF_COM | view | from | BASIC | |
| P_CN_CADECurrencyCode | view | from | BASIC | |
| P_FINS_GL_CLEAREDITEMS | view | inner | BASIC | |
| P_FINS_GL_OPENITEM_AMOUNT | view | inner | BASIC | |
| P_MstrProjAcctDocHdr | view_entity | from | BASIC | |
| P_PrepaymentClearingAcctgDoc | view | inner | BASIC | |
| SDM_GLO_HU_BKPF_VATDATE | view | from | SDM View for BKPF table entries - Hungary | |
| SDM_GLO_IL_IRN_TO_GLO_REF4_HD | view | from | Migration of allocation number from IRN to GLO_REF - Israel | |
| SHSM_FIKR_ELM_BELNR | view | from | ||
| v_faglbsas_rec_view | view | left_outer | FAGLBSAS (Compatibility View) | |
| v_faglbsas_view | view | left_outer | FAGLBSAS (Compatibility View) | |
| v_faglbsis_rec_view | view | left_outer | FAGLBSIS (Compatibility View) | |
| v_faglbsis_view | view | left_outer | FAGLBSIS (Compatibility View) | |
| v_feb_fuzzy_view | view | inner | ||
| v_kncx_doc_1_mgr_view | view | inner | View on BSEG, BKPF, FINS_BCF_FY, only for migration | |
| v_lfcx_arc_1_view | view | inner | ||
| v_lfcx_doc_1_mgr_view | view | inner | ||
| v_lfcx_doc_1_view | view | inner | ||
| VFCP_DDL_FI | view | from |
Fields (176)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | bukrs | BUKRS | Company Code | |||
| KEY | belnr | BELNR_D | Document Number | |||
| KEY | gjahr | GJAHR | Fiscal Year | |||
| blart | BLART | Document Type | ||||
| bldat | BLDAT | Document Date | ||||
| budat | BUDAT | Posting Date | ||||
| monat | MONAT | Period | ||||
| cpudt | CPUDT | Entered On | ||||
| cputm | CPUTM | Entered at | ||||
| aedat | AEDAT_BKPF | Changed On | ||||
| upddt | UPDDT | Last Update | ||||
| wwert | WWERT_D | Translatn Date | ||||
| usnam | USNAM | User Name | ||||
| tcode | TCODE | Transaction Code | ||||
| bvorg | BVORG | Cross-CC Number | ||||
| xblnr | XBLNR1 | Reference | ||||
| dbblg | DBBLG | Rec.Entry Doc. | ||||
| dbblg_gjahr | DBBLG_GJAHR | RecEntry FYear | ||||
| dbblg_bukrs | DBBLG_BUKRS | RecEntry CoCode | ||||
| stblg | STBLG | Reversed With | ||||
| stjah | STJAH | Year | ||||
| bktxt | BKTXT | Doc.Header Text | ||||
| waers | WAERS | Currency | ||||
| kursf | KURSF | Exchange rate | ||||
| kzwrs | KZWRS | Group Currency | ||||
| kzkrs | KZKRS | Group FX Rate | ||||
| bstat | BSTAT_D | Document Status | ||||
| xnetb | XNETB | Net document type | ||||
| frath | FRATH | Unpl.del.costs | ||||
| xrueb | XRUEB | Back-Posting? | ||||
| glvor | GLVOR | Bus.transaction | ||||
| grpid | GRPID_BKPF | Session Name | ||||
| dokid | DOKID_BKPF | Document Name | ||||
| arcid | EXTID_BKPF | Extract ID | ||||
| iblar | IBLAR | Internal Document Type | ||||
| awtyp | AWTYP | Ref. procedure | ||||
| awkey | AWKEY | Reference Key | ||||
| fikrs | FIKRS | FM Area | ||||
| hwaer | HWAER | Local Currency | ||||
| hwae2 | HWAE2 | Local curr. 2 | ||||
| hwae3 | HWAE3 | Local curr. 3 | ||||
| kurs2 | KURS2 | Exchange Rate 2 | ||||
| kurs3 | KURS3 | Exchange Rate 3 | ||||
| basw2 | CURSR | Source Currency | ||||
| basw3 | CURSR | Source Currency | ||||
| umrd2 | UMRD2 | Trans. Date | ||||
| umrd3 | UMRD3 | Trans. Date | ||||
| xstov | XSTOV | Reversal Flag | ||||
| stodt | STODT | Reversal Date | ||||
| xmwst | XMWST | Calculate Tax | ||||
| curt2 | CURT2 | LC2 Crcy Type | ||||
| curt3 | CURT3 | LC3 Crcy Type | ||||
| kuty2 | KURST | Exch. Rate Type | ||||
| kuty3 | KURST | Exch. Rate Type | ||||
| xsnet | XSNET | Net Entry | ||||
| ausbk | AUSBK | Source CoCode | ||||
| xusvr | XUSVR_BKPF | Tax details | ||||
| duefl | DUEFL_BKPF | Data Transfer Status | ||||
| awsys | LOGSYSTEM | Logical System | ||||
| txkrs | TXKRS_BKPF | Rate for Taxes | ||||
| ctxkrs | CTXKRS | Tax Rate: RC | ||||
| lotkz | PSO_LOTKZ | Request Number | ||||
| xwvof | XWVOF | BoE Bf.Due Date | ||||
| stgrd | STGRD | Reversal Reason | ||||
| ppnam | PPNAM | Parked By | ||||
| ppdat | PPDATE | Parked On | ||||
| pptme | PPTME | Parked At | ||||
| pptcod | PPTCOD | Parked with | ||||
| brnch | J_1ABRNCH | Branch number | ||||
| numpg | J_1ANOPG | Number of Pages | ||||
| adisc | J_1ADISC | discount document | ||||
| xref1_hd | XREF1_HD | Ref.key(head) 1 | ||||
| xref2_hd | XREF2_HD | Ref.key(head.)2 | ||||
| xreversal | XREVERSAL | Reversal Ind. | ||||
| reindat | REINDAT | Inv. Recpt Date | ||||
| rldnr | FINS_LEDGER | Ledger | ||||
| ldgrp | FAGL_LDGRP | Ledger Group | ||||
| propmano | RE_MANDAT | Mandate | ||||
| xblnr_alt | XBLNR_ALT | Alt Refer | ||||
| vatdate | VATDATE | Tax Reporting Date | ||||
| fulfilldate | FOT_FULFILLDATE | Tax Fulfill. Date | ||||
| doccat | DOCUMENT_CATEGORY | Doc.Type | ||||
| xsplit | SPLIT_POSTING | Split Posting | ||||
| cash_alloc | FAGL_CASH_ALLOC | Cash Flow-Rel. Doc. | ||||
| follow_on | FAGL_FOLLOW_ON | Follow-on | ||||
| xreorg | FAGL_R_XDOC_REORG | Reorganized | ||||
| subset | ACC_SUBSET | Subset | ||||
| kurst | KURST | Exch. Rate Type | ||||
| kursx | GLE_FXR_DTE_RATEX28 | MD Exchange Rate | ||||
| kur2x | GLE_FXR_DTE_RATE2X28 | MD Exch. Rate 2 | ||||
| kur3x | GLE_FXR_DTE_RATE3X28 | MD Exch. Rate 3 | ||||
| xmca | GLE_DTE_MCA_XMCA | Doc. from MCA | ||||
| resubmission | FM_RESUBDAT | Resubmission Date | ||||
| logsystem_sender | LOGSYSTEM_SENDER | Sender Log Sys. | ||||
| bukrs_sender | BUKRS_SENDER | Sender CoCode | ||||
| belnr_sender | BELNR_SENDER | Sender Doc.No. | ||||
| gjahr_sender | GJAHR_SENDER | Sender FiscalYr | ||||
| intsubid | INTSUBID | SubID for AWKEY | ||||
| aworg_rev | AWORG_REV | Reversal Org. | ||||
| awref_rev | AWREF_REV | Reversal Ref. | ||||
| xreversing | CO_STFLG | Reversal doc. | ||||
| xreversed | CO_STOKZ | Reversed | ||||
| glbtgrp | FINS_GLBTGRP | GL Bus. Trans. Grp | ||||
| co_vrgng | CO_VORGANG | Bus.Transaction | ||||
| co_refbt | CO_REFBT | RefDocType | ||||
| co_alebn | CO_ALEBN | ALE: Org.DocNr | ||||
| co_valdt | CO_VALDT | Valuation Date | ||||
| co_belnr_sender | COBELNR_SENDER | Send. CO Doc.No. | ||||
| kokrs_sender | KOKRS_SENDER | Sender CO Area | ||||
| acc_principle | ACCOUNTING_PRINCIPLE | Accounting Principle | ||||
| _dataaging | DATA_TEMPERATURE | Data Aging | ||||
| trava_pn | TRANSVAR | Transfer var. | ||||
| ldgrpspec_pn | XLDGRPSPEC | LDGRP-Specific | ||||
| afabespec_pn | XAFABESPEC | Area-Specific | ||||
| xsecondary | FINS_SECONDARY_ENTRY | Secondary entry | ||||
| reprocessing_status_code | FINS_REPROCESSING_STATUS_CODE | Reproc status code | ||||
| trr_partial_ind | FINS_TRR_PARTIAL_IND | Partial Processing | ||||
| item_removal_status | FINS_ITEM_REMOVAL_STATUS | Item Removal Status | ||||
| penrc | PENRC | Reason f. Delay | ||||
| glo_ref1_hd | FAC_GLO_REF1_HD | Country/Region Specific Reference 1 | ||||
| glo_dat1_hd | FAC_GLO_DAT1_HD | Country/Region Specific Date 1 | ||||
| glo_ref2_hd | FAC_GLO_REF2_HD | Country/Region Specific Reference 2 | ||||
| glo_dat2_hd | FAC_GLO_DAT2_HD | Country/Region Specific Date 2 | ||||
| glo_ref3_hd | FAC_GLO_REF3_HD | Country/Region Specific Reference 3 | ||||
| glo_dat3_hd | FAC_GLO_DAT3_HD | Country/Region Specific Date 3 | ||||
| glo_ref4_hd | FAC_GLO_REF4_HD | Country/Region Specific Reference 4 | ||||
| glo_dat4_hd | FAC_GLO_DAT4_HD | Country/Region Specific Date 4 | ||||
| glo_ref5_hd | FAC_GLO_REF5_HD | Country/Region Specific Reference 5 | ||||
| glo_dat5_hd | FAC_GLO_DAT5_HD | Country/Region Specific Date 5 | ||||
| glo_bp1_hd | FAC_GLO_BP1_HD | Ctry/Reg. Specific Business Partner 1 | ||||
| glo_bp2_hd | FAC_GLO_BP2_HD | Ctry/Reg. Specific Business Partner 2 | ||||
| ev_postng_ctrl | FINS_ENTRY_VIEW_POSTNG_CONTROL | CntrEntryView | ||||
| whtdate | WHTDATE | Wtax Reporting Date | ||||
| cbttype | FINS_CUSTBTTYPE | Bus. Trans. Type | ||||
| closingstep | FINS_CLOSINGSTEP | Closing Step | ||||
| xdiffledgervalues | FINS_XDIFFLEDGERVALUES | Ledger spec. values | ||||
| xledgermissing | FINS_XLEDGERMISSING | Ledgers are missing | ||||
| xuniquecvtyps | FINS_XUNIQUECVTYPS | Unique Curr. Types | ||||
| tax_country_hd | FOT_TAX_COUNTRY_HD | Tax Ctry/Reg. | ||||
| last_change_datetime | FIS_CHNG_TSTAMP | Last Changed At | ||||
| anxtype | /ILE/TMTYP | invoice type | ||||
| anxamnt | /ILE/TMANXA | annexation amount | ||||
| anxperc | /ILE/TMANXP | annexation percen. | ||||
| zvat_indc | /ILE/TVAT_INDC | V.A.T indicator | ||||
| psoty | PSOTY_D | Request Cat. | ||||
| psoak | PSOAK | Reason | ||||
| psoks | PSOKS | Region | ||||
| psosg | PSOSG | Reversal reason | ||||
| psofn | PSOFN | File number | ||||
| intform | FM_INTFORM | Int.formula | ||||
| intdate | FM_INTDATE | Interest Calc. Date | ||||
| psobt | PSOBT | Posting Day | ||||
| psozl | PSOZL | Actual | ||||
| psodt | AEDAT | Changed On | ||||
| psotm | PSOTM | Changed at | ||||
| fm_umart | FM_UMART | Transfer type | ||||
| ccins | CCINS_30F | Card type | ||||
| ccnum | CCNUM_30F | Card Number | ||||
| ssblk | SSBLK | Sampling Block | ||||
| batch | LOTKZ | Lot No. | ||||
| sname | UNAME | User Name | ||||
| sampled | SAMPLED | Sampled invoice | ||||
| exclude_flag | EXCLUDE_FLG | PPA Exclude | ||||
| blind | FM_BLIND | BL Indicator | ||||
| offset_status | FMFG_OFFSET_STATUS | Offset Status | ||||
| offset_refer_dat | FMFG_REFERRED_OFFSET_DAT | Date Referred | ||||
| knumv | KNUMV | Doc. Condition | ||||
| blo | PFM_1BLO | Document block | ||||
| cnt | PFM_1CNT | Contract No | ||||
| pybastyp | SAFM_AP_PYBSTYP | Payt. Against | ||||
| pybasno | SAFM_AP_PYBSNO | Payt. Ground No. | ||||
| pybasdat | SAFM_AP_PYBSDAT | Payt. Ground Date | ||||
| pyiban | IBAN | IBAN | ||||
| inwardno_hd | SAFM_AP_INWARD_NO | Incg Doc. Nmbr | ||||
| inwarddt_hd | SAFM_AP_INWARD_DT | Incg Doc. Date |
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.
-- Accounting Document Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BKPF (
MANDT, -- Client [MANDT]
BUKRS, -- Company Code [BUKRS]
BELNR, -- Document Number [BELNR_D]
GJAHR, -- Fiscal Year [GJAHR]
BLART, -- Document Type [BLART]
BLDAT, -- Document Date [BLDAT]
BUDAT, -- Posting Date [BUDAT]
MONAT, -- Period [MONAT]
CPUDT, -- Entered On [CPUDT]
CPUTM, -- Entered at [CPUTM]
AEDAT, -- Changed On [AEDAT_BKPF]
UPDDT, -- Last Update [UPDDT]
WWERT, -- Translatn Date [WWERT_D]
USNAM, -- User Name [USNAM]
TCODE, -- Transaction Code [TCODE]
BVORG, -- Cross-CC Number [BVORG]
XBLNR, -- Reference [XBLNR1]
DBBLG, -- Rec.Entry Doc. [DBBLG]
DBBLG_GJAHR, -- RecEntry FYear [DBBLG_GJAHR]
DBBLG_BUKRS, -- RecEntry CoCode [DBBLG_BUKRS]
STBLG, -- Reversed With [STBLG]
STJAH, -- Year [STJAH]
BKTXT, -- Doc.Header Text [BKTXT]
WAERS, -- Currency [WAERS]
KURSF, -- Exchange rate [KURSF]
KZWRS, -- Group Currency [KZWRS]
KZKRS, -- Group FX Rate [KZKRS]
BSTAT, -- Document Status [BSTAT_D]
XNETB, -- Net document type [XNETB]
FRATH, -- Unpl.del.costs [FRATH]
XRUEB, -- Back-Posting? [XRUEB]
GLVOR, -- Bus.transaction [GLVOR]
GRPID, -- Session Name [GRPID_BKPF]
DOKID, -- Document Name [DOKID_BKPF]
ARCID, -- Extract ID [EXTID_BKPF]
IBLAR, -- Internal Document Type [IBLAR]
AWTYP, -- Ref. procedure [AWTYP]
AWKEY, -- Reference Key [AWKEY]
FIKRS, -- FM Area [FIKRS]
HWAER, -- Local Currency [HWAER]
HWAE2, -- Local curr. 2 [HWAE2]
HWAE3, -- Local curr. 3 [HWAE3]
KURS2, -- Exchange Rate 2 [KURS2]
KURS3, -- Exchange Rate 3 [KURS3]
BASW2, -- Source Currency [CURSR]
BASW3, -- Source Currency [CURSR]
UMRD2, -- Trans. Date [UMRD2]
UMRD3, -- Trans. Date [UMRD3]
XSTOV, -- Reversal Flag [XSTOV]
STODT, -- Reversal Date [STODT]
XMWST, -- Calculate Tax [XMWST]
CURT2, -- LC2 Crcy Type [CURT2]
CURT3, -- LC3 Crcy Type [CURT3]
KUTY2, -- Exch. Rate Type [KURST]
KUTY3, -- Exch. Rate Type [KURST]
XSNET, -- Net Entry [XSNET]
AUSBK, -- Source CoCode [AUSBK]
XUSVR, -- Tax details [XUSVR_BKPF]
DUEFL, -- Data Transfer Status [DUEFL_BKPF]
AWSYS, -- Logical System [LOGSYSTEM]
TXKRS, -- Rate for Taxes [TXKRS_BKPF]
CTXKRS, -- Tax Rate: RC [CTXKRS]
LOTKZ, -- Request Number [PSO_LOTKZ]
XWVOF, -- BoE Bf.Due Date [XWVOF]
STGRD, -- Reversal Reason [STGRD]
PPNAM, -- Parked By [PPNAM]
PPDAT, -- Parked On [PPDATE]
PPTME, -- Parked At [PPTME]
PPTCOD, -- Parked with [PPTCOD]
BRNCH, -- Branch number [J_1ABRNCH]
NUMPG, -- Number of Pages [J_1ANOPG]
ADISC, -- discount document [J_1ADISC]
XREF1_HD, -- Ref.key(head) 1 [XREF1_HD]
XREF2_HD, -- Ref.key(head.)2 [XREF2_HD]
XREVERSAL, -- Reversal Ind. [XREVERSAL]
REINDAT, -- Inv. Recpt Date [REINDAT]
RLDNR, -- Ledger [FINS_LEDGER]
LDGRP, -- Ledger Group [FAGL_LDGRP]
PROPMANO, -- Mandate [RE_MANDAT]
XBLNR_ALT, -- Alt Refer [XBLNR_ALT]
VATDATE, -- Tax Reporting Date [VATDATE]
FULFILLDATE, -- Tax Fulfill. Date [FOT_FULFILLDATE]
DOCCAT, -- Doc.Type [DOCUMENT_CATEGORY]
XSPLIT, -- Split Posting [SPLIT_POSTING]
CASH_ALLOC, -- Cash Flow-Rel. Doc. [FAGL_CASH_ALLOC]
FOLLOW_ON, -- Follow-on [FAGL_FOLLOW_ON]
XREORG, -- Reorganized [FAGL_R_XDOC_REORG]
SUBSET, -- Subset [ACC_SUBSET]
KURST, -- Exch. Rate Type [KURST]
KURSX, -- MD Exchange Rate [GLE_FXR_DTE_RATEX28]
KUR2X, -- MD Exch. Rate 2 [GLE_FXR_DTE_RATE2X28]
KUR3X, -- MD Exch. Rate 3 [GLE_FXR_DTE_RATE3X28]
XMCA, -- Doc. from MCA [GLE_DTE_MCA_XMCA]
RESUBMISSION, -- Resubmission Date [FM_RESUBDAT]
LOGSYSTEM_SENDER, -- Sender Log Sys. [LOGSYSTEM_SENDER]
BUKRS_SENDER, -- Sender CoCode [BUKRS_SENDER]
BELNR_SENDER, -- Sender Doc.No. [BELNR_SENDER]
GJAHR_SENDER, -- Sender FiscalYr [GJAHR_SENDER]
INTSUBID, -- SubID for AWKEY [INTSUBID]
AWORG_REV, -- Reversal Org. [AWORG_REV]
AWREF_REV, -- Reversal Ref. [AWREF_REV]
XREVERSING, -- Reversal doc. [CO_STFLG]
XREVERSED, -- Reversed [CO_STOKZ]
GLBTGRP, -- GL Bus. Trans. Grp [FINS_GLBTGRP]
CO_VRGNG, -- Bus.Transaction [CO_VORGANG]
CO_REFBT, -- RefDocType [CO_REFBT]
CO_ALEBN, -- ALE: Org.DocNr [CO_ALEBN]
CO_VALDT, -- Valuation Date [CO_VALDT]
CO_BELNR_SENDER, -- Send. CO Doc.No. [COBELNR_SENDER]
KOKRS_SENDER, -- Sender CO Area [KOKRS_SENDER]
ACC_PRINCIPLE, -- Accounting Principle [ACCOUNTING_PRINCIPLE]
_DATAAGING, -- Data Aging [DATA_TEMPERATURE]
TRAVA_PN, -- Transfer var. [TRANSVAR]
LDGRPSPEC_PN, -- LDGRP-Specific [XLDGRPSPEC]
AFABESPEC_PN, -- Area-Specific [XAFABESPEC]
XSECONDARY, -- Secondary entry [FINS_SECONDARY_ENTRY]
REPROCESSING_STATUS_CODE, -- Reproc status code [FINS_REPROCESSING_STATUS_CODE]
TRR_PARTIAL_IND, -- Partial Processing [FINS_TRR_PARTIAL_IND]
ITEM_REMOVAL_STATUS, -- Item Removal Status [FINS_ITEM_REMOVAL_STATUS]
PENRC, -- Reason f. Delay [PENRC]
GLO_REF1_HD, -- Country/Region Specific Reference 1 [FAC_GLO_REF1_HD]
GLO_DAT1_HD, -- Country/Region Specific Date 1 [FAC_GLO_DAT1_HD]
GLO_REF2_HD, -- Country/Region Specific Reference 2 [FAC_GLO_REF2_HD]
GLO_DAT2_HD, -- Country/Region Specific Date 2 [FAC_GLO_DAT2_HD]
GLO_REF3_HD, -- Country/Region Specific Reference 3 [FAC_GLO_REF3_HD]
GLO_DAT3_HD, -- Country/Region Specific Date 3 [FAC_GLO_DAT3_HD]
GLO_REF4_HD, -- Country/Region Specific Reference 4 [FAC_GLO_REF4_HD]
GLO_DAT4_HD, -- Country/Region Specific Date 4 [FAC_GLO_DAT4_HD]
GLO_REF5_HD, -- Country/Region Specific Reference 5 [FAC_GLO_REF5_HD]
GLO_DAT5_HD, -- Country/Region Specific Date 5 [FAC_GLO_DAT5_HD]
GLO_BP1_HD, -- Ctry/Reg. Specific Business Partner 1 [FAC_GLO_BP1_HD]
GLO_BP2_HD, -- Ctry/Reg. Specific Business Partner 2 [FAC_GLO_BP2_HD]
EV_POSTNG_CTRL, -- CntrEntryView [FINS_ENTRY_VIEW_POSTNG_CONTROL]
WHTDATE, -- Wtax Reporting Date [WHTDATE]
CBTTYPE, -- Bus. Trans. Type [FINS_CUSTBTTYPE]
CLOSINGSTEP, -- Closing Step [FINS_CLOSINGSTEP]
XDIFFLEDGERVALUES, -- Ledger spec. values [FINS_XDIFFLEDGERVALUES]
XLEDGERMISSING, -- Ledgers are missing [FINS_XLEDGERMISSING]
XUNIQUECVTYPS, -- Unique Curr. Types [FINS_XUNIQUECVTYPS]
TAX_COUNTRY_HD, -- Tax Ctry/Reg. [FOT_TAX_COUNTRY_HD]
LAST_CHANGE_DATETIME, -- Last Changed At [FIS_CHNG_TSTAMP]
ANXTYPE, -- invoice type [/ILE/TMTYP]
ANXAMNT, -- annexation amount [/ILE/TMANXA]
ANXPERC, -- annexation percen. [/ILE/TMANXP]
ZVAT_INDC, -- V.A.T indicator [/ILE/TVAT_INDC]
PSOTY, -- Request Cat. [PSOTY_D]
PSOAK, -- Reason [PSOAK]
PSOKS, -- Region [PSOKS]
PSOSG, -- Reversal reason [PSOSG]
PSOFN, -- File number [PSOFN]
INTFORM, -- Int.formula [FM_INTFORM]
INTDATE, -- Interest Calc. Date [FM_INTDATE]
PSOBT, -- Posting Day [PSOBT]
PSOZL, -- Actual [PSOZL]
PSODT, -- Changed On [AEDAT]
PSOTM, -- Changed at [PSOTM]
FM_UMART, -- Transfer type [FM_UMART]
CCINS, -- Card type [CCINS_30F]
CCNUM, -- Card Number [CCNUM_30F]
SSBLK, -- Sampling Block [SSBLK]
BATCH, -- Lot No. [LOTKZ]
SNAME, -- User Name [UNAME]
SAMPLED, -- Sampled invoice [SAMPLED]
EXCLUDE_FLAG, -- PPA Exclude [EXCLUDE_FLG]
BLIND, -- BL Indicator [FM_BLIND]
OFFSET_STATUS, -- Offset Status [FMFG_OFFSET_STATUS]
OFFSET_REFER_DAT, -- Date Referred [FMFG_REFERRED_OFFSET_DAT]
KNUMV, -- Doc. Condition [KNUMV]
BLO, -- Document block [PFM_1BLO]
CNT, -- Contract No [PFM_1CNT]
PYBASTYP, -- Payt. Against [SAFM_AP_PYBSTYP]
PYBASNO, -- Payt. Ground No. [SAFM_AP_PYBSNO]
PYBASDAT, -- Payt. Ground Date [SAFM_AP_PYBSDAT]
PYIBAN, -- IBAN [IBAN]
INWARDNO_HD, -- Incg Doc. Nmbr [SAFM_AP_INWARD_NO]
INWARDDT_HD, -- Incg Doc. Date [SAFM_AP_INWARD_DT]
PRIMARY KEY (MANDT, BUKRS, BELNR, GJAHR)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- BSEG to ACDOCA: The Universal Journal Migration
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA