FAC_DART_Z3_WIP_LINEITEM_FP0

DDL: FAC_DART_Z3_WIP_LINEITEM_FP0 SQL: FAC_DZWIPLNITMP0 Type: view
80 Fields 3 Data Sources

DART Z3 WIP Line Item

FAC_DART_Z3_WIP_LINEITEM_FP0 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 80 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem.

Data Sources (3)

SourceAliasJoin Type
fac_dart_z3_WIP_ACCOUNT fac_dart_z3_WIP_ACCOUNT inner
I_GLAccountLineItem I_GLAccountLineItem from
I_LedgerCompanyCodeCrcyRoles I_LedgerCompanyCodeCrcyRoles inner

Parameters (1)

NameTypeDefault
P_FiscalYear fins_gjahr

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FAC_DZWIPLNITMP0 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 (80)

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

CREATE VIEW FAC_DART_Z3_WIP_LINEITEM_FP0 AS
SELECT
  SourceLedger,
  I_GLAccountLineItem.CompanyCode AS CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  I_GLAccountLineItem.Ledger AS Ledger,
  Plant,
  _Plant.PlantName AS PlantName,
  PostingDate,
  I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant AS FiscalYearVariant,
  AccountingDocumentType,
  _AccountingDocumentType._Text[1: Language = $session.system_language].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  I_GLAccountLineItem.GLAccount AS GLAccount,
  I_GLAccountLineItem.ChartOfAccounts AS ChartOfAccounts,
  _GLAccountInChartOfAccounts._Text[1: Language = $session.system_language].GLAccountLongName AS GLAccountLongName,
  OffsettingAccount,
  OffsettingAccountType,
  OffsettingChartOfAccounts,
  _OffsettingAccountText.OffsettingAccountName AS OffsettingAccountName,
  Material,
  _Material._Text[1: Language = $session.system_language].MaterialName AS MaterialName,
  ControllingArea,
  _JournalEntry.OriginalReferenceDocument AS OriginalReferenceDocument,
  ReferenceDocument,
  ReferenceDocumentType,
  _ReferenceDocumentType._Text[1: Language = $session.system_language ].ReferenceDocumentTypeName AS ReferenceDocumentTypeName,
  AmountInCompanyCodeCurrency,
  CompanyCodeCurrency,
  ValuationQuantity,
  CostSourceUnit,
  Supplier,
  Customer,
  BusinessArea,
  Segment,
  FinancialAccountType,
  ProfitCenter,
  CostCenter,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  ServiceDocumentType,
  ServiceDocument,
  MasterFixedAsset,
  FixedAsset,
  OrderID,
  ValuationArea,
  SalesDocument,
  ProductGroup AS MaterialGroup,
  _ProductGroup._Text[1: Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  WBSElement,
  Project,
  FiscalPeriod,
  I_GLAccountLineItem._CompanyCode AS _CompanyCode,
  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 */
;

Learn More