P_BKPF_COM
Journal Entry
P_BKPF_COM is a CDS View in S/4HANA. Journal Entry. It contains 88 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FIN_SUBVAL_JOURNALENTRY | view_entity | from | Journal Entry | |
| I_CFinTemporaryPosting | view_entity | from | BASIC | CFIN Temporary Posting |
| I_CFinValidJournalEntry | view_entity | from | BASIC | Central Finance valid Journal Entry |
| I_JournalEntry | view_entity | from | BASIC | Journal Entry |
Fields (88)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | belnr | AccountingDocument | 1 |
| KEY | bukrs | CompanyCode | 1 |
| KEY | gjahr | FiscalYear | 1 |
| adisc | IsDiscountDocument | 1 | |
| ausbk | SourceCompanyCode | 1 | |
| awkey | OriginalReferenceDocument | 1 | |
| aworg_rev | ReversalReferenceDocumentCntxt | 1 | |
| awref_rev | ReversalReferenceDocument | 1 | |
| awsys | LogicalSystem | 1 | |
| awtyp | ReferenceDocumentType | 1 | |
| belnr_sender | SenderAccountingDocument | 1 | |
| bktxt | AccountingDocumentHeaderText | 1 | |
| blart | AccountingDocumentType | 1 | |
| bldat | DocumentDate | 1 | |
| brnch | Branch | 1 | |
| bstat | AccountingDocumentCategory | 1 | |
| budat | PostingDate | 1 | |
| bukrs_sender | SenderCompanyCode | 1 | |
| bvorg | IntercompanyTransaction | 1 | |
| cbttype | JrnlEntryBusinessTransType | 1 | |
| co_valdt | CostAccountingValuationDate | 1 | |
| cpudt | AccountingDocumentCreationDate | 1 | |
| cputm | CreationTime | 1 | |
| curt2 | AdditionalCurrency1Role | 1 | |
| curt3 | AdditionalCurrency2Role | 1 | |
| dbblg | RecurringAccountingDocument | 1 | |
| dbblg_bukrs | RecrrgJournalEntryCompanyCode | 1 | |
| dbblg_gjahr | RecrrgJournalEntryFiscalYear | 1 | |
| doccat | AccountingDocumentClass | 1 | |
| ev_postng_ctrl | EntryViewPostingControl | 1 | |
| fikrs | FinancialManagementArea | 1 | |
| fulfilldate | TaxFulfillmentDate | 1 | |
| gjahr_sender | SenderFiscalYear | 1 | |
| glbtgrp | GLBusinessTransactionGroup | 1 | |
| glo_bp1_hd | JrnlEntryCntrySpecificBP1 | 1 | |
| glo_bp2_hd | JrnlEntryCntrySpecificBP2 | 1 | |
| glo_dat1_hd | JrnlEntryCntrySpecificDate1 | 1 | |
| glo_dat2_hd | JrnlEntryCntrySpecificDate2 | 1 | |
| glo_dat3_hd | JrnlEntryCntrySpecificDate3 | 1 | |
| glo_dat4_hd | JrnlEntryCntrySpecificDate4 | 1 | |
| glo_dat5_hd | JrnlEntryCntrySpecificDate5 | 1 | |
| glo_ref1_hd | JrnlEntryCntrySpecificRef1 | 1 | |
| glo_ref2_hd | JrnlEntryCntrySpecificRef2 | 1 | |
| glo_ref3_hd | JrnlEntryCntrySpecificRef3 | 1 | |
| glo_ref4_hd | JrnlEntryCntrySpecificRef4 | 1 | |
| glo_ref5_hd | JrnlEntryCntrySpecificRef5 | 1 | |
| glvor | BusinessTransactionType | 1 | |
| grpid | BatchInputSession | 1 | |
| hwae2 | AdditionalCurrency1 | 1 | |
| hwae3 | AdditionalCurrency2 | 1 | |
| hwaer | CompanyCodeCurrency | 1 | |
| knumv | SalesDocumentCondition | 1 | |
| kursf | ExchangeRate | 1 | |
| kurst | ExchangeRateType | 1 | |
| last_change_datetime | JournalEntryLastChangeDateTime | 1 | |
| ldgrp | LedgerGroup | 1 | |
| logsystem_sender | SenderLogicalSystem | 1 | |
| numpg | NmbrOfPages | 1 | |
| penrc | LatePaymentReason | 1 | |
| ppdat | ParkingDate | 1 | |
| PPTCOD | ParkingTransactionCode | 1 | |
| pptme | ParkingTime | 1 | |
| reindat | InvoiceReceiptDate | 1 | |
| reprocessing_status_code | JournalEntryReprocessingStatus | 1 | |
| rldnr | Ledger | 1 | |
| stblg | ReverseDocument | 1 | |
| stgrd | ReversalReason | 1 | |
| stjah | ReverseDocumentFiscalYear | 1 | |
| stodt | PlannedReversalDate | 1 | |
| TAX_COUNTRY_HD | TaxCountry | 1 | |
| tcode | TransactionCode | 1 | |
| txkrs | TaxExchangeRate | 1 | |
| usnam | AccountingDocCreatedByUser | 1 | |
| vatdate | TaxReportingDate | 1 | |
| waers | TransactionCurrency | 1 | |
| whtdate | WithholdingTaxReportingDate | 1 | |
| wwert | ExchangeRateDate | 1 | |
| xblnr | DocumentReferenceID | 1 | |
| xmwst | TaxIsCalculatedAutomatically | 1 | |
| xnetb | NetAmountIsPosted | 1 | |
| xref1_hd | Reference1InDocumentHeader | 1 | |
| xref2_hd | Reference2InDocumentHeader | 1 | |
| xreversed | IsReversed | 1 | |
| xreversing | IsReversal | 1 | |
| xrueb | JrnlEntryIsPostedToPrevPeriod | 1 | |
| XSECONDARY | JournalEntryIsSecondaryEntry | 1 | |
| xsnet | TaxBaseAmountIsNetAmount | 1 | |
| xstov | ReversalIsPlanned | 1 |
@AbapCatalog.entityBuffer.definitionAllowed: false
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@Metadata.ignorePropagatedAnnotations: true
define view entity P_BKPF_COM
as select from bkpf
{
key cast( bkpf.bukrs as fis_bukrs preserving type ) as bukrs,
key cast( bkpf.belnr as farp_belnr_d preserving type ) as belnr,
key cast( bkpf.gjahr as fis_gjahr_no_conv preserving type ) as gjahr,
cast( bkpf.blart as farp_blart preserving type ) as blart,
cast( bkpf.bldat as fis_bldat preserving type ) as bldat,
cast( bkpf.budat as fis_budat preserving type) as budat,
--cast( monat as FINS_FISCALPERIOD ) as monat,
cast( concat( '0', bkpf.monat ) as abap.numc( 3 ) ) as monat,
cast( bkpf.cpudt as farp_cpudt preserving type ) as cpudt,
cast( bkpf.cputm as ttet_dt_cr_time preserving type) as cputm,
bkpf.aedat,
cast(bkpf.upddt as ttet_dt_chg_date preserving type) as upddt,
cast( bkpf.wwert as vdm_v_exchange_rate_date preserving type) as wwert,
cast( bkpf.usnam as fis_usnam preserving type) as usnam,
bkpf.tcode,
cast( bkpf.bvorg as fac_bvorg preserving type ) as bvorg,
cast( bkpf.xblnr as fis_xblnr1 preserving type ) as xblnr,
cast( bkpf.dbblg as fis_rjet_id preserving type ) as dbblg,
cast( bkpf.dbblg_bukrs as fis_dbblg_bukrs preserving type ) as dbblg_bukrs,
cast( bkpf.dbblg_gjahr as fis_dbblg_gjahr preserving type ) as dbblg_gjahr,
cast( bkpf.stblg as fis_stblg preserving type ) as stblg,
cast( bkpf.stjah as fis_stjah_no_conv preserving type ) as stjah,
bkpf.bktxt,
bkpf.waers as waers,
// DEC9.5 with conversion exit EXCRT --> CHAR13 without conversion exit 14.02.2019
//cast( kursf as fis_kursf_char ) as kursf,
cast( bkpf.kursf as ukurs_curr preserving type ) as kursf,
bkpf.kzwrs as kzwrs,
bkpf.kzkrs,
cast( bkpf.bstat as fis_bstat preserving type ) as bstat,
cast( bkpf.xnetb as fis_xnetb preserving type ) as xnetb,
@Semantics.amount.currencyCode: 'HWAE3'
bkpf.frath,
cast( bkpf.xrueb as fis_xrueb preserving type ) as xrueb,
cast( bkpf.glvor as fins_bttype preserving type ) as glvor,
cast( bkpf.cbttype as fis_jecustbttype preserving type ) as cbttype,
cast( bkpf.grpid as fis_grpid preserving type ) as grpid,
bkpf.dokid,
bkpf.arcid,
bkpf.iblar,
cast( bkpf.awtyp as fis_awtyp preserving type ) as awtyp,
cast( bkpf.awkey as fac_awkey preserving type ) as awkey,
bkpf.fikrs,
cast( bkpf.hwaer as fis_hwaer ) as hwaer,
cast( bkpf.hwae2 as fis_hwae2 ) as hwae2,
cast( bkpf.hwae3 as fis_hwae3 ) as hwae3,
// DEC9.5 with conversion exit EXCRT --> not used in I-View I_JournalEntry
bkpf.kurs2,
// DEC9.5 with conversion exit EXCRT --> not used in I-View I_JournalEntry
bkpf.kurs3,
bkpf.basw2,
bkpf.basw3,
bkpf.umrd2,
bkpf.umrd3,
cast( bkpf.xstov as fis_xstov ) as xstov,
cast( bkpf.stodt as fis_stodt ) as stodt,
cast( bkpf.xmwst as fis_xmwst ) as xmwst,
bkpf.curt2,
bkpf.curt3,
bkpf.kuty2,
bkpf.kuty3,
cast( bkpf.xsnet as fis_xmwsn ) as xsnet,
bkpf.ausbk,
bkpf.xusvr,
bkpf.duefl,
bkpf.awsys,
// DEC9.5 with conversion exit EXCRT --> CHAR13 without conversion exit 14.02.2019
//cast( txkrs as fis_txkrs_char ) as txkrs,
cast( bkpf.txkrs as fis_txkrs_bkpf ) as txkrs,
bkpf.ctxkrs,
bkpf.lotkz,
bkpf.xwvof,
bkpf.stgrd,
bkpf.ppnam,
cast( bkpf.brnch as fis_j_1abrnch preserving type) as brnch,
bkpf.numpg,
bkpf.adisc,
cast( bkpf.xref1_hd as fins_xref1_hd ) as xref1_hd,
cast( bkpf.xref2_hd as fins_xref2_hd ) as xref2_hd,
cast( bkpf.reindat as fis_reindat ) as reindat,
cast( bkpf.rldnr as fis_rldnr preserving type) as rldnr,
bkpf.ldgrp,
cast( bkpf.propmano as fis_re_mandat ) as propmano,
// cast( xblnr_alt as fis_xblnr_alt_wo_exit ) as xblnr_alt,
cast( bkpf.xblnr_alt as fis_xblnr_alt ) as xblnr_alt,
bkpf.vatdate,
bkpf.fulfilldate,
cast( bkpf.doccat as fis_accdoc_class preserving type) as doccat,
bkpf.xsplit,
bkpf.cash_alloc,
bkpf.follow_on,
bkpf.xreorg,
bkpf.subset,
bkpf.kurst,
bkpf.kursx,
bkpf.kur2x,
bkpf.kur3x,
bkpf.xmca,
bkpf.resubmission,
cast( bkpf.logsystem_sender as fis_logsystem_sender preserving type ) as logsystem_sender,
bkpf.bukrs_sender,
cast( bkpf.belnr_sender as fis_belnr_sender preserving type) as belnr_sender,
cast( bkpf.gjahr_sender as fis_gjahr_sender_no_conv preserving type ) as gjahr_sender,
bkpf.aworg_rev,
bkpf.awref_rev,
bkpf.ccins,
bkpf.ccnum,
cast( bkpf.penrc as fis_penrc ) as penrc,
cast( bkpf.knumv as fis_knumv ) as knumv,
cast( bkpf.xreversing as fins_xreversing ) as xreversing,
cast( bkpf.xreversed as fins_xreversed ) as xreversed,
cast( bkpf.glbtgrp as fis_glbtgrp ) as glbtgrp,
bkpf.ppdat,
bkpf.pptme,
cast( bkpf.pptcod as fis_pptcod ) as PPTCOD,
bkpf.co_valdt,
cast(bkpf.tax_country_hd as fis_tax_country_hd preserving type ) as TAX_COUNTRY_HD,
cast(bkpf.last_change_datetime as fis_je_lastchange_datetime preserving type ) as last_change_datetime,
cast( bkpf.xsecondary as journalentryissecondaryentry preserving type ) as XSECONDARY,
cast( bkpf.reprocessing_status_code as fis_je_reprocessing_status preserving type ) as reprocessing_status_code,
// .INCLUDE FAC_BKPF_EXT_GLO STRU 0 0 Document Header: Extension include for globalisation
bkpf.glo_ref1_hd,
bkpf.glo_dat1_hd,
bkpf.glo_ref2_hd,
bkpf.glo_dat2_hd,
bkpf.glo_ref3_hd,
bkpf.glo_dat3_hd,
bkpf.glo_ref4_hd,
bkpf.glo_dat4_hd,
bkpf.glo_ref5_hd,
bkpf.glo_dat5_hd,
bkpf.glo_bp1_hd,
bkpf.glo_bp2_hd,
bkpf.whtdate,
cast( bkpf.ev_postng_ctrl as entryviewpostingcontrol preserving type ) as ev_postng_ctrl
}