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 108 fields with key field BillingDocumentRequest. It has 2 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_BillingDocumentRequest | I_BillingDocumentRequest | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | E_BillingDocument | _Extension | $projection.BillingDocumentRequest = _Extension.BillingDocument |
| [0..*] | R_BillingDocumentRequestItemTP | _Item | |
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 (108)
| 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 | |||
| 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 | |||
| _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') }
@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
//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,
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,
_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