A_BillingDocumentRequest

DDL: A_BILLINGDOCUMENTREQUEST Type: view COMPOSITE
40 Fields 1 Data Sources 4 Associations

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 Time Stamp
CreationTime CreationTime Time of Change
LastChangeDate LastChangeDate Time Stamp
LastChangeDateTime LastChangeDateTime Timestamp
LogicalSystem LogicalSystem Logical System
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
BillingDocumentDate BillingDocumentDate Billing Date
TotalNetAmount TotalNetAmount Total Net Amount
TransactionCurrency TransactionCurrency Transaction Currency
TotalTaxAmount TotalTaxAmount Tax Amount
TotalGrossAmount
TaxDepartureCountry TaxDepartureCountry Tx Dep Ctry/Reg
PayerParty PayerParty Payer
ContractAccount ContractAccount Contract Acct
CustomerPaymentTerms CustomerPaymentTerms Pyt Terms
PaymentMethod PaymentMethod Pymt Meth.
SEPAMandate SEPAMandate SEPA Mandate
CompanyCode CompanyCode Receiver Company Code
ReferenceDocument ReferenceDocument Reference Document
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
ReferenceDocSDDocCategory ReferenceDocSDDocCategory
SoldToParty SoldToParty Sold-to Party
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
PricingDocument PricingDocument Document Condition
BillingIssueType BillingIssueType
IncotermsVersion IncotermsVersion Inco. Version
IncotermsClassification IncotermsClassification Incoterms
IncotermsTransferLocation IncotermsTransferLocation Incoterms 2
IncotermsLocation1 IncotermsLocation1 Inco. Location1
IncotermsLocation2 IncotermsLocation2 Inco. Location2
OverallBillingDocReqStatus OverallBillingDocReqStatus
OverallPricingIncompletionSts OverallPricingIncompletionSts
_Item _Item
_Partner _Partner
_PricingElement _PricingElement

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_BillingDocumentRequest.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW A_BillingDocumentRequest AS
SELECT
  BillingDocumentRequest,
  BillingDocumentRequestType,
  ProposedBillingDocumentType,
  CreationDate,
  CreationTime,
  LastChangeDate,
  LastChangeDateTime,
  LogicalSystem,
  SalesOrganization,
  DistributionChannel,
  Division,
  BillingDocumentDate,
  TotalNetAmount,
  TransactionCurrency,
  TotalTaxAmount,
  (TotalTaxAmount + TotalNetAmount) AS TotalGrossAmount,
  TaxDepartureCountry,
  PayerParty,
  ContractAccount,
  CustomerPaymentTerms,
  PaymentMethod,
  SEPAMandate,
  CompanyCode,
  ReferenceDocument,
  ReferenceDocumentLogicalSystem,
  ReferenceDocSDDocCategory,
  SoldToParty,
  PurchaseOrderByCustomer,
  PricingDocument,
  BillingIssueType,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  OverallBillingDocReqStatus,
  OverallPricingIncompletionSts
FROM I_BillingDocumentRequest
LEFT OUTER JOIN A_BillingDocumentRequestItem AS _Item ON BillingDocumentRequest = _Item.BillingDocumentRequest  -- association [0..*]
LEFT OUTER JOIN A_BillingDocReqPartner AS _Partner ON BillingDocumentRequest = _Partner.BillingDocumentRequest  -- association [0..*]
LEFT OUTER JOIN A_BillingDocReqPrcgElmnt AS _PricingElement ON BillingDocumentRequest = _PricingElement.BillingDocumentRequest  -- association [0..*]
LEFT OUTER JOIN E_BillingDocument AS _Extension ON BillingDocumentRequest = _Extension.BillingDocument  -- association [0..1]
;

Learn More