I_PT_AcctgDocMatlVers

DDL: I_PT_ACCTGDOCMATLVERS SQL: IPTACCMATVERS Type: view COMPOSITE

PT AccountingDoc Material Version

I_PT_AcctgDocMatlVers is a Composite CDS View that provides data about "PT AccountingDoc Material Version" in SAP S/4HANA. It reads from 3 data sources (I_OperationalAcctgDocItem, I_PT_AcctgDocDgtlSgntr, I_PT_MaterialVersion) and exposes 7 fields with key fields CompanyCode, FiscalYear, AccountingDocument, Material.

3 data source(s) 7 fields

Data Sources (3)

SourceAliasJoin Type
I_OperationalAcctgDocItem OperationalAcctgDocItem inner
I_PT_AcctgDocDgtlSgntr Signature from
I_PT_MaterialVersion Version inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPTACCMATVERS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label PT AccountingDoc Material Version view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument
KEY Material I_OperationalAcctgDocItem Product
PortugueseMaterialVersion
PortugueseInvoiceDate I_PT_AcctgDocDgtlSgntr PortugueseInvoiceDate
_Product I_OperationalAcctgDocItem _Product 
@AbapCatalog.sqlViewName: 'IPTACCMATVERS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #D
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'PT AccountingDoc Material Version'
define view I_PT_AcctgDocMatlVers
  as select from I_PT_AcctgDocDgtlSgntr    as Signature

    inner join   I_OperationalAcctgDocItem as OperationalAcctgDocItem on  Signature.CompanyCode        = OperationalAcctgDocItem.CompanyCode
                                                                      and Signature.FiscalYear         = OperationalAcctgDocItem.FiscalYear
                                                                      and Signature.AccountingDocument = OperationalAcctgDocItem.AccountingDocument

    inner join   I_PT_MaterialVersion      as Version                 on OperationalAcctgDocItem.Product               =  Version.Material
                                                                      and(
                                                                        Signature.PortugueseDigitalSignatureDate       >  Version.PortugueseDigitalSignatureDate
                                                                        or(
                                                                          Signature.PortugueseDigitalSignatureDate     =  Version.PortugueseDigitalSignatureDate
                                                                          and Signature.PortugueseDigitalSignatureTime >= Version.PortugueseDigitalSignatureTime
                                                                        )
                                                                      )
{
  key OperationalAcctgDocItem.CompanyCode                                                             as CompanyCode,
  key OperationalAcctgDocItem.FiscalYear                                                              as FiscalYear,
  key OperationalAcctgDocItem.AccountingDocument                                                      as AccountingDocument,
  key OperationalAcctgDocItem.Product                                                                 as Material,

      cast(max(PortugueseMaterialVersion) as sipt_data_version)                                       as PortugueseMaterialVersion,
      Signature.PortugueseInvoiceDate,
      
      /* Associations */
      OperationalAcctgDocItem._Product
}
where
  OperationalAcctgDocItem.Product <> ''
group by
  OperationalAcctgDocItem.CompanyCode,
  OperationalAcctgDocItem.FiscalYear,
  OperationalAcctgDocItem.AccountingDocument,
  Signature.PortugueseInvoiceDate,
  OperationalAcctgDocItem.Product;

Learn More