C_Openbillingrequest

Open Billing Request | view: COPENBILLINGREQ | TRAN | Extraction: Not supported | Component: S/4HANA Professional Services Cloud - CPM
Column Name Description
BillingDocumentCategory Billing Category Show values
BillingDocumentType FK Billing Type
BillingDocumentDate Billing Date
SalesOrganization FK Sales Organization
SoldToParty FK Customer Number
DestinationCountry FK Destination Country/Region
ReferenceSDDocument Sales and Distribution Document Number
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value in Document Currency
Column Name Description
Column Name Description
BillingDocumentDate Billing Date
Column Name Description
BillingDocumentCategory Billing Category Show values
ReferenceSDDocumentCategory SD Document Category Show values
Column Name Description Domain name
SalesDocument Document number of the reference document VBELN
CustomerName Name of Customer
EngagementProjectUUID Engagement Project UUID /BOBF/CONF_KEY
EngagementProject Engagement Project ID
EngagementProjectName Customer Project Name
Master Data Relations Join Conditions
Billing Type
  • Client
  • Billing Type
  • C_OPENBILLINGREQUEST.MANDT == TVFK.MANDT
  • C_OPENBILLINGREQUEST.BILLINGDOCUMENTTYPE == TVFK.FKART
Destination Country/Region
  • Destination Country/Region
  • Client
  • C_OPENBILLINGREQUEST.DESTINATIONCOUNTRY == T005.LAND1
  • C_OPENBILLINGREQUEST.MANDT == T005.MANDT
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • C_OPENBILLINGREQUEST.MANDT == TVKOV.MANDT
  • C_OPENBILLINGREQUEST.SALESORGANIZATION == TVKOV.VKORG
  • C_OPENBILLINGREQUEST.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • C_OPENBILLINGREQUEST.MANDT == TVTA.MANDT
  • C_OPENBILLINGREQUEST.ORGANIZATIONDIVISION == TVTA.SPART
  • C_OPENBILLINGREQUEST.SALESORGANIZATION == TVTA.VKORG
  • C_OPENBILLINGREQUEST.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Order type in order header
  • Client
  • Sales Document Type
  • C_OPENBILLINGREQUEST.MANDT == TVAK.MANDT
  • C_OPENBILLINGREQUEST.SALESDOCUMENTTYPE == TVAK.AUART
Sales Organization
  • Client
  • Sales Organization
  • C_OPENBILLINGREQUEST.MANDT == TVKO.MANDT
  • C_OPENBILLINGREQUEST.SALESORGANIZATION == TVKO.VKORG
Customer Number
  • Client
  • Customer Number
  • C_OPENBILLINGREQUEST.MANDT == KNA1.MANDT
  • C_OPENBILLINGREQUEST.SOLDTOPARTY == KNA1.KUNNR
SD Document Currency
  • Client
  • SD Document Currency
  • C_OPENBILLINGREQUEST.MANDT == TCURC.MANDT
  • C_OPENBILLINGREQUEST.TRANSACTIONCURRENCY == TCURC.WAERS