C_CustomerProjectInvoices

DDL: C_CUSTOMERPROJECTINVOICES SQL: CCUSTPROJINVC Type: view CONSUMPTION

Customer Project Invoices

C_CustomerProjectInvoices is a Consumption CDS View that provides data about "Customer Project Invoices" in SAP S/4HANA. It reads from 2 data sources (I_BillingDocumentItem, C_CustomerProjectBilling) and exposes 18 fields with key fields CustomerProject, CustomerProjectItem, BillingDocument, BillingDocumentItem. It has 3 associations to related views.

2 data source(s) 18 fields

Data Sources (2)

SourceAliasJoin Type
I_BillingDocumentItem BillingDocumentItem inner
C_CustomerProjectBilling CustomerProjectBilling from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_EngagementProjectDetails _EngagementProject $projection.CustomerProject = _EngagementProject.EngagementProject
[1..1] I_BillingDocument _BillingDocument $projection.BillingDocument = _BillingDocument.BillingDocument
[1..1] I_OverallBillingStatus _OverallBillingStatus $projection.overallbillingstatus = _OverallBillingStatus.OverallBillingStatus

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CCUSTPROJINVC view
EndUserText.label Customer Project Invoices view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY CustomerProject C_CustomerProjectBilling CustomerProject
KEY CustomerProjectItem C_CustomerProjectBilling CustomerProjectItem
KEY BillingDocument C_CustomerProjectBilling BillingDocument
KEY BillingDocumentItem I_BillingDocumentItem BillingDocumentItem
BillingDocumentItemText I_BillingDocumentItem BillingDocumentItemText
Material I_BillingDocumentItem Product
BillingQuantity I_BillingDocumentItem BillingQuantity
BillingQuantityUnit I_BillingDocumentItem BillingQuantityUnit
NetAmount I_BillingDocumentItem NetAmount
TransactionCurrency I_BillingDocumentItem TransactionCurrency
SoldToParty _BillingDocument SoldToParty
OverallBillingStatus _BillingDocument OverallBillingStatus
BillingDocumentDate _BillingDocument BillingDocumentDate
CustomerPaymentTerms _BillingDocument CustomerPaymentTerms
AdditionalValueDays _BillingDocument AdditionalValueDays
_OverallBillingStatus _OverallBillingStatus
_EngagementProject _EngagementProject
_BillingDocument _BillingDocument 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'CCUSTPROJINVC'
@EndUserText.label: 'Customer Project Invoices'
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
define view C_CustomerProjectInvoices
  as select from C_CustomerProjectBilling as CustomerProjectBilling
    inner join   I_BillingDocumentItem    as BillingDocumentItem on BillingDocumentItem.BillingDocument = CustomerProjectBilling.BillingDocument

  association [1..1] to C_EngagementProjectDetails    as _EngagementProject    on $projection.CustomerProject = _EngagementProject.EngagementProject
  association [1..1] to I_BillingDocument      as _BillingDocument      on $projection.BillingDocument = _BillingDocument.BillingDocument
  association [1..1] to I_OverallBillingStatus as _OverallBillingStatus on $projection.overallbillingstatus = _OverallBillingStatus.OverallBillingStatus
{
  key CustomerProjectBilling.CustomerProject,
  key CustomerProjectBilling.CustomerProjectItem as CustomerProjectItem,
      //--[ GENERATED:012:GlBfhyJl7kY4nRd09JNw30

      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_BillingDocumentStdVH',
                     element: 'BillingDocument' }
        }]
      // ]--GENERATED

  key CustomerProjectBilling.BillingDocument     as BillingDocument,
  key BillingDocumentItem.BillingDocumentItem,
      BillingDocumentItem.BillingDocumentItemText,
      BillingDocumentItem.Product               as Material,
      @Semantics.quantity.unitOfMeasure: 'BillingQuantityUnit'
      BillingDocumentItem.BillingQuantity,
      @Semantics.unitOfMeasure:'true'
      BillingDocumentItem.BillingQuantityUnit,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      BillingDocumentItem.NetAmount,
      @Semantics.currencyCode: true
      BillingDocumentItem.TransactionCurrency,
      _BillingDocument.SoldToParty,
      _BillingDocument.OverallBillingStatus,
      _BillingDocument.BillingDocumentDate,
      _BillingDocument.CustomerPaymentTerms,
      _BillingDocument.AdditionalValueDays,


      // @Semantics.currencyCode: true

      //BillingDocument.TransactionCurrency,

      //@Semantics.amount.currencyCode: 'TransactionCurrency'

      //BillingDocument.TotalNetAmount as TotalNetAmount,

      _OverallBillingStatus,
      _EngagementProject,
      _BillingDocument
}
where
     _BillingDocument.SDDocumentCategory = 'M'
  or _BillingDocument.SDDocumentCategory = 'N'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_CUSTOMERPROJECTBILLING",
"I_BILLINGDOCUMENT",
"I_BILLINGDOCUMENTITEM"
],
"ASSOCIATED":
[
"C_ENGAGEMENTPROJECTDETAILS",
"I_BILLINGDOCUMENT",
"I_OVERALLBILLINGSTATUS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More