R_MANAGEJOURNALENTRYITEM
Journal Entry Item
R_MANAGEJOURNALENTRYITEM is a CDS View in S/4HANA. Journal Entry Item. It contains 136 fields. 6 CDS views read from this table.
CDS Views using this table (6)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_MngJournalEntryTotalAmount | view_entity | union_all | CONSUMPTION | Journal Entry Total Amount |
| C_SimulatedJournalEntryItem | view_entity | from | CONSUMPTION | Simulated Journal Entry Item |
| P_FAC_MJE_ITEM_UNITED | view_entity | inner | COMPOSITE | Item fields from combining ACDOCA,BSEG |
| P_MngJrnlEntryEntryViewAmount | view_entity | from | COMPOSITE | Journal Entry Entry View Amount |
| P_SmltdJournalEntryItemCommon | view_entity | from | CONSUMPTION | Simulated JE Item Common Fields |
| R_ManageJournalEntryItemTP | view_entity | from | TRANSACTIONAL | Journal Entry Item - Transaction Processing |
Fields (136)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| AbsoluteQuantity | AbsoluteQuantity | 1 | |
| AccountingDocument | SampleAccountingDocument | 1 | |
| AccountingDocumentItemRef | AccountingDocumentItemRef | 1 | |
| AccountingDocumentItemType | AccountingDocumentItemType | 1 | |
| AccountsReceivableIsPledged | AccountsReceivableIsPledged | 1 | |
| AcctsReceivablePledgingCode | AcctsReceivablePledgingCode | 1 | |
| AdditionalCurrency1 | AdditionalCurrency1 | 1 | |
| AdditionalCurrency2 | AdditionalCurrency2 | 1 | |
| AddressAndBankIsSetManually | AddressAndBankIsSetManually | 1 | |
| AlternativePayeePayer | AlternativePayeePayer | 1 | |
| AmountInAdditionalCurrency1 | AmountInAdditionalCurrency1 | 1 | |
| AmountInAdditionalCurrency2 | AmountInAdditionalCurrency2 | 1 | |
| AmountInPaymentCurrency | AmountInPaymentCurrency | 1 | |
| AssetContract | AssetContract | 1 | |
| BillingDocument | BillingDocument | 1 | |
| BillingPeriodOfPerfEndDate | BillingPeriodOfPerfEndDate | 1 | |
| BillingPeriodOfPerfStartDate | BillingPeriodOfPerfStartDate | 1 | |
| BillOfExchangePaymentRequest | BillOfExchangePaymentRequest | 1 | |
| BillOfExchangeUsage | BillOfExchangeUsage | 1 | |
| BOEPaymentRequestCompanyCode | BOEPaymentRequestCompanyCode | 1 | |
| BOEPaymentRequestFiscalYear | BOEPaymentRequestFiscalYear | 1 | |
| BPBankAccountInternalID | BPBankAccountInternalID | 1 | |
| BranchAccount | BranchAccount | 1 | |
| BranchCode | BranchCode | 1 | |
| BusinessPlace | BusinessPlace | 1 | |
| CashDiscount1Days | CashDiscount1Days | 1 | |
| CashDiscount1DueDate | CashDiscount1DueDate | 1 | |
| CashDiscount1Percent | CashDiscount1Percent | 1 | |
| CashDiscount2Days | CashDiscount2Days | 1 | |
| CashDiscount2DueDate | CashDiscount2DueDate | 1 | |
| CashDiscount2Percent | CashDiscount2Percent | 1 | |
| CashDiscountAmount | CashDiscountAmount | 1 | |
| CashDiscountAmtInCoCodeCrcy | CashDiscountAmtInCoCodeCrcy | 1 | |
| CashDiscountBaseAmount | CashDiscountBaseAmount | 1 | |
| CashFlowType | CashFlowType | 1 | |
| ClearingCreationDate | ClearingCreationDate | 1 | |
| ClearingIsReversed | ClearingIsReversed | 1 | |
| ClearingItem | ClearingItem | 1 | |
| CommitmentItemShortID | CommitmentItemShortID | 1 | |
| CompanyCodeCurrencyDetnMethod | CompanyCodeCurrencyDetnMethod | 1 | |
| CorporateGroupAccount | CorporateGroupAccount | 1 | |
| CostElement | CostElement | 1 | |
| CreditAmountInAddlCrcy1 | CreditAmountInAddlCrcy1 | 1 | |
| CreditAmountInAddlCrcy2 | CreditAmountInAddlCrcy2 | 1 | |
| CreditControlArea | CreditControlArea | 1 | |
| CustomerIsInExecution | CustomerIsInExecution | 1 | |
| DataExchangeInstruction1 | DataExchangeInstruction1 | 1 | |
| DataExchangeInstruction2 | DataExchangeInstruction2 | 1 | |
| DataExchangeInstruction3 | DataExchangeInstruction3 | 1 | |
| DataExchangeInstruction4 | DataExchangeInstruction4 | 1 | |
| DebitAmountInAddlCrcy1 | DebitAmountInAddlCrcy1 | 1 | |
| DebitAmountInAddlCrcy2 | DebitAmountInAddlCrcy2 | 1 | |
| DelivOfGoodsDestCountry | DelivOfGoodsDestCountry | 1 | |
| DownPaymentIsNetProcedure | DownPaymentIsNetProcedure | 1 | |
| DueCalculationBaseDate | DueCalculationBaseDate | 1 | |
| DunningArea | DunningArea | 1 | |
| DunningBlockingReason | DunningBlockingReason | 1 | |
| DunningKey | DunningKey | 1 | |
| DunningLevel | DunningLevel | 1 | |
| EarmarkedFundsDocument | EarmarkedFundsDocument | 1 | |
| EarmarkedFundsDocumentItem | EarmarkedFundsDocumentItem | 1 | |
| FixedCashDiscount | FixedCashDiscount | 1 | |
| GoodsMovementEntryUnit | GoodsMovementEntryUnit | 1 | |
| HasPaymentOrder | HasPaymentOrder | 1 | |
| InterestCalculationBlockReason | InterestCalculationBlockReason | 1 | |
| InvoiceList | InvoiceList | 1 | |
| IsAutomaticallyCreated | IsAutomaticallyCreated | 1 | |
| IsBalanceSheetAccount | IsBalanceSheetAccount | 1 | |
| IsCompletelyDelivered | IsCompletelyDelivered | 1 | |
| IsEUTriangularDeal | IsEUTriangularDeal | 1 | |
| IsNotCashDiscountLiable | IsNotCashDiscountLiable | 1 | |
| IsSalesRelated | IsSalesRelated | 1 | |
| IsUsedInPaymentTransaction | IsUsedInPaymentTransaction | 1 | |
| LastDunningDate | LastDunningDate | 1 | |
| LineItemDisplayIsEnabled | LineItemDisplayIsEnabled | 1 | |
| MaterialPriceControl | MaterialPriceControl | 1 | |
| MaterialPriceUnitQty | MaterialPriceUnitQty | 1 | |
| NetPaymentAmount | NetPaymentAmount | 1 | |
| NetPaymentDays | NetPaymentDays | 1 | |
| OperationalGLAccount | OperationalGLAccount | 1 | |
| OplAcctgDocItmCntrySpcfcRef1 | OplAcctgDocItmCntrySpcfcRef1 | 1 | |
| OrderIntBillOfOperationsItem | OrderIntBillOfOperationsItem | 1 | |
| OrderInternalBillOfOperations | OrderInternalBillOfOperations | 1 | |
| OriginalReferenceDocument | OriginalReferenceDocument | 1 | |
| PaymentBlockingReason | PaymentBlockingReason | 1 | |
| PaymentCardItem | PaymentCardItem | 1 | |
| PaymentCardPaymentSettlement | PaymentCardPaymentSettlement | 1 | |
| PaymentCurrency | PaymentCurrency | 1 | |
| PaymentDifferenceReason | PaymentDifferenceReason | 1 | |
| PaymentMethod | PaymentMethod | 1 | |
| PaymentMethodSupplement | PaymentMethodSupplement | 1 | |
| PaymentReason | PaymentReason | 1 | |
| PaymentRefByPaytSrvcProvider | PaymentRefByPaytSrvcProvider | 1 | |
| PaymentReference | PaymentReference | 1 | |
| PaymentServiceProvider | PaymentServiceProvider | 1 | |
| PaymentTerms | PaymentTerms | 1 | |
| PaytSlipWthRefCheckDigit | PaytSlipWthRefCheckDigit | 1 | |
| PaytSlipWthRefReference | PaytSlipWthRefReference | 1 | |
| PaytSlipWthRefSubscriber | PaytSlipWthRefSubscriber | 1 | |
| PlanningLevel | PlanningLevel | 1 | |
| ProfitabilitySegment | ProfitabilitySegment | 1 | |
| ProfitLossAccountType | ProfitLossAccountType | 1 | |
| PurchaseOrderQty | PurchaseOrderQty | 1 | |
| PurchasingDocumentPriceUnit | PurchasingDocumentPriceUnit | 1 | |
| QuantityInEntryUnit | QuantityInEntryUnit | 1 | |
| Reference1IDByBusinessPartner | Reference1IDByBusinessPartner | 1 | |
| Reference2IDByBusinessPartner | Reference2IDByBusinessPartner | 1 | |
| Reference3IDByBusinessPartner | Reference3IDByBusinessPartner | 1 | |
| ReferenceDocumentLogicalSystem | ReferenceDocumentLogicalSystem | 1 | |
| Region | Region | 1 | |
| REInternalFinNumber | REInternalFinNumber | 1 | |
| ScheduleLine | ScheduleLine | 1 | |
| SEPAMandate | SEPAMandate | 1 | |
| SpecialGLAccountAssignment | SpecialGLAccountAssignment | 1 | |
| SpecialGLTransactionType | SpecialGLTransactionType | 1 | |
| StateCentralBankPaymentReason | StateCentralBankPaymentReason | 1 | |
| SupplyingCountry | SupplyingCountry | 1 | |
| TaxAmount | TaxAmount | 1 | |
| TaxAmountInCoCodeCrcy | TaxAmountInCoCodeCrcy | 1 | |
| TaxBaseAmountInCoCodeCrcy | TaxBaseAmountInCoCodeCrcy | 1 | |
| TaxBaseAmountInTransCrcy | TaxBaseAmountInTransCrcy | 1 | |
| TaxDeterminationDate | TaxDeterminationDate | 1 | |
| TaxDistributionCode1 | TaxDistributionCode1 | 1 | |
| TaxDistributionCode2 | TaxDistributionCode2 | 1 | |
| TaxDistributionCode3 | TaxDistributionCode3 | 1 | |
| TaxJurisdiction | TaxJurisdiction | 1 | |
| TaxRateValidityStartDate | TaxRateValidityStartDate | 1 | |
| TaxSection | TaxSection | 1 | |
| TaxType | TaxType | 1 | |
| TreasuryContractType | TreasuryContractType | 1 | |
| VATRegistration | VATRegistration | 1 | |
| WithholdingTaxAmount | WithholdingTaxAmount | 1 | |
| WithholdingTaxBaseAmount | WithholdingTaxBaseAmount | 1 | |
| WithholdingTaxCertificate | WithholdingTaxCertificate | 1 | |
| WithholdingTaxCode | WithholdingTaxCode | 1 | |
| WithholdingTaxExemptionAmt | WithholdingTaxExemptionAmt | 1 |
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.
-- Journal Entry Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_MANAGEJOURNALENTRYITEM (
ABSOLUTEQUANTITY,
ACCOUNTINGDOCUMENT,
ACCOUNTINGDOCUMENTITEMREF,
ACCOUNTINGDOCUMENTITEMTYPE,
ACCOUNTSRECEIVABLEISPLEDGED,
ACCTSRECEIVABLEPLEDGINGCODE,
ADDITIONALCURRENCY1,
ADDITIONALCURRENCY2,
ADDRESSANDBANKISSETMANUALLY,
ALTERNATIVEPAYEEPAYER,
AMOUNTINADDITIONALCURRENCY1,
AMOUNTINADDITIONALCURRENCY2,
AMOUNTINPAYMENTCURRENCY,
ASSETCONTRACT,
BILLINGDOCUMENT,
BILLINGPERIODOFPERFENDDATE,
BILLINGPERIODOFPERFSTARTDATE,
BILLOFEXCHANGEPAYMENTREQUEST,
BILLOFEXCHANGEUSAGE,
BOEPAYMENTREQUESTCOMPANYCODE,
BOEPAYMENTREQUESTFISCALYEAR,
BPBANKACCOUNTINTERNALID,
BRANCHACCOUNT,
BRANCHCODE,
BUSINESSPLACE,
CASHDISCOUNT1DAYS,
CASHDISCOUNT1DUEDATE,
CASHDISCOUNT1PERCENT,
CASHDISCOUNT2DAYS,
CASHDISCOUNT2DUEDATE,
CASHDISCOUNT2PERCENT,
CASHDISCOUNTAMOUNT,
CASHDISCOUNTAMTINCOCODECRCY,
CASHDISCOUNTBASEAMOUNT,
CASHFLOWTYPE,
CLEARINGCREATIONDATE,
CLEARINGISREVERSED,
CLEARINGITEM,
COMMITMENTITEMSHORTID,
COMPANYCODECURRENCYDETNMETHOD,
CORPORATEGROUPACCOUNT,
COSTELEMENT,
CREDITAMOUNTINADDLCRCY1,
CREDITAMOUNTINADDLCRCY2,
CREDITCONTROLAREA,
CUSTOMERISINEXECUTION,
DATAEXCHANGEINSTRUCTION1,
DATAEXCHANGEINSTRUCTION2,
DATAEXCHANGEINSTRUCTION3,
DATAEXCHANGEINSTRUCTION4,
DEBITAMOUNTINADDLCRCY1,
DEBITAMOUNTINADDLCRCY2,
DELIVOFGOODSDESTCOUNTRY,
DOWNPAYMENTISNETPROCEDURE,
DUECALCULATIONBASEDATE,
DUNNINGAREA,
DUNNINGBLOCKINGREASON,
DUNNINGKEY,
DUNNINGLEVEL,
EARMARKEDFUNDSDOCUMENT,
EARMARKEDFUNDSDOCUMENTITEM,
FIXEDCASHDISCOUNT,
GOODSMOVEMENTENTRYUNIT,
HASPAYMENTORDER,
INTERESTCALCULATIONBLOCKREASON,
INVOICELIST,
ISAUTOMATICALLYCREATED,
ISBALANCESHEETACCOUNT,
ISCOMPLETELYDELIVERED,
ISEUTRIANGULARDEAL,
ISNOTCASHDISCOUNTLIABLE,
ISSALESRELATED,
ISUSEDINPAYMENTTRANSACTION,
LASTDUNNINGDATE,
LINEITEMDISPLAYISENABLED,
MATERIALPRICECONTROL,
MATERIALPRICEUNITQTY,
NETPAYMENTAMOUNT,
NETPAYMENTDAYS,
OPERATIONALGLACCOUNT,
OPLACCTGDOCITMCNTRYSPCFCREF1,
ORDERINTBILLOFOPERATIONSITEM,
ORDERINTERNALBILLOFOPERATIONS,
ORIGINALREFERENCEDOCUMENT,
PAYMENTBLOCKINGREASON,
PAYMENTCARDITEM,
PAYMENTCARDPAYMENTSETTLEMENT,
PAYMENTCURRENCY,
PAYMENTDIFFERENCEREASON,
PAYMENTMETHOD,
PAYMENTMETHODSUPPLEMENT,
PAYMENTREASON,
PAYMENTREFBYPAYTSRVCPROVIDER,
PAYMENTREFERENCE,
PAYMENTSERVICEPROVIDER,
PAYMENTTERMS,
PAYTSLIPWTHREFCHECKDIGIT,
PAYTSLIPWTHREFREFERENCE,
PAYTSLIPWTHREFSUBSCRIBER,
PLANNINGLEVEL,
PROFITABILITYSEGMENT,
PROFITLOSSACCOUNTTYPE,
PURCHASEORDERQTY,
PURCHASINGDOCUMENTPRICEUNIT,
QUANTITYINENTRYUNIT,
REFERENCE1IDBYBUSINESSPARTNER,
REFERENCE2IDBYBUSINESSPARTNER,
REFERENCE3IDBYBUSINESSPARTNER,
REFERENCEDOCUMENTLOGICALSYSTEM,
REGION,
REINTERNALFINNUMBER,
SCHEDULELINE,
SEPAMANDATE,
SPECIALGLACCOUNTASSIGNMENT,
SPECIALGLTRANSACTIONTYPE,
STATECENTRALBANKPAYMENTREASON,
SUPPLYINGCOUNTRY,
TAXAMOUNT,
TAXAMOUNTINCOCODECRCY,
TAXBASEAMOUNTINCOCODECRCY,
TAXBASEAMOUNTINTRANSCRCY,
TAXDETERMINATIONDATE,
TAXDISTRIBUTIONCODE1,
TAXDISTRIBUTIONCODE2,
TAXDISTRIBUTIONCODE3,
TAXJURISDICTION,
TAXRATEVALIDITYSTARTDATE,
TAXSECTION,
TAXTYPE,
TREASURYCONTRACTTYPE,
VATREGISTRATION,
WITHHOLDINGTAXAMOUNT,
WITHHOLDINGTAXBASEAMOUNT,
WITHHOLDINGTAXCERTIFICATE,
WITHHOLDINGTAXCODE,
WITHHOLDINGTAXEXEMPTIONAMT
);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