C_SuplrBillgDocDEX

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

Supplier Billing Document Extraction

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.

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 →

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
KEY SuplrBillgDocItem SuplrBillgDocItem
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
SettlmtCat R_SuplrBillgDocDEX SettlmtCat Settl. Category
PostingDate R_SuplrBillgDocDEX PostingDate Posting Date for GR
SuplrBillgDocAcctgTransfSts R_SuplrBillgDocDEX SuplrBillgDocAcctgTransfSts
DocumentDate R_SuplrBillgDocDEX DocumentDate Journal Entry Date
DocumentReferenceID R_SuplrBillgDocDEX DocumentReferenceID Reference
AssignmentReference R_SuplrBillgDocDEX AssignmentReference Assignment Reference
SettlmtApplSts R_SuplrBillgDocDEX SettlmtApplSts Appl. Status
SettlmtApplStsGrp R_SuplrBillgDocDEX SettlmtApplStsGrp Status Group
PricingProcedure R_SuplrBillgDocDEX PricingProcedure Procedure
PricingDocument R_SuplrBillgDocDEX PricingDocument Document Condition
InvoicingParty R_SuplrBillgDocDEX InvoicingParty Supplier
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 User Name
CreationDate R_SuplrBillgDocDEX CreationDate Time Stamp
CreationTime R_SuplrBillgDocDEX CreationTime Time of Change
LastChangeDate R_SuplrBillgDocDEX LastChangeDate Time Stamp
SuplrBillgDocCurrency R_SuplrBillgDocDEX SuplrBillgDocCurrency
ExchangeRate R_SuplrBillgDocDEX ExchangeRate Exchange rate
ExchangeRateType R_SuplrBillgDocDEX ExchangeRateType Exch. Rate Type
ExchangeRateIsFixed R_SuplrBillgDocDEX ExchangeRateIsFixed Fixed Exch.Rate
ExchangeRateDate R_SuplrBillgDocDEX ExchangeRateDate Translatn Date
SuplrBillgDocTotalGrossAmount R_SuplrBillgDocDEX SuplrBillgDocTotalGrossAmount
SuplrBillgDocTotalNetAmount R_SuplrBillgDocDEX SuplrBillgDocTotalNetAmount
SuplrBillgDocTotalTaxAmount R_SuplrBillgDocDEX SuplrBillgDocTotalTaxAmount
PaymentTerms R_SuplrBillgDocDEX PaymentTerms Pyt Terms
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 Pmt Terms Period
CashDiscount1Percent R_SuplrBillgDocDEX CashDiscount1Percent Disc. Percent 1
CashDiscount2Percent R_SuplrBillgDocDEX CashDiscount2Percent Disc. Percent 2
PaymentMethod R_SuplrBillgDocDEX PaymentMethod Pymt Meth.
SuplrTotEligibleAmtForCshDisc R_SuplrBillgDocDEX SuplrTotEligibleAmtForCshDisc Suplr Cash Disc Bas
SuplrBillgDocIsReversed R_SuplrBillgDocDEX SuplrBillgDocIsReversed
RvsdSuplrBillgDoc R_SuplrBillgDocDEX RvsdSuplrBillgDoc
AdditionalValueDays R_SuplrBillgDocDEX AdditionalValueDays Add. Value Days
FixedValueDate R_SuplrBillgDocDEX FixedValueDate Fixed Val. Date
SupplyingCountry R_SuplrBillgDocDEX SupplyingCountry Supplying Ctry/Reg.
StateCentralBankPaymentReason R_SuplrBillgDocDEX StateCentralBankPaymentReason SCB Ind.
TaxDepartureCountry R_SuplrBillgDocDEX TaxDepartureCountry Tx Dep Ctry/Reg
TaxDestinationCountry R_SuplrBillgDocDEX TaxDestinationCountry Tx Des Ctry/Reg
IsEUTriangularDeal R_SuplrBillgDocDEX IsEUTriangularDeal Is EU Triangular Deal
SettlmtCoCodeTaxCountry R_SuplrBillgDocDEX SettlmtCoCodeTaxCountry Tax Ctry/Reg. CoCode
VATRegistration R_SuplrBillgDocDEX VATRegistration VAT Registration No.
CreditControlArea R_SuplrBillgDocDEX CreditControlArea Credit Control Area
SuplrBillgDocActivityReason R_SuplrBillgDocDEX SuplrBillgDocActivityReason
PaymentReference R_SuplrBillgDocDEX PaymentReference Payment Reference
SuplrBillgDocPaymentCurrency R_SuplrBillgDocDEX SuplrBillgDocPaymentCurrency
SuplrBillgDocPaytCrcyExchRate R_SuplrBillgDocDEX SuplrBillgDocPaytCrcyExchRate
OneTimeSupplierAddressID R_SuplrBillgDocDEX OneTimeSupplierAddressID
SettlmtReltdCndnContr R_SuplrBillgDocDEX SettlmtReltdCndnContr Related Condition Contract
SettlmtReltdTrdgContr R_SuplrBillgDocDEX SettlmtReltdTrdgContr
CndnContrType R_SuplrBillgDocDEX CndnContrType Contract Type
FiscalPeriod R_SuplrBillgDocDEX FiscalPeriod Tax period
SettlmtDate R_SuplrBillgDocDEX SettlmtDate Settlement Date
SuplrBillgDocIncmpltnsRsn R_SuplrBillgDocDEX SuplrBillgDocIncmpltnsRsn
DocIntrastatRelevance R_SuplrBillgDocDEX DocIntrastatRelevance Intrastat Rel.
IntrastatDeclnGdsFlwCat R_SuplrBillgDocDEX IntrastatDeclnGdsFlwCat Goods Flow
IncotermsVersion R_SuplrBillgDocDEX IncotermsVersion Inco. Version
IncotermsClassification R_SuplrBillgDocDEX IncotermsClassification Incoterms
IncotermsTransferLocation R_SuplrBillgDocDEX IncotermsTransferLocation Incoterms 2
IncotermsLocation1 R_SuplrBillgDocDEX IncotermsLocation1 Inco. Location1
IncotermsLocation2 R_SuplrBillgDocDEX IncotermsLocation2 Inco. Location2
SettlmtBusProcVar R_SuplrBillgDocDEX SettlmtBusProcVar Proc. Category
SettlmtBusProcCat R_SuplrBillgDocDEX SettlmtBusProcCat Use Case Type
SEPAMandate R_SuplrBillgDocDEX SEPAMandate SEPA Mandate
TotalSettlmtQuantity R_SuplrBillgDocDEX TotalSettlmtQuantity Total Quantity
TotalSettlmtQuantityUnit R_SuplrBillgDocDEX TotalSettlmtQuantityUnit UoM Total Quantity
TotalSettlmtNetWeight R_SuplrBillgDocDEX TotalSettlmtNetWeight Total Net Weight
TotalSettlmtGrossWeight R_SuplrBillgDocDEX TotalSettlmtGrossWeight Total Gross Weight
TotalSettlmtWeightUnit R_SuplrBillgDocDEX TotalSettlmtWeightUnit UoW Total Weight
TotalSettlmtVolume R_SuplrBillgDocDEX TotalSettlmtVolume Total Volume
TotalSettlmtVolumeUnit R_SuplrBillgDocDEX TotalSettlmtVolumeUnit Unit Total Volume
TotalSettlmtPointsQty R_SuplrBillgDocDEX TotalSettlmtPointsQty
TotalSettlmtPointsQtyUnit R_SuplrBillgDocDEX TotalSettlmtPointsQtyUnit
SettlmtDocSmmrznCat R_SuplrBillgDocDEX SettlmtDocSmmrznCat Summarization
SettlmtClassificationCat R_SuplrBillgDocDEX SettlmtClassificationCat Classification Cat.
TrdgExpnSettlmtDoc R_SuplrBillgDocDEX TrdgExpnSettlmtDoc
TrdgExpnDocSettled R_SuplrBillgDocDEX TrdgExpnDocSettled
TrdgExpnAmount R_SuplrBillgDocDEX TrdgExpnAmount
TrdgExpnCurrency R_SuplrBillgDocDEX TrdgExpnCurrency
TrdgExpnSupplier R_SuplrBillgDocDEX TrdgExpnSupplier
Product R_SuplrBillgDocDEX Product Product Sold
ProductGroup R_SuplrBillgDocDEX ProductGroup Product Sold Group
Plant R_SuplrBillgDocDEX Plant Valuation Area
InventoryValuationType R_SuplrBillgDocDEX InventoryValuationType Valuation Type
PricingDate R_SuplrBillgDocDEX PricingDate Pricing Date
TaxCode R_SuplrBillgDocDEX TaxCode Tax Code
TaxJurisdiction R_SuplrBillgDocDEX TaxJurisdiction Tax Jurisdiction
SettlmtQuantity R_SuplrBillgDocDEX SettlmtQuantity SettlmtQuantity
SettlmtQuantityUnit R_SuplrBillgDocDEX SettlmtQuantityUnit Settlement Unit
NetPriceAmount R_SuplrBillgDocDEX NetPriceAmount Net Price
NetPriceQuantity R_SuplrBillgDocDEX NetPriceQuantity Price Unit
NetPriceQuantityUnit R_SuplrBillgDocDEX NetPriceQuantityUnit SettlmtPrcUnit
SettlmtToBaseQuantityNmrtr R_SuplrBillgDocDEX SettlmtToBaseQuantityNmrtr Numerator Settlement UoM to Base UoM
SettlmtToBaseQuantityDnmntr R_SuplrBillgDocDEX SettlmtToBaseQuantityDnmntr Denominator Settlement UoM to Base UoM
SettlmtToNetPriceQtyNmrtr R_SuplrBillgDocDEX SettlmtToNetPriceQtyNmrtr Numerator: Sett. UoM to Sett. Price UoM
SettlmtToNetPriceQtyDnmntr R_SuplrBillgDocDEX SettlmtToNetPriceQtyDnmntr Denominator: Sett. UoM to Sett. PriceUoM
BaseUnit R_SuplrBillgDocDEX BaseUnit 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 Points Unit
ProductPurchasePointsQty R_SuplrBillgDocDEX ProductPurchasePointsQty Points
SuplrBillgDocItemTaxAmount R_SuplrBillgDocDEX SuplrBillgDocItemTaxAmount
SuplrBillgDocItemGrossAmount R_SuplrBillgDocDEX SuplrBillgDocItemGrossAmount
SuplrBillgDocItemNetAmount R_SuplrBillgDocDEX SuplrBillgDocItemNetAmount
SuplrBillgDocSubtotal1Amount R_SuplrBillgDocDEX SuplrBillgDocSubtotal1Amount
SuplrBillgDocSubtotal2Amount R_SuplrBillgDocDEX SuplrBillgDocSubtotal2Amount
SuplrBillgDocSubtotal3Amount R_SuplrBillgDocDEX SuplrBillgDocSubtotal3Amount
SuplrBillgDocSubtotal4Amount R_SuplrBillgDocDEX SuplrBillgDocSubtotal4Amount
SuplrBillgDocSubtotal5Amount R_SuplrBillgDocDEX SuplrBillgDocSubtotal5Amount
SuplrBillgDocSubtotal6Amount R_SuplrBillgDocDEX SuplrBillgDocSubtotal6Amount
SuplrBillgDocRebateBasisAmount R_SuplrBillgDocDEX SuplrBillgDocRebateBasisAmount
SuplrBillgDocEffctvItemAmount R_SuplrBillgDocDEX SuplrBillgDocEffctvItemAmount
SuplrItmEligibleAmtForCshDisc R_SuplrBillgDocDEX SuplrItmEligibleAmtForCshDisc Csh.Disc.Bas
NonDeductibleInputTaxAmount R_SuplrBillgDocDEX NonDeductibleInputTaxAmount Non-deductible
SuplrBillgDocItmStstclPrpty R_SuplrBillgDocDEX SuplrBillgDocItmStstclPrpty
CashDiscountIsDeductible R_SuplrBillgDocDEX CashDiscountIsDeductible Cash Discount
SettlmtSourceDoc R_SuplrBillgDocDEX SettlmtSourceDoc Source Doc.
SettlmtSourceDocItem R_SuplrBillgDocDEX SettlmtSourceDocItem Item of the Source Document
SettlmtSourceDocCat R_SuplrBillgDocDEX SettlmtSourceDocCat SourceDocCat
SettlmtSourceDocFiscalYear R_SuplrBillgDocDEX SettlmtSourceDocFiscalYear Fiscal Year of Source Document
SuplrBillgDocItmActyReason R_SuplrBillgDocDEX SuplrBillgDocItmActyReason
SuplrBillgDocItemText R_SuplrBillgDocDEX SuplrBillgDocItemText
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 WBS Internal ID
SupplierBillingDocumentOrder R_SuplrBillgDocDEX SupplierBillingDocumentOrder
Batch R_SuplrBillgDocDEX Batch Lot No.
PrcDetnIsIncmplt R_SuplrBillgDocDEX PrcDetnIsIncmplt Price Determination Is Incomplete
SettlmtPrecdgDoc R_SuplrBillgDocDEX SettlmtPrecdgDoc Pre. Document
SettlmtPrecdgDocItem R_SuplrBillgDocDEX SettlmtPrecdgDocItem Item of Preceding Document
SettlmtPrecdgDocCat R_SuplrBillgDocDEX SettlmtPrecdgDocCat PreDocCat
SettlmtPrecdgDocFiscalYear R_SuplrBillgDocDEX SettlmtPrecdgDocFiscalYear Fiscal Year of Preceding Document
SuplrBillgDocItmCat R_SuplrBillgDocDEX SuplrBillgDocItmCat
SettlmtItemReltdCndnContr R_SuplrBillgDocDEX SettlmtItemReltdCndnContr ItmRelatedCndnContr
SettlmtItemReltdTrdgContr R_SuplrBillgDocDEX SettlmtItemReltdTrdgContr
SettlmtItemReltdTrdgContrItem R_SuplrBillgDocDEX SettlmtItemReltdTrdgContrItem
SuplrBillgDocItemStatus R_SuplrBillgDocDEX SuplrBillgDocItemStatus
SuplrBillgDocItmReversed R_SuplrBillgDocDEX SuplrBillgDocItmReversed
ServicesRenderedDate R_SuplrBillgDocDEX ServicesRenderedDate Services Rendered Date
SettlementFiscalYear R_SuplrBillgDocDEX SettlementFiscalYear Fiscal Year of Settlement
HigherLevelItem R_SuplrBillgDocDEX HigherLevelItem Higher-Lev.Item
LowerLevelItemExists R_SuplrBillgDocDEX LowerLevelItemExists Subitems
ItemDistributionStatus R_SuplrBillgDocDEX ItemDistributionStatus Distributn Status
SettlmtRefDocType R_SuplrBillgDocDEX SettlmtRefDocType Settlement Reference Document Type
SettlmtRefDoc R_SuplrBillgDocDEX SettlmtRefDoc Settlmt. Ref. Doc.
SettlmtRefDocFiscalYear R_SuplrBillgDocDEX SettlmtRefDocFiscalYear Year of Reference Document
SettlmtRefDocLogicalSyst R_SuplrBillgDocDEX SettlmtRefDocLogicalSyst SM Ref Log Sys
SettlmtRefDocItem R_SuplrBillgDocDEX SettlmtRefDocItem SettlmtRefDocItem
SettlmtRefDocCat R_SuplrBillgDocDEX SettlmtRefDocCat SettlmtRefDocCat
ItemIntrastatRelevance R_SuplrBillgDocDEX ItemIntrastatRelevance Item Intrastat Relevance
SettlmtAddlRefDocType R_SuplrBillgDocDEX SettlmtAddlRefDocType Additional Reference Doc Type in Settlmt
SettlmtAddlRefDoc R_SuplrBillgDocDEX SettlmtAddlRefDoc SettlmtAddlRefDoc
SettlmtAddlRefDocFiscalYear R_SuplrBillgDocDEX SettlmtAddlRefDocFiscalYear Year of Additional Reference Document
SettlmtAddlRefDocLogicalSyst R_SuplrBillgDocDEX SettlmtAddlRefDocLogicalSyst SM Addl Ref Log Sys
SettlmtAddlRefDocItem R_SuplrBillgDocDEX SettlmtAddlRefDocItem SettlmtAddlRefDocItm
SettlmtAddlRefDocCat R_SuplrBillgDocDEX SettlmtAddlRefDocCat SettlmtAddlRefDocCat
CustomerSettlmtRecipient R_SuplrBillgDocDEX CustomerSettlmtRecipient Cust Settlmt Recpnt
ProductHierarchy R_SuplrBillgDocDEX ProductHierarchy Prod.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 Supp. Mat. No.
PriorSupplier R_SuplrBillgDocDEX PriorSupplier Prior Supplier
GLAccount R_SuplrBillgDocDEX GLAccount General Ledger
SupplierSubrange R_SuplrBillgDocDEX SupplierSubrange Suppl. 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