C_PrelimBillgDocumentTP_F6990

DDL: C_PRELIMBILLGDOCUMENTTP_F6990 Type: view_entity CONSUMPTION Package: ODATA_SD_BIL_PBD_UI
67 Fields 1 Data Sources 2 Associations 1 OData Services

Preliminary Billing Document

C_PrelimBillgDocumentTP_F6990 is a Consumption CDS View that provides data about "Preliminary Billing Document" in SAP S/4HANA. It reads from 1 data source (R_PrelimBillingDocumentTP) and exposes 67 fields with key field PrelimBillingDocument. It has 2 associations to related views. It is exposed through 1 OData service (UI_PRELIMBILLINGDOCUMENT_F6990). Part of development package ODATA_SD_BIL_PBD_UI.

Data Sources (1)

SourceAliasJoin Type
R_PrelimBillingDocumentTP R_PrelimBillingDocumentTP projection

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_SalesDocApprovalStatus _PrelimBillgDocApprovalStatus $projection.PrelimBillgDocApprovalStatus = _PrelimBillgDocApprovalStatus.SalesDocApprovalStatus
[0..1] E_BillingDocument _Extension $projection.PrelimBillingDocument = _Extension.BillingDocument

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Preliminary Billing Document view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #TRANSACTIONAL_QUERY view
ObjectModel.query.implementedBy ABAP:CL_S4RAP_STICKY_QRY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
UI_PRELIMBILLINGDOCUMENT_F6990 UI_PRELIMBILLINGDOCUMENT_F6990 V4 C1 NOT_RELEASED

Fields (67)

KeyFieldSource TableSource FieldDescription
KEY PrelimBillingDocument PrelimBillingDocument
BillingDocumentType BillingDocumentType Billing Type
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
BillingDocCreationDateTime BillingDocCreationDateTime
BillingDocumentDate BillingDocumentDate Billing Date
LastChangeDateTime LastChangeDateTime Timestamp
CompanyCode CompanyCode Receiver Company Code
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SoldToParty SoldToParty Sold-to Party
PayerParty PayerParty Payer
BillToParty BillToParty Inv. Recipient
TotalNetAmount TotalNetAmount Total Net Amount
TotalTaxAmount TotalTaxAmount Tax Amount
TotalGrossAmount TotalGrossAmount Total Gross Amount
TransactionCurrency TransactionCurrency Transaction Currency
Country Country Venue: Ctry/Reg
Region Region Venue Region
TaxDepartureCountry TaxDepartureCountry Tx Dep Ctry/Reg
VATRegistration VATRegistration VAT Registration No.
VATRegistrationCountry VATRegistrationCountry CtryRgnSlsTxNo.
VATRegistrationOrigin VATRegistrationOrigin OriginSlsTxNo.
CustomerPaymentTerms CustomerPaymentTerms Pyt Terms
PaymentMethod PaymentMethod Pymt Meth.
PricingProcedure SDPricingProcedure Pric. Procedure
CustomerGroup CustomerGroup Customer Group
DocumentReferenceID DocumentReferenceID Reference
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
PrelimBillingDocumentStatus PrelimBillingDocumentStatus
virtualPrelimBillgDocStsCriticalityint1
PrelimBillgDocApprovalStatus PrelimBillgDocApprovalStatus
PrelimBillgDocApprovalReason PrelimBillgDocApprovalReason
CustomerTaxClassification1 CustomerTaxClassification1
CustomerTaxClassification2 CustomerTaxClassification2
CustomerTaxClassification3 CustomerTaxClassification3
CustomerTaxClassification4 CustomerTaxClassification4
CustomerTaxClassification5 CustomerTaxClassification5
CustomerTaxClassification6 CustomerTaxClassification6
CustomerTaxClassification7 CustomerTaxClassification7
CustomerTaxClassification8 CustomerTaxClassification8
CustomerTaxClassification9 CustomerTaxClassification9
PricingDocument PricingDocument Document Condition
SAPObjectTypeInUppercase SAPObjectTypeInUppercase
PrcgDocumentHostObjectNodeID PrcgDocumentHostObjectNodeID
_BillingDocumentType _BillingDocumentType
_CreatedByUser _CreatedByUser
_CompanyCode _CompanyCode
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_Country _Country
_Region _Region
_TaxDepartureCountry _TaxDepartureCountry
_VATRegistrationCountry _VATRegistrationCountry
_VATRegistrationOrigin _VATRegistrationOrigin
_CustomerPaymentTerms _CustomerPaymentTerms
_PaymentMethod _PaymentMethod
_SDPricingProcedure _SDPricingProcedure
_CustomerGroup _CustomerGroup
_PrelimBillingDocumentStatus _PrelimBillingDocumentStatus
_PrelimBillgDocApprovalStatus _PrelimBillgDocApprovalStatus
_PrelimBillgDocApprovalReason _PrelimBillgDocApprovalReason
_SoldToParty _SoldToParty
_PayerParty _PayerParty
_BillToParty _BillToParty

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 C_PrelimBillgDocumentTP_F6990.
-- 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 C_PrelimBillgDocumentTP_F6990 AS
SELECT
  PrelimBillingDocument,
  BillingDocumentType,
  CreatedByUser,
  CreationDate,
  BillingDocCreationDateTime,
  BillingDocumentDate,
  LastChangeDateTime,
  CompanyCode,
  SalesOrganization,
  DistributionChannel,
  Division,
  SoldToParty,
  PayerParty,
  BillToParty,
  TotalNetAmount,
  TotalTaxAmount,
  TotalGrossAmount,
  TransactionCurrency,
  Country,
  Region,
  TaxDepartureCountry,
  VATRegistration,
  VATRegistrationCountry,
  VATRegistrationOrigin,
  CustomerPaymentTerms,
  PaymentMethod,
  SDPricingProcedure AS PricingProcedure,
  CustomerGroup,
  DocumentReferenceID,
  PurchaseOrderByCustomer,
  PrelimBillingDocumentStatus,
  virtual PrelimBillgDocStsCriticality : int1 AS virtualPrelimBillgDocStsCriticalityint1,
  PrelimBillgDocApprovalStatus,
  PrelimBillgDocApprovalReason,
  CustomerTaxClassification1,
  CustomerTaxClassification2,
  CustomerTaxClassification3,
  CustomerTaxClassification4,
  CustomerTaxClassification5,
  CustomerTaxClassification6,
  CustomerTaxClassification7,
  CustomerTaxClassification8,
  CustomerTaxClassification9,
  PricingDocument,
  SAPObjectTypeInUppercase,
  PrcgDocumentHostObjectNodeID
FROM R_PrelimBillingDocumentTP
LEFT OUTER JOIN I_SalesDocApprovalStatus AS _PrelimBillgDocApprovalStatus ON PrelimBillgDocApprovalStatus = _PrelimBillgDocApprovalStatus.SalesDocApprovalStatus  -- association [0..1]
LEFT OUTER JOIN E_BillingDocument AS _Extension ON PrelimBillingDocument = _Extension.BillingDocument  -- association [0..1]
;

Learn More