P_ARProcessFlowBillgDocRequest

DDL: P_ARPROCESSFLOWBILLGDOCREQUEST Type: view_entity COMPOSITE

Billing Document Request Attributes

P_ARProcessFlowBillgDocRequest is a Composite CDS View that provides data about "Billing Document Request Attributes" in SAP S/4HANA. It reads from 1 data source (I_BillingDocumentRequest) and exposes 36 fields with key field BillingDocumentRequest. It has 2 associations to related views.

1 data source(s) 36 fields

Data Sources (1)

SourceAliasJoin Type
I_BillingDocumentRequest I_BillingDocumentRequest from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BillingDocumentRequest _BDR $projection.BillingDocumentRequest = _BDR.BillingDocumentRequest
[1..1] I_UserContactCard _UserContactCard $projection.CreatedByUser = _UserContactCard.ContactCardID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view
EndUserText.label Billing Document Request Attributes view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY BillingDocumentRequest I_BillingDocumentRequest BillingDocumentRequest
OverallBillingDocReqStatus I_BillingDocumentRequest OverallBillingDocReqStatus
TotalNetAmount I_BillingDocumentRequest TotalNetAmount
TransactionCurrency I_BillingDocumentRequest TransactionCurrency
BillingDocumentDate I_BillingDocumentRequest BillingDocumentDate
SoldToParty I_BillingDocumentRequest SoldToParty
PayerParty I_BillingDocumentRequest PayerParty
DocumentReferenceID I_BillingDocumentRequest DocumentReferenceID
FullName _UserContactCard FullName
SalesOrganization I_BillingDocumentRequest SalesOrganization
DistributionChannel I_BillingDocumentRequest DistributionChannel
Division I_BillingDocumentRequest Division
SalesOrganizationName
DistributionChannelName
DivisionName
OverallBillingStatusDesc
CustomerName
CustomerFullName
PayerPartyName
PaymentTermsName
Divisionastxt_vtrberasSalesArea
DivisionName1astxt_vtrberasSalesAreaDesc
CreatedByUser I_BillingDocumentRequest CreatedByUser
CustomerPaymentTerms I_BillingDocumentRequest CustomerPaymentTerms
CompanyCode I_BillingDocumentRequest CompanyCode
_BDR _BDR
_Item _Item
_SoldToParty _SoldToParty
_PayerParty _PayerParty
_TransactionCurrency _TransactionCurrency
_OvrlBillingDocReqStatus _OvrlBillingDocReqStatus
_CompanyCode _CompanyCode
_CustomerPaymentTerms _CustomerPaymentTerms
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division 
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #L,
  dataClass: #MIXED }

@VDM: {
  viewType: #COMPOSITE,
  private:true
}
@EndUserText.label: 'Billing Document Request Attributes'
define view entity P_ARProcessFlowBillgDocRequest
  as select from I_BillingDocumentRequest

  association [1..1] to I_BillingDocumentRequest as _BDR             on $projection.BillingDocumentRequest = _BDR.BillingDocumentRequest
  association [1..1] to I_UserContactCard        as _UserContactCard on $projection.CreatedByUser = _UserContactCard.ContactCardID

{
  key I_BillingDocumentRequest.BillingDocumentRequest,
      I_BillingDocumentRequest.OverallBillingDocReqStatus,
      I_BillingDocumentRequest.TotalNetAmount,
      I_BillingDocumentRequest.TransactionCurrency,
      I_BillingDocumentRequest.BillingDocumentDate,
      I_BillingDocumentRequest.SoldToParty,
      I_BillingDocumentRequest.PayerParty,
      I_BillingDocumentRequest.DocumentReferenceID, // External reference

      _UserContactCard.FullName,
      I_BillingDocumentRequest.SalesOrganization,
      I_BillingDocumentRequest.DistributionChannel,
      I_BillingDocumentRequest.Division,

      I_BillingDocumentRequest._SalesOrganization._Text[1:Language = $session.system_language].SalesOrganizationName,
      I_BillingDocumentRequest._DistributionChannel._Text[1:Language = $session.system_language].DistributionChannelName,
      I_BillingDocumentRequest._Division._Text[1:Language = $session.system_language].DivisionName,
      I_BillingDocumentRequest._OvrlBillingDocReqStatus._Text[1:Language = $session.system_language].OverallBillingStatusDesc,
      I_BillingDocumentRequest._SoldToParty.CustomerName,
      I_BillingDocumentRequest._SoldToParty.CustomerFullName,
      I_BillingDocumentRequest._PayerParty.CustomerName                                                                                                  as PayerPartyName,
      I_BillingDocumentRequest._CustomerPaymentTerms._Text[1:Language = $session.system_language].CustomerPaymentTermsName                               as PaymentTermsName,

      cast(
        concat(
            concat(
                concat(
                    concat(
                        I_BillingDocumentRequest.SalesOrganization,
                            '/'),
                                I_BillingDocumentRequest.DistributionChannel),
                                    '/'),
                                        I_BillingDocumentRequest.Division) as txt_vtrber )                                                               as SalesArea,

      cast(
        concat_with_space(
            concat(
                concat_with_space(
                    concat(
                        I_BillingDocumentRequest._SalesOrganization._Text[1:Language = $session.system_language].SalesOrganizationName,
                            ','),
                                cast(I_BillingDocumentRequest._DistributionChannel._Text[1:Language = $session.system_language].DistributionChannelName as vtxtk), 1),
                                    ','),
                                        I_BillingDocumentRequest._Division._Text[1:Language = $session.system_language].DivisionName, 1) as txt_vtrber ) as SalesAreaDesc,

      I_BillingDocumentRequest.CreatedByUser,
      cast(dats_tims_to_tstmp(I_BillingDocumentRequest.CreationDate,
                              I_BillingDocumentRequest.CreationTime,
                              abap_system_timezone($session.client, 'NULL'), $session.client, 'NULL') as fap_creationdatetime)                           as CreationDateTime,

      // ?? Payment Terms

      I_BillingDocumentRequest.CustomerPaymentTerms,
      I_BillingDocumentRequest.CompanyCode,

      _BDR,
      _Item,
      _SoldToParty,
      _PayerParty,
      _TransactionCurrency,
      _OvrlBillingDocReqStatus,
      _CompanyCode,
      _CustomerPaymentTerms,
      _SalesOrganization,
      _DistributionChannel,
      _Division
}

Learn More