C_ProjectBillgElmntEntrFlwTP_2

DDL: C_PROJECTBILLGELMNTENTRFLWTP_2 Type: view_entity CONSUMPTION Package: ODATA_PROJBILLINGELEMENT_LIST
37 Fields 1 Data Sources 4 OData Services

Flow Details of Billing Element

C_ProjectBillgElmntEntrFlwTP_2 is a Consumption CDS View that provides data about "Flow Details of Billing Element" in SAP S/4HANA. It reads from 1 data source (R_ProjectBillgElmntEntrFlwTP) and exposes 37 fields with key field ProjBillgElmntEntrItmFlowUUID. It is exposed through 4 OData services (ASQL_F4374A, ASQL_F4456A, UI_PROJECTBILLINGELEMENT, ...). Part of development package ODATA_PROJBILLINGELEMENT_LIST.

Data Sources (1)

SourceAliasJoin Type
R_ProjectBillgElmntEntrFlwTP R_ProjectBillgElmntEntrFlwTP projection

Annotations (6)

NameValueLevelField
EndUserText.label Flow Details of Billing Element view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view

OData Services (4)

ServiceBindingVersionContractRelease
ASQL_F4374A ASQL_F4374A C2 NOT_RELEASED
ASQL_F4456A ASQL_F4456A C2 NOT_RELEASED
UI_PROJECTBILLINGELEMENT UI_PROJECTBILLINGELEMENT V4 C1 NOT_RELEASED
UI_PROJECTBILLINGREQUEST UI_PROJECTBILLINGREQUEST V4 C1 NOT_RELEASED

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY ProjBillgElmntEntrItmFlowUUID ProjBillgElmntEntrItmFlowUUID PBE Flow UUID
ProjBillgElmntEntrItmUUID ProjBillgElmntEntrItmUUID PBE Entry UUID
ProjectBillingElementUUID ProjectBillingElementUUID PBE UUID
BillingDocument BillingDocument SD Document
BillingDocumentItem BillingDocumentItem Item
BillingDocumentType BillingDocumentType Billing Type
SDDocumentCategory SDDocumentCategory Document Cat.
ProjectBillingRequest PBR
BillingDocRequestItemReference BillingDocRequestItemReference
DocumentBillingStatus DocumentBillingStatus PBEE BDR Status
BillingDate BillingDate Billing Date
TransactionCurrency TransactionCurrency Transaction Currency
ProjectCurrency ProjectCurrency Project Currency
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
DocumentCurrency DocumentCurrency Document Currency
NetPriceAmountInDocCrcy NetPriceAmountInDocCrcy Net Price
NetPriceQuantity NetPriceQuantity Price Unit
NetPriceQuantityUnit NetPriceQuantityUnit SettlmtPrcUnit
QuantityUnit QuantityUnit Unit of measure
BillingRequestedQuantity BillingRequestedQuantity Billg Reqd Quantity
BillgReqdAmtInTransacCrcy BillgReqdAmtInTransacCrcy Billg Reqd Amount
BillgReqdAmtInProjectCrcy BillgReqdAmtInProjectCrcy Billg Reqd Amount
BillgReqdAmtInGlobalCrcy BillgReqdAmtInGlobalCrcy Billg Reqd Amount
WrittenOffQuantity WrittenOffQuantity Written-off Quantity
WrittenOffAmtInTransacCrcy WrittenOffAmtInTransacCrcy Written-off Amount
WrittenOffAmtInProjectCrcy WrittenOffAmtInProjectCrcy Written-off Amount
WrittenOffAmtInGlobalCrcy WrittenOffAmtInGlobalCrcy Written-off Amount
PostponedQuantity PostponedQuantity Postponed Quantity
PostponedAmountInTransacCrcy PostponedAmountInTransacCrcy Postponed Amount
PostponedAmountInProjectCrcy PostponedAmountInProjectCrcy Postponed Amount
PostponedAmountInGlobalCrcy PostponedAmountInGlobalCrcy Postponed InGCrcy
BillgReqdRevenueAmtInDocCrcy BillgReqdRevenueAmtInDocCrcy Billg Reqd Revn
WrittenOffRevenueAmtInDocCrcy WrittenOffRevenueAmtInDocCrcy Written-off Revenue
PrjBlgElmEntrFlwCreatedByUser PrjBlgElmEntrFlwCreatedByUser Entry Flow Crted By
PrjBlgElmEntrFlwCrtedAtDteTme PrjBlgElmEntrFlwCrtedAtDteTme Entry Flow Crted On
PrjBlgElmEntrFlwChangedByUser PrjBlgElmEntrFlwChangedByUser Entry Flow Chgd By
PrjBlgElmEntrFlwChgdAtDteTme PrjBlgElmEntrFlwChgdAtDteTme Entry Flow Chgd On

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_ProjectBillgElmntEntrFlwTP_2.
-- 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_ProjectBillgElmntEntrFlwTP_2 AS
SELECT
  ProjBillgElmntEntrItmFlowUUID,
  ProjBillgElmntEntrItmUUID,
  ProjectBillingElementUUID,
  BillingDocument,
  BillingDocumentItem,
  BillingDocumentType,
  SDDocumentCategory,
  cast( ProjectBillingRequest as pbr_extid preserving type ) AS ProjectBillingRequest,
  BillingDocRequestItemReference,
  DocumentBillingStatus,
  BillingDate,
  TransactionCurrency,
  ProjectCurrency,
  GlobalCurrency,
  DocumentCurrency,
  NetPriceAmountInDocCrcy,
  NetPriceQuantity,
  NetPriceQuantityUnit,
  QuantityUnit,
  BillingRequestedQuantity,
  BillgReqdAmtInTransacCrcy,
  BillgReqdAmtInProjectCrcy,
  BillgReqdAmtInGlobalCrcy,
  WrittenOffQuantity,
  WrittenOffAmtInTransacCrcy,
  WrittenOffAmtInProjectCrcy,
  WrittenOffAmtInGlobalCrcy,
  PostponedQuantity,
  PostponedAmountInTransacCrcy,
  PostponedAmountInProjectCrcy,
  PostponedAmountInGlobalCrcy,
  BillgReqdRevenueAmtInDocCrcy,
  WrittenOffRevenueAmtInDocCrcy,
  PrjBlgElmEntrFlwCreatedByUser,
  PrjBlgElmEntrFlwCrtedAtDteTme,
  PrjBlgElmEntrFlwChangedByUser,
  PrjBlgElmEntrFlwChgdAtDteTme
FROM R_ProjectBillgElmntEntrFlwTP
;

Learn More