A_BillingDocumentRequest

DDL: A_BILLINGDOCUMENTREQUEST Type: view COMPOSITE

Billing Document Request Header

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

Data Sources (1)

SourceAliasJoin Type
I_BillingDocumentRequest I_BillingDocumentRequest from

Associations (4)

CardinalityTargetAliasCondition
[0..*] A_BillingDocumentRequestItem _Item $projection.BillingDocumentRequest = _Item.BillingDocumentRequest
[0..*] A_BillingDocReqPartner _Partner $projection.BillingDocumentRequest = _Partner.BillingDocumentRequest
[0..*] A_BillingDocReqPrcgElmnt _PricingElement $projection.BillingDocumentRequest = _PricingElement.BillingDocumentRequest
[0..1] E_BillingDocument _Extension $projection.BillingDocumentRequest = _Extension.BillingDocument

Annotations (16)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Billing Document Request Header view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.sqlViewName ASDBDREQ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey BillingDocumentRequest view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY BillingDocumentRequest BillingDocumentRequest
BillingDocumentRequestType BillingDocumentRequestType
ProposedBillingDocumentType ProposedBillingDocumentType
CreationDate CreationDate
CreationTime CreationTime
LastChangeDate LastChangeDate
LastChangeDateTime LastChangeDateTime
LogicalSystem LogicalSystem
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
Division Division
BillingDocumentDate BillingDocumentDate
TotalNetAmount TotalNetAmount
TransactionCurrency TransactionCurrency
TotalTaxAmount TotalTaxAmount
TotalGrossAmount
TaxDepartureCountry TaxDepartureCountry
PayerParty PayerParty
ContractAccount ContractAccount
CustomerPaymentTerms CustomerPaymentTerms
PaymentMethod PaymentMethod
SEPAMandate SEPAMandate
CompanyCode CompanyCode
ReferenceDocument ReferenceDocument
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem
ReferenceDocSDDocCategory ReferenceDocSDDocCategory
SoldToParty SoldToParty
PurchaseOrderByCustomer PurchaseOrderByCustomer
PricingDocument PricingDocument
BillingIssueType BillingIssueType
IncotermsVersion IncotermsVersion
IncotermsClassification IncotermsClassification
IncotermsTransferLocation IncotermsTransferLocation
IncotermsLocation1 IncotermsLocation1
IncotermsLocation2 IncotermsLocation2
OverallBillingDocReqStatus OverallBillingDocReqStatus
OverallPricingIncompletionSts OverallPricingIncompletionSts
_Item _Item
_Partner _Partner
_PricingElement _PricingElement
@ClientHandling.algorithm:#SESSION_VARIABLE
@EndUserText.label: 'Billing Document Request Header'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AbapCatalog: {
  sqlViewName: 'ASDBDREQ',
  compiler.compareFilter: true,
  preserveKey: true
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
  representativeKey: 'BillingDocumentRequest',
  createEnabled: false,
  updateEnabled: false,
  deleteEnabled: true,
  usageType: {
    dataClass: #TRANSACTIONAL,
    serviceQuality: #A,
    sizeCategory: #XL
  }
} 
@Metadata: {
  ignorePropagatedAnnotations: true
}

define view A_BillingDocumentRequest as select from I_BillingDocumentRequest

  association [0..*] to A_BillingDocumentRequestItem  as _Item                        on  $projection.BillingDocumentRequest = _Item.BillingDocumentRequest
  association [0..*] to A_BillingDocReqPartner        as _Partner                     on  $projection.BillingDocumentRequest = _Partner.BillingDocumentRequest 
  association [0..*] to A_BillingDocReqPrcgElmnt      as _PricingElement              on  $projection.BillingDocumentRequest = _PricingElement.BillingDocumentRequest                                                                        

  //Extensibility

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

{

      //key

  key BillingDocumentRequest,

      @ObjectModel.sapObjectNodeTypeReference: 'BillingDocumentRequestType'                
      BillingDocumentRequestType,      
      @ObjectModel.sapObjectNodeTypeReference: 'BillingDocumentType'                
      ProposedBillingDocumentType, 

      //admin

      CreationDate,
      CreationTime,
      LastChangeDate,
      LastChangeDateTime,
      LogicalSystem,

      //org

      SalesOrganization,
      DistributionChannel,
      @ObjectModel.sapObjectNodeTypeReference: 'Division'                
      Division,

      //billing

      BillingDocumentDate,

      //pricing

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      TotalNetAmount,
      @Semantics.currencyCode: true
      @ObjectModel.sapObjectNodeTypeReference: 'Currency'                
      TransactionCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      TotalTaxAmount,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      (TotalTaxAmount + TotalNetAmount) as TotalGrossAmount,     
      TaxDepartureCountry,
      
      //payment

      PayerParty,
      ContractAccount,
      CustomerPaymentTerms,
      @ObjectModel.sapObjectNodeTypeReference: 'PaymentMethod'          
      PaymentMethod,
      SEPAMandate,

      //accounting

      CompanyCode,

      //reference

      ReferenceDocument,//BillingDocRequestReference,

      ReferenceDocumentLogicalSystem,//BillgDocReqRefLgclSyst,

      ReferenceDocSDDocCategory,//BillgDocReqRefSDDocCategory,


      //sales

      SoldToParty,
      PurchaseOrderByCustomer,
      PricingDocument,
      @ObjectModel.sapObjectNodeTypeReference: 'BillingIssueType'          
      BillingIssueType,

      //shipping

      @ObjectModel.sapObjectNodeTypeReference: 'IncotermsVersion'          
      IncotermsVersion,
      @ObjectModel.sapObjectNodeTypeReference: 'IncotermsClassification'          
      IncotermsClassification,
      IncotermsTransferLocation,
      IncotermsLocation1,
      IncotermsLocation2,

      //status

      @ObjectModel.sapObjectNodeTypeReference: 'OverallBillingDocRequestStatus'          
      OverallBillingDocReqStatus,
      @ObjectModel.sapObjectNodeTypeReference: 'OverallSDDocPrcgIncompltnSts'          
      OverallPricingIncompletionSts,

      //associations

      @ObjectModel.readOnly: true
      _Item,
      @ObjectModel.readOnly: true
      _Partner,
      @ObjectModel.readOnly: true
      _PricingElement
      
}
      
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLINGDOCUMENTREQUEST"
],
"ASSOCIATED":
[
"A_BILLINGDOCREQPARTNER",
"A_BILLINGDOCREQPRCGELMNT",
"A_BILLINGDOCUMENTREQUESTITEM",
"E_BILLINGDOCUMENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/