I_JournalEntryItemWIP

DDL: I_JOURNALENTRYITEMWIP SQL: IFIJRNLENTITMWIP Type: view BASIC
69 Fields 1 Data Sources 1 Associations

Interface View of Journal Entry Item Work In Process

I_JournalEntryItemWIP is a Basic CDS View that provides data about "Interface View of Journal Entry Item Work In Process" in SAP S/4HANA. It reads from 1 data source (I_JournalEntryItem) and exposes 69 fields with key fields CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem, Ledger. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_JournalEntryItem _a from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ProductCostCtrlgOrder OrderHeader $projection.OrderID = OrderHeader.OrderID

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IFIJRNLENTITMWIP view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Interface View of Journal Entry Item Work In Process view

Fields (69)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY Ledger _Ledger Ledger Ledger
LedgerFiscalYear LedgerFiscalYear
BusinessTransactionCategory BusinessTransactionCategory Business Transaction Category
BusinessTransactionType BusinessTransactionType Bus.transaction
ReferenceDocumentType ReferenceDocumentType Reference Document Type
ReferenceDocument ReferenceDocument Reference Document
ReferenceDocumentItem ReferenceDocumentItem Reference item
GLAccount GLAccount General Ledger
ChartOfAccounts ChartOfAccounts Node Class
ProfitCenter ProfitCenter Profit Center
ControllingArea ControllingArea Controlling Area
PostingDate PostingDate Posting Date for GR
Material Material Vehicle Model
Plant Plant Valuation Area
OrderID OrderID Order ID
OrderCategory OrderCategory Order Category
MaterialGroup MaterialGroup Product Group
SubLedgerAcctLineItemType SubLedgerAcctLineItemType SLALineItemType
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency AmountInGlobalCurrency Amount in Global Currency
FreeDefinedCurrency1 FreeDefinedCurrency1 Freely Defined Currency 1
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
FreeDefinedCurrency2 FreeDefinedCurrency2 Freely Defined Currency 2
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
FreeDefinedCurrency3 FreeDefinedCurrency3 Freely Defined Currency 3
AmountInFreeDefinedCurrency3 AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
FreeDefinedCurrency4 FreeDefinedCurrency4 Freely Defined Currency 4
AmountInFreeDefinedCurrency4 AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
FreeDefinedCurrency5 FreeDefinedCurrency5 Freely Defined Currency 5
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
FreeDefinedCurrency6 FreeDefinedCurrency6 Freely Defined Currency 6
AmountInFreeDefinedCurrency6 AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
FreeDefinedCurrency7 FreeDefinedCurrency7 Freely Defined Currency 7
AmountInFreeDefinedCurrency7 AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
FreeDefinedCurrency8 FreeDefinedCurrency8 Freely Defined Currency 8
AmountInFreeDefinedCurrency8 AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_JournalEntry _JournalEntry
_BusinessTransactionCategory _BusinessTransactionCategory
_BusinessTransactionType _BusinessTransactionType
_ReferenceDocumentType _ReferenceDocumentType
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_ChartOfAccounts _ChartOfAccounts
_ProfitCenter _ProfitCenter
_ControllingArea _ControllingArea
_Material _Material
_Plant _Plant
_Order _Order
_OrderCategory _OrderCategory
_MaterialGroup _MaterialGroup
_SubLedgerAccLineItemType _SubLedgerAccLineItemType
_CompanyCodeCurrency _CompanyCodeCurrency
_GlobalCurrency _GlobalCurrency
_FreeDefinedCurrency1 _FreeDefinedCurrency1
_FreeDefinedCurrency2 _FreeDefinedCurrency2
_FreeDefinedCurrency3 _FreeDefinedCurrency3
_FreeDefinedCurrency4 _FreeDefinedCurrency4
_FreeDefinedCurrency5 _FreeDefinedCurrency5
_FreeDefinedCurrency6 _FreeDefinedCurrency6
_FreeDefinedCurrency7 _FreeDefinedCurrency7
_FreeDefinedCurrency8 _FreeDefinedCurrency8
OrderIsRefurbishmentOrder OrderHeader OrderIsRefurbishmentOrder Refurbishment

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_JournalEntryItemWIP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IFIJRNLENTITMWIP

CREATE VIEW I_JournalEntryItemWIP AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  _Ledger.Ledger AS Ledger,
  LedgerFiscalYear,
  BusinessTransactionCategory,
  BusinessTransactionType,
  ReferenceDocumentType,
  ReferenceDocument,
  ReferenceDocumentItem,
  GLAccount,
  ChartOfAccounts,
  ProfitCenter,
  ControllingArea,
  PostingDate,
  Material,
  Plant,
  OrderID,
  OrderCategory,
  MaterialGroup,
  SubLedgerAcctLineItemType,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  OrderHeader.OrderIsRefurbishmentOrder AS OrderIsRefurbishmentOrder
FROM I_JournalEntryItem AS _a
LEFT OUTER JOIN I_ProductCostCtrlgOrder AS OrderHeader ON OrderID = OrderHeader.OrderID  -- association [1..1]
;

Learn More