A_BillingDocument_2
Billing Document
A_BillingDocument_2 is a Consumption CDS View that provides data about "Billing Document" in SAP S/4HANA. It reads from 1 data source (R_BillingDocumentTP) and exposes 98 fields with key field BillingDocument.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_BillingDocumentTP | R_BillingDocumentTP | projection |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Billing Document | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.modelingPattern | #TRANSACTIONAL_QUERY | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| OData.entityType.name | BillingDocument_Type | view | |
| VDM.lifecycle.contract.type | #PUBLIC_REMOTE_API | view | |
| VDM.viewType | #CONSUMPTION | view | |
| Search.searchable | true | view |
Fields (98)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | BillingDocument | BillingDocument | BillingDocument | |
| SDDocumentCategory | BillingDocument | SDDocumentCategory | ||
| BillingDocumentCategory | BillingDocument | BillingDocumentCategory | ||
| BillingDocumentType | ||||
| CreatedByUser | BillingDocument | CreatedByUser | ||
| CreationDate | BillingDocument | CreationDate | ||
| CreationTime | BillingDocument | CreationTime | ||
| LastChangeDate | BillingDocument | LastChangeDate | ||
| LastChangeDateTime | BillingDocument | LastChangeDateTime | ||
| LogicalSystem | BillingDocument | LogicalSystem | ||
| SalesOrganization | BillingDocument | SalesOrganization | ||
| DistributionChannel | BillingDocument | DistributionChannel | ||
| Division | BillingDocument | Division | ||
| BillingDocumentDate | BillingDocument | BillingDocumentDate | ||
| BillingDocumentIsCancelled | BillingDocument | BillingDocumentIsCancelled | ||
| CancelledBillingDocument | BillingDocument | CancelledBillingDocument | ||
| BillingDocCombinationCriteria | BillingDocument | BillingDocCombinationCriteria | ||
| ManualInvoiceMaintIsRelevant | BillingDocument | ManualInvoiceMaintIsRelevant | ||
| NmbrOfPages | BillingDocument | NmbrOfPages | ||
| IsIntrastatReportingRelevant | BillingDocument | IsIntrastatReportingRelevant | ||
| IsIntrastatReportingExcluded | BillingDocument | IsIntrastatReportingExcluded | ||
| BillingDocumentIsTemporary | BillingDocument | BillingDocumentIsTemporary | ||
| TotalNetAmount | BillingDocument | TotalNetAmount | ||
| TransactionCurrency | BillingDocument | TransactionCurrency | ||
| StatisticsCurrency | BillingDocument | StatisticsCurrency | ||
| TotalTaxAmount | BillingDocument | TotalTaxAmount | ||
| CustomerPriceGroup | BillingDocument | CustomerPriceGroup | ||
| PriceListType | BillingDocument | PriceListType | ||
| TaxDepartureCountry | BillingDocument | TaxDepartureCountry | ||
| VATRegistration | BillingDocument | VATRegistration | ||
| VATRegistrationOrigin | BillingDocument | VATRegistrationOrigin | ||
| VATRegistrationCountry | BillingDocument | VATRegistrationCountry | ||
| HierarchyTypePricing | BillingDocument | HierarchyTypePricing | ||
| CustomerTaxClassification1 | BillingDocument | CustomerTaxClassification1 | ||
| CustomerTaxClassification2 | BillingDocument | CustomerTaxClassification2 | ||
| CustomerTaxClassification3 | BillingDocument | CustomerTaxClassification3 | ||
| CustomerTaxClassification4 | BillingDocument | CustomerTaxClassification4 | ||
| CustomerTaxClassification5 | BillingDocument | CustomerTaxClassification5 | ||
| CustomerTaxClassification6 | BillingDocument | CustomerTaxClassification6 | ||
| CustomerTaxClassification7 | BillingDocument | CustomerTaxClassification7 | ||
| CustomerTaxClassification8 | BillingDocument | CustomerTaxClassification8 | ||
| CustomerTaxClassification9 | BillingDocument | CustomerTaxClassification9 | ||
| IsEUTriangularDeal | BillingDocument | IsEUTriangularDeal | ||
| SDPricingProcedure | BillingDocument | SDPricingProcedure | ||
| ShippingCondition | BillingDocument | ShippingCondition | ||
| IncotermsVersion | BillingDocument | IncotermsVersion | ||
| IncotermsClassification | BillingDocument | IncotermsClassification | ||
| IncotermsTransferLocation | BillingDocument | IncotermsTransferLocation | ||
| IncotermsLocation1 | BillingDocument | IncotermsLocation1 | ||
| IncotermsLocation2 | BillingDocument | IncotermsLocation2 | ||
| PayerParty | BillingDocument | PayerParty | ||
| ContractAccount | BillingDocument | ContractAccount | ||
| CustomerPaymentTerms | BillingDocument | CustomerPaymentTerms | ||
| PaymentMethod | BillingDocument | PaymentMethod | ||
| PaymentReference | BillingDocument | PaymentReference | ||
| FixedValueDate | BillingDocument | FixedValueDate | ||
| AdditionalValueDays | BillingDocument | AdditionalValueDays | ||
| SEPAMandate | BillingDocument | SEPAMandate | ||
| CompanyCode | BillingDocument | CompanyCode | ||
| FiscalYear | BillingDocument | FiscalYear | ||
| AccountingDocument | BillingDocument | AccountingDocument | ||
| FiscalPeriod | BillingDocument | FiscalPeriod | ||
| CustomerAccountAssignmentGroup | BillingDocument | CustomerAccountAssignmentGroup | ||
| AccountingExchangeRateIsSet | BillingDocument | AccountingExchangeRateIsSet | ||
| AccountingExchangeRate | BillingDocument | AccountingExchangeRate | ||
| ExchangeRateDate | BillingDocument | ExchangeRateDate | ||
| ExchangeRateType | BillingDocument | ExchangeRateType | ||
| DocumentReferenceID | BillingDocument | DocumentReferenceID | ||
| AssignmentReference | BillingDocument | AssignmentReference | ||
| ReversalReason | BillingDocument | ReversalReason | ||
| DunningArea | BillingDocument | DunningArea | ||
| DunningBlockingReason | BillingDocument | DunningBlockingReason | ||
| DunningKey | BillingDocument | DunningKey | ||
| InternalFinancialDocument | BillingDocument | InternalFinancialDocument | ||
| IsRelevantForAccrual | BillingDocument | IsRelevantForAccrual | ||
| SoldToParty | BillingDocument | SoldToParty | ||
| PartnerCompany | BillingDocument | PartnerCompany | ||
| PurchaseOrderByCustomer | BillingDocument | PurchaseOrderByCustomer | ||
| CustomerGroup | BillingDocument | CustomerGroup | ||
| Country | BillingDocument | Country | ||
| CityCode | BillingDocument | CityCode | ||
| SalesDistrict | BillingDocument | SalesDistrict | ||
| Region | BillingDocument | Region | ||
| County | BillingDocument | County | ||
| CreditControlArea | BillingDocument | CreditControlArea | ||
| CustomerRebateAgreement | BillingDocument | CustomerRebateAgreement | ||
| PricingDocument | BillingDocument | PricingDocument | ||
| OverallSDProcessStatus | BillingDocument | OverallSDProcessStatus | ||
| OverallBillingStatus | BillingDocument | OverallBillingStatus | ||
| AccountingPostingStatus | BillingDocument | AccountingPostingStatus | ||
| AccountingTransferStatus | BillingDocument | AccountingTransferStatus | ||
| BillingIssueType | BillingDocument | BillingIssueType | ||
| InvoiceListStatus | BillingDocument | InvoiceListStatus | ||
| OvrlItmGeneralIncompletionSts | BillingDocument | OvrlItmGeneralIncompletionSts | ||
| OverallPricingIncompletionSts | BillingDocument | OverallPricingIncompletionSts | ||
| InvoiceClearingStatus | BillingDocument | InvoiceClearingStatus | ||
| InvoiceListType | BillingDocument | InvoiceListType | ||
| InvoiceListBillingDate | BillingDocument | InvoiceListBillingDate |
@EndUserText.label: 'Billing Document'
@AccessControl: {
authorizationCheck: #MANDATORY,
personalData.blocking: #('TRANSACTIONAL_DATA')
}
@Metadata: {
// allowExtensions: false,
ignorePropagatedAnnotations: true
}
@ObjectModel: {
modelingPattern: #TRANSACTIONAL_QUERY,
supportedCapabilities: [#TRANSACTIONAL_PROVIDER],
usageType: {
serviceQuality: #C,
sizeCategory: #L,
dataClass: #TRANSACTIONAL
}
}
@OData: {
entityType.name: 'BillingDocument_Type'
}
@VDM: {
lifecycle.contract.type: #PUBLIC_REMOTE_API,
viewType: #CONSUMPTION,
usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
}
@Search.searchable: true
define root view entity A_BillingDocument_2
provider contract transactional_query
as projection on R_BillingDocumentTP as BillingDocument
{
@Search: {
defaultSearchElement: true,
ranking: #HIGH,
fuzzinessThreshold: 0.8
}
key BillingDocument.BillingDocument,
BillingDocument.SDDocumentCategory,
BillingDocument.BillingDocumentCategory,
@ObjectModel.sapObjectNodeTypeReference: 'BillingDocumentType'
cast(BillingDocument.BillingDocumentType as fkart preserving type ) as BillingDocumentType,
BillingDocument.CreatedByUser,
BillingDocument.CreationDate,
BillingDocument.CreationTime,
BillingDocument.LastChangeDate,
BillingDocument.LastChangeDateTime,
BillingDocument.LogicalSystem,
BillingDocument.SalesOrganization,
BillingDocument.DistributionChannel,
BillingDocument.Division,
BillingDocument.BillingDocumentDate,
BillingDocument.BillingDocumentIsCancelled,
BillingDocument.CancelledBillingDocument,
BillingDocument.BillingDocCombinationCriteria,
BillingDocument.ManualInvoiceMaintIsRelevant,
BillingDocument.NmbrOfPages,
BillingDocument.IsIntrastatReportingRelevant,
BillingDocument.IsIntrastatReportingExcluded,
BillingDocument.BillingDocumentIsTemporary,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BillingDocument.TotalNetAmount,
BillingDocument.TransactionCurrency,
BillingDocument.StatisticsCurrency,
@Semantics.amount.currencyCode: 'TransactionCurrency'
BillingDocument.TotalTaxAmount,
BillingDocument.CustomerPriceGroup,
BillingDocument.PriceListType,
BillingDocument.TaxDepartureCountry,
BillingDocument.VATRegistration,
BillingDocument.VATRegistrationOrigin,
BillingDocument.VATRegistrationCountry,
BillingDocument.HierarchyTypePricing,
BillingDocument.CustomerTaxClassification1,
BillingDocument.CustomerTaxClassification2,
BillingDocument.CustomerTaxClassification3,
BillingDocument.CustomerTaxClassification4,
BillingDocument.CustomerTaxClassification5,
BillingDocument.CustomerTaxClassification6,
BillingDocument.CustomerTaxClassification7,
BillingDocument.CustomerTaxClassification8,
BillingDocument.CustomerTaxClassification9,
BillingDocument.IsEUTriangularDeal,
BillingDocument.SDPricingProcedure,
BillingDocument.ShippingCondition,
BillingDocument.IncotermsVersion,
BillingDocument.IncotermsClassification,
BillingDocument.IncotermsTransferLocation,
BillingDocument.IncotermsLocation1,
BillingDocument.IncotermsLocation2,
BillingDocument.PayerParty,
BillingDocument.ContractAccount,
BillingDocument.CustomerPaymentTerms,
BillingDocument.PaymentMethod,
BillingDocument.PaymentReference,
BillingDocument.FixedValueDate,
BillingDocument.AdditionalValueDays,
BillingDocument.SEPAMandate,
BillingDocument.CompanyCode,
BillingDocument.FiscalYear,
BillingDocument.AccountingDocument,
BillingDocument.FiscalPeriod,
BillingDocument.CustomerAccountAssignmentGroup,
BillingDocument.AccountingExchangeRateIsSet,
BillingDocument.AccountingExchangeRate,
BillingDocument.ExchangeRateDate,
BillingDocument.ExchangeRateType,
BillingDocument.DocumentReferenceID,
BillingDocument.AssignmentReference,
BillingDocument.ReversalReason,
BillingDocument.DunningArea,
BillingDocument.DunningBlockingReason,
BillingDocument.DunningKey,
BillingDocument.InternalFinancialDocument,
BillingDocument.IsRelevantForAccrual,
BillingDocument.SoldToParty,
BillingDocument.PartnerCompany,
BillingDocument.PurchaseOrderByCustomer,
BillingDocument.CustomerGroup,
BillingDocument.Country,
BillingDocument.CityCode,
BillingDocument.SalesDistrict,
BillingDocument.Region,
BillingDocument.County,
BillingDocument.CreditControlArea,
BillingDocument.CustomerRebateAgreement,
BillingDocument.PricingDocument,
BillingDocument.OverallSDProcessStatus,
BillingDocument.OverallBillingStatus,
BillingDocument.AccountingPostingStatus,
BillingDocument.AccountingTransferStatus,
BillingDocument.BillingIssueType,
BillingDocument.InvoiceListStatus,
BillingDocument.OvrlItmGeneralIncompletionSts,
BillingDocument.OverallPricingIncompletionSts,
BillingDocument.InvoiceClearingStatus,
BillingDocument.InvoiceListType,
BillingDocument.InvoiceListBillingDate,
//Compositions
_Item as _Item : redirected to composition child A_BillingDocumentItem_2
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_BILLINGDOCUMENTTP"
],
"ASSOCIATED":
[
"A_BILLINGDOCUMENTITEM_2",
"R_BILLINGDOCUMENTITEMTP"
],
"BASE":
[
"R_BILLINGDOCUMENTTP"
],
"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