P_ARProcessFlowBillingDoc

DDL: P_ARPROCESSFLOWBILLINGDOC Type: view_entity CONSUMPTION Package: ODATA_PROCESS_FLOW_AR

Billing Doc details for AR Process Flow

P_ARProcessFlowBillingDoc is a Consumption CDS View that provides data about "Billing Doc details for AR Process Flow" in SAP S/4HANA. It reads from 3 data sources (I_SDDocumentPartner, I_SDDocumentPartner, I_BillingDocument) and exposes 40 fields with key field BillingDocument. It has 3 associations to related views. Part of development package ODATA_PROCESS_FLOW_AR.

3 data source(s) 40 fields

Data Sources (3)

SourceAliasJoin Type
I_SDDocumentPartner _BillTo left_outer
I_SDDocumentPartner _ShipTo left_outer
I_BillingDocument I_BillingDocument from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_UserContactCard _UserContactCard _UserContactCard.ContactCardID = $projection.CreatedByUser
[0..1] I_Customer _ShipToParty $projection.ShipToParty = _ShipToParty.Customer
[0..1] I_Customer _BillToParty $projection.BillToParty = _BillToParty.Customer

Annotations (8)

NameValueLevelField
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Billing Doc details for AR Process Flow view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
AccessControl.personalData.blocking #REQUIRED view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument I_BillingDocument BillingDocument
BillingDocumentType I_BillingDocument BillingDocumentType
BillingDocumentTypeName
SDDocumentCategory I_BillingDocument SDDocumentCategory
SoldToParty I_BillingDocument SoldToParty
CustomerName
ShipToParty I_SDDocumentPartner Customer
ShipToPartyName _ShipToParty CustomerName
PayerParty I_BillingDocument PayerParty
PayerPartyName
BillToParty I_SDDocumentPartner Customer
BillToPartyName _BillToParty CustomerName
TaxAmount I_BillingDocument TotalTaxAmount
TotalGrossAmount
TotalNetAmount I_BillingDocument TotalNetAmount
TransactionCurrency I_BillingDocument TransactionCurrency
BillingDocumentDate I_BillingDocument BillingDocumentDate
OverallSDProcessStatus I_BillingDocument OverallSDProcessStatus
OverallSDProcessStatusDesc
SalesOrganization I_BillingDocument SalesOrganization
SalesOrganizationName
DistributionChannel I_BillingDocument DistributionChannel
DistributionChannelName
Division I_BillingDocument Division
DivisionName
Divisionastxt_vtrberasSalesArea
DivisionName1astxt_vtrberasSalesAreaDesc
CustomerPaymentTerms I_BillingDocument CustomerPaymentTerms
CustomerPaymentTermsName
CreatedByUser I_BillingDocument CreatedByUser
FullName _UserContactCard FullName
CreationDate I_BillingDocument CreationDate
CreationTime I_BillingDocument CreationTime
_Item I_BillingDocument _Item
_SoldToParty I_BillingDocument _SoldToParty
_PayerParty I_BillingDocument _PayerParty
_ShipToParty _ShipToParty
_BillToParty _BillToParty
_TransactionCurrency I_BillingDocument _TransactionCurrency
_UserContactCard _UserContactCard 
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.privilegedAssociations:  [ '_UserContactCard'] 
@EndUserText.label: 'Billing Doc details for AR Process Flow'
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass:  #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #D
@AccessControl.personalData.blocking: #REQUIRED
define view entity P_ARProcessFlowBillingDoc
  as
  
select from I_BillingDocument

  left outer join I_SDDocumentPartner as _ShipTo        on  I_BillingDocument.BillingDocument = _ShipTo.SDDocument  
                                                        and _ShipTo.PartnerFunction = 'WE'
 
  left outer join I_SDDocumentPartner as _BillTo        on  I_BillingDocument.BillingDocument = _BillTo.SDDocument  
                                                        and _BillTo.PartnerFunction = 'RE'

  association [1..1] to I_UserContactCard  as _UserContactCard on  _UserContactCard.ContactCardID = $projection.CreatedByUser
  
  association [0..1] to I_Customer         as _ShipToParty     on  $projection.ShipToParty = _ShipToParty.Customer
  association [0..1] to I_Customer         as _BillToParty     on  $projection.BillToParty = _BillToParty.Customer

{
  key I_BillingDocument.BillingDocument,
      
      I_BillingDocument.BillingDocumentType,
      I_BillingDocument._BillingDocumentType._Text[1:Language = $session.system_language].BillingDocumentTypeName,
      
      I_BillingDocument.SDDocumentCategory,
      
      I_BillingDocument.SoldToParty,
      I_BillingDocument._SoldToParty.CustomerName,
      
      _ShipTo.Customer                                        as ShipToParty,
      _ShipToParty.CustomerName                               as ShipToPartyName,   
      
      I_BillingDocument.PayerParty,
      I_BillingDocument._PayerParty.CustomerName                                as PayerPartyName,
      
      _BillTo.Customer                                        as BillToParty,
      _BillToParty.CustomerName                               as BillToPartyName,
      
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      I_BillingDocument.TotalTaxAmount as TaxAmount,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      (I_BillingDocument.TotalTaxAmount + I_BillingDocument.TotalNetAmount) as TotalGrossAmount,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      I_BillingDocument.TotalNetAmount,
      @ObjectModel.foreignKey.association: '_TransactionCurrency'     
      I_BillingDocument.TransactionCurrency,
            
      I_BillingDocument.BillingDocumentDate,
            
      I_BillingDocument.OverallSDProcessStatus,
      I_BillingDocument._OverallSDProcessStatus._Text[1:Language = $session.system_language].OverallSDProcessStatusDesc,
      
      I_BillingDocument.SalesOrganization,
      I_BillingDocument._SalesOrganization._Text[1:Language = $session.system_language].SalesOrganizationName,
      I_BillingDocument.DistributionChannel,
      I_BillingDocument._DistributionChannel._Text[1:Language = $session.system_language].DistributionChannelName,
      I_BillingDocument.Division,
      I_BillingDocument._Division._Text[1:Language = $session.system_language].DivisionName,
      cast( 
        concat(
        concat( 
        concat(
        concat(
        I_BillingDocument.SalesOrganization, 
        '/'), 
         I_BillingDocument.DistributionChannel), 
         '/'), 
         I_BillingDocument.Division)                                                                       as txt_vtrber ) as SalesArea,
         
      cast( 
        concat_with_space(
        concat(
        concat_with_space(
        concat(
        I_BillingDocument._SalesOrganization._Text[1:Language = $session.system_language].SalesOrganizationName, 
        ','), 
        cast(I_BillingDocument._DistributionChannel._Text[1:Language = $session.system_language].DistributionChannelName as vtxtk), 1), 
        ','),  
        I_BillingDocument._Division._Text[1:Language = $session.system_language].DivisionName, 1)            as txt_vtrber ) as SalesAreaDesc,
         
      
      I_BillingDocument.CustomerPaymentTerms,
      I_BillingDocument._CustomerPaymentTerms._Text[1:Language = $session.system_language].CustomerPaymentTermsName,
      
      I_BillingDocument.CreatedByUser,
      _UserContactCard.FullName,
      
      I_BillingDocument.CreationDate,
      I_BillingDocument.CreationTime,
      I_BillingDocument._Item,
      I_BillingDocument._SoldToParty,
      I_BillingDocument._PayerParty,
      _ShipToParty,
      _BillToParty,
      I_BillingDocument._TransactionCurrency,
      _UserContactCard

}

Learn More