P_HU_MMInvoiceConsignment

DDL: P_HU_MMINVOICECONSIGNMENT SQL: PMMCONREPORT Type: view COMPOSITE

P_HU_MMInvoiceConsignment is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_MaterialText, I_ReceivablesPayablesItem, P_HU_AuditReport) and exposes 34 fields with key fields OriginalReferenceDocument, CompanyCode, BusinessPartner.

3 data source(s) 34 fields

Data Sources (3)

SourceAliasJoin Type
I_MaterialText I_MaterialText inner
I_ReceivablesPayablesItem I_ReceivablesPayablesItem inner
P_HU_AuditReport P_HU_AuditReport from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMMCONREPORT view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.personalData.blocking #REQUIRED view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY OriginalReferenceDocument P_HU_AuditReport AccountingDocument
KEY CompanyCode P_HU_AuditReport CompanyCode
KEY BusinessPartner
AccountingDocument P_HU_AuditReport AccountingDocument
AccountingDocumentItem P_HU_AuditReport AccountingDocumentItem
CompanyCodeCurrency P_HU_AuditReport CompanyCodeCurrency
TaxBaseAmountInCoCodeCrcy P_HU_AuditReport TaxBaseAmountInCoCodeCrcy
TaxCode P_HU_AuditReport TaxCode
ReferenceDocumentType P_HU_AuditReport ReferenceDocumentType
FiscalYear P_HU_AuditReport FiscalYear
DocumentNumber P_HU_AuditReport OriginalReferenceDocument
DocumentDate P_HU_AuditReport DocumentDate
PostingDate P_HU_AuditReport PostingDate
Language I_MaterialText Language
ProductName I_MaterialText MaterialName
Quantity I_ReceivablesPayablesItem Quantity
UnitOfMeasure I_ReceivablesPayablesItem BaseUnit
NetPriceAmount P_HU_AuditReport TaxBaseAmountInCoCodeCrcy
TaxAmount
TaxRate P_HU_AuditReport TaxRate
GrossAmount
AuthorizationGroup P_HU_AuditReport AuthorizationGroup
DocumentCurrency P_HU_AuditReport DocumentCurrency
DataControllerSet
DataController1
DataController2
DataController3
DataController4
DataController5
DataController6
DataController7
DataController8
DataController9
DataController10 
@AbapCatalog.sqlViewName: 'PMMCONREPORT'
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@VDM.private:true
@AccessControl.personalData.blocking: #REQUIRED

define view P_HU_MMInvoiceConsignment
  as select from P_HU_AuditReport

    inner join   I_ReceivablesPayablesItem on  P_HU_AuditReport.AccountingDocument = I_ReceivablesPayablesItem.AccountingDocument
                                           and P_HU_AuditReport.CompanyCode        = I_ReceivablesPayablesItem.CompanyCode
                                           and P_HU_AuditReport.FiscalYear         = I_ReceivablesPayablesItem.FiscalYear

    inner join   I_MaterialText            on  I_MaterialText.Material = I_ReceivablesPayablesItem.Material
                                           and I_MaterialText.Language = $session.system_language

{
      //Key Fields

      //============================================================================================================================================

  key P_HU_AuditReport.AccountingDocument                                                                                                    as OriginalReferenceDocument,

      //Company Code & Business Partner

      //============================================================================================================================================

  key P_HU_AuditReport.CompanyCode                                                                                                           as CompanyCode,
  key P_HU_AuditReport._BusinessPartner.BusinessPartner                                                                                      as BusinessPartner,

      //Help & Technical Fields

      //============================================================================================================================================

      P_HU_AuditReport.AccountingDocument,
      P_HU_AuditReport.AccountingDocumentItem,
      P_HU_AuditReport.CompanyCodeCurrency,
      P_HU_AuditReport.TaxBaseAmountInCoCodeCrcy,
      P_HU_AuditReport.TaxCode,
      P_HU_AuditReport.ReferenceDocumentType,
      P_HU_AuditReport.FiscalYear,
      //HEADER part

      //============================================================================================================================================

      // as Invoice_Nr

      P_HU_AuditReport.OriginalReferenceDocument                                                                                             as DocumentNumber,
      // as Invoice_Date,

      P_HU_AuditReport.DocumentDate                                                                                                          as DocumentDate,
      // as Fullfilment_Date

      P_HU_AuditReport.PostingDate                                                                                                           as PostingDate,



      I_MaterialText.Language                                                                                                                as Language,
      I_MaterialText.MaterialName                                                                                                            as ProductName,
      I_ReceivablesPayablesItem.Quantity                                                                                                     as Quantity,
      I_ReceivablesPayablesItem.BaseUnit                                                                                                     as UnitOfMeasure,

      // as Net_Price

      P_HU_AuditReport.TaxBaseAmountInCoCodeCrcy                                                                                             as NetPriceAmount,
      abs(P_HU_AuditReport.TaxAmountInCoCodeCrcy)                                                                                            as TaxAmount,
      P_HU_AuditReport.TaxRate                                                                                                               as TaxRate,
      (abs(P_HU_AuditReport.TaxAmountInCoCodeCrcy) + abs(P_HU_AuditReport.TaxBaseAmountInCoCodeCrcy))                                        as GrossAmount,
      P_HU_AuditReport.AuthorizationGroup,
      P_HU_AuditReport.DocumentCurrency,
      /*DPP*/
      P_HU_AuditReport._BusinessPartner.DataControllerSet as DataControllerSet,
      P_HU_AuditReport._BusinessPartner.DataController1   as DataController1,
      P_HU_AuditReport._BusinessPartner.DataController2   as DataController2,
      P_HU_AuditReport._BusinessPartner.DataController3   as DataController3,
      P_HU_AuditReport._BusinessPartner.DataController4   as DataController4,
      P_HU_AuditReport._BusinessPartner.DataController5   as DataController5,
      P_HU_AuditReport._BusinessPartner.DataController6   as DataController6,
      P_HU_AuditReport._BusinessPartner.DataController7   as DataController7,
      P_HU_AuditReport._BusinessPartner.DataController8   as DataController8,
      P_HU_AuditReport._BusinessPartner.DataController9   as DataController9,
      P_HU_AuditReport._BusinessPartner.DataController10  as DataController10
}
where
  P_HU_AuditReport._AccountingDocument.TransactionCode = 'MRKO'

Learn More