R_SuplrBillgDocDEX

DDL: R_SUPLRBILLGDOCDEX Type: view COMPOSITE
194 Fields 1 Data Sources

Supplier Billing Doc Basic Extraction

R_SuplrBillgDocDEX is a Composite CDS View that provides data about "Supplier Billing Doc Basic Extraction" in SAP S/4HANA. It reads from 1 data source (R_SuplrBillgDocItem) and exposes 194 fields with key fields SuplrBillgDoc, SuplrBillgDocItem.

Data Sources (1)

SourceAliasJoin Type
R_SuplrBillgDocItem SuplrBillgDocItem from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName RWLFSUPLRBGDDEX view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Supplier Billing Doc Basic Extraction view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.compositionRoot true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view

Fields (194)

KeyFieldSource TableSource FieldDescription
KEY SuplrBillgDoc R_SuplrBillgDocItem SuplrBillgDoc
KEY SuplrBillgDocItem R_SuplrBillgDocItem SuplrBillgDocItem Item
SettlmtDocType SuplrBillgDoc SettlmtDocType Settlement Document Type
SettlmtDocCat SuplrBillgDoc SettlmtDocCat Settlement Document Category
SettlmtProcessType SuplrBillgDoc SettlmtProcessType Settlement Process Type
LogisticsDataEntryCat SuplrBillgDoc LogisticsDataEntryCat Entry Category
SettlmtCat SuplrBillgDoc SettlmtCat Settl. Category
PostingDate SuplrBillgDoc PostingDate Posting Date for GR
SuplrBillgDocAcctgTransfSts SuplrBillgDoc SuplrBillgDocAcctgTransfSts
DocumentDate SuplrBillgDoc DocumentDate Journal Entry Date
DocumentReferenceID SuplrBillgDoc DocumentReferenceID Reference
AssignmentReference SuplrBillgDoc AssignmentReference Assignment Reference
SettlmtApplSts SuplrBillgDoc SettlmtApplSts Appl. Status
SettlmtApplStsGrp SuplrBillgDoc SettlmtApplStsGrp Status Group
PricingProcedure SuplrBillgDoc PricingProcedure Procedure
PricingDocument SuplrBillgDoc PricingDocument Document Condition
InvoicingParty SuplrBillgDoc InvoicingParty Supplier
PayeeParty SuplrBillgDoc PayeeParty Payee
AlternativeInvoicingParty SuplrBillgDoc AlternativeInvoicingParty Alternative Supplier
CompanyCode SuplrBillgDoc CompanyCode Receiver Company Code
PurchasingOrganization SuplrBillgDoc PurchasingOrganization Purchasing Organization
PurchasingGroup SuplrBillgDoc PurchasingGroup Purchasing Group
CreatedByUser SuplrBillgDoc CreatedByUser User Name
CreationDate SuplrBillgDoc CreationDate Time Stamp
CreationTime SuplrBillgDoc CreationTime Time of Change
LastChangeDate SuplrBillgDoc LastChangeDate Time Stamp
SuplrBillgDocCurrency SuplrBillgDoc SuplrBillgDocCurrency Doc. Currency
ExchangeRate SuplrBillgDoc ExchangeRate Exchange rate
ExchangeRateType SuplrBillgDoc ExchangeRateType Exch. Rate Type
ExchangeRateIsFixed SuplrBillgDoc ExchangeRateIsFixed Fixed Exch.Rate
ExchangeRateDate SuplrBillgDoc ExchangeRateDate Translatn Date
SuplrBillgDocTotalGrossAmount SuplrBillgDoc SuplrBillgDocTotalGrossAmount
SuplrBillgDocTotalNetAmount SuplrBillgDoc SuplrBillgDocTotalNetAmount
SuplrBillgDocTotalTaxAmount SuplrBillgDoc SuplrBillgDocTotalTaxAmount
PaymentTerms SuplrBillgDoc PaymentTerms Pyt Terms
CashDiscount1Days SuplrBillgDoc CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days SuplrBillgDoc CashDiscount2Days Days from Baseline Date for Payment
NetPaymentDays SuplrBillgDoc NetPaymentDays Net Pmt Terms Period
CashDiscount1Percent SuplrBillgDoc CashDiscount1Percent Disc. Percent 1
CashDiscount2Percent SuplrBillgDoc CashDiscount2Percent Disc. Percent 2
PaymentMethod SuplrBillgDoc PaymentMethod Pymt Meth.
SuplrTotEligibleAmtForCshDisc SuplrBillgDoc SuplrTotEligibleAmtForCshDisc Suplr Cash Disc Bas
SuplrBillgDocIsReversed SuplrBillgDoc SuplrBillgDocIsReversed
RvsdSuplrBillgDoc SuplrBillgDoc RvsdSuplrBillgDoc
AdditionalValueDays SuplrBillgDoc AdditionalValueDays Add. Value Days
FixedValueDate SuplrBillgDoc FixedValueDate Fixed Val. Date
SupplyingCountry SuplrBillgDoc SupplyingCountry Supplying Ctry/Reg.
StateCentralBankPaymentReason SuplrBillgDoc StateCentralBankPaymentReason SCB Ind.
TaxDepartureCountry SuplrBillgDoc TaxDepartureCountry Tx Dep Ctry/Reg
TaxDestinationCountry SuplrBillgDoc TaxDestinationCountry Tx Des Ctry/Reg
IsEUTriangularDeal SuplrBillgDoc IsEUTriangularDeal Is EU Triangular Deal
SettlmtCoCodeTaxCountry SuplrBillgDoc SettlmtCoCodeTaxCountry Tax Ctry/Reg. CoCode
VATRegistration SuplrBillgDoc VATRegistration VAT Registration No.
CreditControlArea SuplrBillgDoc CreditControlArea Credit Control Area
SuplrBillgDocActivityReason SuplrBillgDoc SuplrBillgDocActivityReason
PaymentReference SuplrBillgDoc PaymentReference Payment Reference
SuplrBillgDocPaymentCurrency SuplrBillgDoc SuplrBillgDocPaymentCurrency
SuplrBillgDocPaytCrcyExchRate SuplrBillgDoc SuplrBillgDocPaytCrcyExchRate
OneTimeSupplierAddressID SuplrBillgDoc OneTimeSupplierAddressID
SettlmtReltdRefDocCat SuplrBillgDoc SettlmtReltdRefDocCat Contract Cat.
SettlmtReltdRefDoc SuplrBillgDoc SettlmtReltdRefDoc Contract
CndnContrType SuplrBillgDoc CndnContrType Contract Type
FiscalPeriod SuplrBillgDoc FiscalPeriod Tax period
SettlmtDate SuplrBillgDoc SettlmtDate Settlement Date
SuplrBillgDocIncmpltnsRsn SuplrBillgDoc SuplrBillgDocIncmpltnsRsn
DocIntrastatRelevance SuplrBillgDoc DocIntrastatRelevance Intrastat Rel.
IntrastatDeclnGdsFlwCat SuplrBillgDoc IntrastatDeclnGdsFlwCat Goods Flow
IncotermsVersion SuplrBillgDoc IncotermsVersion Inco. Version
IncotermsClassification SuplrBillgDoc IncotermsClassification Incoterms
IncotermsTransferLocation SuplrBillgDoc IncotermsTransferLocation Incoterms 2
IncotermsLocation1 SuplrBillgDoc IncotermsLocation1 Inco. Location1
IncotermsLocation2 SuplrBillgDoc IncotermsLocation2 Inco. Location2
SettlmtBusProcVar SuplrBillgDoc SettlmtBusProcVar Proc. Category
SettlmtBusProcCat SuplrBillgDoc SettlmtBusProcCat Use Case Type
SEPAMandate SuplrBillgDoc SEPAMandate SEPA Mandate
TotalSettlmtQuantity SuplrBillgDoc TotalSettlmtQuantity Total Quantity
TotalSettlmtQuantityUnit SuplrBillgDoc TotalSettlmtQuantityUnit UoM Total Quantity
TotalSettlmtNetWeight SuplrBillgDoc TotalSettlmtNetWeight Total Net Weight
TotalSettlmtGrossWeight SuplrBillgDoc TotalSettlmtGrossWeight Total Gross Weight
TotalSettlmtWeightUnit SuplrBillgDoc TotalSettlmtWeightUnit UoW Total Weight
TotalSettlmtVolume SuplrBillgDoc TotalSettlmtVolume Total Volume
TotalSettlmtVolumeUnit SuplrBillgDoc TotalSettlmtVolumeUnit Unit Total Volume
TotalSettlmtPointsQty SuplrBillgDoc TotalSettlmtPointsQty
TotalSettlmtPointsQtyUnit SuplrBillgDoc TotalSettlmtPointsQtyUnit
SettlmtDocSmmrznCat SuplrBillgDoc SettlmtDocSmmrznCat Summarization
SettlmtClassificationCat SuplrBillgDoc SettlmtClassificationCat Classification Cat.
TrdgExpnSettlmtDoc SuplrBillgDoc TrdgExpnSettlmtDoc
TrdgExpnDocSettled SuplrBillgDoc TrdgExpnDocSettled
TrdgExpnAmount SuplrBillgDoc TrdgExpnAmount
TrdgExpnCurrency SuplrBillgDoc TrdgExpnCurrency
TrdgExpnSupplier SuplrBillgDoc TrdgExpnSupplier
Product R_SuplrBillgDocItem Product Product Sold
ProductGroup R_SuplrBillgDocItem ProductGroup Product Sold Group
Plant R_SuplrBillgDocItem Plant Valuation Area
InventoryValuationType R_SuplrBillgDocItem InventoryValuationType Valuation Type
PricingDate R_SuplrBillgDocItem PricingDate Pricing Date
TaxCode R_SuplrBillgDocItem TaxCode Tax Code
TaxJurisdiction R_SuplrBillgDocItem TaxJurisdiction Tax Jurisdiction
SettlmtQuantity R_SuplrBillgDocItem SettlmtQuantity SettlmtQuantity
SettlmtQuantityUnit R_SuplrBillgDocItem SettlmtQuantityUnit Settlement Unit
NetPriceAmount R_SuplrBillgDocItem NetPriceAmount Net Price
NetPriceQuantity R_SuplrBillgDocItem NetPriceQuantity Price Unit
NetPriceQuantityUnit R_SuplrBillgDocItem NetPriceQuantityUnit SettlmtPrcUnit
SettlmtToBaseQuantityNmrtr R_SuplrBillgDocItem SettlmtToBaseQuantityNmrtr Numerator Settlement UoM to Base UoM
SettlmtToBaseQuantityDnmntr R_SuplrBillgDocItem SettlmtToBaseQuantityDnmntr Denominator Settlement UoM to Base UoM
SettlmtToNetPriceQtyNmrtr R_SuplrBillgDocItem SettlmtToNetPriceQtyNmrtr Numerator: Sett. UoM to Sett. Price UoM
SettlmtToNetPriceQtyDnmntr R_SuplrBillgDocItem SettlmtToNetPriceQtyDnmntr Denominator: Sett. UoM to Sett. PriceUoM
BaseUnit R_SuplrBillgDocItem BaseUnit Unit of Measure
ItemNetWeight R_SuplrBillgDocItem ItemNetWeight Net Weight
ItemGrossWeight R_SuplrBillgDocItem ItemGrossWeight Gross Weight
ItemWeightUnit R_SuplrBillgDocItem ItemWeightUnit Unit of Weight
ItemVolume R_SuplrBillgDocItem ItemVolume Volume
ItemVolumeUnit R_SuplrBillgDocItem ItemVolumeUnit Volume Unit
ProductPurchasePointsQtyUnit R_SuplrBillgDocItem ProductPurchasePointsQtyUnit Points Unit
ProductPurchasePointsQty R_SuplrBillgDocItem ProductPurchasePointsQty Points
SuplrBillgDocItemTaxAmount R_SuplrBillgDocItem SuplrBillgDocItemTaxAmount
SuplrBillgDocItemGrossAmount R_SuplrBillgDocItem SuplrBillgDocItemGrossAmount
SuplrBillgDocItemNetAmount R_SuplrBillgDocItem SuplrBillgDocItemNetAmount
SuplrBillgDocSubtotal1Amount R_SuplrBillgDocItem SuplrBillgDocSubtotal1Amount
SuplrBillgDocSubtotal2Amount R_SuplrBillgDocItem SuplrBillgDocSubtotal2Amount
SuplrBillgDocSubtotal3Amount R_SuplrBillgDocItem SuplrBillgDocSubtotal3Amount
SuplrBillgDocSubtotal4Amount R_SuplrBillgDocItem SuplrBillgDocSubtotal4Amount
SuplrBillgDocSubtotal5Amount R_SuplrBillgDocItem SuplrBillgDocSubtotal5Amount
SuplrBillgDocSubtotal6Amount R_SuplrBillgDocItem SuplrBillgDocSubtotal6Amount
SuplrBillgDocRebateBasisAmount R_SuplrBillgDocItem SuplrBillgDocRebateBasisAmount
SuplrBillgDocEffctvItemAmount R_SuplrBillgDocItem SuplrBillgDocEffctvItemAmount Supplier Effective Item Amount
SuplrItmEligibleAmtForCshDisc R_SuplrBillgDocItem SuplrItmEligibleAmtForCshDisc Csh.Disc.Bas
NonDeductibleInputTaxAmount R_SuplrBillgDocItem NonDeductibleInputTaxAmount Non-deductible
SuplrBillgDocItmStstclPrpty R_SuplrBillgDocItem SuplrBillgDocItmStstclPrpty Statistical Prpty
CashDiscountIsDeductible R_SuplrBillgDocItem CashDiscountIsDeductible Cash Discount
SettlmtRefDocReltdFiscalYear R_SuplrBillgDocItem SettlmtRefDocReltdFiscalYear
SettlmtSourceDoc R_SuplrBillgDocItem SettlmtSourceDoc Source Doc.
SettlmtSourceDocItem R_SuplrBillgDocItem SettlmtSourceDocItem Item of the Source Document
SettlmtSourceDocCat R_SuplrBillgDocItem SettlmtSourceDocCat SourceDocCat
SuplrBillgDocItmActyReason R_SuplrBillgDocItem SuplrBillgDocItmActyReason Activity Reason
SuplrBillgDocItemText R_SuplrBillgDocItem SuplrBillgDocItemText
BusinessArea R_SuplrBillgDocItem BusinessArea Business Area
ControllingArea R_SuplrBillgDocItem ControllingArea Controlling Area
CostCenter R_SuplrBillgDocItem CostCenter Cost Center
ProfitCenter R_SuplrBillgDocItem ProfitCenter Profit Center
WBSElementInternalID R_SuplrBillgDocItem WBSElementInternalID WBS Internal ID
SupplierBillingDocumentOrder R_SuplrBillgDocItem SupplierBillingDocumentOrder
Batch R_SuplrBillgDocItem Batch Lot No.
PrcDetnIsIncmplt R_SuplrBillgDocItem PrcDetnIsIncmplt Price Determination Is Incomplete
SettlmtPrecdgDoc R_SuplrBillgDocItem SettlmtPrecdgDoc Pre. Document
SettlmtPrecdgDocItem R_SuplrBillgDocItem SettlmtPrecdgDocItem Item of Preceding Document
SettlmtPrecdgDocCat R_SuplrBillgDocItem SettlmtPrecdgDocCat PreDocCat
SuplrBillgDocItmCat R_SuplrBillgDocItem SuplrBillgDocItmCat
SettlmtItemReltdRefDocCat R_SuplrBillgDocItem SettlmtItemReltdRefDocCat Settlement Item Related Ref. Doc. Cat.
SettlmtItemReltdRefDoc R_SuplrBillgDocItem SettlmtItemReltdRefDoc Settlement Item Related Reference Doc.
SettlmtItemReltdRefDocItem R_SuplrBillgDocItem SettlmtItemReltdRefDocItem Settlement Item Related Ref. Doc. Item
SuplrBillgDocItemStatus R_SuplrBillgDocItem SuplrBillgDocItemStatus
SuplrBillgDocItmReversed R_SuplrBillgDocItem SuplrBillgDocItmReversed
ServicesRenderedDate R_SuplrBillgDocItem ServicesRenderedDate Services Rendered Date
SettlementFiscalYear R_SuplrBillgDocItem SettlementFiscalYear Fiscal Year of Settlement
HigherLevelItem R_SuplrBillgDocItem HigherLevelItem Higher-Lev.Item
LowerLevelItemExists R_SuplrBillgDocItem LowerLevelItemExists Subitems
ItemDistributionStatus R_SuplrBillgDocItem ItemDistributionStatus Distributn Status
SettlmtRefDocType R_SuplrBillgDocItem SettlmtRefDocType Settlement Reference Document Type
SettlmtRefDoc R_SuplrBillgDocItem SettlmtRefDoc Settlmt. Ref. Doc.
SettlmtRefDocFiscalYear R_SuplrBillgDocItem SettlmtRefDocFiscalYear Year of Reference Document
SettlmtRefDocLogicalSyst R_SuplrBillgDocItem SettlmtRefDocLogicalSyst SM Ref Log Sys
SettlmtRefDocItem R_SuplrBillgDocItem SettlmtRefDocItem SettlmtRefDocItem
SettlmtRefDocCat R_SuplrBillgDocItem SettlmtRefDocCat SettlmtRefDocCat
ItemIntrastatRelevance R_SuplrBillgDocItem ItemIntrastatRelevance Item Intrastat Relevance
SettlmtAddlRefDocType R_SuplrBillgDocItem SettlmtAddlRefDocType Additional Reference Doc Type in Settlmt
SettlmtAddlRefDoc R_SuplrBillgDocItem SettlmtAddlRefDoc SettlmtAddlRefDoc
SettlmtAddlRefDocFiscalYear R_SuplrBillgDocItem SettlmtAddlRefDocFiscalYear Year of Additional Reference Document
SettlmtAddlRefDocLogicalSyst R_SuplrBillgDocItem SettlmtAddlRefDocLogicalSyst SM Addl Ref Log Sys
SettlmtAddlRefDocItem R_SuplrBillgDocItem SettlmtAddlRefDocItem SettlmtAddlRefDocItm
SettlmtAddlRefDocCat R_SuplrBillgDocItem SettlmtAddlRefDocCat SettlmtAddlRefDocCat
CustomerSettlmtRecipient R_SuplrBillgDocItem CustomerSettlmtRecipient Cust Settlmt Recpnt
ProductHierarchy R_SuplrBillgDocItem ProductHierarchy Prod.hierarchy
SalesSpcfcProductGroup1 R_SuplrBillgDocItem SalesSpcfcProductGroup1 Sales-Specific Product Group 1
SalesSpcfcProductGroup2 R_SuplrBillgDocItem SalesSpcfcProductGroup2 Sales-Specific Product Group 2
SalesSpcfcProductGroup3 R_SuplrBillgDocItem SalesSpcfcProductGroup3 Sales-Specific Product Group 3
SalesSpcfcProductGroup4 R_SuplrBillgDocItem SalesSpcfcProductGroup4 Sales-Specific Product Group 4
SalesSpcfcProductGroup5 R_SuplrBillgDocItem SalesSpcfcProductGroup5 Sales-Specific Product Group 5
SupplierProductID R_SuplrBillgDocItem SupplierProductID Supp. Mat. No.
PriorSupplier R_SuplrBillgDocItem PriorSupplier Prior Supplier
GLAccount R_SuplrBillgDocItem GLAccount General Ledger
SupplierSubrange R_SuplrBillgDocItem SupplierSubrange Suppl. Subrange
_AlternativeInvoicingParty SuplrBillgDoc _AlternativeInvoicingParty
_AltvInvoicingPartyCompany SuplrBillgDoc _AltvInvoicingPartyCompany
_InvoicingParty SuplrBillgDoc _InvoicingParty
_InvoicingPartyCompany SuplrBillgDoc _InvoicingPartyCompany
_PayeeParty SuplrBillgDoc _PayeeParty
_PayeePartyCompany SuplrBillgDoc _PayeePartyCompany
_TotalSettlmtQuantityUnit SuplrBillgDoc _TotalSettlmtQuantityUnit
_TotalSettlmtWeightUnit SuplrBillgDoc _TotalSettlmtWeightUnit
_TotalSettlmtVolumeUnit SuplrBillgDoc _TotalSettlmtVolumeUnit
_TotalSettlmtPointsQtyUnit SuplrBillgDoc _TotalSettlmtPointsQtyUnit
_SuplrBillgDocPaymentCurrency SuplrBillgDoc _SuplrBillgDocPaymentCurrency
_TrdgExpnCurrency SuplrBillgDoc _TrdgExpnCurrency

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

Learn More