C_MPInvoiceWOSO

DDL: C_MPINVOICEWOSO SQL: CMPINVOICEWOSO Type: view CONSUMPTION

Master Project Invoice without Sales Order

C_MPInvoiceWOSO is a Consumption CDS View that provides data about "Master Project Invoice without Sales Order" in SAP S/4HANA. It reads from 1 data source (C_MstrProjInvoice) and exposes 9 fields with key fields MasterProject, BillingDocument.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
C_MstrProjInvoice Invoice from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CMPINVOICEWOSO view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Master Project Invoice without Sales Order view
AccessControl.personalData.blocking #REQUIRED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY MasterProject C_MstrProjInvoice MasterProject
KEY BillingDocument C_MstrProjInvoice BillingDocument
BillingDocumentType C_MstrProjInvoice BillingDocumentType
SalesOrganization C_MstrProjInvoice SalesOrganization
MasterProjectUUID C_MstrProjInvoice MasterProjectUUID
MasterProjectName C_MstrProjInvoice MasterProjectName
ExchangeRateDate C_MstrProjInvoice ExchangeRateDate
OverdueAmountInDisplayCrcy
TransactionCurrency C_MstrProjInvoice TransactionCurrency 
@AbapCatalog.sqlViewName: 'CMPINVOICEWOSO'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
//@Search.searchable: true    *ATC Error

@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Master Project Invoice without Sales Order'
@AccessControl.personalData.blocking: #REQUIRED
define view C_MPInvoiceWOSO as select from C_MstrProjInvoice as Invoice
{
//Open Invoices only

        @ObjectModel.text.element: 'MasterProjectName'
        @UI.lineItem
      //  @Search.defaultSearchElement: true    *ATC Error

        key Invoice.MasterProject,

      //  @Search.defaultSearchElement: true     *ATC Error

        @UI.lineItem
        key Invoice.BillingDocument,

        Invoice.BillingDocumentType,

        Invoice.SalesOrganization,

        Invoice.MasterProjectUUID,

        @Semantics.text: true
       // @Search.defaultSearchElement: true        *ATC Error

        @UI.lineItem
        Invoice.MasterProjectName,

        // @Search.defaultSearchElement: true        *ATC Error

        @UI.lineItem
        Invoice.ExchangeRateDate,

        @Semantics.amount.currencyCode: 'TransactionCurrency'
       // @Search.defaultSearchElement: true           *ATC Error

        @UI.lineItem
        sum(Invoice.OverdueAmountInDisplayCrcy) as OverdueAmountInDisplayCrcy,

        @Semantics.currencyCode: true
        @UI.lineItem
        Invoice.TransactionCurrency
}

//where Invoice.OverallBillingStatus <> 'C'

where Invoice.OverallBillingStatus = 'B'
group by Invoice.MasterProject,
Invoice.BillingDocument,
Invoice.BillingDocumentType,
Invoice.SalesOrganization,
Invoice.MasterProjectUUID,
Invoice.MasterProjectName,
Invoice.ExchangeRateDate,
Invoice.TransactionCurrency






/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_MSTRPROJINVOICE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More