A_BillingDocumentRequest
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)
| Source | Alias | Join Type |
|---|---|---|
| I_BillingDocumentRequest | I_BillingDocumentRequest | from |
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA