A_BillingDocumentRequestS2S

DDL: A_BILLINGDOCUMENTREQUESTS2S Type: view_entity CONSUMPTION Package: ODATA_SD_BIL_BDR_API
68 Fields 1 Data Sources 1 OData Services

Header

A_BillingDocumentRequestS2S is a Consumption CDS View that provides data about "Header" in SAP S/4HANA. It reads from 1 data source (R_BillingDocumentRequestTP) and exposes 68 fields with key field BillingDocumentRequest. It is exposed through 1 OData service (API_BILLINGDOCUMENTREQUESTS2S). Part of development package ODATA_SD_BIL_BDR_API.

Data Sources (1)

SourceAliasJoin Type
R_BillingDocumentRequestTP R_BillingDocumentRequestTP projection

Annotations (10)

NameValueLevelField
EndUserText.label Header 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 BillingDocumentRequest_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
API_BILLINGDOCUMENTREQUESTS2S API_BILLINGDOCUMENTREQUESTS2S V4 C2 C1

Fields (68)

KeyFieldSource TableSource FieldDescription
KEY BillingDocumentRequest BillingDocumentRequest BillingDocumentRequest
SDDocumentCategory BillingDocumentRequest SDDocumentCategory Document Cat.
BillingDocumentRequestType
ProposedBillingDocumentType BillingDocumentRequest ProposedBillingDocumentType
CreatedByUser BillingDocumentRequest CreatedByUser User Name
CreationDate BillingDocumentRequest CreationDate Time Stamp
CreationTime BillingDocumentRequest CreationTime Time of Change
LastChangeDate BillingDocumentRequest LastChangeDate Time Stamp
LastChangeDateTime BillingDocumentRequest LastChangeDateTime Timestamp
LogicalSystem BillingDocumentRequest LogicalSystem Logical System
SalesOrganization BillingDocumentRequest SalesOrganization Sales Organization
DistributionChannel BillingDocumentRequest DistributionChannel RefDistCh-Cust/Mat.
Division BillingDocumentRequest Division Internal Division ID
BillingDocumentDate BillingDocumentRequest BillingDocumentDate Billing Date
BillgDocReqCombinationCriteria BillingDocumentRequest BillgDocReqCombinationCriteria
TotalNetAmount BillingDocumentRequest TotalNetAmount Total Net Amount
TransactionCurrency BillingDocumentRequest TransactionCurrency Transaction Currency
TotalTaxAmount BillingDocumentRequest TotalTaxAmount Tax Amount
TotalGrossAmount BillingDocumentRequest TotalGrossAmount Total Gross Amount
CustomerPriceGroup BillingDocumentRequest CustomerPriceGroup CustPrice Group
PriceListType BillingDocumentRequest PriceListType Price List Tp.
TaxDepartureCountry BillingDocumentRequest TaxDepartureCountry Tx Dep Ctry/Reg
VATRegistration BillingDocumentRequest VATRegistration VAT Registration No.
VATRegistrationOrigin BillingDocumentRequest VATRegistrationOrigin OriginSlsTxNo.
VATRegistrationCountry BillingDocumentRequest VATRegistrationCountry CtryRgnSlsTxNo.
CustomerTaxClassification1 BillingDocumentRequest CustomerTaxClassification1
CustomerTaxClassification2 BillingDocumentRequest CustomerTaxClassification2
CustomerTaxClassification3 BillingDocumentRequest CustomerTaxClassification3
CustomerTaxClassification4 BillingDocumentRequest CustomerTaxClassification4
CustomerTaxClassification5 BillingDocumentRequest CustomerTaxClassification5
CustomerTaxClassification6 BillingDocumentRequest CustomerTaxClassification6
CustomerTaxClassification7 BillingDocumentRequest CustomerTaxClassification7
CustomerTaxClassification8 BillingDocumentRequest CustomerTaxClassification8
CustomerTaxClassification9 BillingDocumentRequest CustomerTaxClassification9
SDPricingProcedure BillingDocumentRequest SDPricingProcedure Pric. Procedure
IncotermsVersion BillingDocumentRequest IncotermsVersion Inco. Version
IncotermsClassification BillingDocumentRequest IncotermsClassification Incoterms
IncotermsTransferLocation BillingDocumentRequest IncotermsTransferLocation Incoterms 2
IncotermsLocation1 BillingDocumentRequest IncotermsLocation1 Inco. Location1
IncotermsLocation2 BillingDocumentRequest IncotermsLocation2 Inco. Location2
PayerParty BillingDocumentRequest PayerParty Payer
ContractAccount BillingDocumentRequest ContractAccount Contract Acct
CustomerPaymentTerms BillingDocumentRequest CustomerPaymentTerms Pyt Terms
PaymentMethod BillingDocumentRequest PaymentMethod Pymt Meth.
FixedValueDate BillingDocumentRequest FixedValueDate Fixed Val. Date
AdditionalValueDays BillingDocumentRequest AdditionalValueDays Add. Value Days
SEPAMandate BillingDocumentRequest SEPAMandate SEPA Mandate
CompanyCode BillingDocumentRequest CompanyCode Receiver Company Code
CustomerAccountAssignmentGroup BillingDocumentRequest CustomerAccountAssignmentGroup AccAssmtGrpCust
ExchangeRateDate BillingDocumentRequest ExchangeRateDate Translatn Date
ExchangeRateType BillingDocumentRequest ExchangeRateType Exch. Rate Type
DocumentReferenceID BillingDocumentRequest DocumentReferenceID Reference
ReferenceDocument BillingDocumentRequest ReferenceDocument Reference Document
ReferenceDocumentLogicalSystem BillingDocumentRequest ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
ReferenceDocSDDocCategory BillingDocumentRequest ReferenceDocSDDocCategory
SoldToParty BillingDocumentRequest SoldToParty Sold-to Party
PurchaseOrderByCustomer BillingDocumentRequest PurchaseOrderByCustomer Purchase Order Number
CustomerGroup BillingDocumentRequest CustomerGroup Customer Group
Country BillingDocumentRequest Country Venue: Ctry/Reg
CityCode BillingDocumentRequest CityCode IATA: City
SalesDistrict BillingDocumentRequest SalesDistrict Sales District
Region BillingDocumentRequest Region Venue Region
County BillingDocumentRequest County Wyoming County
CreditControlArea BillingDocumentRequest CreditControlArea Credit Control Area
PricingDocument BillingDocumentRequest PricingDocument Document Condition
OverallBillingDocReqStatus BillingDocumentRequest OverallBillingDocReqStatus
BillingIssueType BillingDocumentRequest BillingIssueType
OverallPricingIncompletionSts BillingDocumentRequest OverallPricingIncompletionSts

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_BillingDocumentRequestS2S.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW A_BillingDocumentRequestS2S AS
SELECT
  BillingDocumentRequest.BillingDocumentRequest AS BillingDocumentRequest,
  BillingDocumentRequest.SDDocumentCategory AS SDDocumentCategory,
  cast (BillingDocumentRequestType as sdbil_odata_bdr_type preserving type ) AS BillingDocumentRequestType,
  BillingDocumentRequest.ProposedBillingDocumentType AS ProposedBillingDocumentType,
  BillingDocumentRequest.CreatedByUser AS CreatedByUser,
  BillingDocumentRequest.CreationDate AS CreationDate,
  BillingDocumentRequest.CreationTime AS CreationTime,
  BillingDocumentRequest.LastChangeDate AS LastChangeDate,
  BillingDocumentRequest.LastChangeDateTime AS LastChangeDateTime,
  BillingDocumentRequest.LogicalSystem AS LogicalSystem,
  BillingDocumentRequest.SalesOrganization AS SalesOrganization,
  BillingDocumentRequest.DistributionChannel AS DistributionChannel,
  BillingDocumentRequest.Division AS Division,
  BillingDocumentRequest.BillingDocumentDate AS BillingDocumentDate,
  BillingDocumentRequest.BillgDocReqCombinationCriteria AS BillgDocReqCombinationCriteria,
  BillingDocumentRequest.TotalNetAmount AS TotalNetAmount,
  BillingDocumentRequest.TransactionCurrency AS TransactionCurrency,
  BillingDocumentRequest.TotalTaxAmount AS TotalTaxAmount,
  BillingDocumentRequest.TotalGrossAmount AS TotalGrossAmount,
  BillingDocumentRequest.CustomerPriceGroup AS CustomerPriceGroup,
  BillingDocumentRequest.PriceListType AS PriceListType,
  BillingDocumentRequest.TaxDepartureCountry AS TaxDepartureCountry,
  BillingDocumentRequest.VATRegistration AS VATRegistration,
  BillingDocumentRequest.VATRegistrationOrigin AS VATRegistrationOrigin,
  BillingDocumentRequest.VATRegistrationCountry AS VATRegistrationCountry,
  BillingDocumentRequest.CustomerTaxClassification1 AS CustomerTaxClassification1,
  BillingDocumentRequest.CustomerTaxClassification2 AS CustomerTaxClassification2,
  BillingDocumentRequest.CustomerTaxClassification3 AS CustomerTaxClassification3,
  BillingDocumentRequest.CustomerTaxClassification4 AS CustomerTaxClassification4,
  BillingDocumentRequest.CustomerTaxClassification5 AS CustomerTaxClassification5,
  BillingDocumentRequest.CustomerTaxClassification6 AS CustomerTaxClassification6,
  BillingDocumentRequest.CustomerTaxClassification7 AS CustomerTaxClassification7,
  BillingDocumentRequest.CustomerTaxClassification8 AS CustomerTaxClassification8,
  BillingDocumentRequest.CustomerTaxClassification9 AS CustomerTaxClassification9,
  BillingDocumentRequest.SDPricingProcedure AS SDPricingProcedure,
  BillingDocumentRequest.IncotermsVersion AS IncotermsVersion,
  BillingDocumentRequest.IncotermsClassification AS IncotermsClassification,
  BillingDocumentRequest.IncotermsTransferLocation AS IncotermsTransferLocation,
  BillingDocumentRequest.IncotermsLocation1 AS IncotermsLocation1,
  BillingDocumentRequest.IncotermsLocation2 AS IncotermsLocation2,
  BillingDocumentRequest.PayerParty AS PayerParty,
  BillingDocumentRequest.ContractAccount AS ContractAccount,
  BillingDocumentRequest.CustomerPaymentTerms AS CustomerPaymentTerms,
  BillingDocumentRequest.PaymentMethod AS PaymentMethod,
  BillingDocumentRequest.FixedValueDate AS FixedValueDate,
  BillingDocumentRequest.AdditionalValueDays AS AdditionalValueDays,
  BillingDocumentRequest.SEPAMandate AS SEPAMandate,
  BillingDocumentRequest.CompanyCode AS CompanyCode,
  BillingDocumentRequest.CustomerAccountAssignmentGroup AS CustomerAccountAssignmentGroup,
  BillingDocumentRequest.ExchangeRateDate AS ExchangeRateDate,
  BillingDocumentRequest.ExchangeRateType AS ExchangeRateType,
  BillingDocumentRequest.DocumentReferenceID AS DocumentReferenceID,
  BillingDocumentRequest.ReferenceDocument AS ReferenceDocument,
  BillingDocumentRequest.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  BillingDocumentRequest.ReferenceDocSDDocCategory AS ReferenceDocSDDocCategory,
  BillingDocumentRequest.SoldToParty AS SoldToParty,
  BillingDocumentRequest.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  BillingDocumentRequest.CustomerGroup AS CustomerGroup,
  BillingDocumentRequest.Country AS Country,
  BillingDocumentRequest.CityCode AS CityCode,
  BillingDocumentRequest.SalesDistrict AS SalesDistrict,
  BillingDocumentRequest.Region AS Region,
  BillingDocumentRequest.County AS County,
  BillingDocumentRequest.CreditControlArea AS CreditControlArea,
  BillingDocumentRequest.PricingDocument AS PricingDocument,
  BillingDocumentRequest.OverallBillingDocReqStatus AS OverallBillingDocReqStatus,
  BillingDocumentRequest.BillingIssueType AS BillingIssueType,
  BillingDocumentRequest.OverallPricingIncompletionSts AS OverallPricingIncompletionSts
FROM R_BillingDocumentRequestTP
;

Learn More