Relatório de romaneio

former_member638291 · ‎2019 Oct 30

Quando a transportadora vem buscar a carga na empresa, existe a necessidade de mandar um documento com todas as notas fiscais que foram embarcadas e algumas informações como valor, volumetria, peso e cliente "Romaneio".

Essa informação serve para facilitar o trabalho da transportadora na organização das entregas.

Montei um cubo para coletar as informações do banco Hana.

@AccessControl.authorizationCheck: #CHECK

@AbapCatalog.compiler.compareFilter: true

@DataAging.noAgingRestriction: true

@EndUserText.label: 'Romaneio'

@AbapCatalog.sqlViewName: 'ZCROMANEIO'

@Analytics.dataCategory: #CUBE

@Search.searchable: false

//ajust

define view ZC_ROMANEIO

  as select from I_BillingDocumentPartner as I_BillingDocumentPartner

  association [0..1] to I_Customer               as _I_Customer_1            on  _I_Customer_1.Customer = I_BillingDocumentPartner.Supplier

  association [0..*] to I_BillingDocumentItem    as _I_BillingDocumentItem_2 on  _I_BillingDocumentItem_2.BillingDocument = I_BillingDocumentPartner.BillingDocument

  association [1..1] to I_BillingDocumentPartner as _CKE_toBase              on  _CKE_toBase.BillingDocument = I_BillingDocumentPartner.BillingDocument

                                                                             and _CKE_toBase.PartnerFunction = I_BillingDocumentPartner.PartnerFunction

{

      @EndUserText.label: 'Billing Document'

      @ObjectModel.text.element: null

      @Consumption.hidden: false

      @Consumption.filter.mandatory: false

      @Consumption.filter.multipleSelections: false

  key I_BillingDocumentPartner.BillingDocument                                                                          as BillingDocument,

      @EndUserText.label: 'Partner Function'

      @ObjectModel.text.element: null

      @Consumption.hidden: false

      @Consumption.filter.mandatory: false

      @Consumption.filter.multipleSelections: false

  key I_BillingDocumentPartner.PartnerFunction                                                                          as PartnerFunction,

      @EndUserText.label: 'Vendor'

      @ObjectModel.text.element: null

      @Consumption.hidden: false

      @Consumption.filter.mandatory: false

      @Consumption.filter.multipleSelections: false

      I_BillingDocumentPartner.Supplier                                                                                 as Supplier,

      @EndUserText.label: 'Name of Customer'

      @ObjectModel.text.element: null

      @Consumption.hidden: false

      @Consumption.filter.mandatory: false

      @Consumption.filter.multipleSelections: false

      @Semantics.text: true

      _I_Customer_1.CustomerName                                                                                        as CustomerName,

      @EndUserText.label: 'Billing Date'

      @ObjectModel.text.element: null

      @Consumption.hidden: false

      @Consumption.filter.mandatory: false

      @Consumption.filter.multipleSelections: false

      I_BillingDocumentPartner._BillingDocument.BillingDocumentDate                                                     as BillingDocumentDate,

      @EndUserText.label: 'Document Currency'

      @ObjectModel.text.element: null

      @Consumption.hidden: false

      @Consumption.filter.mandatory: false

      @Consumption.filter.multipleSelections: false

      @Semantics.currencyCode: true

      I_BillingDocumentPartner._BillingDocument.TransactionCurrency                                                     as TransactionCurrency,

      @EndUserText.label: 'Gross weight'

      @ObjectModel.text.element: null

      @Consumption.hidden: false

      @Consumption.filter.mandatory: false

      @Consumption.filter.multipleSelections: false

      @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'

      @Aggregation.default: #SUM

      _I_BillingDocumentItem_2.ItemGrossWeight                                                                          as ItemGrossWeight,

      @EndUserText.label: 'Net weight'

      @ObjectModel.text.element: null

      @Consumption.hidden: false

      @Consumption.filter.mandatory: false

      @Consumption.filter.multipleSelections: false

      @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'

      @Aggregation.default: #SUM

      _I_BillingDocumentItem_2.ItemNetWeight                                                                            as ItemNetWeight,

      @EndUserText.label: 'Weight unit'

      @ObjectModel.text.element: null

      @Consumption.hidden: false

      @Consumption.filter.mandatory: false

      @Consumption.filter.multipleSelections: false

      @Semantics.unitOfMeasure: true

      _I_BillingDocumentItem_2.ItemWeightUnit                                                                           as ItemWeightUnit,

      @EndUserText.label: 'Volume'

      @ObjectModel.text.element: null

      @Consumption.hidden: false

      @Consumption.filter.mandatory: false

      @Consumption.filter.multipleSelections: false

      @Semantics.quantity.unitOfMeasure: 'ItemVolumeUnit'

      @Aggregation.default: #SUM

      _I_BillingDocumentItem_2.ItemVolume                                                                               as ItemVolume,

      @EndUserText.label: 'Volume unit'

      @ObjectModel.text.element: null

      @Consumption.hidden: false

      @Consumption.filter.mandatory: false

      @Consumption.filter.multipleSelections: false

      @Semantics.unitOfMeasure: true

      _I_BillingDocumentItem_2.ItemVolumeUnit                                                                           as ItemVolumeUnit,

      @EndUserText.label: 'Region'

      @ObjectModel.text.element: null

      @Consumption.hidden: false

      @Consumption.filter.mandatory: false

      @Consumption.filter.multipleSelections: false

      I_BillingDocumentPartner._BillingDocument.Region                                                                  as Region,

      @EndUserText.label: 'Partner Function Name'

      @ObjectModel.text.element: null

      @Consumption.hidden: false

      @Consumption.filter.mandatory: false

      @Consumption.filter.multipleSelections: false

      @Semantics.text: true

      I_BillingDocumentPartner._PartnerFunction._Text.PartnerFunctionName                                               as PartnerFunctionName,

      @EndUserText.label: 'Name of Customer'

      @ObjectModel.text.element: null

      @Consumption.hidden: false

      @Consumption.filter.mandatory: false

      @Consumption.filter.multipleSelections: false

      @Semantics.text: true

      I_BillingDocumentPartner._BillingDocument._PayerParty.CustomerName                                                as CustomerName_3,

      @EndUserText.label: 'Customer'

      @ObjectModel.text.element: null

      @Consumption.hidden: false

      @Consumption.filter.mandatory: false

      @Consumption.filter.multipleSelections: false

      I_BillingDocumentPartner._BillingDocument._PayerParty.Customer                                                    as Customer,

      @EndUserText.label: 'City'

      @ObjectModel.text.element: null

      @Consumption.hidden: false

      @Consumption.filter.mandatory: false

      @Consumption.filter.multipleSelections: false

      I_BillingDocumentPartner._BillingDocument._PayerParty.CityName                                                    as CityName,

      @EndUserText.label: 'Reference'

      @ObjectModel.text.element: null

      @Consumption.hidden: false

      @Consumption.filter.mandatory: false

      @Consumption.filter.multipleSelections: false

      I_BillingDocumentPartner._BillingDocument.DocumentReferenceID                                                     as DocumentReferenceID,

      @EndUserText.label: 'Net Value'

      @ObjectModel.text.element: null

      @Consumption.hidden: false

      @Consumption.filter.mandatory: false

      @Consumption.filter.multipleSelections: false

      @Semantics.amount.currencyCode: 'TransactionCurrency'

      @Aggregation.default: #SUM

      _I_BillingDocumentItem_2.NetAmount                                                                                as NetAmount,

      @EndUserText.label: 'Tax Amount'

      @ObjectModel.text.element: null

      @Consumption.hidden: false

      @Consumption.filter.mandatory: false

      @Consumption.filter.multipleSelections: false

      @Semantics.amount.currencyCode: 'TransactionCurrency'

      @Aggregation.default: #SUM

      _I_BillingDocumentItem_2.TaxAmount                                                                                as TaxAmount,

      @EndUserText.label: 'Number of Packages'

      @ObjectModel.text.element: null

      @Consumption.hidden: false

      @Consumption.filter.mandatory: false

      @Consumption.filter.multipleSelections: false

      @Aggregation.default: #SUM

      cast(_I_BillingDocumentItem_2._ReferenceDeliveryDocumentItem._DeliveryDocument.TotalNumberOfPackage as abap.int4) as TotalNumberOfPackage,

      @EndUserText.label: 'Material'

      @ObjectModel.text.element: null

      @Consumption.hidden: false

      _I_BillingDocumentItem_2.Material                                                                                 as material,

      @EndUserText.label: 'Document Type'

      @ObjectModel.text.element: null

      @Consumption.hidden: false

      I_BillingDocumentPartner._BillingDocument.BillingDocumentType                                                     as BillingDocumentType,

      @EndUserText.label: 'Document is Cancelled'

      @ObjectModel.text.element: null

      @Consumption.hidden: false

      I_BillingDocumentPartner._BillingDocument.BillingDocumentIsCancelled                                              as BillingDocumentIsCancelled,

      @EndUserText.label: 'Document is Temporary'

      @ObjectModel.text.element: null

      @Consumption.hidden: false

      I_BillingDocumentPartner._BillingDocument.BillingDocumentIsTemporary                                              as BillingDocumentIsTemporary,

      @ObjectModel.text.element: null

      @Consumption.hidden: true

      _CKE_toBase                                                                                                       as _CKE_toBase

}

E montei a query para consumir as informações.

@AbapCatalog.sqlViewName : 'ZCROMANEIOQ'

@Analytics.query: true

@OData.publish: true

@EndUserText.label: 'Romaneio'

define view ZC_ROMANEIOQ

  as select from ZC_ROMANEIO

{



    //ajust

  @EndUserText.label: 'Transportadora'



  CustomerName,

  @AnalyticsDetails.query.axis:#ROWS

  @EndUserText.label: 'Nota Fiscal'

  DocumentReferenceID,

  @AnalyticsDetails.query.axis:#ROWS

  @EndUserText.label: 'ID Cliente'

  Customer,

  @AnalyticsDetails.query.axis:#ROWS

  @EndUserText.label: 'Cliente'

  CustomerName_3,

  @AnalyticsDetails.query.axis:#ROWS

  @EndUserText.label: 'Data de Faturamento'



  BillingDocumentDate,

  @AnalyticsDetails.query.axis:#ROWS

  @EndUserText.label: 'UF'

  Region,

  @AnalyticsDetails.query.axis:#ROWS

  @EndUserText.label: 'Cidade'

  CityName,

  @DefaultAggregation: #FORMULA

  @AnalyticsDetails.query.formula: '$projection.TotalNumberOfPackage / $projection.cont'

  @EndUserText.label: 'QtdePacotes'

  @AnalyticsDetails: {   exceptionAggregationSteps: [{  exceptionAggregationBehavior : #SUM, exceptionAggregationElements: ['DocumentReferenceID']   }]  }

  @AnalyticsDetails.query.decimals: 0

  0 as QtdePacotes,

  @EndUserText.label: 'Qtd Caixas'

  @AnalyticsDetails.query.decimals: 0

  @DefaultAggregation: #SUM

  @Consumption.hidden : true

  TotalNumberOfPackage,

  @DefaultAggregation: #FORMULA

  @AnalyticsDetails.query.formula: '$projection.NetAmount + $projection.TaxAmount'

  @EndUserText.label: 'Valor'

  0 as Valor,

  @AnalyticsDetails.query.decimals: 3

  ItemVolume,

  @AnalyticsDetails.query.decimals: 3

  @EndUserText.label: 'Peso Bruto'

  ItemGrossWeight,

  @AnalyticsDetails.query.decimals: 3

  @EndUserText.label: 'Peso Líquido'

  ItemNetWeight,

  @Consumption.hidden : true

  NetAmount,

  @EndUserText.label: 'Tipo de Parceiro'

  PartnerFunctionName,

  @EndUserText.label: 'ID Transportadora'

  Supplier,

  @Consumption.hidden : true

  TaxAmount,

  @EndUserText.label: 'Material'

  material,

  @EndUserText.label: 'Document Type'

  BillingDocumentType,

//  @EndUserText.label: 'Document is Cancelled'

//  BillingDocumentIsCancelled,



  @DefaultAggregation: #FORMULA

  @Consumption.hidden : true

  @EndUserText.label: 'cont'

  @AnalyticsDetails: {   exceptionAggregationSteps: [{  exceptionAggregationBehavior : #SUM, exceptionAggregationElements: ['material']   }]  }

  1 as cont



}

where

  (

    PartnerFunctionName = 'Agente de frete'

  )

  and

  (

    BillingDocumentIsCancelled = '#'

  )

    and

  (

    BillingDocumentType != 'S1'

  )

      and

  (

    BillingDocumentType != 'S2'

  )

Como o objetivo do relatório é para imprimir e mandar com a transportadora, não vi necessidade de utilizar o SAP Analytics Cloud.

Utilizei somente o View Browser "Business Role - SAP_BR_ANALYTICS_SPECIALIST"

Veja na imagem abaixo o relatório.

Com esse relatório atendemos uma necessidade que não existe de forma standard no S4/Hana.

Relatório de romaneio

IDoc Basics For Functional Consultants

LSMW for Functional Consultants in simple step-by-step way

Pricing procedure Steps and Details in SAP MM