MNGJEITEM_DRAFT
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- 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