BSEG
Accounting Document Segment
BSEG is an SAP database table in S/4HANA. Accounting Document Segment. It contains 424 fields. 65 CDS views read from this table.
CDS Views using this table (65)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_OperationalAcctgDocItem | view | from | EXTENSION | Operational Acctg Doc Item - Extension |
| ESH_N_ACCT_DOC_LINEITEM_BSEG_H | view | from | Accounting Document Segment | |
| FACVD_GLCASHMC_WLI_03 | view | left_outer | Cash account clearing worklist item | |
| FACVD_GLLGMC_WLI_03 | view | left_outer | OPEN ITEMS | |
| FACVD_GLMC_OIT | view | from | GL Open Items select to clearing | |
| FACVD_GLMC_OIT_04 | view | from | GL Open Items to be cleared | |
| FACVD_GLMC_WLI_03 | view | left_outer | OPEN ITEMS | |
| FACVD_RJET_WLI_06 | view | from | Creating sums of amounts from bseg | |
| Fapvd_Vendor_Bal_5 | view | from | Supplier Balance Intermediate View | |
| Farvd_Cust_Bal_5 | view | from | Customer Balance Intermediate View | |
| Fclm_Bseg_Actitem | view | from | Actual Item in BSEG | |
| Fclm_Bseg_Basic | view | from | BASIC BSEG | |
| Fclm_Bseg_Level | view | from | BSEG level | |
| Fclm_Bseg_Prjk | view | from | BSEG Projection | |
| Fclm_Bseg_Woactitem | view | from | BSEG items without actual | |
| FCOV_ACC_DOC | view | from | ||
| Fdm_Coll_Tax_View | view | inner | Tax to be added to Payments | |
| Fdm_Inv_Ref2_View | view | inner | Open Invoices and References to invoices | |
| fgl_lib_c | view_entity | from | LIB Base View | |
| fgl_lib_n_gl | view_entity | left_outer | FGLV_LIB_N_GL: GL Line Item Browser | |
| FIACCDOCINHSN | view | from | ||
| FIN_SUBVAL_JOURNALENTRYITEM | view | from | FIN Subst. Validation Journal Entry Item | |
| finoc_check_oi | view_entity | inner | Org.Chg: Check for unenriched open items | |
| FINOC_SPL_DC_OI | view | inner | OrgChg: Document chains to reconstruct | |
| finoc_spl_dockey | view | inner | Split reconstruction: document keys | |
| fins_cnv_rec_bcbs | view_entity | from | LCC: REconcile BSE_CLR with BSEG | |
| fiscds_evlit_01 | view | from | Line Item Browser: DDL Source | |
| fiscds_litb_gl_01 | view | from | Line Item Browser: DDL Source | |
| FISCDS_TRK_DOC_04 | view | from | Journal Entry History 04 | |
| FISTRPGSTR1ITEM | view | left_outer | ||
| FISTRPGSTR3BITEM | view | left_outer | ||
| FISVD_OPNIT_01 | view | from | Open Items of Manual Clearing | |
| FISVD_OPNIT_01 | view | union_all | Open Items of Manual Clearing | |
| FISVD_OPNITM_01 | view | union | Open Items of Manual Clearing | |
| FISVD_OPNITM_01 | view | from | Open Items of Manual Clearing | |
| FOP_AUTH_CANCEL | view | inner | ||
| I_AcctgDocItmForChgDoc | view | from | BASIC | Accounting Documents |
| I_AcctgDocItmForChgDoc | view | union_all | BASIC | Accounting Documents |
| I_BillgDocForCorrespncHistory | view | inner | BASIC | Billing Document for Correspondence History |
| I_JVANonOperatorInvoiceFDP | view | inner | COMPOSITE | Non Operator Invoice Data |
| I_PaymentOrderItem | view | left_outer | BASIC | Payment Order Item |
| I_PostedMCAJournalEntry | view | from | BASIC | Posted MCA Journal Entry details |
| I_PPS_AccountingDocument | view | from | BASIC | Accounting Doc For Extended PO History |
| I_RO_SAFTAccountingItem | view | from | BASIC | RO SAFT Accounting Document Item |
| I_RO_SAFTPurInvoiceItemAmount | view | from | BASIC | RO SAFT Purchase Invoice Item Amount |
| I_RO_SAFTPurInvoiceSupplier | view | from | BASIC | RO SAFT Purchase Invoice Supplier |
| I_USFedAPInvoiceTradingPartner | view_entity | inner | BASIC | AP Invoice Trading Partner details |
| ICA_BSEG_ENTRY_VIEW | view | from | ICA: Entry View Based on BSEG | |
| ICA_MatchingOplAcctgDocItem | view_entity | from | Match Opl Accounting Document Item | |
| MB5B_BSEG_PROXY | view_entity | inner | MB5B fetch FI data from ACDOCA | |
| MMIM_BSIM_PROXY | view_entity | inner | FI union view for MM-IM reporting | |
| P_APARLineItemCompanyCode | view | from | BASIC | |
| P_APARLineItemTimeRstrcnFields | view | from | BASIC | |
| P_ARBSITMCLRITEM01 | view | inner | BASIC | |
| P_BSEG_COM1 | view_entity | from | BASIC | |
| P_BSEG_GL_POSTINGS | view | from | BASIC | |
| P_FCLM_BSEG_FLWLVL | view_entity | inner | BASIC | Document item with flow level |
| P_PrepaymentClearingAcctgDoc | view | from | BASIC | |
| P_RO_SAFTBSEGVALUT | view | from | BASIC | BSEG valut |
| P_TaxRecon07 | view | from | BASIC | |
| P_TaxRecon10 | view | from | BASIC | |
| P_UNBLOCKED_FI_INVOICE | view | inner | BASIC | |
| SDM_GLO_IL_IRN_TO_GLO_REF4_HD | view | inner | Migration of allocation number from IRN to GLO_REF - Israel | |
| VFCP_DDL_FI | view | inner | ||
| WB2_CDS_CHECK_FI_NOT_CLEARED | view | inner | Check not cleared FI document existst |
Fields (424)
| 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 | |||
| KEY | buzei | BUZEI | Item | |||
| buzid | BUZID | Line Item ID | ||||
| augdt | AUGDT | Clearing | ||||
| augcp | AUGCP | ClearingEntDate | ||||
| augbl | AUGBL | Clrng doc. | ||||
| bschl | BSCHL | Posting Key | ||||
| koart | KOART | Account type | ||||
| umskz | UMSKZ | Special G/L Ind | ||||
| umsks | UMSKS | Transact.Type | ||||
| zumsk | DZUMSK | Trg.Sp.G/L Ind. | ||||
| shkzg | SHKZG | Debit/Credit | ||||
| gsber | GSBER | Business Area | ||||
| pargb | PARGB | Trdg Part.BA | ||||
| tax_country | FOT_TAX_COUNTRY | Tax Ctry/Reg. | ||||
| mwskz | MWSKZ | Tax Code | ||||
| txdat_from | FOT_TXDAT_FROM | Tax Rate Valid-From | ||||
| qsskz | QSSKZ | WTax Code | ||||
| dmbtr | DMBTR | Amount in LC | ||||
| wrbtr | WRBTR | Amount | ||||
| fcsl | FINS_VFCCUR12 | Amount in FunctCrcy | ||||
| rfccur | FINS_CURRFC | Functional Currency | ||||
| kzbtr | KZBTR_FI | Orig.Reduction | ||||
| pswbt | PSWBT | G/L Amount | ||||
| pswsl | PSWSL | G/L Currency | ||||
| txbhw | TXBHW | Original Tax Base Amount | ||||
| txbfw | TXBFW | Original Tax Base Amount | ||||
| mwsts | MWSTS | LC Tax | ||||
| wmwst | WMWST | Tax Amount | ||||
| lwsts | LWSTS | RC Tax | ||||
| lwbtr | LWBTX | RC Amount | ||||
| hwbas | HWBAS | LC Base | ||||
| fwbas | FWBAS | Base Amount | ||||
| hwzuz | HWZUZ | LC Provis. | ||||
| fwzuz | FWZUZ | Addit.tax | ||||
| shzuz | SHZUZ | Cash Discount (+/-) | ||||
| stekz | CHAR2 | Component of the Version Number | ||||
| mwart | MWART | Tax Type | ||||
| txgrp | TXGRP | Group Indicator | ||||
| ktosl | KTOSL | Transaction | ||||
| qsshb | QSSHB | WTax Base | ||||
| kursr | KURSR | Hedged Ex.Rt | ||||
| gbetr | GBETR | Hedged | ||||
| bdiff | BDIFF | Valuation Diff. | ||||
| bdif2 | BDIF2 | Valuation Diff. 2 | ||||
| valut | VALUT | Value date | ||||
| zuonr | DZUONR | Assignment | ||||
| sgtxt | SGTXT | Text | ||||
| zinkz | DZINKZ | Interest Block | ||||
| vbund | RASSC | Trading Partner | ||||
| bewar | RMVCT | Transact. Type | ||||
| altkt | BILKT_SKA1 | Group Account Number | ||||
| vorgn | VORGN | Transact. Type | ||||
| fdlev | FDLEV | Planning Level | ||||
| fdgrp | FDGRP | Planning group | ||||
| fdwbt | FDWBT | Planned Amount | ||||
| fdtag | FDTAG | Planning Date | ||||
| fkont | FIPLS | Fin.Budget | ||||
| kokrs | KOKRS | CO Area | ||||
| kostl | KOSTL | Cost Center | ||||
| projn | PROJN | not in use | ||||
| aufnr | AUFNR | Order | ||||
| vbeln | VBELN_VF | Billing Doc. | ||||
| vbel2 | VBELN_VA | Sales Document | ||||
| posn2 | POSNR_VA | Item | ||||
| eten2 | ETENR | Schedule Line | ||||
| service_doc_type | FCO_SRVDOC_TYPE | Service Doc. Type | ||||
| service_doc_id | FCO_SRVDOC_ID | Service Document | ||||
| service_doc_item_id | FCO_SRVDOC_ITEM_ID | Service Doc. Item | ||||
| anln1 | ANLN1 | Asset | ||||
| anln2 | ANLN2 | Sub-number | ||||
| anbwa | ANBWA | Ast Transaction Type | ||||
| bzdat | BZDAT | Asset Val. Date | ||||
| pernr | PERNR_D | Personnel No. | ||||
| xumsw | XUMSW | Sales-Related | ||||
| xhres | XHRES | Indicator: Resident G/L Account? | ||||
| xkres | XKRES | Line Items | ||||
| xopvw | XOPVW | OI Management | ||||
| xcpdd | XCPDD | Individ. Set | ||||
| xskst | XSKST | CCtPosting Stat | ||||
| xsauf | XSAUF | Ord.Post.Stat. | ||||
| xspro | XSPRO | ProjPost. Stat | ||||
| xserg | XSERG | PA Post. Stat. | ||||
| xfakt | XFAKT | Indicator: Billing Document Update Successful? | ||||
| xuman | XUMAN | Indicator: Transfer Posting from Down Payment? | ||||
| xanet | XANET | Indicator: Down Payment in Net Procedure? | ||||
| xskrl | XSKRL | W/o CashDsc. | ||||
| xinve | XINVE | Invest.ID | ||||
| xpanz | XPANZ | Display Item | ||||
| xauto | XAUTO | Auto. created | ||||
| xncop | XNCOP | Indicator: Items Cannot Be Copied? | ||||
| xzahl | XZAHL | Payt Tran. | ||||
| saknr | SAKNR | G/L Account | ||||
| hkont | HKONT | G/L Acct | ||||
| kunnr | KUNNR | Customer | ||||
| lifnr | LIFNR | Supplier | ||||
| filkd | FILKD | Branch | ||||
| xbilk | XBILK | Balance sheet acct | ||||
| gvtyp | GVTYP | P&L state. acct | ||||
| hzuon | HZUON | Sp.G/L Assgt | ||||
| zfbdt | DZFBDT | Baseline Date | ||||
| zterm | DZTERM | Pyt Terms | ||||
| zbd1t | DZBD1T | Days 1 | ||||
| zbd2t | DZBD2T | Days 2 | ||||
| zbd3t | DZBD3T | Days Net | ||||
| zbd1p | DZBD1P | CD Percentage 1 | ||||
| zbd2p | DZBD2P | CD Percentage 2 | ||||
| skfbt | SKFBT | CD Base | ||||
| sknto | SKNTO | Discount Amt | ||||
| wskto | WSKTO | CD Amount | ||||
| zlsch | SCHZW_BSEG | Payt Method | ||||
| zlspr | DZLSPR | Pmnt block | ||||
| zbfix | DZBFIX | Fixed | ||||
| hbkid | HBKID | House Bank | ||||
| bvtyp | BVTYP | Part.bank type | ||||
| nebtr | NEBTR | Payment Amt | ||||
| mwsk1 | MWSKX | Tax Code | ||||
| txdat_from1 | FOT_TXDAT_FROMX | Tax Rate Valid-From | ||||
| tax_country1 | FOT_TAX_COUNTRYX | Tax Breakdown C/R | ||||
| dmbt1 | DMBTX | Amount | ||||
| wrbt1 | WRBTX | Amount | ||||
| hist_tax_factor1 | FOT_HIST_FACTOR_FOR_TAX_AMOUNT | CrcyCnvrsnFctrTaxAmt | ||||
| mwsk2 | MWSKX | Tax Code | ||||
| txdat_from2 | FOT_TXDAT_FROMX | Tax Rate Valid-From | ||||
| tax_country2 | FOT_TAX_COUNTRYX | Tax Breakdown C/R | ||||
| dmbt2 | DMBTX | Amount | ||||
| wrbt2 | WRBTX | Amount | ||||
| hist_tax_factor2 | FOT_HIST_FACTOR_FOR_TAX_AMOUNT | CrcyCnvrsnFctrTaxAmt | ||||
| mwsk3 | MWSKX | Tax Code | ||||
| txdat_from3 | FOT_TXDAT_FROMX | Tax Rate Valid-From | ||||
| tax_country3 | FOT_TAX_COUNTRYX | Tax Breakdown C/R | ||||
| dmbt3 | DMBTX | Amount | ||||
| wrbt3 | WRBTX | Amount | ||||
| hist_tax_factor3 | FOT_HIST_FACTOR_FOR_TAX_AMOUNT | CrcyCnvrsnFctrTaxAmt | ||||
| hist_tax_factor | FOT_HIST_FACTOR_FOR_TAX_AMOUNT | CrcyCnvrsnFctrTaxAmt | ||||
| rebzg | REBZG | Invoice Ref. | ||||
| rebzj | REBZJ | Fiscal Year | ||||
| rebzz | REBZZ | Item | ||||
| rebzt | REBZT | Follow-On Doc. Type | ||||
| zollt | DZOLLT | Cust.Tariff No. | ||||
| zolld | DZOLLD | Customs Date | ||||
| lzbkz | LZBKZ | SCB Ind. | ||||
| landl | LANDL | Supply C/R | ||||
| diekz | DIEKZ | Service Ind. | ||||
| samnr | SAMNR | Collect.Inv. | ||||
| abper | ABPER_RF | Settl.Period | ||||
| vrskz | VRSKZ | Insurance Ind. | ||||
| vrsdt | VRSDT | Insurance Date | ||||
| disbn | DISBN | Usage Document | ||||
| disbj | DISBJ | Year | ||||
| disbz | DISBZ | Line Item | ||||
| wverw | WVERW | Usage | ||||
| anfbn | ANFBN | BoE Payt Req. | ||||
| anfbj | ANFBJ | Fisc. Year | ||||
| anfbu | ANFBU | Company Code | ||||
| anfae | ANFAE | Return Bef. | ||||
| blnbt | BLNBT | Preference Amt | ||||
| blnkz | BLNKZ | Subs.ind. | ||||
| blnpz | BLNPZ | Pref. % Rate | ||||
| mschl | MSCHL | Dunning key | ||||
| mansp | MANSP | Dunn. Block | ||||
| madat | MADAT | Last Dunned | ||||
| manst | MAHNS_D | Dunning Level | ||||
| maber | MABER | Dunning Area | ||||
| esrnr | ESRNR | ISR Number | ||||
| esrre | ESRRE | ISR/QR Ref. | ||||
| esrpz | ESRPZ | Check digit | ||||
| klibt | KLIBT | Credit Ctrl Amt | ||||
| qsznr | QSZNR | Exemption No. | ||||
| qbshb | QBSHB | Withholding Tax | ||||
| qsfbt | QSFBT | WTax-Exempt | ||||
| navhw | NAVHW | Non-Deductible | ||||
| navfw | NAVFW | Non-Deductible | ||||
| matnr | MATNR | Material | ||||
| werks | WERKS_D | Plant | ||||
| menge | MENGE_D | Quantity | ||||
| meins | MEINS | Base Unit | ||||
| erfmg | ERFMG | Quantity in UnE | ||||
| erfme | ERFME | Unit of Entry | ||||
| bpmng | BPMNG | Qty in OPUn | ||||
| bprme | BPRME | PO Price Unit | ||||
| ebeln_logsys | EBELN_LOGSYS | LogSys of PurchDoc | ||||
| ebeln | EBELN | Purchasing Doc. | ||||
| ebelp | EBELP | Item | ||||
| zekkn | DZEKKN | Account Assgmt No. | ||||
| elikz | ELIKZ | Deliv. Compl. | ||||
| vprsv | VPRSV | Price control | ||||
| peinh | PEINH | Price unit | ||||
| bwkey | BWKEY | Valuation Area | ||||
| bwtar | BWTAR_D | Valuation Type | ||||
| bustw | BUSTW | Value String | ||||
| rewrt | REEWR | Invoice Value | ||||
| rewwr | REWWR | FC Invoice Amt | ||||
| bonfb | BONFB | Amount | ||||
| bualt | BUALT | Amount | ||||
| psalt | PSALT | Alt. Price Ctrl | ||||
| nprei | NPREI | New Price | ||||
| tbtkz | TBTKZ | Subseq. Dr/Cr | ||||
| spgrp | SPGRP | Block.Reas.:Prc | ||||
| spgrm | SPGRM | Block.Reas.:Qty | ||||
| spgrt | SPGRT | Bl. Reason Date | ||||
| spgrg | SPGRG | Block.Reas: OPQ | ||||
| spgrv | SPGRV | Block.Reas:Proj | ||||
| spgrq | SPGRQ | Man.Block.Reasn | ||||
| stceg | STCEG | VAT Reg. No. | ||||
| egbld | EGBLD | Dest. C/R | ||||
| eglld | EGLLD | Supplying C/R | ||||
| rstgr | RSTGR | Reason Code | ||||
| ryacq | RYACQ | Yr of acquisitn | ||||
| rpacq | RPACQ | Period of Acq. | ||||
| rdiff | RDIFF | Diff. Realized | ||||
| rdif2 | RDIF2 | Diff.Realized 2 | ||||
| prctr | PRCTR | Profit Center | ||||
| xhkom | XHKOM | Manual G/L Acct | ||||
| fs_product_group | FFS_PRODUCT_GROUP | Product Group (FS) | ||||
| branch_id | FFS_BRANCH_ID | Branch (FS) | ||||
| datasource_id | FFS_DATASOURCE_ID | Data Source | ||||
| vname | JV_NAME | Joint venture | ||||
| recid | JV_RECIND | Recovery Ind. | ||||
| egrup | JV_EGROUP | Equity group | ||||
| vptnr | JV_PART | Partner | ||||
| vertt | RANTYP | Contract Type | ||||
| vertn | RANL | Contract Number | ||||
| vbewa | SBEWART | Flow Type | ||||
| depot | RLDEPO | Securities Acct | ||||
| txjcd | TXJCD | Tax Jur. | ||||
| imkey | IMKEY | Real Estate Key | ||||
| dabrz | DABRBEZ | Reference date | ||||
| popts | POPTSATZ | Option Rate | ||||
| fipos | FIPOS | Commitment item | ||||
| kstrg | KSTRG | Cost Object | ||||
| nplnr | NPLNR | Network | ||||
| aufpl | AUFPL_CH | TaskList No.Ops | ||||
| aplzl | APLZL_CH | Counter | ||||
| projk | PS_PSP_PNR | WBS Element | ||||
| paobjnr | RKEOBJNR | Profit. segment | ||||
| pasubnr | RKESUBNR | Subnumber | ||||
| spgrs | SPGRS | Blkg Reas. Amount | ||||
| spgrc | SPGRC | Block: Quality | ||||
| btype | JV_BILIND | Billing ind. | ||||
| etype | JV_ETYPE | Equity Type | ||||
| xegdr | XEGDR | EU Triang. Deal | ||||
| lnran | LNRAN | Sequence Number | ||||
| hrkft | HRKFT | Origin Group | ||||
| dmbe2 | DMBE2 | LC2 Amount | ||||
| dmbe3 | DMBE3 | LC3 Amount | ||||
| dmb21 | DMB2X | Amount | ||||
| dmb22 | DMB2X | Amount | ||||
| dmb23 | DMB2X | Amount | ||||
| dmb31 | DMB3X | Amount | ||||
| dmb32 | DMB3X | Amount | ||||
| dmb33 | DMB3X | Amount | ||||
| mwst2 | MWST2 | LC2 Tax | ||||
| mwst3 | MWST3 | LC3 Tax | ||||
| navh2 | NAVH2 | LC2 Non-Ded. | ||||
| navh3 | NAVH3 | LC3 Non-Ded. | ||||
| sknt2 | SKNT2 | CD Amt LC2 | ||||
| sknt3 | SKNT3 | CD Amt LC3 | ||||
| bdif3 | BDIF3 | Valuation Diff. 3 | ||||
| rdif3 | RDIF3 | Diff.Realized 3 | ||||
| hwmet | HWMET | Calculation Method | ||||
| glupm | GLUPM | Update | ||||
| xragl | XRAGL | Reverse Clearing | ||||
| uzawe | UZAWE | Pmnt Meth. Sup. | ||||
| lokkt | ALTKT_SKB1 | Altern. Account | ||||
| fistl | FISTL | Funds Center | ||||
| geber | BP_GEBER | Fund | ||||
| stbuk | STBUK | Tax CoCode | ||||
| txbh2 | TXBH2 | LC2 Tax Base Amount | ||||
| txbh3 | TXBH3 | LC3 Tax Base Amount | ||||
| pprct | PPRCTR | Partner PC | ||||
| xref1 | XREF1 | Reference Key 1 | ||||
| xref2 | XREF2 | Reference Key 2 | ||||
| kblnr | KBLNR_FI | Earmarked funds | ||||
| kblpos | KBLPOS | Document Item | ||||
| sttax | STTAX | Statistical Tax | ||||
| fkber | FKBER_SHORT | Functional Area | ||||
| obzei | OBZEI | Original Item | ||||
| xnegp | XNEGP | Negative Postg | ||||
| rfzei | RFZEI_CC | Payt Card Item | ||||
| ccbtc | CCBTC | Settlement | ||||
| kkber | KKBER | Cred.Contr.Area | ||||
| empfb | EMPFB | Payer | ||||
| xref3 | XREF3 | Reference Key 3 | ||||
| dtws1 | DTAT16 | Instruct. Key 1 | ||||
| dtws2 | DTAT17 | Instruct. Key 2 | ||||
| dtws3 | DTAT18 | Instruct. key 3 | ||||
| dtws4 | DTAT19 | Instruct. key 4 | ||||
| gricd | J_1AGICD_D | Activity Code | ||||
| grirg | REGIO | Region | ||||
| gityp | J_1ADTYP_D | Distr. Type | ||||
| xpypr | XPYPR | Payment Sent | ||||
| kidno | KIDNO | Payment Ref. | ||||
| absbt | ABSBT | Hedged Amount | ||||
| idxsp | J_1AINDXSP | Inflation Index | ||||
| linfv | J_1ALINFVL | Last Adj. Date | ||||
| kontt | KONTT_FI | Acct Assmt Cat. | ||||
| kontl | KONTL_FI | Acct assignment | ||||
| uebgdat | UEBGDATUM | Date of Legal Dunn. | ||||
| txdat | TXDAT | Tax Date | ||||
| agzei | AGZEI | Clearing Item | ||||
| pycur | PYCUR | Paymnt Crcy | ||||
| pyamt | PYAMT | Pt Crcy Amt | ||||
| bupla | BUPLA | Business place | ||||
| secco | SECCO | Section Code | ||||
| lstar | LSTAR | Activity Type | ||||
| cession_kz | CESSION_KZ | AR Pledging Ind | ||||
| prznr | CO_PRZNR | Business Process | ||||
| ppdiff | PPDIFF | Diff. Realized | ||||
| ppdif2 | PPDIF2 | Diff. Realized | ||||
| ppdif3 | PPDIF3 | Diff. Realized | ||||
| penlc1 | PENALTY1 | Penalty Chge LC | ||||
| penlc2 | PENALTY2 | Pen.Charge LC2 | ||||
| penlc3 | PENALTY3 | Pen.Charge LC3 | ||||
| penfc | PENALTY | Penalty Charge | ||||
| pendays | PDAYS | Days in Arrears | ||||
| penrc | PENRC | Reason f. Delay | ||||
| grant_nbr | GM_GRANT_NBR | Grant | ||||
| sctax | SCTAX | FI-CA Tax Portion | ||||
| fkber_long | FKBER | Functional Area | ||||
| gmvkz | FM_GMVKZ | Execution | ||||
| srtype | FM_SRTYPE | Addit.Receivab. | ||||
| intreno | VVINTRENO | RE code | ||||
| measure | FM_MEASURE | Funded Program | ||||
| auggj | AUGGJ | Clrg Fiscal Yr | ||||
| ppa_ex_ind | EXCLUDE_FLG | PPA Exclude | ||||
| docln | DOCLN6 | G/L Line Item | ||||
| segment | FB_SEGMENT | Segment | ||||
| psegment | FB_PSEGMENT | Partner Segment | ||||
| pfkber | SFKBER | Partner FArea | ||||
| hktid | HKTID | Account ID | ||||
| kstar | KSTAR | Cost Element | ||||
| xlgclr | XLGCLR | OI Mgmt by LedgerGrp | ||||
| taxps | TAX_POSNR | Tax doc. item number | ||||
| pays_prov | COM_WEC_PAYMENT_SRV_PROVIDER | PSP | ||||
| pays_tran | FPS_TRANSACTION | PSP Payment Ref. | ||||
| mndid | SEPA_MNDID | Mandate Ref. | ||||
| xfrge_bseg | XFRGE_BSEG | Released | ||||
| awtyp | AWTYP | Ref. procedure | ||||
| awkey | AWKEY | Reference Key | ||||
| awsys | AWSYS | Logical System | ||||
| posnr | POSNR_ACC | Position | ||||
| buzei_sender | BUZEI_SENDER | Sender Item | ||||
| h_monat | MONAT | Period | ||||
| h_bstat | BSTAT_D | Document Status | ||||
| h_budat | BUDAT | Posting Date | ||||
| h_bldat | BLDAT | Document Date | ||||
| h_waers | WAERS | Currency | ||||
| h_blart | BLART | Document Type | ||||
| h_hwaer | HWAER | Local Currency | ||||
| h_hwae2 | HWAE2 | Local curr. 2 | ||||
| h_hwae3 | HWAE3 | Local curr. 3 | ||||
| sk1dt | SK1DT | Cash Discount 1 | ||||
| sk2dt | SK2DT | Cash Discount 2 | ||||
| prctr_drvtn_source_type | FINOC_PRCTR_DRVTN_SOURCE_TYPE | Profit Center Source | ||||
| payt_rsn | FARP_PAYT_RSN | Payment Reason | ||||
| _dataaging | DATA_TEMPERATURE | Data Aging | ||||
| fqftype | FQM_FLOW_TYPE | Flow Type | ||||
| lqitem | FLQPOS | Liquidity Item | ||||
| gkont | GKONT | Offsetting Acct | ||||
| gkart | GKOAR | Offst.Acct Type | ||||
| ghkon | GHKONT | G/L Offsetting Acct | ||||
| squan | SIGN_QUANTITY | Qty +/- Sign | ||||
| anln2_pn | ANLN2 | Sub-number | ||||
| bwasl_pn | BWASL | Trans. Type | ||||
| bzdat_pn | BZDAT | Asset Val. Date | ||||
| xvabg_pn | XVABG | Compl.Retiremnt | ||||
| anbtr_pn | ANBTR | Amount Posted | ||||
| prozs_pn | PROZS | Percentage Rate | ||||
| acdoc_eew_dummy | CFD_DUMMY | Dummy | ||||
| dummy_incl_eew_cobl | CFD_DUMMY | Dummy | ||||
| kdgrp | KDGRP | Customer Group | ||||
| land1 | COBL_LAND1_GP | Country/Region | ||||
| brsch | BRSCH | Industry | ||||
| acrobjtype | ACR_OBJ_TYPE | Accrual Object Type | ||||
| acrlogsys | ACR_LOGSYS | Logical Syst. AcrObj | ||||
| acrobj_id | ACR_OBJ_ID | Accrual Object | ||||
| acrsobj_id | ACR_SUBOBJ_ID | Accrual Subobject | ||||
| acritmtype | ACR_ITEM_TYPE | Accrual Item Type | ||||
| acrrefobj_id | ACR_REFOBJ_ID | Acr. Reference ID | ||||
| acrvaldat | ACR_VALUE_DATE | Accrual Value Date | ||||
| valobjtype | VAL_OBJ_TYPE | Type of Fin.Val.Obj. | ||||
| valobj_id | VAL_OBJ_ID | Fin Valuation Object | ||||
| valsobj_id | VAL_SUBOBJ_ID | Fin.Val.Sub.Object | ||||
| netdt | NETDT | Due On | ||||
| risk_class | UKM_RISK_CLASS | Risk Class | ||||
| sdm_version | FINS_SDM_VERSION_BSEG | SDM Versioning | ||||
| glo_ref1 | FAC_GLO_REF1 | Country/Region Specific Reference 1 | ||||
| re_bukrs | FAGL_RE_BUKRS | Company Code | ||||
| re_account | FAGL_RE_ACCOUNT | Ex/Rv A/c in CL | ||||
| dp_payment_type | DP_PAYMENT_TYPE | Payment Type | ||||
| dp_trans_id | DP_TRANSID | Transaction/Payt ID | ||||
| dp_payment_request | DP_PAYTREQUEST | Payment Request | ||||
| pgeber | FM_PFUND | Partner Fund | ||||
| pgrant_nbr | GM_GRANT_PARTNER | Partner Grant | ||||
| budget_pd | FM_BUDGET_PERIOD | Budget Period | ||||
| pbudget_pd | FM_PBUDGET_PERIOD | Par. BudPer | ||||
| j_1tpbupl | BCODE | Branch Code | ||||
| perop_beg | FM_PEROP_FI_LOW | Per. of Perf. Start | ||||
| perop_end | FM_PEROP_FI_HIGH | Per. of Perf. End | ||||
| fastpay | FMFG_FASTPAY_FLG | Fast Pay | ||||
| ignr_ivref | FMFG_IGNORE_INV_REF | Ignore Invoice Ref. | ||||
| fmfgus_key | FMFG_US_KEY | US Govt | ||||
| fmxdocnr | FM_XDOCNR | FM Ref. Doc. Nr. | ||||
| fmxyear | FM_XYEAR | FM Ref. Year | ||||
| fmxdocln | FM_XDOCLN | FM Ref. Item | ||||
| fmxzekkn | FM_XZEKKN | FM Ref. AA. | ||||
| prodper | JV_PRODPER | Prod.Month | ||||
| gst_part | J_1IG_PARTNER | GST Partner | ||||
| plc_sup | J_1IG_REGION | Place of Supply | ||||
| hsn_sac | J_1IG_HSN_SAC | HSN/SAC Code | ||||
| irn | J_1IG_IRN | Invoice Ref. Number | ||||
| recrf | J_1IRECRF | Recredit Flag | ||||
| bdgt_account | PSM_BDGT_ACCOUNT | Budget Account | ||||
| bdgt_account_cocode | PSM_BDGT_ACCOUNT_COCODE | Company Code for Budget Account | ||||
| inward_no | SAFM_AP_INWARD_NO | Incg Doc. Nmbr | ||||
| inward_dt | SAFM_AP_INWARD_DT | Incg Doc. Date | ||||
| ground_no | SAFM_AP_PYBSNO | Payt. Ground No. | ||||
| ground_dt | SAFM_AP_PYBSDAT | Payt. Ground Date | ||||
| ground_typ | SAFM_AP_PYBSTYP | Payt. Against | ||||
| pymtkey | SAFM_AP_PYMNTKEY | Payt/Prop Key |
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 Segment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BSEG (
MANDT, -- Client [MANDT]
BUKRS, -- Company Code [BUKRS]
BELNR, -- Document Number [BELNR_D]
GJAHR, -- Fiscal Year [GJAHR]
BUZEI, -- Item [BUZEI]
BUZID, -- Line Item ID [BUZID]
AUGDT, -- Clearing [AUGDT]
AUGCP, -- ClearingEntDate [AUGCP]
AUGBL, -- Clrng doc. [AUGBL]
BSCHL, -- Posting Key [BSCHL]
KOART, -- Account type [KOART]
UMSKZ, -- Special G/L Ind [UMSKZ]
UMSKS, -- Transact.Type [UMSKS]
ZUMSK, -- Trg.Sp.G/L Ind. [DZUMSK]
SHKZG, -- Debit/Credit [SHKZG]
GSBER, -- Business Area [GSBER]
PARGB, -- Trdg Part.BA [PARGB]
TAX_COUNTRY, -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
MWSKZ, -- Tax Code [MWSKZ]
TXDAT_FROM, -- Tax Rate Valid-From [FOT_TXDAT_FROM]
QSSKZ, -- WTax Code [QSSKZ]
DMBTR, -- Amount in LC [DMBTR]
WRBTR, -- Amount [WRBTR]
FCSL, -- Amount in FunctCrcy [FINS_VFCCUR12]
RFCCUR, -- Functional Currency [FINS_CURRFC]
KZBTR, -- Orig.Reduction [KZBTR_FI]
PSWBT, -- G/L Amount [PSWBT]
PSWSL, -- G/L Currency [PSWSL]
TXBHW, -- Original Tax Base Amount [TXBHW]
TXBFW, -- Original Tax Base Amount [TXBFW]
MWSTS, -- LC Tax [MWSTS]
WMWST, -- Tax Amount [WMWST]
LWSTS, -- RC Tax [LWSTS]
LWBTR, -- RC Amount [LWBTX]
HWBAS, -- LC Base [HWBAS]
FWBAS, -- Base Amount [FWBAS]
HWZUZ, -- LC Provis. [HWZUZ]
FWZUZ, -- Addit.tax [FWZUZ]
SHZUZ, -- Cash Discount (+/-) [SHZUZ]
STEKZ, -- Component of the Version Number [CHAR2]
MWART, -- Tax Type [MWART]
TXGRP, -- Group Indicator [TXGRP]
KTOSL, -- Transaction [KTOSL]
QSSHB, -- WTax Base [QSSHB]
KURSR, -- Hedged Ex.Rt [KURSR]
GBETR, -- Hedged [GBETR]
BDIFF, -- Valuation Diff. [BDIFF]
BDIF2, -- Valuation Diff. 2 [BDIF2]
VALUT, -- Value date [VALUT]
ZUONR, -- Assignment [DZUONR]
SGTXT, -- Text [SGTXT]
ZINKZ, -- Interest Block [DZINKZ]
VBUND, -- Trading Partner [RASSC]
BEWAR, -- Transact. Type [RMVCT]
ALTKT, -- Group Account Number [BILKT_SKA1]
VORGN, -- Transact. Type [VORGN]
FDLEV, -- Planning Level [FDLEV]
FDGRP, -- Planning group [FDGRP]
FDWBT, -- Planned Amount [FDWBT]
FDTAG, -- Planning Date [FDTAG]
FKONT, -- Fin.Budget [FIPLS]
KOKRS, -- CO Area [KOKRS]
KOSTL, -- Cost Center [KOSTL]
PROJN, -- not in use [PROJN]
AUFNR, -- Order [AUFNR]
VBELN, -- Billing Doc. [VBELN_VF]
VBEL2, -- Sales Document [VBELN_VA]
POSN2, -- Item [POSNR_VA]
ETEN2, -- Schedule Line [ETENR]
SERVICE_DOC_TYPE, -- Service Doc. Type [FCO_SRVDOC_TYPE]
SERVICE_DOC_ID, -- Service Document [FCO_SRVDOC_ID]
SERVICE_DOC_ITEM_ID, -- Service Doc. Item [FCO_SRVDOC_ITEM_ID]
ANLN1, -- Asset [ANLN1]
ANLN2, -- Sub-number [ANLN2]
ANBWA, -- Ast Transaction Type [ANBWA]
BZDAT, -- Asset Val. Date [BZDAT]
PERNR, -- Personnel No. [PERNR_D]
XUMSW, -- Sales-Related [XUMSW]
XHRES, -- Indicator: Resident G/L Account? [XHRES]
XKRES, -- Line Items [XKRES]
XOPVW, -- OI Management [XOPVW]
XCPDD, -- Individ. Set [XCPDD]
XSKST, -- CCtPosting Stat [XSKST]
XSAUF, -- Ord.Post.Stat. [XSAUF]
XSPRO, -- ProjPost. Stat [XSPRO]
XSERG, -- PA Post. Stat. [XSERG]
XFAKT, -- Indicator: Billing Document Update Successful? [XFAKT]
XUMAN, -- Indicator: Transfer Posting from Down Payment? [XUMAN]
XANET, -- Indicator: Down Payment in Net Procedure? [XANET]
XSKRL, -- W/o CashDsc. [XSKRL]
XINVE, -- Invest.ID [XINVE]
XPANZ, -- Display Item [XPANZ]
XAUTO, -- Auto. created [XAUTO]
XNCOP, -- Indicator: Items Cannot Be Copied? [XNCOP]
XZAHL, -- Payt Tran. [XZAHL]
SAKNR, -- G/L Account [SAKNR]
HKONT, -- G/L Acct [HKONT]
KUNNR, -- Customer [KUNNR]
LIFNR, -- Supplier [LIFNR]
FILKD, -- Branch [FILKD]
XBILK, -- Balance sheet acct [XBILK]
GVTYP, -- P&L state. acct [GVTYP]
HZUON, -- Sp.G/L Assgt [HZUON]
ZFBDT, -- Baseline Date [DZFBDT]
ZTERM, -- Pyt Terms [DZTERM]
ZBD1T, -- Days 1 [DZBD1T]
ZBD2T, -- Days 2 [DZBD2T]
ZBD3T, -- Days Net [DZBD3T]
ZBD1P, -- CD Percentage 1 [DZBD1P]
ZBD2P, -- CD Percentage 2 [DZBD2P]
SKFBT, -- CD Base [SKFBT]
SKNTO, -- Discount Amt [SKNTO]
WSKTO, -- CD Amount [WSKTO]
ZLSCH, -- Payt Method [SCHZW_BSEG]
ZLSPR, -- Pmnt block [DZLSPR]
ZBFIX, -- Fixed [DZBFIX]
HBKID, -- House Bank [HBKID]
BVTYP, -- Part.bank type [BVTYP]
NEBTR, -- Payment Amt [NEBTR]
MWSK1, -- Tax Code [MWSKX]
TXDAT_FROM1, -- Tax Rate Valid-From [FOT_TXDAT_FROMX]
TAX_COUNTRY1, -- Tax Breakdown C/R [FOT_TAX_COUNTRYX]
DMBT1, -- Amount [DMBTX]
WRBT1, -- Amount [WRBTX]
HIST_TAX_FACTOR1, -- CrcyCnvrsnFctrTaxAmt [FOT_HIST_FACTOR_FOR_TAX_AMOUNT]
MWSK2, -- Tax Code [MWSKX]
TXDAT_FROM2, -- Tax Rate Valid-From [FOT_TXDAT_FROMX]
TAX_COUNTRY2, -- Tax Breakdown C/R [FOT_TAX_COUNTRYX]
DMBT2, -- Amount [DMBTX]
WRBT2, -- Amount [WRBTX]
HIST_TAX_FACTOR2, -- CrcyCnvrsnFctrTaxAmt [FOT_HIST_FACTOR_FOR_TAX_AMOUNT]
MWSK3, -- Tax Code [MWSKX]
TXDAT_FROM3, -- Tax Rate Valid-From [FOT_TXDAT_FROMX]
TAX_COUNTRY3, -- Tax Breakdown C/R [FOT_TAX_COUNTRYX]
DMBT3, -- Amount [DMBTX]
WRBT3, -- Amount [WRBTX]
HIST_TAX_FACTOR3, -- CrcyCnvrsnFctrTaxAmt [FOT_HIST_FACTOR_FOR_TAX_AMOUNT]
HIST_TAX_FACTOR, -- CrcyCnvrsnFctrTaxAmt [FOT_HIST_FACTOR_FOR_TAX_AMOUNT]
REBZG, -- Invoice Ref. [REBZG]
REBZJ, -- Fiscal Year [REBZJ]
REBZZ, -- Item [REBZZ]
REBZT, -- Follow-On Doc. Type [REBZT]
ZOLLT, -- Cust.Tariff No. [DZOLLT]
ZOLLD, -- Customs Date [DZOLLD]
LZBKZ, -- SCB Ind. [LZBKZ]
LANDL, -- Supply C/R [LANDL]
DIEKZ, -- Service Ind. [DIEKZ]
SAMNR, -- Collect.Inv. [SAMNR]
ABPER, -- Settl.Period [ABPER_RF]
VRSKZ, -- Insurance Ind. [VRSKZ]
VRSDT, -- Insurance Date [VRSDT]
DISBN, -- Usage Document [DISBN]
DISBJ, -- Year [DISBJ]
DISBZ, -- Line Item [DISBZ]
WVERW, -- Usage [WVERW]
ANFBN, -- BoE Payt Req. [ANFBN]
ANFBJ, -- Fisc. Year [ANFBJ]
ANFBU, -- Company Code [ANFBU]
ANFAE, -- Return Bef. [ANFAE]
BLNBT, -- Preference Amt [BLNBT]
BLNKZ, -- Subs.ind. [BLNKZ]
BLNPZ, -- Pref. % Rate [BLNPZ]
MSCHL, -- Dunning key [MSCHL]
MANSP, -- Dunn. Block [MANSP]
MADAT, -- Last Dunned [MADAT]
MANST, -- Dunning Level [MAHNS_D]
MABER, -- Dunning Area [MABER]
ESRNR, -- ISR Number [ESRNR]
ESRRE, -- ISR/QR Ref. [ESRRE]
ESRPZ, -- Check digit [ESRPZ]
KLIBT, -- Credit Ctrl Amt [KLIBT]
QSZNR, -- Exemption No. [QSZNR]
QBSHB, -- Withholding Tax [QBSHB]
QSFBT, -- WTax-Exempt [QSFBT]
NAVHW, -- Non-Deductible [NAVHW]
NAVFW, -- Non-Deductible [NAVFW]
MATNR, -- Material [MATNR]
WERKS, -- Plant [WERKS_D]
MENGE, -- Quantity [MENGE_D]
MEINS, -- Base Unit [MEINS]
ERFMG, -- Quantity in UnE [ERFMG]
ERFME, -- Unit of Entry [ERFME]
BPMNG, -- Qty in OPUn [BPMNG]
BPRME, -- PO Price Unit [BPRME]
EBELN_LOGSYS, -- LogSys of PurchDoc [EBELN_LOGSYS]
EBELN, -- Purchasing Doc. [EBELN]
EBELP, -- Item [EBELP]
ZEKKN, -- Account Assgmt No. [DZEKKN]
ELIKZ, -- Deliv. Compl. [ELIKZ]
VPRSV, -- Price control [VPRSV]
PEINH, -- Price unit [PEINH]
BWKEY, -- Valuation Area [BWKEY]
BWTAR, -- Valuation Type [BWTAR_D]
BUSTW, -- Value String [BUSTW]
REWRT, -- Invoice Value [REEWR]
REWWR, -- FC Invoice Amt [REWWR]
BONFB, -- Amount [BONFB]
BUALT, -- Amount [BUALT]
PSALT, -- Alt. Price Ctrl [PSALT]
NPREI, -- New Price [NPREI]
TBTKZ, -- Subseq. Dr/Cr [TBTKZ]
SPGRP, -- Block.Reas.:Prc [SPGRP]
SPGRM, -- Block.Reas.:Qty [SPGRM]
SPGRT, -- Bl. Reason Date [SPGRT]
SPGRG, -- Block.Reas: OPQ [SPGRG]
SPGRV, -- Block.Reas:Proj [SPGRV]
SPGRQ, -- Man.Block.Reasn [SPGRQ]
STCEG, -- VAT Reg. No. [STCEG]
EGBLD, -- Dest. C/R [EGBLD]
EGLLD, -- Supplying C/R [EGLLD]
RSTGR, -- Reason Code [RSTGR]
RYACQ, -- Yr of acquisitn [RYACQ]
RPACQ, -- Period of Acq. [RPACQ]
RDIFF, -- Diff. Realized [RDIFF]
RDIF2, -- Diff.Realized 2 [RDIF2]
PRCTR, -- Profit Center [PRCTR]
XHKOM, -- Manual G/L Acct [XHKOM]
FS_PRODUCT_GROUP, -- Product Group (FS) [FFS_PRODUCT_GROUP]
BRANCH_ID, -- Branch (FS) [FFS_BRANCH_ID]
DATASOURCE_ID, -- Data Source [FFS_DATASOURCE_ID]
VNAME, -- Joint venture [JV_NAME]
RECID, -- Recovery Ind. [JV_RECIND]
EGRUP, -- Equity group [JV_EGROUP]
VPTNR, -- Partner [JV_PART]
VERTT, -- Contract Type [RANTYP]
VERTN, -- Contract Number [RANL]
VBEWA, -- Flow Type [SBEWART]
DEPOT, -- Securities Acct [RLDEPO]
TXJCD, -- Tax Jur. [TXJCD]
IMKEY, -- Real Estate Key [IMKEY]
DABRZ, -- Reference date [DABRBEZ]
POPTS, -- Option Rate [POPTSATZ]
FIPOS, -- Commitment item [FIPOS]
KSTRG, -- Cost Object [KSTRG]
NPLNR, -- Network [NPLNR]
AUFPL, -- TaskList No.Ops [AUFPL_CH]
APLZL, -- Counter [APLZL_CH]
PROJK, -- WBS Element [PS_PSP_PNR]
PAOBJNR, -- Profit. segment [RKEOBJNR]
PASUBNR, -- Subnumber [RKESUBNR]
SPGRS, -- Blkg Reas. Amount [SPGRS]
SPGRC, -- Block: Quality [SPGRC]
BTYPE, -- Billing ind. [JV_BILIND]
ETYPE, -- Equity Type [JV_ETYPE]
XEGDR, -- EU Triang. Deal [XEGDR]
LNRAN, -- Sequence Number [LNRAN]
HRKFT, -- Origin Group [HRKFT]
DMBE2, -- LC2 Amount [DMBE2]
DMBE3, -- LC3 Amount [DMBE3]
DMB21, -- Amount [DMB2X]
DMB22, -- Amount [DMB2X]
DMB23, -- Amount [DMB2X]
DMB31, -- Amount [DMB3X]
DMB32, -- Amount [DMB3X]
DMB33, -- Amount [DMB3X]
MWST2, -- LC2 Tax [MWST2]
MWST3, -- LC3 Tax [MWST3]
NAVH2, -- LC2 Non-Ded. [NAVH2]
NAVH3, -- LC3 Non-Ded. [NAVH3]
SKNT2, -- CD Amt LC2 [SKNT2]
SKNT3, -- CD Amt LC3 [SKNT3]
BDIF3, -- Valuation Diff. 3 [BDIF3]
RDIF3, -- Diff.Realized 3 [RDIF3]
HWMET, -- Calculation Method [HWMET]
GLUPM, -- Update [GLUPM]
XRAGL, -- Reverse Clearing [XRAGL]
UZAWE, -- Pmnt Meth. Sup. [UZAWE]
LOKKT, -- Altern. Account [ALTKT_SKB1]
FISTL, -- Funds Center [FISTL]
GEBER, -- Fund [BP_GEBER]
STBUK, -- Tax CoCode [STBUK]
TXBH2, -- LC2 Tax Base Amount [TXBH2]
TXBH3, -- LC3 Tax Base Amount [TXBH3]
PPRCT, -- Partner PC [PPRCTR]
XREF1, -- Reference Key 1 [XREF1]
XREF2, -- Reference Key 2 [XREF2]
KBLNR, -- Earmarked funds [KBLNR_FI]
KBLPOS, -- Document Item [KBLPOS]
STTAX, -- Statistical Tax [STTAX]
FKBER, -- Functional Area [FKBER_SHORT]
OBZEI, -- Original Item [OBZEI]
XNEGP, -- Negative Postg [XNEGP]
RFZEI, -- Payt Card Item [RFZEI_CC]
CCBTC, -- Settlement [CCBTC]
KKBER, -- Cred.Contr.Area [KKBER]
EMPFB, -- Payer [EMPFB]
XREF3, -- Reference Key 3 [XREF3]
DTWS1, -- Instruct. Key 1 [DTAT16]
DTWS2, -- Instruct. Key 2 [DTAT17]
DTWS3, -- Instruct. key 3 [DTAT18]
DTWS4, -- Instruct. key 4 [DTAT19]
GRICD, -- Activity Code [J_1AGICD_D]
GRIRG, -- Region [REGIO]
GITYP, -- Distr. Type [J_1ADTYP_D]
XPYPR, -- Payment Sent [XPYPR]
KIDNO, -- Payment Ref. [KIDNO]
ABSBT, -- Hedged Amount [ABSBT]
IDXSP, -- Inflation Index [J_1AINDXSP]
LINFV, -- Last Adj. Date [J_1ALINFVL]
KONTT, -- Acct Assmt Cat. [KONTT_FI]
KONTL, -- Acct assignment [KONTL_FI]
UEBGDAT, -- Date of Legal Dunn. [UEBGDATUM]
TXDAT, -- Tax Date [TXDAT]
AGZEI, -- Clearing Item [AGZEI]
PYCUR, -- Paymnt Crcy [PYCUR]
PYAMT, -- Pt Crcy Amt [PYAMT]
BUPLA, -- Business place [BUPLA]
SECCO, -- Section Code [SECCO]
LSTAR, -- Activity Type [LSTAR]
CESSION_KZ, -- AR Pledging Ind [CESSION_KZ]
PRZNR, -- Business Process [CO_PRZNR]
PPDIFF, -- Diff. Realized [PPDIFF]
PPDIF2, -- Diff. Realized [PPDIF2]
PPDIF3, -- Diff. Realized [PPDIF3]
PENLC1, -- Penalty Chge LC [PENALTY1]
PENLC2, -- Pen.Charge LC2 [PENALTY2]
PENLC3, -- Pen.Charge LC3 [PENALTY3]
PENFC, -- Penalty Charge [PENALTY]
PENDAYS, -- Days in Arrears [PDAYS]
PENRC, -- Reason f. Delay [PENRC]
GRANT_NBR, -- Grant [GM_GRANT_NBR]
SCTAX, -- FI-CA Tax Portion [SCTAX]
FKBER_LONG, -- Functional Area [FKBER]
GMVKZ, -- Execution [FM_GMVKZ]
SRTYPE, -- Addit.Receivab. [FM_SRTYPE]
INTRENO, -- RE code [VVINTRENO]
MEASURE, -- Funded Program [FM_MEASURE]
AUGGJ, -- Clrg Fiscal Yr [AUGGJ]
PPA_EX_IND, -- PPA Exclude [EXCLUDE_FLG]
DOCLN, -- G/L Line Item [DOCLN6]
SEGMENT, -- Segment [FB_SEGMENT]
PSEGMENT, -- Partner Segment [FB_PSEGMENT]
PFKBER, -- Partner FArea [SFKBER]
HKTID, -- Account ID [HKTID]
KSTAR, -- Cost Element [KSTAR]
XLGCLR, -- OI Mgmt by LedgerGrp [XLGCLR]
TAXPS, -- Tax doc. item number [TAX_POSNR]
PAYS_PROV, -- PSP [COM_WEC_PAYMENT_SRV_PROVIDER]
PAYS_TRAN, -- PSP Payment Ref. [FPS_TRANSACTION]
MNDID, -- Mandate Ref. [SEPA_MNDID]
XFRGE_BSEG, -- Released [XFRGE_BSEG]
AWTYP, -- Ref. procedure [AWTYP]
AWKEY, -- Reference Key [AWKEY]
AWSYS, -- Logical System [AWSYS]
POSNR, -- Position [POSNR_ACC]
BUZEI_SENDER, -- Sender Item [BUZEI_SENDER]
H_MONAT, -- Period [MONAT]
H_BSTAT, -- Document Status [BSTAT_D]
H_BUDAT, -- Posting Date [BUDAT]
H_BLDAT, -- Document Date [BLDAT]
H_WAERS, -- Currency [WAERS]
H_BLART, -- Document Type [BLART]
H_HWAER, -- Local Currency [HWAER]
H_HWAE2, -- Local curr. 2 [HWAE2]
H_HWAE3, -- Local curr. 3 [HWAE3]
SK1DT, -- Cash Discount 1 [SK1DT]
SK2DT, -- Cash Discount 2 [SK2DT]
PRCTR_DRVTN_SOURCE_TYPE, -- Profit Center Source [FINOC_PRCTR_DRVTN_SOURCE_TYPE]
PAYT_RSN, -- Payment Reason [FARP_PAYT_RSN]
_DATAAGING, -- Data Aging [DATA_TEMPERATURE]
FQFTYPE, -- Flow Type [FQM_FLOW_TYPE]
LQITEM, -- Liquidity Item [FLQPOS]
GKONT, -- Offsetting Acct [GKONT]
GKART, -- Offst.Acct Type [GKOAR]
GHKON, -- G/L Offsetting Acct [GHKONT]
SQUAN, -- Qty +/- Sign [SIGN_QUANTITY]
ANLN2_PN, -- Sub-number [ANLN2]
BWASL_PN, -- Trans. Type [BWASL]
BZDAT_PN, -- Asset Val. Date [BZDAT]
XVABG_PN, -- Compl.Retiremnt [XVABG]
ANBTR_PN, -- Amount Posted [ANBTR]
PROZS_PN, -- Percentage Rate [PROZS]
ACDOC_EEW_DUMMY, -- Dummy [CFD_DUMMY]
DUMMY_INCL_EEW_COBL, -- Dummy [CFD_DUMMY]
KDGRP, -- Customer Group [KDGRP]
LAND1, -- Country/Region [COBL_LAND1_GP]
BRSCH, -- Industry [BRSCH]
ACROBJTYPE, -- Accrual Object Type [ACR_OBJ_TYPE]
ACRLOGSYS, -- Logical Syst. AcrObj [ACR_LOGSYS]
ACROBJ_ID, -- Accrual Object [ACR_OBJ_ID]
ACRSOBJ_ID, -- Accrual Subobject [ACR_SUBOBJ_ID]
ACRITMTYPE, -- Accrual Item Type [ACR_ITEM_TYPE]
ACRREFOBJ_ID, -- Acr. Reference ID [ACR_REFOBJ_ID]
ACRVALDAT, -- Accrual Value Date [ACR_VALUE_DATE]
VALOBJTYPE, -- Type of Fin.Val.Obj. [VAL_OBJ_TYPE]
VALOBJ_ID, -- Fin Valuation Object [VAL_OBJ_ID]
VALSOBJ_ID, -- Fin.Val.Sub.Object [VAL_SUBOBJ_ID]
NETDT, -- Due On [NETDT]
RISK_CLASS, -- Risk Class [UKM_RISK_CLASS]
SDM_VERSION, -- SDM Versioning [FINS_SDM_VERSION_BSEG]
GLO_REF1, -- Country/Region Specific Reference 1 [FAC_GLO_REF1]
RE_BUKRS, -- Company Code [FAGL_RE_BUKRS]
RE_ACCOUNT, -- Ex/Rv A/c in CL [FAGL_RE_ACCOUNT]
DP_PAYMENT_TYPE, -- Payment Type [DP_PAYMENT_TYPE]
DP_TRANS_ID, -- Transaction/Payt ID [DP_TRANSID]
DP_PAYMENT_REQUEST, -- Payment Request [DP_PAYTREQUEST]
PGEBER, -- Partner Fund [FM_PFUND]
PGRANT_NBR, -- Partner Grant [GM_GRANT_PARTNER]
BUDGET_PD, -- Budget Period [FM_BUDGET_PERIOD]
PBUDGET_PD, -- Par. BudPer [FM_PBUDGET_PERIOD]
J_1TPBUPL, -- Branch Code [BCODE]
PEROP_BEG, -- Per. of Perf. Start [FM_PEROP_FI_LOW]
PEROP_END, -- Per. of Perf. End [FM_PEROP_FI_HIGH]
FASTPAY, -- Fast Pay [FMFG_FASTPAY_FLG]
IGNR_IVREF, -- Ignore Invoice Ref. [FMFG_IGNORE_INV_REF]
FMFGUS_KEY, -- US Govt [FMFG_US_KEY]
FMXDOCNR, -- FM Ref. Doc. Nr. [FM_XDOCNR]
FMXYEAR, -- FM Ref. Year [FM_XYEAR]
FMXDOCLN, -- FM Ref. Item [FM_XDOCLN]
FMXZEKKN, -- FM Ref. AA. [FM_XZEKKN]
PRODPER, -- Prod.Month [JV_PRODPER]
GST_PART, -- GST Partner [J_1IG_PARTNER]
PLC_SUP, -- Place of Supply [J_1IG_REGION]
HSN_SAC, -- HSN/SAC Code [J_1IG_HSN_SAC]
IRN, -- Invoice Ref. Number [J_1IG_IRN]
RECRF, -- Recredit Flag [J_1IRECRF]
BDGT_ACCOUNT, -- Budget Account [PSM_BDGT_ACCOUNT]
BDGT_ACCOUNT_COCODE, -- Company Code for Budget Account [PSM_BDGT_ACCOUNT_COCODE]
INWARD_NO, -- Incg Doc. Nmbr [SAFM_AP_INWARD_NO]
INWARD_DT, -- Incg Doc. Date [SAFM_AP_INWARD_DT]
GROUND_NO, -- Payt. Ground No. [SAFM_AP_PYBSNO]
GROUND_DT, -- Payt. Ground Date [SAFM_AP_PYBSDAT]
GROUND_TYP, -- Payt. Against [SAFM_AP_PYBSTYP]
PYMTKEY, -- Payt/Prop Key [SAFM_AP_PYMNTKEY]
PRIMARY KEY (MANDT, BUKRS, BELNR, GJAHR, BUZEI)
);
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