MNGJEITEM_DRAFT

Transparent Table Application Table

Draft table for entity R_MANAGEJOURNALENTRYITEMTP

MNGJEITEM_DRAFT is an SAP database table in S/4HANA. Draft table for entity R_MANAGEJOURNALENTRYITEMTP. It contains 271 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_JrnlEntrItmMngJrnlEntryDraft view_entity from EXTENSION Manage Journal Entry Item - Extension
R_ManageJournalEntryItemDraft view_entity from BASIC Draft Data for Journal Entry Item

Fields (271)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY companycode fis_bukrs Company Code
KEY fiscalyear fis_gjahr_no_conv Fiscal Year
KEY accountingdocument farp_belnr_d Journal Entry
KEY accountingdocumentitem fis_buzei Posting View Item
chartofaccounts fis_ktopl Chart of Accounts
clearingdate fis_augdt Clearing Date
clearingcreationdate fis_augcp Clrg Creation Date
clearingjournalentry fis_augbl Clearing Journal Entry
postingkey fis_bschl Posting Key
financialaccounttype farp_koart Account Type
specialglcode fac_umskz Special G/L
specialgltransactiontype farp_umsks Sp. G/L Trans.Type
debitcreditcode fis_shkzg Debit/Credit Code
businessarea fis_rbusa Business Area
partnerbusinessarea fis_pargb Partner Bus. Area
taxcode fis_mwskz Tax Code
withholdingtaxcode fac_qsskz Withholding Tax Code
taxtype mwart Tax Type
transactiontypedetermination fac_ktosl Transaction Key
valuedate valut Value date
assignmentreference fis_zuonr Assignment Reference
documentitemtext farp_sgtxt Item Text
partnercompany fis_rassc Trading Partner
financialtransactiontype fis_rmvct Financial Transaction Type
corporategroupaccount fis_bilkt_ska1 Corporate Group Account
planninglevel fdlev Planning Level
controllingarea fis_kokrs Controlling Area
costcenter fis_kostl Cost Center
orderid fis_aufnr Order ID
billingdocument vbeln_vf Billing Doc.
salesdocument vbeln_va Sales Document
salesdocumentitem fis_posnr_va Sales Document Item
scheduleline fis_etenr Schedule Line
servicedocumenttype fco_srvdoc_type Service Doc. Type
servicedocument fco_srvdoc_id Service Document
servicedocumentitem fco_srvdoc_item_id Service Doc. Item
masterfixedasset fis_anln1 Fixed Asset
fixedasset fis_anln2 Asset Subnumber
fixedassetexternalid fis_fixedasset_ext_id Asset Number
assettransactiontype fco_asset_transaction_type Asset Transaction Type
assetvaluedate bzdat Asset Val. Date
personnelnumber pernr_d Personnel No.
issalesrelated fis_xumsw Is Sales Related
lineitemdisplayisenabled fis_xkres Line Item Display Enabled
isopenitemmanaged fis_xopvw Open Item Management
isnotcashdiscountliable fis_xskrl Is Not Cash Discount Liable
isautomaticallycreated fis_xauto Is Automatically Created
isusedinpaymenttransaction fis_xzahl Is Used In Payment Transaction
operationalglaccount fis_op_saknr Operational G/L Acct
glaccount fis_racct G/L Account
customer kunnr Customer
supplier md_supplier Supplier
branchaccount fis_filkd Branch Account
isbalancesheetaccount fis_xbilk Is Balance Sheet Account
profitlossaccounttype fis_gvtyp Profit Loss Account Type
specialglaccountassignment fins_hzuon Special G/L Assignmt
duecalculationbasedate fis_dzfbdt Due Calculation Base Date
paymentterms farp_dzterm Payment Terms
cashdiscountbaseamount fis_skfbt Cash Dscnt Base Amt
cashdiscountamount fis_wskto Cash Discount Amount
cashdiscount1days farp_dzbd1t Cash Discount Days 1
cashdiscount2days farp_dzbd2t Cash Discount Days 2
netpaymentdays farp_dzbd3t Days Net
cashdiscount1percent dzbd1p_farp Disc. Percent 1
cashdiscount2percent dzbd2p_farp Disc. Percent 2
paymentmethod farp_schzw_bseg Payment Method
paymentblockingreason fis_dzlspr Payment Blocking Reason
fixedcashdiscount fis_dzbfix Fixed Cash Discount
housebank farp_hbkid House Bank
bpbankaccountinternalid farp_bvtyp BP Bank Account
taxdistributioncode1 fis_mwsk1 Tax Distr. Code 1
taxdistributioncode2 fis_mwsk2 Tax Distr. Code 2
taxdistributioncode3 fis_mwsk3 Tax Distr. Code 3
invoicereference fis_rebzg Invoice Reference
invoicereferencefiscalyear fis_rebzj_no_conv Invoice Reference Fiscal Year
invoiceitemreference fis_rebzz Invoice Item Reference
followondocumenttype farp_rebzt Follow-On Doc.Type
statecentralbankpaymentreason lzbkz SCB Ind.
supplyingcountry fac_landl Supplying Ctry/Reg.
invoicelist fis_samnr Invoice List
billofexchangeusage farp_wverw BoE Usage
billofexchangepaymentrequest billofexchangepaymentrequest
boepaymentrequestfiscalyear boepaymentrequestfiscalyear
boepaymentrequestcompanycode boepaymentrequestcompanycode
dunningkey farp_mschl Dunning Key
dunningblockingreason fis_mansp Dunning Blocking Reason
lastdunningdate farp_madat Last Dunned
dunninglevel farp_mahns_d Dunning Level
dunningarea farp_maber Dunning Area
withholdingtaxcertificate fis_wtcert WHT Certificate
product productnumber Product
plant werks_d Plant
purchasingdocument fis_ebeln Purchasing Document
purchasingdocumentitem fis_ebelp Purchasing Doc. Item
accountassignmentnumber dzekkn Account Assgmt No.
iscompletelydelivered fis_elikz Is completely delivered
lineitemiscompleted fis_elikz Is completely delivered
materialpricecontrol fis_vprsv Material Price Control
valuationarea bwkey Valuation Area
inventoryvaluationtype bwtar_d Valuation Type
vatregistration fis_stceg VAT Registration
delivofgoodsdestcountry egbld Dest. C/R
paymentdifferencereason fis_rstgr Payment Difference Reason
profitcenter fis_prctr Profit Center
jointventure jv_name Joint venture
jointventurecostrecoverycode jv_recind Recovery Ind.
jointventureequitygroup jv_egroup_cds Joint Venture Equity Group
treasurycontracttype fis_rantyp Treasury Contract Type
assetcontract fis_ranl Asset Contract
cashflowtype farp_sbewart Flow Type
taxjurisdiction fis_txjcd Tax Jurisdiction
reinternalfinnumber recaimkeyfi Real Estate Key
settlementreferencedate farp_dabrbez Reference Date
commitmentitem fm_fipex Commitment Item
commitmentitemshortid fis_fipos_shortid Commitment Item Short ID
costobject kstrg Cost Object
projectnetwork nplnr Network
orderinternalbillofoperations fis_ordintbillofops Order Internal Bill of Operations
orderintbillofoperationsitem fis_ordintbillofopitm Order Internal Bill of Operations Item
wbselementinternalid fis_wbsint_no_conv WBS Element Internal ID
wbselementexternalid ps_posid_edit WBS Element
wbsdescription ps_s4_post1 WBS Element Name
profitabilitysegment rkeobjnr_char Profitability Segment
jointventureequitytype jv_etype_cds Joint Venture Equity Type
iseutriangulardeal fis_xegdr Is EU Triangular Deal
costorigingroup hrkft Origin Group
companycodecurrencydetnmethod fac_hwmet Co Crcy Detn Meth
clearingisreversed fis_xragl Clearing Is Reversed
paymentmethodsupplement farp_uzawe Payt Method Suplmnt
alternativeglaccount fis_altkt_skb1 Altern. G/L Account
partnerprofitcenter fis_pprctr Partner Profit Center
reference1idbybusinesspartner fis_xref1 Reference 1 ID By Business Partner
reference2idbybusinesspartner fis_xref2 Reference 2 ID By Business Partner
isnegativeposting fis_xnegp Is Negative Posting
paymentcarditem fis_rfzei_cc Payment Card Item
paymentcardpaymentsettlement fis_ccbtc Payment Card Payment Settlement
creditcontrolarea farp_kkber Credit Control Area
reference3idbybusinesspartner fis_xref3 Reference 3 ID By Business Partner
dataexchangeinstruction1 fis_dtat16 Data Exchange Instruction 1
dataexchangeinstruction2 fis_dtat17 Data Exchange Instruction 2
dataexchangeinstruction3 fis_dtat18 Data Exchange Instruction 3
dataexchangeinstruction4 fis_dtat19 Data Exchange Instruction 4
region regio Region
haspaymentorder farp_xpypr Payment Sent
paymentreference farp_kidno Payment Reference
taxdeterminationdate fis_txdat Tx Determination Dte
clearingitem fis_agzei Clearing Item
businessplace farp_bupla Business Place
taxsection fis_secco Tax Section
costctractivitytype lstar Activity Type
accountsreceivableispledged fis_cession_kz_ind Accounts Receivable Is Pledged
acctsreceivablepledgingcode fis_cession_kz_code Accounts Receivable Pledging Code
businessprocess co_prznr Business Process
functionalarea fm_farea Functional Area
customerisinexecution fis_gmvkzd Customer Is In Execution
clearingjournalentryfiscalyear fis_auggj_no_conv Fiscal Year of Clearing Journal Entry
ledgergllineitem fis_docln Journal Entry Item
segment fb_segment Segment
partnersegment fb_psegment Partner Segment
partnerfunctionalarea fis_sfkber Partner Func. Area
housebankaccount fac_hktid House Bank Account
costelement kstar Cost Element
paymentserviceprovider farp_payment_srv_provider Payt Srvc Provider
paymentrefbypaytsrvcprovider farp_fps_transaction Reference by PSP
sepamandate fis_sepa_mndid SEPA Mandate
referencedocumenttype fis_awtyp Reference Document Type
originalreferencedocument fis_awkey Original Reference Document
referencedocumentlogicalsystem fis_awsys Ref. Doc. Lgcl Syst.
accountingdocumentitemref fis_posnr_acc Journal Entry Line Item Reference
fiscalperiod fins_fiscalperiod Fiscal Period
accountingdocumentcategory fis_bstat Journal Entry Category
postingdate fis_budat Posting Date
documentdate fis_bldat Journal Entry Date
accountingdocumenttype farp_blart Journal Entry Type
netduedate farp_netdt Net Due Date
cashdiscount1duedate farp_sk1dt Cash Disc 1 Due Date
cashdiscount2duedate farp_sk2dt Cash Disc 2 Due Date
offsettingaccount fis_gkont Offsetting Account
offsettingaccounttype farp_gkoar Offset Acct Type
offsettingchartofaccounts fis_offsettingktopl Offsetting Chart of Accounts
cashledgercompanycode fis_re_bukrs Cash Origin CoCode
cashledgeraccount fis_re_account Cash Origin Account
financialmanagementarea fikrs FM Area
fundscenter farp_fistl Funds Center
fundedprogram fm_measure Funded Program
fund bp_geber Fund
grantid gm_grant_nbr Grant
budgetperiod fm_budget_period Budget Period
partnerfund bp_p_geber Partner Fund
partnergrant gm_grant_partner Partner Grant
partnerbudgetperiod fm_pbudget_period Par. BudPer
pubsecbudgetaccount psm_bdgt_account Budget Account
pubsecbudgetaccountcocode psm_bdgt_account_cocode Company Code for Budget Account
companycodecurrency fis_hwaer Company Code Currency
amountincompanycodecurrency fis_hsl Amount in Company Code Currency
creditamountincocodecrcy fis_cr_hsl Credit Amount in Company Code Currency
debitamountincocodecrcy fis_dr_hsl Debit Amount in Company Code Currency
functionalcurrency fins_currfc Functional Currency
amountinfunctionalcurrency fis_vfccur12 Amount in Functional Currency
creditamountinfunctionalcrcy fis_cr_amt_funccrcy Credit Amount in Functional Currency
debitamountinfunctionalcrcy fis_dr_amt_funccrcy Debit Amount in Functional Currency
transactioncurrency fis_rwcur Transaction Currency
amountintransactioncurrency fis_wsl Amount in Transaction Currency
creditamountintranscrcy fis_cr_wsl Credit Amount in Transaction Currency
debitamountintranscrcy fis_dr_wsl Debit Amount in Transaction Currency
balancetransactioncurrency fis_rtcur Balance Transaction Currency
amountinbalancetransaccrcy fis_tsl Amount in Balance Transaction Currency
creditamountinbalancetranscrcy fis_cr_tsl Credit Amount in Balance Trans. Currency
debitamountinbalancetranscrcy fis_dr_tsl Debit Amount in Balance Trans. Currency
additionalcurrency1 fis_hwae2 Additional Crcy 1
amountinadditionalcurrency1 fis_dmbe2 Amount in Additional Currency 1
creditamountinaddlcrcy1 fis_dmbe2 Amount in Additional Currency 1
debitamountinaddlcrcy1 fis_dmbe2 Amount in Additional Currency 1
additionalcurrency2 fis_hwae3 Additional Crcy 2
amountinadditionalcurrency2 fis_dmbe3 Amount in Additional Currency 2
creditamountinaddlcrcy2 fis_dmbe3 Amount in Additional Currency 2
debitamountinaddlcrcy2 fis_dmbe3 Amount in Additional Currency 2
baseunit meins Base Unit
quantity quan1_12 Quantity
absolutequantity fis_absolute_quantity Absolute Quantity
goodsmovemententryunit erfme Unit of Entry
quantityinentryunit fis_quantityinentryunit Quantity in Entry Unit
purchasingdocumentpriceunit fis_bprme Purchasing Document Price Unit
purchaseorderqty fis_bpmng_long Purchase Order Quantity
materialpriceunitqty fis_peinh Material Price Unit Quantity
earmarkedfundsdocument kblnr_fi Earmarked funds
earmarkedfundsdocumentitem kblpos Document Item
paytslipwthrefreference fac_mje_esrre QR Reference
taxratevaliditystartdate fis_txdat_from Tax Rate Validity Start Date
paytslipwthrefcheckdigit fis_esrpz ISR Check Digit
paytslipwthrefsubscriber fis_esrnr ISR Subscriber Number
paymentreason farp_payt_rsn Payment Reason
branchcode bcode Branch Code
paymentcurrency farp_pycur Autom. Payt. Crcy.
amountinpaymentcurrency fis_pyamt Amount in Payment Currency
netpaymentamount fis_nebtr Net Payment Amount
taxbaseamountincocodecrcy hwbas_shl TxBaseAmt CoCodeCrcy
taxbaseamountintranscrcy fwbas_shl Tx Bse Amt TransCrcy
withholdingtaxamount fis_qbshb Withholding Tax Amt
withholdingtaxexemptionamt fis_qsfbt Withholding T-E Amt
withholdingtaxbaseamount fis_qsshb Withholding T.B. Amt
taxcountry fot_tax_country Tax Ctry/Reg.
addressandbankissetmanually farp_xcpdd Address and Bank is Set Manually
addressischangedmanually xfeld Checkbox
isonetimeaccount xcpdk One-time acct
alternativepayeeisallowed xzemp Payee in doc.
payerisalternativepayer farp_isalternativepayer Is Alternative Payer
payeeisalternativepayee farp_isalternativepayee Is Alternative Payee
oplacctgdocitmcntryspcfcref1 fac_glo_ref1 Country/Region Specific Reference 1
financialservicesproductgroup ffs_product_group Product Group (FS)
financialservicesbranch ffs_branch_id Branch (FS)
financialdatasource ffs_datasource_id Data Source
customergroup kdgrp Customer Group
customersuppliercountry fis_land1_gp Customer or Supplier Country/Region
customersupplierindustry fis_brsch Customer Supplier Industry
cashdiscountamtincocodecrcy fis_sknto CashD Amt in CC Crcy
accountingdocumentitemtype buzid Line Item ID
alternativepayeepayer fis_empfb Alternative Payee/Payer
downpaymentisnetprocedure xanet Indicator: Down Payment in Net Procedure?
taxamountincocodecrcy fis_mwsts Tax Amount in Company Code Currency
taxamount wmwst_shl Tax Amount
recrrgsuplrinvcissrvcinvoice fac_diekz Service
suplrinvciscapitalgoodsrelated fac_xinve Capital Goods
clearingisledgergroupspecific xlgclr OI Mgmt by LedgerGrp
acctgdocitmcustomstariffnumber dzollt Cust.Tariff No.
acctgdocitmcstmsclearancedate dzolld Customs Date
invcitmisexcldfrmpromptpaytact exclude_flg PPA Exclude
interestcalculationblockreason fis_dzinkz Interest Calculation Block Reason
deliveryofgoodsreportingcntry fac_egmld_bsez Reporting Ctry/Reg.
assetclass anlkl Asset Class

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.

-- Draft table for entity R_MANAGEJOURNALENTRYITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MNGJEITEM_DRAFT (
    MANDT,                           -- Client [mandt]
    COMPANYCODE,                     -- Company Code [fis_bukrs]
    FISCALYEAR,                      -- Fiscal Year [fis_gjahr_no_conv]
    ACCOUNTINGDOCUMENT,              -- Journal Entry [farp_belnr_d]
    ACCOUNTINGDOCUMENTITEM,          -- Posting View Item [fis_buzei]
    CHARTOFACCOUNTS,                 -- Chart of Accounts [fis_ktopl]
    CLEARINGDATE,                    -- Clearing Date [fis_augdt]
    CLEARINGCREATIONDATE,            -- Clrg Creation Date [fis_augcp]
    CLEARINGJOURNALENTRY,            -- Clearing Journal Entry [fis_augbl]
    POSTINGKEY,                      -- Posting Key [fis_bschl]
    FINANCIALACCOUNTTYPE,            -- Account Type [farp_koart]
    SPECIALGLCODE,                   -- Special G/L [fac_umskz]
    SPECIALGLTRANSACTIONTYPE,        -- Sp. G/L Trans.Type [farp_umsks]
    DEBITCREDITCODE,                 -- Debit/Credit Code [fis_shkzg]
    BUSINESSAREA,                    -- Business Area [fis_rbusa]
    PARTNERBUSINESSAREA,             -- Partner Bus. Area [fis_pargb]
    TAXCODE,                         -- Tax Code [fis_mwskz]
    WITHHOLDINGTAXCODE,              -- Withholding Tax Code [fac_qsskz]
    TAXTYPE,                         -- Tax Type [mwart]
    TRANSACTIONTYPEDETERMINATION,    -- Transaction Key [fac_ktosl]
    VALUEDATE,                       -- Value date [valut]
    ASSIGNMENTREFERENCE,             -- Assignment Reference [fis_zuonr]
    DOCUMENTITEMTEXT,                -- Item Text [farp_sgtxt]
    PARTNERCOMPANY,                  -- Trading Partner [fis_rassc]
    FINANCIALTRANSACTIONTYPE,        -- Financial Transaction Type [fis_rmvct]
    CORPORATEGROUPACCOUNT,           -- Corporate Group Account [fis_bilkt_ska1]
    PLANNINGLEVEL,                   -- Planning Level [fdlev]
    CONTROLLINGAREA,                 -- Controlling Area [fis_kokrs]
    COSTCENTER,                      -- Cost Center [fis_kostl]
    ORDERID,                         -- Order ID [fis_aufnr]
    BILLINGDOCUMENT,                 -- Billing Doc. [vbeln_vf]
    SALESDOCUMENT,                   -- Sales Document [vbeln_va]
    SALESDOCUMENTITEM,               -- Sales Document Item [fis_posnr_va]
    SCHEDULELINE,                    -- Schedule Line [fis_etenr]
    SERVICEDOCUMENTTYPE,             -- Service Doc. Type [fco_srvdoc_type]
    SERVICEDOCUMENT,                 -- Service Document [fco_srvdoc_id]
    SERVICEDOCUMENTITEM,             -- Service Doc. Item [fco_srvdoc_item_id]
    MASTERFIXEDASSET,                -- Fixed Asset [fis_anln1]
    FIXEDASSET,                      -- Asset Subnumber [fis_anln2]
    FIXEDASSETEXTERNALID,            -- Asset Number [fis_fixedasset_ext_id]
    ASSETTRANSACTIONTYPE,            -- Asset Transaction Type [fco_asset_transaction_type]
    ASSETVALUEDATE,                  -- Asset Val. Date [bzdat]
    PERSONNELNUMBER,                 -- Personnel No. [pernr_d]
    ISSALESRELATED,                  -- Is Sales Related [fis_xumsw]
    LINEITEMDISPLAYISENABLED,        -- Line Item Display Enabled [fis_xkres]
    ISOPENITEMMANAGED,               -- Open Item Management [fis_xopvw]
    ISNOTCASHDISCOUNTLIABLE,         -- Is Not Cash Discount Liable [fis_xskrl]
    ISAUTOMATICALLYCREATED,          -- Is Automatically Created [fis_xauto]
    ISUSEDINPAYMENTTRANSACTION,      -- Is Used In Payment Transaction [fis_xzahl]
    OPERATIONALGLACCOUNT,            -- Operational G/L Acct [fis_op_saknr]
    GLACCOUNT,                       -- G/L Account [fis_racct]
    CUSTOMER,                        -- Customer [kunnr]
    SUPPLIER,                        -- Supplier [md_supplier]
    BRANCHACCOUNT,                   -- Branch Account [fis_filkd]
    ISBALANCESHEETACCOUNT,           -- Is Balance Sheet Account [fis_xbilk]
    PROFITLOSSACCOUNTTYPE,           -- Profit Loss Account Type [fis_gvtyp]
    SPECIALGLACCOUNTASSIGNMENT,      -- Special G/L Assignmt [fins_hzuon]
    DUECALCULATIONBASEDATE,          -- Due Calculation Base Date [fis_dzfbdt]
    PAYMENTTERMS,                    -- Payment Terms [farp_dzterm]
    CASHDISCOUNTBASEAMOUNT,          -- Cash Dscnt Base Amt [fis_skfbt]
    CASHDISCOUNTAMOUNT,              -- Cash Discount Amount [fis_wskto]
    CASHDISCOUNT1DAYS,               -- Cash Discount Days 1 [farp_dzbd1t]
    CASHDISCOUNT2DAYS,               -- Cash Discount Days 2 [farp_dzbd2t]
    NETPAYMENTDAYS,                  -- Days Net [farp_dzbd3t]
    CASHDISCOUNT1PERCENT,            -- Disc. Percent 1 [dzbd1p_farp]
    CASHDISCOUNT2PERCENT,            -- Disc. Percent 2 [dzbd2p_farp]
    PAYMENTMETHOD,                   -- Payment Method [farp_schzw_bseg]
    PAYMENTBLOCKINGREASON,           -- Payment Blocking Reason [fis_dzlspr]
    FIXEDCASHDISCOUNT,               -- Fixed Cash Discount [fis_dzbfix]
    HOUSEBANK,                       -- House Bank [farp_hbkid]
    BPBANKACCOUNTINTERNALID,         -- BP Bank Account [farp_bvtyp]
    TAXDISTRIBUTIONCODE1,            -- Tax Distr. Code 1 [fis_mwsk1]
    TAXDISTRIBUTIONCODE2,            -- Tax Distr. Code 2 [fis_mwsk2]
    TAXDISTRIBUTIONCODE3,            -- Tax Distr. Code 3 [fis_mwsk3]
    INVOICEREFERENCE,                -- Invoice Reference [fis_rebzg]
    INVOICEREFERENCEFISCALYEAR,      -- Invoice Reference Fiscal Year [fis_rebzj_no_conv]
    INVOICEITEMREFERENCE,            -- Invoice Item Reference [fis_rebzz]
    FOLLOWONDOCUMENTTYPE,            -- Follow-On Doc.Type [farp_rebzt]
    STATECENTRALBANKPAYMENTREASON,   -- SCB Ind. [lzbkz]
    SUPPLYINGCOUNTRY,                -- Supplying Ctry/Reg. [fac_landl]
    INVOICELIST,                     -- Invoice List [fis_samnr]
    BILLOFEXCHANGEUSAGE,             -- BoE Usage [farp_wverw]
    BILLOFEXCHANGEPAYMENTREQUEST,    -- billofexchangepaymentrequest
    BOEPAYMENTREQUESTFISCALYEAR,     -- boepaymentrequestfiscalyear
    BOEPAYMENTREQUESTCOMPANYCODE,    -- boepaymentrequestcompanycode
    DUNNINGKEY,                      -- Dunning Key [farp_mschl]
    DUNNINGBLOCKINGREASON,           -- Dunning Blocking Reason [fis_mansp]
    LASTDUNNINGDATE,                 -- Last Dunned [farp_madat]
    DUNNINGLEVEL,                    -- Dunning Level [farp_mahns_d]
    DUNNINGAREA,                     -- Dunning Area [farp_maber]
    WITHHOLDINGTAXCERTIFICATE,       -- WHT Certificate [fis_wtcert]
    PRODUCT,                         -- Product [productnumber]
    PLANT,                           -- Plant [werks_d]
    PURCHASINGDOCUMENT,              -- Purchasing Document [fis_ebeln]
    PURCHASINGDOCUMENTITEM,          -- Purchasing Doc. Item [fis_ebelp]
    ACCOUNTASSIGNMENTNUMBER,         -- Account Assgmt No. [dzekkn]
    ISCOMPLETELYDELIVERED,           -- Is completely delivered [fis_elikz]
    LINEITEMISCOMPLETED,             -- Is completely delivered [fis_elikz]
    MATERIALPRICECONTROL,            -- Material Price Control [fis_vprsv]
    VALUATIONAREA,                   -- Valuation Area [bwkey]
    INVENTORYVALUATIONTYPE,          -- Valuation Type [bwtar_d]
    VATREGISTRATION,                 -- VAT Registration [fis_stceg]
    DELIVOFGOODSDESTCOUNTRY,         -- Dest. C/R [egbld]
    PAYMENTDIFFERENCEREASON,         -- Payment Difference Reason [fis_rstgr]
    PROFITCENTER,                    -- Profit Center [fis_prctr]
    JOINTVENTURE,                    -- Joint venture [jv_name]
    JOINTVENTURECOSTRECOVERYCODE,    -- Recovery Ind. [jv_recind]
    JOINTVENTUREEQUITYGROUP,         -- Joint Venture Equity Group [jv_egroup_cds]
    TREASURYCONTRACTTYPE,            -- Treasury Contract Type [fis_rantyp]
    ASSETCONTRACT,                   -- Asset Contract [fis_ranl]
    CASHFLOWTYPE,                    -- Flow Type [farp_sbewart]
    TAXJURISDICTION,                 -- Tax Jurisdiction [fis_txjcd]
    REINTERNALFINNUMBER,             -- Real Estate Key [recaimkeyfi]
    SETTLEMENTREFERENCEDATE,         -- Reference Date [farp_dabrbez]
    COMMITMENTITEM,                  -- Commitment Item [fm_fipex]
    COMMITMENTITEMSHORTID,           -- Commitment Item Short ID [fis_fipos_shortid]
    COSTOBJECT,                      -- Cost Object [kstrg]
    PROJECTNETWORK,                  -- Network [nplnr]
    ORDERINTERNALBILLOFOPERATIONS,   -- Order Internal Bill of Operations [fis_ordintbillofops]
    ORDERINTBILLOFOPERATIONSITEM,    -- Order Internal Bill of Operations Item [fis_ordintbillofopitm]
    WBSELEMENTINTERNALID,            -- WBS Element Internal ID [fis_wbsint_no_conv]
    WBSELEMENTEXTERNALID,            -- WBS Element [ps_posid_edit]
    WBSDESCRIPTION,                  -- WBS Element Name [ps_s4_post1]
    PROFITABILITYSEGMENT,            -- Profitability Segment [rkeobjnr_char]
    JOINTVENTUREEQUITYTYPE,          -- Joint Venture Equity Type [jv_etype_cds]
    ISEUTRIANGULARDEAL,              -- Is EU Triangular Deal [fis_xegdr]
    COSTORIGINGROUP,                 -- Origin Group [hrkft]
    COMPANYCODECURRENCYDETNMETHOD,   -- Co Crcy Detn Meth [fac_hwmet]
    CLEARINGISREVERSED,              -- Clearing Is Reversed [fis_xragl]
    PAYMENTMETHODSUPPLEMENT,         -- Payt Method Suplmnt [farp_uzawe]
    ALTERNATIVEGLACCOUNT,            -- Altern. G/L Account [fis_altkt_skb1]
    PARTNERPROFITCENTER,             -- Partner Profit Center [fis_pprctr]
    REFERENCE1IDBYBUSINESSPARTNER,   -- Reference 1 ID By Business Partner [fis_xref1]
    REFERENCE2IDBYBUSINESSPARTNER,   -- Reference 2 ID By Business Partner [fis_xref2]
    ISNEGATIVEPOSTING,               -- Is Negative Posting [fis_xnegp]
    PAYMENTCARDITEM,                 -- Payment Card Item [fis_rfzei_cc]
    PAYMENTCARDPAYMENTSETTLEMENT,    -- Payment Card Payment Settlement [fis_ccbtc]
    CREDITCONTROLAREA,               -- Credit Control Area [farp_kkber]
    REFERENCE3IDBYBUSINESSPARTNER,   -- Reference 3 ID By Business Partner [fis_xref3]
    DATAEXCHANGEINSTRUCTION1,        -- Data Exchange Instruction 1 [fis_dtat16]
    DATAEXCHANGEINSTRUCTION2,        -- Data Exchange Instruction 2 [fis_dtat17]
    DATAEXCHANGEINSTRUCTION3,        -- Data Exchange Instruction 3 [fis_dtat18]
    DATAEXCHANGEINSTRUCTION4,        -- Data Exchange Instruction 4 [fis_dtat19]
    REGION,                          -- Region [regio]
    HASPAYMENTORDER,                 -- Payment Sent [farp_xpypr]
    PAYMENTREFERENCE,                -- Payment Reference [farp_kidno]
    TAXDETERMINATIONDATE,            -- Tx Determination Dte [fis_txdat]
    CLEARINGITEM,                    -- Clearing Item [fis_agzei]
    BUSINESSPLACE,                   -- Business Place [farp_bupla]
    TAXSECTION,                      -- Tax Section [fis_secco]
    COSTCTRACTIVITYTYPE,             -- Activity Type [lstar]
    ACCOUNTSRECEIVABLEISPLEDGED,     -- Accounts Receivable Is Pledged [fis_cession_kz_ind]
    ACCTSRECEIVABLEPLEDGINGCODE,     -- Accounts Receivable Pledging Code [fis_cession_kz_code]
    BUSINESSPROCESS,                 -- Business Process [co_prznr]
    FUNCTIONALAREA,                  -- Functional Area [fm_farea]
    CUSTOMERISINEXECUTION,           -- Customer Is In Execution [fis_gmvkzd]
    CLEARINGJOURNALENTRYFISCALYEAR,  -- Fiscal Year of Clearing Journal Entry [fis_auggj_no_conv]
    LEDGERGLLINEITEM,                -- Journal Entry Item [fis_docln]
    SEGMENT,                         -- Segment [fb_segment]
    PARTNERSEGMENT,                  -- Partner Segment [fb_psegment]
    PARTNERFUNCTIONALAREA,           -- Partner Func. Area [fis_sfkber]
    HOUSEBANKACCOUNT,                -- House Bank Account [fac_hktid]
    COSTELEMENT,                     -- Cost Element [kstar]
    PAYMENTSERVICEPROVIDER,          -- Payt Srvc Provider [farp_payment_srv_provider]
    PAYMENTREFBYPAYTSRVCPROVIDER,    -- Reference by PSP [farp_fps_transaction]
    SEPAMANDATE,                     -- SEPA Mandate [fis_sepa_mndid]
    REFERENCEDOCUMENTTYPE,           -- Reference Document Type [fis_awtyp]
    ORIGINALREFERENCEDOCUMENT,       -- Original Reference Document [fis_awkey]
    REFERENCEDOCUMENTLOGICALSYSTEM,  -- Ref. Doc. Lgcl Syst. [fis_awsys]
    ACCOUNTINGDOCUMENTITEMREF,       -- Journal Entry Line Item Reference [fis_posnr_acc]
    FISCALPERIOD,                    -- Fiscal Period [fins_fiscalperiod]
    ACCOUNTINGDOCUMENTCATEGORY,      -- Journal Entry Category [fis_bstat]
    POSTINGDATE,                     -- Posting Date [fis_budat]
    DOCUMENTDATE,                    -- Journal Entry Date [fis_bldat]
    ACCOUNTINGDOCUMENTTYPE,          -- Journal Entry Type [farp_blart]
    NETDUEDATE,                      -- Net Due Date [farp_netdt]
    CASHDISCOUNT1DUEDATE,            -- Cash Disc 1 Due Date [farp_sk1dt]
    CASHDISCOUNT2DUEDATE,            -- Cash Disc 2 Due Date [farp_sk2dt]
    OFFSETTINGACCOUNT,               -- Offsetting Account [fis_gkont]
    OFFSETTINGACCOUNTTYPE,           -- Offset Acct Type [farp_gkoar]
    OFFSETTINGCHARTOFACCOUNTS,       -- Offsetting Chart of Accounts [fis_offsettingktopl]
    CASHLEDGERCOMPANYCODE,           -- Cash Origin CoCode [fis_re_bukrs]
    CASHLEDGERACCOUNT,               -- Cash Origin Account [fis_re_account]
    FINANCIALMANAGEMENTAREA,         -- FM Area [fikrs]
    FUNDSCENTER,                     -- Funds Center [farp_fistl]
    FUNDEDPROGRAM,                   -- Funded Program [fm_measure]
    FUND,                            -- Fund [bp_geber]
    GRANTID,                         -- Grant [gm_grant_nbr]
    BUDGETPERIOD,                    -- Budget Period [fm_budget_period]
    PARTNERFUND,                     -- Partner Fund [bp_p_geber]
    PARTNERGRANT,                    -- Partner Grant [gm_grant_partner]
    PARTNERBUDGETPERIOD,             -- Par. BudPer [fm_pbudget_period]
    PUBSECBUDGETACCOUNT,             -- Budget Account [psm_bdgt_account]
    PUBSECBUDGETACCOUNTCOCODE,       -- Company Code for Budget Account [psm_bdgt_account_cocode]
    COMPANYCODECURRENCY,             -- Company Code Currency [fis_hwaer]
    AMOUNTINCOMPANYCODECURRENCY,     -- Amount in Company Code Currency [fis_hsl]
    CREDITAMOUNTINCOCODECRCY,        -- Credit Amount in Company Code Currency [fis_cr_hsl]
    DEBITAMOUNTINCOCODECRCY,         -- Debit Amount in Company Code Currency [fis_dr_hsl]
    FUNCTIONALCURRENCY,              -- Functional Currency [fins_currfc]
    AMOUNTINFUNCTIONALCURRENCY,      -- Amount in Functional Currency [fis_vfccur12]
    CREDITAMOUNTINFUNCTIONALCRCY,    -- Credit Amount in Functional Currency [fis_cr_amt_funccrcy]
    DEBITAMOUNTINFUNCTIONALCRCY,     -- Debit Amount in Functional Currency [fis_dr_amt_funccrcy]
    TRANSACTIONCURRENCY,             -- Transaction Currency [fis_rwcur]
    AMOUNTINTRANSACTIONCURRENCY,     -- Amount in Transaction Currency [fis_wsl]
    CREDITAMOUNTINTRANSCRCY,         -- Credit Amount in Transaction Currency [fis_cr_wsl]
    DEBITAMOUNTINTRANSCRCY,          -- Debit Amount in Transaction Currency [fis_dr_wsl]
    BALANCETRANSACTIONCURRENCY,      -- Balance Transaction Currency [fis_rtcur]
    AMOUNTINBALANCETRANSACCRCY,      -- Amount in Balance Transaction Currency [fis_tsl]
    CREDITAMOUNTINBALANCETRANSCRCY,  -- Credit Amount in Balance Trans. Currency [fis_cr_tsl]
    DEBITAMOUNTINBALANCETRANSCRCY,   -- Debit Amount in Balance Trans. Currency [fis_dr_tsl]
    ADDITIONALCURRENCY1,             -- Additional Crcy 1 [fis_hwae2]
    AMOUNTINADDITIONALCURRENCY1,     -- Amount in Additional Currency 1 [fis_dmbe2]
    CREDITAMOUNTINADDLCRCY1,         -- Amount in Additional Currency 1 [fis_dmbe2]
    DEBITAMOUNTINADDLCRCY1,          -- Amount in Additional Currency 1 [fis_dmbe2]
    ADDITIONALCURRENCY2,             -- Additional Crcy 2 [fis_hwae3]
    AMOUNTINADDITIONALCURRENCY2,     -- Amount in Additional Currency 2 [fis_dmbe3]
    CREDITAMOUNTINADDLCRCY2,         -- Amount in Additional Currency 2 [fis_dmbe3]
    DEBITAMOUNTINADDLCRCY2,          -- Amount in Additional Currency 2 [fis_dmbe3]
    BASEUNIT,                        -- Base Unit [meins]
    QUANTITY,                        -- Quantity [quan1_12]
    ABSOLUTEQUANTITY,                -- Absolute Quantity [fis_absolute_quantity]
    GOODSMOVEMENTENTRYUNIT,          -- Unit of Entry [erfme]
    QUANTITYINENTRYUNIT,             -- Quantity in Entry Unit [fis_quantityinentryunit]
    PURCHASINGDOCUMENTPRICEUNIT,     -- Purchasing Document Price Unit [fis_bprme]
    PURCHASEORDERQTY,                -- Purchase Order Quantity [fis_bpmng_long]
    MATERIALPRICEUNITQTY,            -- Material Price Unit Quantity [fis_peinh]
    EARMARKEDFUNDSDOCUMENT,          -- Earmarked funds [kblnr_fi]
    EARMARKEDFUNDSDOCUMENTITEM,      -- Document Item [kblpos]
    PAYTSLIPWTHREFREFERENCE,         -- QR Reference [fac_mje_esrre]
    TAXRATEVALIDITYSTARTDATE,        -- Tax Rate Validity Start Date [fis_txdat_from]
    PAYTSLIPWTHREFCHECKDIGIT,        -- ISR Check Digit [fis_esrpz]
    PAYTSLIPWTHREFSUBSCRIBER,        -- ISR Subscriber Number [fis_esrnr]
    PAYMENTREASON,                   -- Payment Reason [farp_payt_rsn]
    BRANCHCODE,                      -- Branch Code [bcode]
    PAYMENTCURRENCY,                 -- Autom. Payt. Crcy. [farp_pycur]
    AMOUNTINPAYMENTCURRENCY,         -- Amount in Payment Currency [fis_pyamt]
    NETPAYMENTAMOUNT,                -- Net Payment Amount [fis_nebtr]
    TAXBASEAMOUNTINCOCODECRCY,       -- TxBaseAmt CoCodeCrcy [hwbas_shl]
    TAXBASEAMOUNTINTRANSCRCY,        -- Tx Bse Amt TransCrcy [fwbas_shl]
    WITHHOLDINGTAXAMOUNT,            -- Withholding Tax Amt [fis_qbshb]
    WITHHOLDINGTAXEXEMPTIONAMT,      -- Withholding T-E Amt [fis_qsfbt]
    WITHHOLDINGTAXBASEAMOUNT,        -- Withholding T.B. Amt [fis_qsshb]
    TAXCOUNTRY,                      -- Tax Ctry/Reg. [fot_tax_country]
    ADDRESSANDBANKISSETMANUALLY,     -- Address and Bank is Set Manually [farp_xcpdd]
    ADDRESSISCHANGEDMANUALLY,        -- Checkbox [xfeld]
    ISONETIMEACCOUNT,                -- One-time acct [xcpdk]
    ALTERNATIVEPAYEEISALLOWED,       -- Payee in doc. [xzemp]
    PAYERISALTERNATIVEPAYER,         -- Is Alternative Payer [farp_isalternativepayer]
    PAYEEISALTERNATIVEPAYEE,         -- Is Alternative Payee [farp_isalternativepayee]
    OPLACCTGDOCITMCNTRYSPCFCREF1,    -- Country/Region Specific Reference 1 [fac_glo_ref1]
    FINANCIALSERVICESPRODUCTGROUP,   -- Product Group (FS) [ffs_product_group]
    FINANCIALSERVICESBRANCH,         -- Branch (FS) [ffs_branch_id]
    FINANCIALDATASOURCE,             -- Data Source [ffs_datasource_id]
    CUSTOMERGROUP,                   -- Customer Group [kdgrp]
    CUSTOMERSUPPLIERCOUNTRY,         -- Customer or Supplier Country/Region [fis_land1_gp]
    CUSTOMERSUPPLIERINDUSTRY,        -- Customer Supplier Industry [fis_brsch]
    CASHDISCOUNTAMTINCOCODECRCY,     -- CashD Amt in CC Crcy [fis_sknto]
    ACCOUNTINGDOCUMENTITEMTYPE,      -- Line Item ID [buzid]
    ALTERNATIVEPAYEEPAYER,           -- Alternative Payee/Payer [fis_empfb]
    DOWNPAYMENTISNETPROCEDURE,       -- Indicator: Down Payment in Net Procedure? [xanet]
    TAXAMOUNTINCOCODECRCY,           -- Tax Amount in Company Code Currency [fis_mwsts]
    TAXAMOUNT,                       -- Tax Amount [wmwst_shl]
    RECRRGSUPLRINVCISSRVCINVOICE,    -- Service [fac_diekz]
    SUPLRINVCISCAPITALGOODSRELATED,  -- Capital Goods [fac_xinve]
    CLEARINGISLEDGERGROUPSPECIFIC,   -- OI Mgmt by LedgerGrp [xlgclr]
    ACCTGDOCITMCUSTOMSTARIFFNUMBER,  -- Cust.Tariff No. [dzollt]
    ACCTGDOCITMCSTMSCLEARANCEDATE,   -- Customs Date [dzolld]
    INVCITMISEXCLDFRMPROMPTPAYTACT,  -- PPA Exclude [exclude_flg]
    INTERESTCALCULATIONBLOCKREASON,  -- Interest Calculation Block Reason [fis_dzinkz]
    DELIVERYOFGOODSREPORTINGCNTRY,   -- Reporting Ctry/Reg. [fac_egmld_bsez]
    ASSETCLASS,                      -- Asset Class [anlkl]
    PRIMARY KEY (MANDT, COMPANYCODE, FISCALYEAR, ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM)
);