C_SuplrBillgDocDEX

DDL: C_SUPLRBILLGDOCDEX Type: view_entity CONSUMPTION Package: WZRE_PC
189 Fields 1 Data Sources

Supplier Billing Document Extraction

C_SuplrBillgDocDEX (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Supplier Billing Document · Sales

C_SuplrBillgDocDEX is a Consumption CDS View (Fact) that provides data about "Supplier Billing Document Extraction" in SAP S/4HANA. It reads from 1 data source (R_SuplrBillgDocDEX) and exposes 189 fields with key fields SuplrBillgDoc, SuplrBillgDocItem. Part of development package WZRE_PC.

SAP Help Documentation

CategorySupplier Billing Document
Data CategoryFact
StatusReleased
Purpose
This CDS view supports data extraction to SAP BW/4HANA. It enables the data transfer to SAP BW/4HANA for supplier billing documents. Providing all relevant supplier billing document information, this CDS view also allows you to build analytical reports. This CDS view provides the data to answer the following business question: Which supplier billing documents are relevant for SAP BW/4HANA data extraction? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations In order to use this CDS view as a basis for data extraction, the settlement document types of the corresponding supplier billing documents must be enabled for SAP BW/4HANA data extraction in Customizing for Settlement Management under Settlement Documents Settlement Document Types . Users must have the following authorization objects assigned: Authorization Object: W_WBRK_FKA Authorization required for Settlement Document Type ( LFART ) Authorization Object: W_WBRK_ORG Authorization required for the following: Company Code ( BUKRS ) Purchasing Organization ( EKORG ) Purchasing Group ( EKGRP ) Authorization Object: F_LFA1_BEK Authorization group needs to be maintained for the following: Invoicing Party Invoicing Party Company Payee Party Payee Party Company Alternative Invoicing Party Alternative Invoicing Party Company

Structure
Object types This CDS view is built on the following business object: Supplier Billing Document ( SupplierBillingDocument ). The key fields are: SuplrBillgDoc SuplrBillgDocItem Measures and attributes Some important measures and attributes are: Supplier billing document number ( SuplrBillgDoc ) Supplier billing document item number ( SuplrBillgDocItem ) Product ( Product ) Plant ( Plant ) Item category ( SuplrBillgDocItmCat ) Supplier billing document currency ( SuplrBillgDocCurrency ) Supplier billing document item gross amount ( SuplrBillgDocItemGrossAmount ) Supplier billing document item net amount ( SuplrBillgDocItemNetAmount ) Supplier billing document item tax amount ( SuplrBillgDocItemTaxAmount ) Item quantity ( SettlmtQuantity ) Unit of measure of item quantity ( SettlmtQuantityUnit )

SAP Business Warehouse (SAP BW) Extraction
Data extraction type Full (physical deletions are possible in source tables) Delta (change data capture) Corresponding DataSource (Extractor) 2LIS_45_HDR 2LIS_45_ITM Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. For details about the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Use SAP Library BI Content . For more information about data extraction, see Extracting Data Through CDS Views to SAP BW/4HANA .

Constraints
This CDS view only displays documents for which the relevant settlement document types were enabled for SAP BW/4HANA data extraction in Customizing. Documents related to other settlement document types will not be displayed. Once data extraction is activated in SAP BW/4HANA and you would like to make any changes in Customizing, for example removing the BW4HANA Extraction flag, please note that your changes will not be included in the next delta extraction. The data that would be affected by your change will not be removed in SAP BW/4HANA. If you want to remove these entries, you must execute a full extraction.

View on SAP Help Portal →

SAP API Hub

CategoryConsumption
StateC1
Line of BusinessSales
Application ComponentLO-AB
CapabilitiesData Source for Data Extraction,Data Source for Defining CDS Entities,Data Source in SQL Select
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageSales for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
R_SuplrBillgDocDEX SuplrBillgDocDEX from

Annotations (13)

NameValueLevelField
ObjectModel.compositionRoot true view
ObjectModel.modelingPattern #ANALYTICAL_FACT view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.sapObjectNodeType.name SupplierBillingDocument view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Supplier Billing Document Extraction view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view

Fields (189)

KeyFieldSource TableSource FieldDescription
KEY SuplrBillgDoc SuplrBillgDoc Supplier Billing Document Number
KEY SuplrBillgDocItem SuplrBillgDocItem Document Item
SettlmtDocType R_SuplrBillgDocDEX SettlmtDocType Settlement Document Type
SettlmtDocCat R_SuplrBillgDocDEX SettlmtDocCat Settlement Document Category
SettlmtProcessType R_SuplrBillgDocDEX SettlmtProcessType Settlement Process Type
LogisticsDataEntryCat R_SuplrBillgDocDEX LogisticsDataEntryCat Entry Category for Logistics Data
SettlmtCat R_SuplrBillgDocDEX SettlmtCat Settlement Category
PostingDate R_SuplrBillgDocDEX PostingDate Posting Date for GR
SuplrBillgDocAcctgTransfSts R_SuplrBillgDocDEX SuplrBillgDocAcctgTransfSts Posting Status for Transfer to Financial Accounting
DocumentDate R_SuplrBillgDocDEX DocumentDate Document Date in Settlement Management Document
DocumentReferenceID R_SuplrBillgDocDEX DocumentReferenceID Reference Document Number
AssignmentReference R_SuplrBillgDocDEX AssignmentReference Assignment Reference
SettlmtApplSts R_SuplrBillgDocDEX SettlmtApplSts Application Status for a Settlement Management Document
SettlmtApplStsGrp R_SuplrBillgDocDEX SettlmtApplStsGrp Status Group for Settlement Management Documents
PricingProcedure R_SuplrBillgDocDEX PricingProcedure Pricing Procedure
PricingDocument R_SuplrBillgDocDEX PricingDocument Number of the Document Condition
InvoicingParty R_SuplrBillgDocDEX InvoicingParty Supplier in Settlement Management
PayeeParty R_SuplrBillgDocDEX PayeeParty Payee
AlternativeInvoicingParty R_SuplrBillgDocDEX AlternativeInvoicingParty Alternative Supplier
CompanyCode R_SuplrBillgDocDEX CompanyCode Receiver Company Code
PurchasingOrganization R_SuplrBillgDocDEX PurchasingOrganization Purchasing Organization
PurchasingGroup R_SuplrBillgDocDEX PurchasingGroup Purchasing Group
CreatedByUser R_SuplrBillgDocDEX CreatedByUser Name of User who Created the Document
CreationDate R_SuplrBillgDocDEX CreationDate Date of Document Creation
CreationTime R_SuplrBillgDocDEX CreationTime Time of Document Creation
LastChangeDate R_SuplrBillgDocDEX LastChangeDate Date of Last Document Change
SuplrBillgDocCurrency R_SuplrBillgDocDEX SuplrBillgDocCurrency Currency of Settlement Document
ExchangeRate R_SuplrBillgDocDEX ExchangeRate Conversion Rate (Not Converted)
ExchangeRateType R_SuplrBillgDocDEX ExchangeRateType Exchange Rate Type
ExchangeRateIsFixed R_SuplrBillgDocDEX ExchangeRateIsFixed Indicator for Fixed Exchange Rate
ExchangeRateDate R_SuplrBillgDocDEX ExchangeRateDate Exchange Rate Date
SuplrBillgDocTotalGrossAmount R_SuplrBillgDocDEX SuplrBillgDocTotalGrossAmount Gross Settlement Amount in Document Currency
SuplrBillgDocTotalNetAmount R_SuplrBillgDocDEX SuplrBillgDocTotalNetAmount Net Settlement Amount in Document Currency
SuplrBillgDocTotalTaxAmount R_SuplrBillgDocDEX SuplrBillgDocTotalTaxAmount Total Tax Amount in Document Currency
PaymentTerms R_SuplrBillgDocDEX PaymentTerms Terms of Payment Key
CashDiscount1Days R_SuplrBillgDocDEX CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days R_SuplrBillgDocDEX CashDiscount2Days Days from Baseline Date for Payment
NetPaymentDays R_SuplrBillgDocDEX NetPaymentDays Net Payment Terms Period
CashDiscount1Percent R_SuplrBillgDocDEX CashDiscount1Percent Cash Discount Percentage 1
CashDiscount2Percent R_SuplrBillgDocDEX CashDiscount2Percent Cash Discount Percentage 2
PaymentMethod R_SuplrBillgDocDEX PaymentMethod Payment Method
SuplrTotEligibleAmtForCshDisc R_SuplrBillgDocDEX SuplrTotEligibleAmtForCshDisc Total Amount eligible for cash discount in document currency
SuplrBillgDocIsReversed R_SuplrBillgDocDEX SuplrBillgDocIsReversed Supplier Billing Document Is Reversed
RvsdSuplrBillgDoc R_SuplrBillgDocDEX RvsdSuplrBillgDoc Reversed Document
AdditionalValueDays R_SuplrBillgDocDEX AdditionalValueDays Additional Value Days
FixedValueDate R_SuplrBillgDocDEX FixedValueDate Fixed Value Date
SupplyingCountry R_SuplrBillgDocDEX SupplyingCountry Supplying Country/Region
StateCentralBankPaymentReason R_SuplrBillgDocDEX StateCentralBankPaymentReason State Central Bank Indicator
TaxDepartureCountry R_SuplrBillgDocDEX TaxDepartureCountry Tax Departure Country/Region
TaxDestinationCountry R_SuplrBillgDocDEX TaxDestinationCountry Tax Destination Country/Region
IsEUTriangularDeal R_SuplrBillgDocDEX IsEUTriangularDeal Indicator: Triangular Deal Within the EU
SettlmtCoCodeTaxCountry R_SuplrBillgDocDEX SettlmtCoCodeTaxCountry Tax Country/Region Company Code
VATRegistration R_SuplrBillgDocDEX VATRegistration VAT Registration Number
CreditControlArea R_SuplrBillgDocDEX CreditControlArea Credit Control Area
SuplrBillgDocActivityReason R_SuplrBillgDocDEX SuplrBillgDocActivityReason Header Activity Reason for Document Creation
PaymentReference R_SuplrBillgDocDEX PaymentReference Payment Reference
SuplrBillgDocPaymentCurrency R_SuplrBillgDocDEX SuplrBillgDocPaymentCurrency Payment Currency
SuplrBillgDocPaytCrcyExchRate R_SuplrBillgDocDEX SuplrBillgDocPaytCrcyExchRate Exchange Rate of Payment Currency (not converted)
OneTimeSupplierAddressID R_SuplrBillgDocDEX OneTimeSupplierAddressID Address of One-Time Supplier
SettlmtReltdCndnContr R_SuplrBillgDocDEX SettlmtReltdCndnContr Related Condition Contract in Settlement Management
SettlmtReltdTrdgContr R_SuplrBillgDocDEX SettlmtReltdTrdgContr Related Trading Contract in Settlement Management
CndnContrType R_SuplrBillgDocDEX CndnContrType Condition Contract Type
FiscalPeriod R_SuplrBillgDocDEX FiscalPeriod Fiscal Period
SettlmtDate R_SuplrBillgDocDEX SettlmtDate Rebates: Settlement Date
SuplrBillgDocIncmpltnsRsn R_SuplrBillgDocDEX SuplrBillgDocIncmpltnsRsn Incompleteness Reason of Settlement Management Document
DocIntrastatRelevance R_SuplrBillgDocDEX DocIntrastatRelevance Document is Relevant for Intrastat Declarations
IntrastatDeclnGdsFlwCat R_SuplrBillgDocDEX IntrastatDeclnGdsFlwCat Type of Goods Flow for Intrastat Declarations
IncotermsVersion R_SuplrBillgDocDEX IncotermsVersion Incoterms Version
IncotermsClassification R_SuplrBillgDocDEX IncotermsClassification Incoterms (Part 1)
IncotermsTransferLocation R_SuplrBillgDocDEX IncotermsTransferLocation Incoterms (Part 2)
IncotermsLocation1 R_SuplrBillgDocDEX IncotermsLocation1 Incoterms Location 1
IncotermsLocation2 R_SuplrBillgDocDEX IncotermsLocation2 Incoterms Location 2
SettlmtBusProcVar R_SuplrBillgDocDEX SettlmtBusProcVar Settlement Management Process Category
SettlmtBusProcCat R_SuplrBillgDocDEX SettlmtBusProcCat Use Case Type
SEPAMandate R_SuplrBillgDocDEX SEPAMandate Unique Reference to Mandate for each Payee
TotalSettlmtQuantity R_SuplrBillgDocDEX TotalSettlmtQuantity Total Quantity of the Business Volume in a Settlement Run
TotalSettlmtQuantityUnit R_SuplrBillgDocDEX TotalSettlmtQuantityUnit Unit of Measure for Total Quantity
TotalSettlmtNetWeight R_SuplrBillgDocDEX TotalSettlmtNetWeight Total Net Weight of the Business Volume in a Settlement Run
TotalSettlmtGrossWeight R_SuplrBillgDocDEX TotalSettlmtGrossWeight Total Gross Weight of the Bus Volume in a Settlement Run
TotalSettlmtWeightUnit R_SuplrBillgDocDEX TotalSettlmtWeightUnit Unit of Weight for Total Weight
TotalSettlmtVolume R_SuplrBillgDocDEX TotalSettlmtVolume Total Volume of the Business Volume in a Settlement Run
TotalSettlmtVolumeUnit R_SuplrBillgDocDEX TotalSettlmtVolumeUnit Volume Unit for Total Volume
TotalSettlmtPointsQty R_SuplrBillgDocDEX TotalSettlmtPointsQty Total Points of the Business Volume in a Settlement Run
TotalSettlmtPointsQtyUnit R_SuplrBillgDocDEX TotalSettlmtPointsQtyUnit Points Unit for Total Points
SettlmtDocSmmrznCat R_SuplrBillgDocDEX SettlmtDocSmmrznCat Document Summarization Category
SettlmtClassificationCat R_SuplrBillgDocDEX SettlmtClassificationCat Settlement Classification Category
TrdgExpnSettlmtDoc R_SuplrBillgDocDEX TrdgExpnSettlmtDoc Settlement Document of planned Trading Expenses
TrdgExpnDocSettled R_SuplrBillgDocDEX TrdgExpnDocSettled Trading Expense Document Settled Indicator
TrdgExpnAmount R_SuplrBillgDocDEX TrdgExpnAmount Reference Value for Trading Expenses
TrdgExpnCurrency R_SuplrBillgDocDEX TrdgExpnCurrency Ref. Field for Trading Expenses Ref. Value (Crcy, %, Unit)
TrdgExpnSupplier R_SuplrBillgDocDEX TrdgExpnSupplier Trading Expense Supplier
Product R_SuplrBillgDocDEX Product Product Sold
ProductGroup R_SuplrBillgDocDEX ProductGroup Product Sold Group
Plant R_SuplrBillgDocDEX Plant Valuation Area
InventoryValuationType R_SuplrBillgDocDEX InventoryValuationType Inventory Valuation Type
PricingDate R_SuplrBillgDocDEX PricingDate Date for Pricing and Exchange Rate
TaxCode R_SuplrBillgDocDEX TaxCode Tax on Sales/Purchases Code
TaxJurisdiction R_SuplrBillgDocDEX TaxJurisdiction Tax Jurisdiction
SettlmtQuantity R_SuplrBillgDocDEX SettlmtQuantity Quantity of Settlement Management Document Item
SettlmtQuantityUnit R_SuplrBillgDocDEX SettlmtQuantityUnit Unit of Measure of Settlement Management Doc Item Quantity
NetPriceAmount R_SuplrBillgDocDEX NetPriceAmount Net Price in Document Currency
NetPriceQuantity R_SuplrBillgDocDEX NetPriceQuantity Price Unit of Settlement Management Document Item
NetPriceQuantityUnit R_SuplrBillgDocDEX NetPriceQuantityUnit Settlement Management Document Item Price Unit
SettlmtToBaseQuantityNmrtr R_SuplrBillgDocDEX SettlmtToBaseQuantityNmrtr Numerator Converting Qty in Settlement Document to Base Unit
SettlmtToBaseQuantityDnmntr R_SuplrBillgDocDEX SettlmtToBaseQuantityDnmntr Denominator Converting Qty in Settlement Doc. to Base Unit
SettlmtToNetPriceQtyNmrtr R_SuplrBillgDocDEX SettlmtToNetPriceQtyNmrtr Numerator for Converting Settl. UoM to Settl. Price UoM
SettlmtToNetPriceQtyDnmntr R_SuplrBillgDocDEX SettlmtToNetPriceQtyDnmntr Denominator for Converting Settl. UoM to Settl. Price UoM
BaseUnit R_SuplrBillgDocDEX BaseUnit Base Unit of Measure
ItemNetWeight R_SuplrBillgDocDEX ItemNetWeight Net Weight
ItemGrossWeight R_SuplrBillgDocDEX ItemGrossWeight Gross Weight
ItemWeightUnit R_SuplrBillgDocDEX ItemWeightUnit Unit of Weight
ItemVolume R_SuplrBillgDocDEX ItemVolume Volume
ItemVolumeUnit R_SuplrBillgDocDEX ItemVolumeUnit Volume Unit
ProductPurchasePointsQtyUnit R_SuplrBillgDocDEX ProductPurchasePointsQtyUnit Quantity Unit of Purchase Points of a Product
ProductPurchasePointsQty R_SuplrBillgDocDEX ProductPurchasePointsQty Purchase Points Quantity of a Product
SuplrBillgDocItemTaxAmount R_SuplrBillgDocDEX SuplrBillgDocItemTaxAmount Item Tax Amount in Document Currency
SuplrBillgDocItemGrossAmount R_SuplrBillgDocDEX SuplrBillgDocItemGrossAmount Gross Amount of Item in Document Currency
SuplrBillgDocItemNetAmount R_SuplrBillgDocDEX SuplrBillgDocItemNetAmount Net Amount of Item in Document Currency
SuplrBillgDocSubtotal1Amount R_SuplrBillgDocDEX SuplrBillgDocSubtotal1Amount Subtotal 1 Amount
SuplrBillgDocSubtotal2Amount R_SuplrBillgDocDEX SuplrBillgDocSubtotal2Amount Subtotal 2 Amount
SuplrBillgDocSubtotal3Amount R_SuplrBillgDocDEX SuplrBillgDocSubtotal3Amount Subtotal 3 Amount
SuplrBillgDocSubtotal4Amount R_SuplrBillgDocDEX SuplrBillgDocSubtotal4Amount Subtotal 4 Amount
SuplrBillgDocSubtotal5Amount R_SuplrBillgDocDEX SuplrBillgDocSubtotal5Amount Subtotal 5 Amount
SuplrBillgDocSubtotal6Amount R_SuplrBillgDocDEX SuplrBillgDocSubtotal6Amount Subtotal 6 Amount
SuplrBillgDocRebateBasisAmount R_SuplrBillgDocDEX SuplrBillgDocRebateBasisAmount Rebate Basis Amount
SuplrBillgDocEffctvItemAmount R_SuplrBillgDocDEX SuplrBillgDocEffctvItemAmount Effective Amount of Item (Supplier-Side)
SuplrItmEligibleAmtForCshDisc R_SuplrBillgDocDEX SuplrItmEligibleAmtForCshDisc Amount Eligible for Cash Discount in Document Currency
NonDeductibleInputTaxAmount R_SuplrBillgDocDEX NonDeductibleInputTaxAmount Non Deductible Input Tax Amount
SuplrBillgDocItmStstclPrpty R_SuplrBillgDocDEX SuplrBillgDocItmStstclPrpty Statistical Property of Settlement Management Item
CashDiscountIsDeductible R_SuplrBillgDocDEX CashDiscountIsDeductible Cash Discount is Deductible
SettlmtSourceDoc R_SuplrBillgDocDEX SettlmtSourceDoc Document Number of the Source Document
SettlmtSourceDocItem R_SuplrBillgDocDEX SettlmtSourceDocItem Item of the Source Document
SettlmtSourceDocCat R_SuplrBillgDocDEX SettlmtSourceDocCat Document Category of Source Document
SettlmtSourceDocFiscalYear R_SuplrBillgDocDEX SettlmtSourceDocFiscalYear Fiscal Year of a Source Document in Settlement Management
SuplrBillgDocItmActyReason R_SuplrBillgDocDEX SuplrBillgDocItmActyReason Activity Reason for Document Creation
SuplrBillgDocItemText R_SuplrBillgDocDEX SuplrBillgDocItemText Short Text
BusinessArea R_SuplrBillgDocDEX BusinessArea Business Area
ControllingArea R_SuplrBillgDocDEX ControllingArea Controlling Area
CostCenter R_SuplrBillgDocDEX CostCenter Cost Center
ProfitCenter R_SuplrBillgDocDEX ProfitCenter Profit Center
WBSElementInternalID R_SuplrBillgDocDEX WBSElementInternalID Work Breakdown Structure Element (WBS Element) not converted
SupplierBillingDocumentOrder R_SuplrBillgDocDEX SupplierBillingDocumentOrder Order for Account Assignment in Settlement Management
Batch R_SuplrBillgDocDEX Batch Batch Number
PrcDetnIsIncmplt R_SuplrBillgDocDEX PrcDetnIsIncmplt Price Determination Is Incomplete
SettlmtPrecdgDoc R_SuplrBillgDocDEX SettlmtPrecdgDoc Preceding Document of the Settlement Management Document
SettlmtPrecdgDocItem R_SuplrBillgDocDEX SettlmtPrecdgDocItem Item of Preceding Document
SettlmtPrecdgDocCat R_SuplrBillgDocDEX SettlmtPrecdgDocCat Document Category of Preceding Document
SettlmtPrecdgDocFiscalYear R_SuplrBillgDocDEX SettlmtPrecdgDocFiscalYear Fiscal Year of a Preceding Document in Settlement Management
SuplrBillgDocItmCat R_SuplrBillgDocDEX SuplrBillgDocItmCat Item Category
SettlmtItemReltdCndnContr R_SuplrBillgDocDEX SettlmtItemReltdCndnContr Related Condition Contract of a Settlement Management Item
SettlmtItemReltdTrdgContr R_SuplrBillgDocDEX SettlmtItemReltdTrdgContr Related Trading Contract of a Settlement Management Item
SettlmtItemReltdTrdgContrItem R_SuplrBillgDocDEX SettlmtItemReltdTrdgContrItem Related Trading Contract Item of a Settlmt Mgmt Item
SuplrBillgDocItemStatus R_SuplrBillgDocDEX SuplrBillgDocItemStatus Item Status
SuplrBillgDocItmReversed R_SuplrBillgDocDEX SuplrBillgDocItmReversed Item Was Canceled
ServicesRenderedDate R_SuplrBillgDocDEX ServicesRenderedDate Date of Services Rendered
SettlementFiscalYear R_SuplrBillgDocDEX SettlementFiscalYear Fiscal Year of Settlement
HigherLevelItem R_SuplrBillgDocDEX HigherLevelItem Higher-Level Item in Bill of Material Structures
LowerLevelItemExists R_SuplrBillgDocDEX LowerLevelItemExists Subitems Exist
ItemDistributionStatus R_SuplrBillgDocDEX ItemDistributionStatus Distribution Status of Settlement Item
SettlmtRefDocType R_SuplrBillgDocDEX SettlmtRefDocType Type of Reference Document for Settlement Management
SettlmtRefDoc R_SuplrBillgDocDEX SettlmtRefDoc Reference Document for Settlement Management
SettlmtRefDocFiscalYear R_SuplrBillgDocDEX SettlmtRefDocFiscalYear Year of Reference Document
SettlmtRefDocLogicalSyst R_SuplrBillgDocDEX SettlmtRefDocLogicalSyst Logical System of Reference Document for Smt Mgmt
SettlmtRefDocItem R_SuplrBillgDocDEX SettlmtRefDocItem Reference Document Item for Settlement Management Document
SettlmtRefDocCat R_SuplrBillgDocDEX SettlmtRefDocCat Reference Document Category in Settlement Management
ItemIntrastatRelevance R_SuplrBillgDocDEX ItemIntrastatRelevance Document Item Is Relevant for Intrastat Declarations
SettlmtAddlRefDocType R_SuplrBillgDocDEX SettlmtAddlRefDocType Type of Additional Reference Document for Settlmt Mgmt
SettlmtAddlRefDoc R_SuplrBillgDocDEX SettlmtAddlRefDoc Additional Reference Document for Settlement Management
SettlmtAddlRefDocFiscalYear R_SuplrBillgDocDEX SettlmtAddlRefDocFiscalYear Year of Additional Reference Document
SettlmtAddlRefDocLogicalSyst R_SuplrBillgDocDEX SettlmtAddlRefDocLogicalSyst Logical System of Additional Reference Document for Smt Mgmt
SettlmtAddlRefDocItem R_SuplrBillgDocDEX SettlmtAddlRefDocItem Additional Reference Doc Item for Settlement Mgmt. Document
SettlmtAddlRefDocCat R_SuplrBillgDocDEX SettlmtAddlRefDocCat Additional Reference Document Category
CustomerSettlmtRecipient R_SuplrBillgDocDEX CustomerSettlmtRecipient Customer Settlement Recipient
ProductHierarchy R_SuplrBillgDocDEX ProductHierarchy Product Hierarchy
SalesSpcfcProductGroup1 R_SuplrBillgDocDEX SalesSpcfcProductGroup1 Sales-Specific Product Group 1
SalesSpcfcProductGroup2 R_SuplrBillgDocDEX SalesSpcfcProductGroup2 Sales-Specific Product Group 2
SalesSpcfcProductGroup3 R_SuplrBillgDocDEX SalesSpcfcProductGroup3 Sales-Specific Product Group 3
SalesSpcfcProductGroup4 R_SuplrBillgDocDEX SalesSpcfcProductGroup4 Sales-Specific Product Group 4
SalesSpcfcProductGroup5 R_SuplrBillgDocDEX SalesSpcfcProductGroup5 Sales-Specific Product Group 5
SupplierProductID R_SuplrBillgDocDEX SupplierProductID Material Number Used by Supplier
PriorSupplier R_SuplrBillgDocDEX PriorSupplier Prior Supplier
GLAccount R_SuplrBillgDocDEX GLAccount General Ledger
SupplierSubrange R_SuplrBillgDocDEX SupplierSubrange Supplier Subrange
_AlternativeInvoicingParty R_SuplrBillgDocDEX _AlternativeInvoicingParty
_AltvInvoicingPartyCompany R_SuplrBillgDocDEX _AltvInvoicingPartyCompany
_InvoicingParty R_SuplrBillgDocDEX _InvoicingParty
_InvoicingPartyCompany R_SuplrBillgDocDEX _InvoicingPartyCompany
_PayeeParty R_SuplrBillgDocDEX _PayeeParty
_PayeePartyCompany R_SuplrBillgDocDEX _PayeePartyCompany

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_SuplrBillgDocDEX.
-- 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_SuplrBillgDocDEX AS
SELECT
  SuplrBillgDoc,
  SuplrBillgDocItem,
  SuplrBillgDocDEX.SettlmtDocType AS SettlmtDocType,
  SuplrBillgDocDEX.SettlmtDocCat AS SettlmtDocCat,
  SuplrBillgDocDEX.SettlmtProcessType AS SettlmtProcessType,
  SuplrBillgDocDEX.LogisticsDataEntryCat AS LogisticsDataEntryCat,
  SuplrBillgDocDEX.SettlmtCat AS SettlmtCat,
  SuplrBillgDocDEX.PostingDate AS PostingDate,
  SuplrBillgDocDEX.SuplrBillgDocAcctgTransfSts AS SuplrBillgDocAcctgTransfSts,
  SuplrBillgDocDEX.DocumentDate AS DocumentDate,
  SuplrBillgDocDEX.DocumentReferenceID AS DocumentReferenceID,
  SuplrBillgDocDEX.AssignmentReference AS AssignmentReference,
  SuplrBillgDocDEX.SettlmtApplSts AS SettlmtApplSts,
  SuplrBillgDocDEX.SettlmtApplStsGrp AS SettlmtApplStsGrp,
  SuplrBillgDocDEX.PricingProcedure AS PricingProcedure,
  SuplrBillgDocDEX.PricingDocument AS PricingDocument,
  SuplrBillgDocDEX.InvoicingParty AS InvoicingParty,
  SuplrBillgDocDEX.PayeeParty AS PayeeParty,
  SuplrBillgDocDEX.AlternativeInvoicingParty AS AlternativeInvoicingParty,
  SuplrBillgDocDEX.CompanyCode AS CompanyCode,
  SuplrBillgDocDEX.PurchasingOrganization AS PurchasingOrganization,
  SuplrBillgDocDEX.PurchasingGroup AS PurchasingGroup,
  SuplrBillgDocDEX.CreatedByUser AS CreatedByUser,
  SuplrBillgDocDEX.CreationDate AS CreationDate,
  SuplrBillgDocDEX.CreationTime AS CreationTime,
  SuplrBillgDocDEX.LastChangeDate AS LastChangeDate,
  SuplrBillgDocDEX.SuplrBillgDocCurrency AS SuplrBillgDocCurrency,
  SuplrBillgDocDEX.ExchangeRate AS ExchangeRate,
  SuplrBillgDocDEX.ExchangeRateType AS ExchangeRateType,
  SuplrBillgDocDEX.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  SuplrBillgDocDEX.ExchangeRateDate AS ExchangeRateDate,
  SuplrBillgDocDEX.SuplrBillgDocTotalGrossAmount AS SuplrBillgDocTotalGrossAmount,
  SuplrBillgDocDEX.SuplrBillgDocTotalNetAmount AS SuplrBillgDocTotalNetAmount,
  SuplrBillgDocDEX.SuplrBillgDocTotalTaxAmount AS SuplrBillgDocTotalTaxAmount,
  SuplrBillgDocDEX.PaymentTerms AS PaymentTerms,
  SuplrBillgDocDEX.CashDiscount1Days AS CashDiscount1Days,
  SuplrBillgDocDEX.CashDiscount2Days AS CashDiscount2Days,
  SuplrBillgDocDEX.NetPaymentDays AS NetPaymentDays,
  SuplrBillgDocDEX.CashDiscount1Percent AS CashDiscount1Percent,
  SuplrBillgDocDEX.CashDiscount2Percent AS CashDiscount2Percent,
  SuplrBillgDocDEX.PaymentMethod AS PaymentMethod,
  SuplrBillgDocDEX.SuplrTotEligibleAmtForCshDisc AS SuplrTotEligibleAmtForCshDisc,
  SuplrBillgDocDEX.SuplrBillgDocIsReversed AS SuplrBillgDocIsReversed,
  SuplrBillgDocDEX.RvsdSuplrBillgDoc AS RvsdSuplrBillgDoc,
  SuplrBillgDocDEX.AdditionalValueDays AS AdditionalValueDays,
  SuplrBillgDocDEX.FixedValueDate AS FixedValueDate,
  SuplrBillgDocDEX.SupplyingCountry AS SupplyingCountry,
  SuplrBillgDocDEX.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
  SuplrBillgDocDEX.TaxDepartureCountry AS TaxDepartureCountry,
  SuplrBillgDocDEX.TaxDestinationCountry AS TaxDestinationCountry,
  SuplrBillgDocDEX.IsEUTriangularDeal AS IsEUTriangularDeal,
  SuplrBillgDocDEX.SettlmtCoCodeTaxCountry AS SettlmtCoCodeTaxCountry,
  SuplrBillgDocDEX.VATRegistration AS VATRegistration,
  SuplrBillgDocDEX.CreditControlArea AS CreditControlArea,
  SuplrBillgDocDEX.SuplrBillgDocActivityReason AS SuplrBillgDocActivityReason,
  SuplrBillgDocDEX.PaymentReference AS PaymentReference,
  SuplrBillgDocDEX.SuplrBillgDocPaymentCurrency AS SuplrBillgDocPaymentCurrency,
  SuplrBillgDocDEX.SuplrBillgDocPaytCrcyExchRate AS SuplrBillgDocPaytCrcyExchRate,
  SuplrBillgDocDEX.OneTimeSupplierAddressID AS OneTimeSupplierAddressID,
  SuplrBillgDocDEX.SettlmtReltdCndnContr AS SettlmtReltdCndnContr,
  SuplrBillgDocDEX.SettlmtReltdTrdgContr AS SettlmtReltdTrdgContr,
  SuplrBillgDocDEX.CndnContrType AS CndnContrType,
  SuplrBillgDocDEX.FiscalPeriod AS FiscalPeriod,
  SuplrBillgDocDEX.SettlmtDate AS SettlmtDate,
  SuplrBillgDocDEX.SuplrBillgDocIncmpltnsRsn AS SuplrBillgDocIncmpltnsRsn,
  SuplrBillgDocDEX.DocIntrastatRelevance AS DocIntrastatRelevance,
  SuplrBillgDocDEX.IntrastatDeclnGdsFlwCat AS IntrastatDeclnGdsFlwCat,
  SuplrBillgDocDEX.IncotermsVersion AS IncotermsVersion,
  SuplrBillgDocDEX.IncotermsClassification AS IncotermsClassification,
  SuplrBillgDocDEX.IncotermsTransferLocation AS IncotermsTransferLocation,
  SuplrBillgDocDEX.IncotermsLocation1 AS IncotermsLocation1,
  SuplrBillgDocDEX.IncotermsLocation2 AS IncotermsLocation2,
  SuplrBillgDocDEX.SettlmtBusProcVar AS SettlmtBusProcVar,
  SuplrBillgDocDEX.SettlmtBusProcCat AS SettlmtBusProcCat,
  SuplrBillgDocDEX.SEPAMandate AS SEPAMandate,
  SuplrBillgDocDEX.TotalSettlmtQuantity AS TotalSettlmtQuantity,
  SuplrBillgDocDEX.TotalSettlmtQuantityUnit AS TotalSettlmtQuantityUnit,
  SuplrBillgDocDEX.TotalSettlmtNetWeight AS TotalSettlmtNetWeight,
  SuplrBillgDocDEX.TotalSettlmtGrossWeight AS TotalSettlmtGrossWeight,
  SuplrBillgDocDEX.TotalSettlmtWeightUnit AS TotalSettlmtWeightUnit,
  SuplrBillgDocDEX.TotalSettlmtVolume AS TotalSettlmtVolume,
  SuplrBillgDocDEX.TotalSettlmtVolumeUnit AS TotalSettlmtVolumeUnit,
  SuplrBillgDocDEX.TotalSettlmtPointsQty AS TotalSettlmtPointsQty,
  SuplrBillgDocDEX.TotalSettlmtPointsQtyUnit AS TotalSettlmtPointsQtyUnit,
  SuplrBillgDocDEX.SettlmtDocSmmrznCat AS SettlmtDocSmmrznCat,
  SuplrBillgDocDEX.SettlmtClassificationCat AS SettlmtClassificationCat,
  SuplrBillgDocDEX.TrdgExpnSettlmtDoc AS TrdgExpnSettlmtDoc,
  SuplrBillgDocDEX.TrdgExpnDocSettled AS TrdgExpnDocSettled,
  SuplrBillgDocDEX.TrdgExpnAmount AS TrdgExpnAmount,
  SuplrBillgDocDEX.TrdgExpnCurrency AS TrdgExpnCurrency,
  SuplrBillgDocDEX.TrdgExpnSupplier AS TrdgExpnSupplier,
  SuplrBillgDocDEX.Product AS Product,
  SuplrBillgDocDEX.ProductGroup AS ProductGroup,
  SuplrBillgDocDEX.Plant AS Plant,
  SuplrBillgDocDEX.InventoryValuationType AS InventoryValuationType,
  SuplrBillgDocDEX.PricingDate AS PricingDate,
  SuplrBillgDocDEX.TaxCode AS TaxCode,
  SuplrBillgDocDEX.TaxJurisdiction AS TaxJurisdiction,
  SuplrBillgDocDEX.SettlmtQuantity AS SettlmtQuantity,
  SuplrBillgDocDEX.SettlmtQuantityUnit AS SettlmtQuantityUnit,
  SuplrBillgDocDEX.NetPriceAmount AS NetPriceAmount,
  SuplrBillgDocDEX.NetPriceQuantity AS NetPriceQuantity,
  SuplrBillgDocDEX.NetPriceQuantityUnit AS NetPriceQuantityUnit,
  SuplrBillgDocDEX.SettlmtToBaseQuantityNmrtr AS SettlmtToBaseQuantityNmrtr,
  SuplrBillgDocDEX.SettlmtToBaseQuantityDnmntr AS SettlmtToBaseQuantityDnmntr,
  SuplrBillgDocDEX.SettlmtToNetPriceQtyNmrtr AS SettlmtToNetPriceQtyNmrtr,
  SuplrBillgDocDEX.SettlmtToNetPriceQtyDnmntr AS SettlmtToNetPriceQtyDnmntr,
  SuplrBillgDocDEX.BaseUnit AS BaseUnit,
  SuplrBillgDocDEX.ItemNetWeight AS ItemNetWeight,
  SuplrBillgDocDEX.ItemGrossWeight AS ItemGrossWeight,
  SuplrBillgDocDEX.ItemWeightUnit AS ItemWeightUnit,
  SuplrBillgDocDEX.ItemVolume AS ItemVolume,
  SuplrBillgDocDEX.ItemVolumeUnit AS ItemVolumeUnit,
  SuplrBillgDocDEX.ProductPurchasePointsQtyUnit AS ProductPurchasePointsQtyUnit,
  SuplrBillgDocDEX.ProductPurchasePointsQty AS ProductPurchasePointsQty,
  SuplrBillgDocDEX.SuplrBillgDocItemTaxAmount AS SuplrBillgDocItemTaxAmount,
  SuplrBillgDocDEX.SuplrBillgDocItemGrossAmount AS SuplrBillgDocItemGrossAmount,
  SuplrBillgDocDEX.SuplrBillgDocItemNetAmount AS SuplrBillgDocItemNetAmount,
  SuplrBillgDocDEX.SuplrBillgDocSubtotal1Amount AS SuplrBillgDocSubtotal1Amount,
  SuplrBillgDocDEX.SuplrBillgDocSubtotal2Amount AS SuplrBillgDocSubtotal2Amount,
  SuplrBillgDocDEX.SuplrBillgDocSubtotal3Amount AS SuplrBillgDocSubtotal3Amount,
  SuplrBillgDocDEX.SuplrBillgDocSubtotal4Amount AS SuplrBillgDocSubtotal4Amount,
  SuplrBillgDocDEX.SuplrBillgDocSubtotal5Amount AS SuplrBillgDocSubtotal5Amount,
  SuplrBillgDocDEX.SuplrBillgDocSubtotal6Amount AS SuplrBillgDocSubtotal6Amount,
  SuplrBillgDocDEX.SuplrBillgDocRebateBasisAmount AS SuplrBillgDocRebateBasisAmount,
  SuplrBillgDocDEX.SuplrBillgDocEffctvItemAmount AS SuplrBillgDocEffctvItemAmount,
  SuplrBillgDocDEX.SuplrItmEligibleAmtForCshDisc AS SuplrItmEligibleAmtForCshDisc,
  SuplrBillgDocDEX.NonDeductibleInputTaxAmount AS NonDeductibleInputTaxAmount,
  SuplrBillgDocDEX.SuplrBillgDocItmStstclPrpty AS SuplrBillgDocItmStstclPrpty,
  SuplrBillgDocDEX.CashDiscountIsDeductible AS CashDiscountIsDeductible,
  SuplrBillgDocDEX.SettlmtSourceDoc AS SettlmtSourceDoc,
  SuplrBillgDocDEX.SettlmtSourceDocItem AS SettlmtSourceDocItem,
  SuplrBillgDocDEX.SettlmtSourceDocCat AS SettlmtSourceDocCat,
  SuplrBillgDocDEX.SettlmtSourceDocFiscalYear AS SettlmtSourceDocFiscalYear,
  SuplrBillgDocDEX.SuplrBillgDocItmActyReason AS SuplrBillgDocItmActyReason,
  SuplrBillgDocDEX.SuplrBillgDocItemText AS SuplrBillgDocItemText,
  SuplrBillgDocDEX.BusinessArea AS BusinessArea,
  SuplrBillgDocDEX.ControllingArea AS ControllingArea,
  SuplrBillgDocDEX.CostCenter AS CostCenter,
  SuplrBillgDocDEX.ProfitCenter AS ProfitCenter,
  SuplrBillgDocDEX.WBSElementInternalID AS WBSElementInternalID,
  SuplrBillgDocDEX.SupplierBillingDocumentOrder AS SupplierBillingDocumentOrder,
  SuplrBillgDocDEX.Batch AS Batch,
  SuplrBillgDocDEX.PrcDetnIsIncmplt AS PrcDetnIsIncmplt,
  SuplrBillgDocDEX.SettlmtPrecdgDoc AS SettlmtPrecdgDoc,
  SuplrBillgDocDEX.SettlmtPrecdgDocItem AS SettlmtPrecdgDocItem,
  SuplrBillgDocDEX.SettlmtPrecdgDocCat AS SettlmtPrecdgDocCat,
  SuplrBillgDocDEX.SettlmtPrecdgDocFiscalYear AS SettlmtPrecdgDocFiscalYear,
  SuplrBillgDocDEX.SuplrBillgDocItmCat AS SuplrBillgDocItmCat,
  SuplrBillgDocDEX.SettlmtItemReltdCndnContr AS SettlmtItemReltdCndnContr,
  SuplrBillgDocDEX.SettlmtItemReltdTrdgContr AS SettlmtItemReltdTrdgContr,
  SuplrBillgDocDEX.SettlmtItemReltdTrdgContrItem AS SettlmtItemReltdTrdgContrItem,
  SuplrBillgDocDEX.SuplrBillgDocItemStatus AS SuplrBillgDocItemStatus,
  SuplrBillgDocDEX.SuplrBillgDocItmReversed AS SuplrBillgDocItmReversed,
  SuplrBillgDocDEX.ServicesRenderedDate AS ServicesRenderedDate,
  SuplrBillgDocDEX.SettlementFiscalYear AS SettlementFiscalYear,
  SuplrBillgDocDEX.HigherLevelItem AS HigherLevelItem,
  SuplrBillgDocDEX.LowerLevelItemExists AS LowerLevelItemExists,
  SuplrBillgDocDEX.ItemDistributionStatus AS ItemDistributionStatus,
  SuplrBillgDocDEX.SettlmtRefDocType AS SettlmtRefDocType,
  SuplrBillgDocDEX.SettlmtRefDoc AS SettlmtRefDoc,
  SuplrBillgDocDEX.SettlmtRefDocFiscalYear AS SettlmtRefDocFiscalYear,
  SuplrBillgDocDEX.SettlmtRefDocLogicalSyst AS SettlmtRefDocLogicalSyst,
  SuplrBillgDocDEX.SettlmtRefDocItem AS SettlmtRefDocItem,
  SuplrBillgDocDEX.SettlmtRefDocCat AS SettlmtRefDocCat,
  SuplrBillgDocDEX.ItemIntrastatRelevance AS ItemIntrastatRelevance,
  SuplrBillgDocDEX.SettlmtAddlRefDocType AS SettlmtAddlRefDocType,
  SuplrBillgDocDEX.SettlmtAddlRefDoc AS SettlmtAddlRefDoc,
  SuplrBillgDocDEX.SettlmtAddlRefDocFiscalYear AS SettlmtAddlRefDocFiscalYear,
  SuplrBillgDocDEX.SettlmtAddlRefDocLogicalSyst AS SettlmtAddlRefDocLogicalSyst,
  SuplrBillgDocDEX.SettlmtAddlRefDocItem AS SettlmtAddlRefDocItem,
  SuplrBillgDocDEX.SettlmtAddlRefDocCat AS SettlmtAddlRefDocCat,
  SuplrBillgDocDEX.CustomerSettlmtRecipient AS CustomerSettlmtRecipient,
  SuplrBillgDocDEX.ProductHierarchy AS ProductHierarchy,
  SuplrBillgDocDEX.SalesSpcfcProductGroup1 AS SalesSpcfcProductGroup1,
  SuplrBillgDocDEX.SalesSpcfcProductGroup2 AS SalesSpcfcProductGroup2,
  SuplrBillgDocDEX.SalesSpcfcProductGroup3 AS SalesSpcfcProductGroup3,
  SuplrBillgDocDEX.SalesSpcfcProductGroup4 AS SalesSpcfcProductGroup4,
  SuplrBillgDocDEX.SalesSpcfcProductGroup5 AS SalesSpcfcProductGroup5,
  SuplrBillgDocDEX.SupplierProductID AS SupplierProductID,
  SuplrBillgDocDEX.PriorSupplier AS PriorSupplier,
  SuplrBillgDocDEX.GLAccount AS GLAccount,
  SuplrBillgDocDEX.SupplierSubrange AS SupplierSubrange,
  SuplrBillgDocDEX._AlternativeInvoicingParty AS _AlternativeInvoicingParty,
  SuplrBillgDocDEX._AltvInvoicingPartyCompany AS _AltvInvoicingPartyCompany,
  SuplrBillgDocDEX._InvoicingParty AS _InvoicingParty,
  SuplrBillgDocDEX._InvoicingPartyCompany AS _InvoicingPartyCompany,
  SuplrBillgDocDEX._PayeeParty AS _PayeeParty,
  SuplrBillgDocDEX._PayeePartyCompany AS _PayeePartyCompany
FROM R_SuplrBillgDocDEX AS SuplrBillgDocDEX
;

Learn More