What is FAC_DART_Z3_WIP_LINEITEM in SAP S/4HANA?

FAC_DART_Z3_WIP_LINEITEM is a cds CDS view in SAP S/4HANA. DART Z3 WIP Line Item It contains 85 fields.

Which tables does FAC_DART_Z3_WIP_LINEITEM read from?

FAC_DART_Z3_WIP_LINEITEM reads data from: fac_dart_z3_WIP_ACCOUNT, I_GLAccountLineItem, I_LedgerCompanyCodeCrcyRoles.

FAC_DART_Z3_WIP_LINEITEM

DDL: FAC_DART_Z3_WIP_LINEITEM SQL: FAC_DZWIPLNITM Type: view

85 Fields 3 Data Sources 2 Associations

DART Z3 WIP Line Item

FAC_DART_Z3_WIP_LINEITEM is a CDS View that provides data about "DART Z3 WIP Line Item" in SAP S/4HANA. It reads from 3 data sources (fac_dart_z3_WIP_ACCOUNT, I_GLAccountLineItem, I_LedgerCompanyCodeCrcyRoles) and exposes 85 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. It has 2 associations to related views.

Data Sources (3)

Source	Alias	Join Type
fac_dart_z3_WIP_ACCOUNT	fac_dart_z3_WIP_ACCOUNT	inner
I_GLAccountLineItem	I_GLAccountLineItem	from
I_LedgerCompanyCodeCrcyRoles	I_LedgerCompanyCodeCrcyRoles	inner

Parameters (3)

Name	Type	Default
P_FiscalYear	fins_gjahr
P_FromFiscalPeriod	fins_fagl_fiscper_from
P_ToFiscalPeriod	fins_fagl_fiscper_to

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_FiscalPeriodForVariant	_FromFiscalPeriodForVariant	`_FromFiscalPeriodForVariant.FiscalYearVariant = $projection.FiscalYearVariant and _FromFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear and _FromFiscalPeriodForVariant.FiscalPeriod = $parameters.P_FromFiscalPeriod`
[0..1]	I_FiscalPeriodForVariant	_ToFiscalPeriodForVariant	`_ToFiscalPeriodForVariant.FiscalYearVariant = $projection.FiscalYearVariant and _ToFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear and _ToFiscalPeriodForVariant.FiscalPeriod = $parameters.P_ToFiscalPeriod`

Annotations (9)

Name	Value	Level
AbapCatalog.sqlViewName	FAC_DZWIPLNITM	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
EndUserText.label	DART Z3 WIP Line Item	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view

Fields (85)

Key	Field	Source Table	Source Field	Description
KEY	SourceLedger	I_GLAccountLineItem	SourceLedger	Source Ledger
KEY	CompanyCode	I_GLAccountLineItem	CompanyCode	Receiver Company Code
KEY	FiscalYear	I_GLAccountLineItem	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	I_GLAccountLineItem	AccountingDocument	Journal Entry
KEY	LedgerGLLineItem	I_GLAccountLineItem	LedgerGLLineItem	Journal Entry Item
KEY	Ledger	I_GLAccountLineItem	Ledger	Ledger
	Plant	I_GLAccountLineItem	Plant	Valuation Area
	PlantName
	PostingDate	I_GLAccountLineItem	PostingDate	Posting Date for GR
	FiscalYearVariant	I_LedgerCompanyCodeCrcyRoles	FiscalYearVariant	FY Variant
	AccountingDocumentType	I_GLAccountLineItem	AccountingDocumentType	Journal Entry Type
	AccountingDocumentTypeName
	GLAccount	I_GLAccountLineItem	GLAccount	General Ledger
	ChartOfAccounts	I_GLAccountLineItem	ChartOfAccounts	Node Class
	GLAccountLongName
	OffsettingAccount	I_GLAccountLineItem	OffsettingAccount	Offsetting Acct
	OffsettingAccountType	I_GLAccountLineItem	OffsettingAccountType	Offset Acct Type
	OffsettingChartOfAccounts	I_GLAccountLineItem	OffsettingChartOfAccounts	Offsetting Chart of Accounts
	OffsettingAccountName
	Material	I_GLAccountLineItem	Material	Vehicle Model
	MaterialName
	ControllingArea	I_GLAccountLineItem	ControllingArea	Controlling Area
	OriginalReferenceDocument			Original Reference Document
	ReferenceDocument	I_GLAccountLineItem	ReferenceDocument	Reference Document
	ReferenceDocumentType	I_GLAccountLineItem	ReferenceDocumentType	Reference Document Type
	ReferenceDocumentTypeName			Business Transaction Type
	AmountInCompanyCodeCurrency	I_GLAccountLineItem	AmountInCompanyCodeCurrency	Local Crcy Amt
	CompanyCodeCurrency	I_GLAccountLineItem	CompanyCodeCurrency	Local Currency
	ValuationQuantity	I_GLAccountLineItem	ValuationQuantity
	CostSourceUnit	I_GLAccountLineItem	CostSourceUnit
	Supplier	I_GLAccountLineItem	Supplier	Supplier
	Customer	I_GLAccountLineItem	Customer	Sold-to Party
	BusinessArea	I_GLAccountLineItem	BusinessArea	Business Area
	Segment	I_GLAccountLineItem	Segment	Segment number
	FinancialAccountType	I_GLAccountLineItem	FinancialAccountType	Fin. Account Type
	ProfitCenter	I_GLAccountLineItem	ProfitCenter	Profit Center
	CostCenter	I_GLAccountLineItem	CostCenter	Cost Center
	SalesOrganization	I_GLAccountLineItem	SalesOrganization	Sales Organization
	DistributionChannel	I_GLAccountLineItem	DistributionChannel	RefDistCh-Cust/Mat.
	OrganizationDivision	I_GLAccountLineItem	OrganizationDivision	Org. Division
	ServiceDocumentType	I_GLAccountLineItem	ServiceDocumentType	Transaction Type
	ServiceDocument	I_GLAccountLineItem	ServiceDocument	Transaction ID
	MasterFixedAsset	I_GLAccountLineItem	MasterFixedAsset	Fixed Asset
	FixedAsset	I_GLAccountLineItem	FixedAsset	Sub-number
	AssetClass	I_GLAccountLineItem	AssetClass	Asset Class
	OrderID	I_GLAccountLineItem	OrderID	Order ID
	OrderCategory	I_GLAccountLineItem	OrderCategory	Order Category
	ValuationArea	I_GLAccountLineItem	ValuationArea	Valuation Area
	SalesDocument	I_GLAccountLineItem	SalesDocument	SD Document
	FunctionalArea	I_GLAccountLineItem	FunctionalArea	Sendr Fctl Area
	MaterialGroup	I_GLAccountLineItem	ProductGroup	Product Sold Group
	MaterialGroupName
	WBSElement	I_GLAccountLineItem	WBSElement	WBS Internal ID
	Project	I_GLAccountLineItem	Project	WBS Element
	FiscalPeriod	I_GLAccountLineItem	FiscalPeriod	Tax period
	_FunctionalArea	I_GLAccountLineItem	_FunctionalArea
	_Plant	I_GLAccountLineItem	_Plant
	_AccountingDocumentType	I_GLAccountLineItem	_AccountingDocumentType
	_GLAccountInChartOfAccounts	I_GLAccountLineItem	_GLAccountInChartOfAccounts
	_ChartOfAccounts	I_GLAccountLineItem	_ChartOfAccounts
	_ReferenceDocumentType	I_GLAccountLineItem	_ReferenceDocumentType
	_GLAccountInCompanyCode	I_GLAccountLineItem	_GLAccountInCompanyCode
	_Supplier	I_GLAccountLineItem	_Supplier
	_Customer	I_GLAccountLineItem	_Customer
	_BusinessArea	I_GLAccountLineItem	_BusinessArea
	_FinancialAccountType	I_GLAccountLineItem	_FinancialAccountType
	_ProfitCenter	I_GLAccountLineItem	_ProfitCenter
	_CurrentProfitCenter	I_GLAccountLineItem	_CurrentProfitCenter
	_CostCenter	I_GLAccountLineItem	_CostCenter
	_CurrentCostCenter	I_GLAccountLineItem	_CurrentCostCenter
	_SalesOrganization	I_GLAccountLineItem	_SalesOrganization
	_DistributionChannel	I_GLAccountLineItem	_DistributionChannel
	_ServiceDocumentType	I_GLAccountLineItem	_ServiceDocumentType
	_ServiceDocument	I_GLAccountLineItem	_ServiceDocument
	_MasterFixedAsset	I_GLAccountLineItem	_MasterFixedAsset
	_FixedAsset	I_GLAccountLineItem	_FixedAsset
	_Order	I_GLAccountLineItem	_Order
	_OrderCategory	I_GLAccountLineItem	_OrderCategory
	_PurReqValuationArea	I_GLAccountLineItem	_PurReqValuationArea
	_SalesDocument	I_GLAccountLineItem	_SalesDocument
	_SourceLedger	I_GLAccountLineItem	_SourceLedger
	_CompanyCode	I_GLAccountLineItem	_CompanyCode
	_FiscalYear	I_GLAccountLineItem	_FiscalYear
	_JournalEntry	I_GLAccountLineItem	_JournalEntry
	_Ledger	I_GLAccountLineItem	_Ledger

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 FAC_DART_Z3_WIP_LINEITEM.
-- 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: FAC_DZWIPLNITM
-- Parameters: P_FiscalYear : fins_gjahr, P_FromFiscalPeriod : fins_fagl_fiscper_from, P_ToFiscalPeriod : fins_fagl_fiscper_to

CREATE VIEW FAC_DART_Z3_WIP_LINEITEM AS
SELECT
  I_GLAccountLineItem.SourceLedger AS SourceLedger,
  I_GLAccountLineItem.CompanyCode AS CompanyCode,
  I_GLAccountLineItem.FiscalYear AS FiscalYear,
  I_GLAccountLineItem.AccountingDocument AS AccountingDocument,
  I_GLAccountLineItem.LedgerGLLineItem AS LedgerGLLineItem,
  I_GLAccountLineItem.Ledger AS Ledger,
  I_GLAccountLineItem.Plant AS Plant,
  I_GLAccountLineItem._Plant.PlantName AS PlantName,
  I_GLAccountLineItem.PostingDate AS PostingDate,
  I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant AS FiscalYearVariant,
  I_GLAccountLineItem.AccountingDocumentType AS AccountingDocumentType,
  I_GLAccountLineItem._AccountingDocumentType._Text[1: Language = $session.system_language].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  I_GLAccountLineItem.GLAccount AS GLAccount,
  I_GLAccountLineItem.ChartOfAccounts AS ChartOfAccounts,
  I_GLAccountLineItem._GLAccountInChartOfAccounts._Text[1: Language = $session.system_language].GLAccountLongName AS GLAccountLongName,
  I_GLAccountLineItem.OffsettingAccount AS OffsettingAccount,
  I_GLAccountLineItem.OffsettingAccountType AS OffsettingAccountType,
  I_GLAccountLineItem.OffsettingChartOfAccounts AS OffsettingChartOfAccounts,
  I_GLAccountLineItem._OffsettingAccountText.OffsettingAccountName AS OffsettingAccountName,
  I_GLAccountLineItem.Material AS Material,
  I_GLAccountLineItem._Material._Text[1: Language = $session.system_language].MaterialName AS MaterialName,
  I_GLAccountLineItem.ControllingArea AS ControllingArea,
  I_GLAccountLineItem._JournalEntry.OriginalReferenceDocument AS OriginalReferenceDocument,
  I_GLAccountLineItem.ReferenceDocument AS ReferenceDocument,
  I_GLAccountLineItem.ReferenceDocumentType AS ReferenceDocumentType,
  I_GLAccountLineItem._ReferenceDocumentType._Text[1: Language = $session.system_language ].ReferenceDocumentTypeName AS ReferenceDocumentTypeName,
  I_GLAccountLineItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  I_GLAccountLineItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_GLAccountLineItem.ValuationQuantity AS ValuationQuantity,
  I_GLAccountLineItem.CostSourceUnit AS CostSourceUnit,
  I_GLAccountLineItem.Supplier AS Supplier,
  I_GLAccountLineItem.Customer AS Customer,
  I_GLAccountLineItem.BusinessArea AS BusinessArea,
  I_GLAccountLineItem.Segment AS Segment,
  I_GLAccountLineItem.FinancialAccountType AS FinancialAccountType,
  I_GLAccountLineItem.ProfitCenter AS ProfitCenter,
  I_GLAccountLineItem.CostCenter AS CostCenter,
  I_GLAccountLineItem.SalesOrganization AS SalesOrganization,
  I_GLAccountLineItem.DistributionChannel AS DistributionChannel,
  I_GLAccountLineItem.OrganizationDivision AS OrganizationDivision,
  I_GLAccountLineItem.ServiceDocumentType AS ServiceDocumentType,
  I_GLAccountLineItem.ServiceDocument AS ServiceDocument,
  I_GLAccountLineItem.MasterFixedAsset AS MasterFixedAsset,
  I_GLAccountLineItem.FixedAsset AS FixedAsset,
  I_GLAccountLineItem.AssetClass AS AssetClass,
  I_GLAccountLineItem.OrderID AS OrderID,
  I_GLAccountLineItem.OrderCategory AS OrderCategory,
  I_GLAccountLineItem.ValuationArea AS ValuationArea,
  I_GLAccountLineItem.SalesDocument AS SalesDocument,
  I_GLAccountLineItem.FunctionalArea AS FunctionalArea,
  I_GLAccountLineItem.ProductGroup AS MaterialGroup,
  I_GLAccountLineItem._ProductGroup._Text[1: Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  I_GLAccountLineItem.WBSElement AS WBSElement,
  I_GLAccountLineItem.Project AS Project,
  I_GLAccountLineItem.FiscalPeriod AS FiscalPeriod,
  I_GLAccountLineItem._FunctionalArea AS _FunctionalArea,
  I_GLAccountLineItem._Plant AS _Plant,
  I_GLAccountLineItem._AccountingDocumentType AS _AccountingDocumentType,
  I_GLAccountLineItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  I_GLAccountLineItem._ChartOfAccounts AS _ChartOfAccounts,
  I_GLAccountLineItem._ReferenceDocumentType AS _ReferenceDocumentType,
  I_GLAccountLineItem._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  I_GLAccountLineItem._Supplier AS _Supplier,
  I_GLAccountLineItem._Customer AS _Customer,
  I_GLAccountLineItem._BusinessArea AS _BusinessArea,
  I_GLAccountLineItem._FinancialAccountType AS _FinancialAccountType,
  I_GLAccountLineItem._ProfitCenter AS _ProfitCenter,
  I_GLAccountLineItem._CurrentProfitCenter AS _CurrentProfitCenter,
  I_GLAccountLineItem._CostCenter AS _CostCenter,
  I_GLAccountLineItem._CurrentCostCenter AS _CurrentCostCenter,
  I_GLAccountLineItem._SalesOrganization AS _SalesOrganization,
  I_GLAccountLineItem._DistributionChannel AS _DistributionChannel,
  I_GLAccountLineItem._ServiceDocumentType AS _ServiceDocumentType,
  I_GLAccountLineItem._ServiceDocument AS _ServiceDocument,
  I_GLAccountLineItem._MasterFixedAsset AS _MasterFixedAsset,
  I_GLAccountLineItem._FixedAsset AS _FixedAsset,
  I_GLAccountLineItem._Order AS _Order,
  I_GLAccountLineItem._OrderCategory AS _OrderCategory,
  I_GLAccountLineItem._PurReqValuationArea AS _PurReqValuationArea,
  I_GLAccountLineItem._SalesDocument AS _SalesDocument,
  I_GLAccountLineItem._SourceLedger AS _SourceLedger,
  I_GLAccountLineItem._CompanyCode AS _CompanyCode,
  I_GLAccountLineItem._FiscalYear AS _FiscalYear,
  I_GLAccountLineItem._JournalEntry AS _JournalEntry,
  I_GLAccountLineItem._Ledger AS _Ledger
FROM I_GLAccountLineItem
INNER JOIN fac_dart_z3_WIP_ACCOUNT ON /* join condition not captured in parsed metadata */
INNER JOIN I_LedgerCompanyCodeCrcyRoles ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FromFiscalPeriodForVariant ON _FromFiscalPeriodForVariant.FiscalYearVariant = FiscalYearVariant AND _FromFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _FromFiscalPeriodForVariant.FiscalPeriod = $parameters.P_FromFiscalPeriod  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _ToFiscalPeriodForVariant ON _ToFiscalPeriodForVariant.FiscalYearVariant = FiscalYearVariant AND _ToFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _ToFiscalPeriodForVariant.FiscalPeriod = $parameters.P_ToFiscalPeriod  -- association [0..1]
;

Depth:

FAC_DART_Z3_WIP_LINEITEM view

FAC_DART_Z3_WIP_LINEITEM_WP0 view