C_ProjBillingElementEntrFlw

DDL: C_PROJBILLINGELEMENTENTRFLW Type: view_entity CONSUMPTION Package: VDM_PROJBILLINGELEMENTENTRY
74 Fields 1 Data Sources 4 Associations

C-View for Proj Billing Element Flow

C_ProjBillingElementEntrFlw is a Consumption CDS View that provides data about "C-View for Proj Billing Element Flow" in SAP S/4HANA. It reads from 1 data source (P_ProjBillingElementEntrFlw00) and exposes 74 fields with key fields ProjBillgElmntEntrItmFlowUUID, BillingDocument, BillingDocumentItem. It has 4 associations to related views. Part of development package VDM_PROJBILLINGELEMENTENTRY.

Data Sources (1)

SourceAliasJoin Type
P_ProjBillingElementEntrFlw00 P_ProjBillingElementEntrFlw00 from

Associations (4)

CardinalityTargetAliasCondition
[0..1] E_JournalEntryItem _JournalEntryItemExtension $projection.SourceLedger = _JournalEntryItemExtension.SourceLedger and $projection.CompanyCode = _JournalEntryItemExtension.CompanyCode and $projection.FiscalYear = _JournalEntryItemExtension.FiscalYear and $projection.AccountingDocument = _JournalEntryItemExtension.AccountingDocument and $projection.LedgerGLLineItem = _JournalEntryItemExtension.LedgerGLLineItem
[0..1] I_WorkItemText _WorkItemText _WorkItemText.WorkItem = $projection.WorkItem and _WorkItemText.Language = $session.system_language
[0..1] I_WorkPackageWorkItem _CustomWorkItemText _CustomWorkItemText.WorkItem = $projection.WorkItem and $projection.WorkPackage = _CustomWorkItemText.WorkPackage
[0..1] E_ProjectBillingElementEntry _ProjBillgElementEntry $projection.ProjBillgElmntEntrItmUUID = _ProjBillgElementEntry.ProjBillgElmntEntrItmUUID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label C-View for Proj Billing Element Flow view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (74)

KeyFieldSource TableSource FieldDescription
KEY ProjBillgElmntEntrItmFlowUUID ProjBillgElmntEntrItmFlowUUID PBE Flow UUID
KEY BillingDocument BillingDocument SD Document
KEY BillingDocumentItem BillingDocumentItem Item
SalesDocument SalesDocument SD Document
SalesDocumentItem SalesDocumentItem Sales Document Item
ProjBillgElmntEntrItmUUID ProjBillgElmntEntrItmUUID PBE Entry UUID
SDDocumentCategory SDDocumentCategory Document Cat.
TransactionCurrency TransactionCurrency Transaction Currency
QuantityUnit QuantityUnit Unit of measure
BillingRequestedQuantity BillingRequestedQuantity Billg Reqd Quantity
BillgReqdAmtInTransacCrcy BillgReqdAmtInTransacCrcy Billg Reqd Amount
BillgReqdAmtInGlobalCrcy BillgReqdAmtInGlobalCrcy Billg Reqd Amount
WrittenOffQuantity WrittenOffQuantity Written-off Quantity
WrittenOffAmtInTransacCrcy WrittenOffAmtInTransacCrcy Written-off Amount
WrittenOffAmtInGlobalCrcy WrittenOffAmtInGlobalCrcy Written-off Amount
PostponedQuantity PostponedQuantity Postponed Quantity
PostponedAmountInTransacCrcy PostponedAmountInTransacCrcy Postponed Amount
PostponedAmountInGlobalCrcy PostponedAmountInGlobalCrcy Postponed InGCrcy
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
NetPriceAmountInDocCrcy NetPriceAmountInDocCrcy Net Price
DocumentCurrency DocumentCurrency Document Currency
NetAmount NetAmount Stated Amount
Ledger Ledger Ledger
FiscalYear FiscalYear G/L Fiscal Year
AccountingDocument AccountingDocument Journal Entry
LedgerGLLineItem LedgerGLLineItem Journal Entry Item
CompanyCode CompanyCode Receiver Company Code
ForICO
BillingPlanasBillingPlan
BillingPlan
BillingPlanItem BillingPlanItem Item
ControllingObject ControllingObject Object number
CostCtrActivityType CostCtrActivityType Activity Type
ProjBillingRequestItemLongText ProjBillingRequestItemLongText Note
TimeSheetOvertimeCategory TimeSheetOvertimeCategory
SourceLedger SourceLedger Source Ledger
ControllingArea ControllingArea Controlling Area
ProfitCenter ProfitCenter Profit Center
ResponsibleCostCenter ResponsibleCostCenter Responsible Cost Center
ServicesRenderedDate ServicesRenderedDate Services Rendered Date
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
PartnerCompanyCode PartnerCompanyCode Partner Company Code
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSElement WBSElement WBS Internal ID
WBSDescription WBSDescription WBS Element Name
WBSElementObject WBSElementObject Object number
EmployeeFullName
Project Project WBS Element
WorkItem WorkItem Work Item ID
WorkPackage WorkPackage Plan Item
WorkItemNameendasWorkItemName
CostElement CostElement G/L Account
MaterialName _MaterialText MaterialName Material Description
ProjectDescription ProjectDescription Project Name
Personnel Personnel Personnel No.
TimeSheetOvertimeCategoryText _TimeSheetOvertimeCatText TimeSheetOvertimeCategoryText
CostCtrActivityTypeName _CostCenterActivityTypeText CostCtrActivityTypeName
ForICO
DocumentReferenceID DocumentReferenceID Reference
BillingPlanBillingDate _SlsDocItemBillingPlanDueDate BillingPlanBillingDate
BillingDocumentType BillingDocumentType Billing Type
ReferenceDocument ReferenceDocument Reference Document
ReferenceDocumentItem ReferenceDocumentItem Reference item
ReferenceDocumentType ReferenceDocumentType Reference Document Type
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
ProjBillgElmntEntrSrvcExpnCode ProjBillgElmntEntrSrvcExpnCode
_JournalEntry _JournalEntry
_MaterialText _MaterialText
_WBSElement _WBSElement
_ProjectBillingElementEntry _ProjectBillingElementEntry

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 C_ProjBillingElementEntrFlw.
-- 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.

CREATE VIEW C_ProjBillingElementEntrFlw AS
SELECT
  ProjBillgElmntEntrItmFlowUUID,
  BillingDocument,
  BillingDocumentItem,
  SalesDocument,
  SalesDocumentItem,
  ProjBillgElmntEntrItmUUID,
  SDDocumentCategory,
  TransactionCurrency,
  QuantityUnit,
  BillingRequestedQuantity,
  BillgReqdAmtInTransacCrcy,
  BillgReqdAmtInGlobalCrcy,
  WrittenOffQuantity,
  WrittenOffAmtInTransacCrcy,
  WrittenOffAmtInGlobalCrcy,
  PostponedQuantity,
  PostponedAmountInTransacCrcy,
  PostponedAmountInGlobalCrcy,
  GlobalCurrency,
  NetPriceAmountInDocCrcy,
  DocumentCurrency,
  NetAmount,
  Ledger,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  CompanyCode,
  Billing plan makes duplication of records while fetching from _SalesOrderItem _SalesOrderItem.BillingPlan as BillingPlan AS BillingPlanasBillingPlan,
  BillingPlanItem,
  ControllingObject,
  CostCtrActivityType,
  ProjBillingRequestItemLongText,
  TimeSheetOvertimeCategory,
  SourceLedger,
  ControllingArea,
  ProfitCenter,
  ResponsibleCostCenter,
  ServicesRenderedDate,
  PostingDate,
  DocumentDate,
  PartnerCompanyCode,
  Material,
  MaterialGroup,
  WBSElementInternalID,
  WBSElement,
  WBSDescription,
  WBSElementObject,
  _WorkForcePersonMappings._WorkForcePersonBPDetails.PersonFullName AS EmployeeFullName,
  Project,
  WorkItem,
  WorkPackage,
  case when _WorkItemText.WorkItemName is null then _CustomWorkItemText.WorkItemName else _WorkItemText.WorkItemName end as WorkItemName AS WorkItemNameendasWorkItemName,
  CostElement,
  _MaterialText.MaterialName AS MaterialName,
  ProjectDescription,
  Personnel,
  _TimeSheetOvertimeCatText.TimeSheetOvertimeCategoryText AS TimeSheetOvertimeCategoryText,
  _CostCenterActivityTypeText.CostCtrActivityTypeName AS CostCtrActivityTypeName,
  DocumentReferenceID,
  _SlsDocItemBillingPlanDueDate.BillingPlanBillingDate AS BillingPlanBillingDate,
  BillingDocumentType,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocumentType,
  IsReversal,
  IsReversed,
  ProjBillgElmntEntrSrvcExpnCode
FROM P_ProjBillingElementEntrFlw00
LEFT OUTER JOIN E_JournalEntryItem AS _JournalEntryItemExtension ON SourceLedger = _JournalEntryItemExtension.SourceLedger AND CompanyCode = _JournalEntryItemExtension.CompanyCode AND FiscalYear = _JournalEntryItemExtension.FiscalYear AND AccountingDocument = _JournalEntryItemExtension.AccountingDocument AND LedgerGLLineItem = _JournalEntryItemExtension.LedgerGLLineItem  -- association [0..1]
LEFT OUTER JOIN I_WorkItemText AS _WorkItemText ON _WorkItemText.WorkItem = WorkItem AND _WorkItemText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_WorkPackageWorkItem AS _CustomWorkItemText ON _CustomWorkItemText.WorkItem = WorkItem AND WorkPackage = _CustomWorkItemText.WorkPackage  -- association [0..1]
LEFT OUTER JOIN E_ProjectBillingElementEntry AS _ProjBillgElementEntry ON ProjBillgElmntEntrItmUUID = _ProjBillgElementEntry.ProjBillgElmntEntrItmUUID  -- association [0..1]
;

Learn More