A_BillingDocument_2

DDL: A_BILLINGDOCUMENT_2 Type: view_entity CONSUMPTION

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)

SourceAliasJoin Type
R_BillingDocumentTP R_BillingDocumentTP projection

Annotations (11)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/