R_BILLINGDOCUMENTREQUESTTP

CDS View

Billing Document Request - TP

R_BILLINGDOCUMENTREQUESTTP is a CDS View in S/4HANA. Billing Document Request - TP. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
A_BillingDocumentRequest_2 view_entity projection CONSUMPTION Header
A_BillingDocumentRequestS2S view_entity projection CONSUMPTION Header
I_BillingDocumentRequestTP view_entity projection TRANSACTIONAL Billing Document Request - TP 
@AccessControl: { authorizationCheck: #MANDATORY, personalData.blocking: #('TRANSACTIONAL_DATA'), privilegedAssociations: [ '_CreatedByUser' ] }

@EndUserText.label: 'Billing Document Request - TP'

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@ObjectModel: {
  sapObjectNodeType.name: 'BillingDocumentRequest',
  semanticKey: ['BillingDocumentRequest'],
  usageType: { 
    dataClass: #TRANSACTIONAL, 
    serviceQuality: #A, 
    sizeCategory: #L }
}
  
define root view entity R_BillingDocumentRequestTP
  as select from I_BillingDocumentRequest
  composition [0..*] of R_BillingDocumentRequestItemTP      as _Item
  composition [0..*] of R_BillgDocRequestPartnerTP          as _Partner
  composition [0..*] of R_BillingDocumentRequestTextTP      as _Text
  
    //Extensibility

  association [0..1] to E_BillingDocument               as _Extension      on $projection.BillingDocumentRequest = _Extension.BillingDocument

{
  key BillingDocumentRequest,
      SDDocumentCategory,
      BillingDocumentRequestType,
      ProposedBillingDocumentType,
      CreatedByUser,
      CreationDate,
      CreationTime,
      LastChangeDate,
      LastChangeDateTime,
      LogicalSystem,
      SalesOrganization,
      DistributionChannel,
      Division,
      BillingDocumentDate,
      BillgDocReqCombinationCriteria,
      TotalNetAmount,
      TransactionCurrency,
      TotalTaxAmount,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      cast( TotalTaxAmount + TotalNetAmount as sdci_odata_total_amount ) as TotalGrossAmount,
      CustomerPriceGroup,
      PriceListType,
      TaxDepartureCountry,
      VATRegistration,
      VATRegistrationOrigin,
      VATRegistrationCountry,
      CustomerTaxClassification1,
      CustomerTaxClassification2,
      CustomerTaxClassification3,
      CustomerTaxClassification4,
      CustomerTaxClassification5,
      CustomerTaxClassification6,
      CustomerTaxClassification7,
      CustomerTaxClassification8,
      CustomerTaxClassification9,
      SDPricingProcedure,
      IncotermsVersion,
      IncotermsClassification,
      IncotermsTransferLocation,
      IncotermsLocation1,
      IncotermsLocation2,
      PayerParty,
      ContractAccount,
      CustomerPaymentTerms,
      // Wrong foreign key association is used in the basic interface view

      @ObjectModel.foreignKey.association: null
      PaymentMethod,
      FixedValueDate,
      AdditionalValueDays,
      SEPAMandate,
      CompanyCode,
      CustomerAccountAssignmentGroup,
      ExchangeRateDate,
      ExchangeRateType,
      DocumentReferenceID,
      DunningArea,
      DunningBlockingReason,
      DunningKey,
      ReferenceDocument,
      ReferenceDocumentLogicalSystem,
      ReferenceDocSDDocCategory,
      SoldToParty,
      PurchaseOrderByCustomer,
      CustomerGroup,
      Country,
      CityCode,
      SalesDistrict,
      Region,
      @ObjectModel.foreignKey.association: '_County'
      County,
      CreditControlArea,
      PricingDocument,
      OverallBillingDocReqStatus,
      BillingIssueType,
      OverallPricingIncompletionSts,

      _Item,
      _Partner,
      _Text,
      
      _SDDocumentCategory,
      _ReferenceDocSDDocCategory,
      _BillingDocumentRequestType,
      _ProposedBillingDocumentType,
      _CreatedByUser,
      _LogicalSystem,
      _SalesOrganization,
      _DistributionChannel,
      _Division,
      _TransactionCurrency,
      _CustomerPriceGroup,
      _PriceListType,
      _TaxDepartureCountry,
      _VATRegistrationOrigin,
      _VATRegistrationCountry,
      _SDPricingProcedure,
      _IncotermsClassification,
      _IncotermsVersion,
      _PayerParty,
      _CustomerPaymentTerms,
      _CompanyCode,
      _CustomerAccountAssgmtGroup,
      _ExchangeRateType,
      _DunningArea,
      _DunningBlockingReason,
      _DunningKey,
      _SoldToParty,
      _CustomerGroup,
      _Country,
      _CityCode,
      _SalesDistrict,
      _Region,
      _County_2 as _County,
      _CreditControlArea,
      _OvrlBillingDocReqStatus,
      _BillingIssueType,
      _OverallPricingIncompletionSts

}

Learn More