R_BillingDocumentRequestTP
Billing Document Request - TP
R_BillingDocumentRequestTP is a Transactional CDS View that provides data about "Billing Document Request - TP" in SAP S/4HANA. It reads from 1 data source (I_BillingDocumentRequest) and exposes 111 fields with key field BillingDocumentRequest. It has 4 associations to related views. Part of development package RAP_SD_BIL_BDR.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_BillingDocumentRequest | I_BillingDocumentRequest | from |
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | E_BillingDocument | _Extension | $projection.BillingDocumentRequest = _Extension.BillingDocument |
| [0..*] | R_BillingDocumentRequestItemTP | _Item | |
| [0..*] | R_BillgDocRequestPartnerTP | _Partner | |
| [0..*] | R_BillingDocumentRequestTextTP | _Text | |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | Billing Document Request - TP | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| ObjectModel.sapObjectNodeType.name | BillingDocumentRequest | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #L | view |
Fields (111)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | BillingDocumentRequest | BillingDocumentRequest | ||
| SDDocumentCategory | SDDocumentCategory | |||
| BillingDocumentRequestType | BillingDocumentRequestType | |||
| ProposedBillingDocumentType | ProposedBillingDocumentType | |||
| CreatedByUser | CreatedByUser | |||
| CreationDate | CreationDate | |||
| CreationTime | CreationTime | |||
| LastChangeDate | LastChangeDate | |||
| LastChangeDateTime | LastChangeDateTime | |||
| LogicalSystem | LogicalSystem | |||
| SalesOrganization | SalesOrganization | |||
| DistributionChannel | DistributionChannel | |||
| Division | Division | |||
| BillingDocumentDate | BillingDocumentDate | |||
| BillgDocReqCombinationCriteria | BillgDocReqCombinationCriteria | |||
| TotalNetAmount | TotalNetAmount | |||
| TransactionCurrency | TransactionCurrency | |||
| TotalTaxAmount | TotalTaxAmount | |||
| TotalGrossAmount | ||||
| CustomerPriceGroup | CustomerPriceGroup | |||
| PriceListType | PriceListType | |||
| TaxDepartureCountry | TaxDepartureCountry | |||
| VATRegistration | VATRegistration | |||
| VATRegistrationOrigin | VATRegistrationOrigin | |||
| VATRegistrationCountry | VATRegistrationCountry | |||
| CustomerTaxClassification1 | CustomerTaxClassification1 | |||
| CustomerTaxClassification2 | CustomerTaxClassification2 | |||
| CustomerTaxClassification3 | CustomerTaxClassification3 | |||
| CustomerTaxClassification4 | CustomerTaxClassification4 | |||
| CustomerTaxClassification5 | CustomerTaxClassification5 | |||
| CustomerTaxClassification6 | CustomerTaxClassification6 | |||
| CustomerTaxClassification7 | CustomerTaxClassification7 | |||
| CustomerTaxClassification8 | CustomerTaxClassification8 | |||
| CustomerTaxClassification9 | CustomerTaxClassification9 | |||
| SDPricingProcedure | SDPricingProcedure | |||
| IncotermsVersion | IncotermsVersion | |||
| IncotermsClassification | IncotermsClassification | |||
| IncotermsTransferLocation | IncotermsTransferLocation | |||
| IncotermsLocation1 | IncotermsLocation1 | |||
| IncotermsLocation2 | IncotermsLocation2 | |||
| PayerParty | PayerParty | |||
| ContractAccount | ContractAccount | |||
| CustomerPaymentTerms | CustomerPaymentTerms | |||
| PaymentMethod | PaymentMethod | |||
| FixedValueDate | FixedValueDate | |||
| AdditionalValueDays | AdditionalValueDays | |||
| SEPAMandate | SEPAMandate | |||
| CompanyCode | CompanyCode | |||
| CustomerAccountAssignmentGroup | CustomerAccountAssignmentGroup | |||
| ExchangeRateDate | ExchangeRateDate | |||
| ExchangeRateType | ExchangeRateType | |||
| DocumentReferenceID | DocumentReferenceID | |||
| DunningArea | DunningArea | |||
| DunningBlockingReason | DunningBlockingReason | |||
| DunningKey | DunningKey | |||
| ReferenceDocument | ReferenceDocument | |||
| ReferenceDocumentLogicalSystem | ReferenceDocumentLogicalSystem | |||
| ReferenceDocSDDocCategory | ReferenceDocSDDocCategory | |||
| SoldToParty | SoldToParty | |||
| PurchaseOrderByCustomer | PurchaseOrderByCustomer | |||
| CustomerGroup | CustomerGroup | |||
| Country | Country | |||
| CityCode | CityCode | |||
| SalesDistrict | SalesDistrict | |||
| Region | Region | |||
| County | County | |||
| CreditControlArea | CreditControlArea | |||
| PricingDocument | PricingDocument | |||
| OverallBillingDocReqStatus | OverallBillingDocReqStatus | |||
| BillingIssueType | BillingIssueType | |||
| OverallPricingIncompletionSts | OverallPricingIncompletionSts | |||
| _Item | _Item | |||
| _Partner | _Partner | |||
| _Text | _Text | |||
| _SDDocumentCategory | _SDDocumentCategory | |||
| _ReferenceDocSDDocCategory | _ReferenceDocSDDocCategory | |||
| _BillingDocumentRequestType | _BillingDocumentRequestType | |||
| _ProposedBillingDocumentType | _ProposedBillingDocumentType | |||
| _CreatedByUser | _CreatedByUser | |||
| _LogicalSystem | _LogicalSystem | |||
| _SalesOrganization | _SalesOrganization | |||
| _DistributionChannel | _DistributionChannel | |||
| _Division | _Division | |||
| _TransactionCurrency | _TransactionCurrency | |||
| _CustomerPriceGroup | _CustomerPriceGroup | |||
| _PriceListType | _PriceListType | |||
| _TaxDepartureCountry | _TaxDepartureCountry | |||
| _VATRegistrationOrigin | _VATRegistrationOrigin | |||
| _VATRegistrationCountry | _VATRegistrationCountry | |||
| _SDPricingProcedure | _SDPricingProcedure | |||
| _IncotermsClassification | _IncotermsClassification | |||
| _IncotermsVersion | _IncotermsVersion | |||
| _PayerParty | _PayerParty | |||
| _CustomerPaymentTerms | _CustomerPaymentTerms | |||
| _CompanyCode | _CompanyCode | |||
| _CustomerAccountAssgmtGroup | _CustomerAccountAssgmtGroup | |||
| _ExchangeRateType | _ExchangeRateType | |||
| _DunningArea | _DunningArea | |||
| _DunningBlockingReason | _DunningBlockingReason | |||
| _DunningKey | _DunningKey | |||
| _SoldToParty | _SoldToParty | |||
| _CustomerGroup | _CustomerGroup | |||
| _Country | _Country | |||
| _CityCode | _CityCode | |||
| _SalesDistrict | _SalesDistrict | |||
| _Region | _Region | |||
| _County | _County_2 | |||
| _CreditControlArea | _CreditControlArea | |||
| _OvrlBillingDocReqStatus | _OvrlBillingDocReqStatus | |||
| _BillingIssueType | _BillingIssueType | |||
| _OverallPricingIncompletionSts | _OverallPricingIncompletionSts |
@AccessControl: { authorizationCheck: #MANDATORY, personalData.blocking: #('TRANSACTIONAL_DATA'), privilegedAssociations: [ '_CreatedByUser' ] }
@EndUserText.label: 'Billing Document Request - TP'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel: {
sapObjectNodeType.name: 'BillingDocumentRequest',
semanticKey: ['BillingDocumentRequest'],
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #A,
sizeCategory: #L }
}
define root view entity R_BillingDocumentRequestTP
as select from I_BillingDocumentRequest
composition [0..*] of R_BillingDocumentRequestItemTP as _Item
composition [0..*] of R_BillgDocRequestPartnerTP as _Partner
composition [0..*] of R_BillingDocumentRequestTextTP as _Text
//Extensibility
association [0..1] to E_BillingDocument as _Extension on $projection.BillingDocumentRequest = _Extension.BillingDocument
{
key BillingDocumentRequest,
SDDocumentCategory,
BillingDocumentRequestType,
ProposedBillingDocumentType,
CreatedByUser,
CreationDate,
CreationTime,
LastChangeDate,
LastChangeDateTime,
LogicalSystem,
SalesOrganization,
DistributionChannel,
Division,
BillingDocumentDate,
BillgDocReqCombinationCriteria,
TotalNetAmount,
TransactionCurrency,
TotalTaxAmount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
cast( TotalTaxAmount + TotalNetAmount as sdci_odata_total_amount ) as TotalGrossAmount,
CustomerPriceGroup,
PriceListType,
TaxDepartureCountry,
VATRegistration,
VATRegistrationOrigin,
VATRegistrationCountry,
CustomerTaxClassification1,
CustomerTaxClassification2,
CustomerTaxClassification3,
CustomerTaxClassification4,
CustomerTaxClassification5,
CustomerTaxClassification6,
CustomerTaxClassification7,
CustomerTaxClassification8,
CustomerTaxClassification9,
SDPricingProcedure,
IncotermsVersion,
IncotermsClassification,
IncotermsTransferLocation,
IncotermsLocation1,
IncotermsLocation2,
PayerParty,
ContractAccount,
CustomerPaymentTerms,
// Wrong foreign key association is used in the basic interface view
@ObjectModel.foreignKey.association: null
PaymentMethod,
FixedValueDate,
AdditionalValueDays,
SEPAMandate,
CompanyCode,
CustomerAccountAssignmentGroup,
ExchangeRateDate,
ExchangeRateType,
DocumentReferenceID,
DunningArea,
DunningBlockingReason,
DunningKey,
ReferenceDocument,
ReferenceDocumentLogicalSystem,
ReferenceDocSDDocCategory,
SoldToParty,
PurchaseOrderByCustomer,
CustomerGroup,
Country,
CityCode,
SalesDistrict,
Region,
@ObjectModel.foreignKey.association: '_County'
County,
CreditControlArea,
PricingDocument,
OverallBillingDocReqStatus,
BillingIssueType,
OverallPricingIncompletionSts,
_Item,
_Partner,
_Text,
_SDDocumentCategory,
_ReferenceDocSDDocCategory,
_BillingDocumentRequestType,
_ProposedBillingDocumentType,
_CreatedByUser,
_LogicalSystem,
_SalesOrganization,
_DistributionChannel,
_Division,
_TransactionCurrency,
_CustomerPriceGroup,
_PriceListType,
_TaxDepartureCountry,
_VATRegistrationOrigin,
_VATRegistrationCountry,
_SDPricingProcedure,
_IncotermsClassification,
_IncotermsVersion,
_PayerParty,
_CustomerPaymentTerms,
_CompanyCode,
_CustomerAccountAssgmtGroup,
_ExchangeRateType,
_DunningArea,
_DunningBlockingReason,
_DunningKey,
_SoldToParty,
_CustomerGroup,
_Country,
_CityCode,
_SalesDistrict,
_Region,
_County_2 as _County,
_CreditControlArea,
_OvrlBillingDocReqStatus,
_BillingIssueType,
_OverallPricingIncompletionSts
}
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