R_SettlmtDocTP

DDL: R_SETTLMTDOCTP Type: view_entity TRANSACTIONAL

Settlement Document - TP

R_SettlmtDocTP is a Transactional CDS View that provides data about "Settlement Document - TP" in SAP S/4HANA. It reads from 1 data source (R_SettlmtDoc) and exposes 205 fields with key field SettlmtDoc. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_SettlmtDoc SettlmtDoc from

Associations (7)

CardinalityTargetAliasCondition
[0..*] R_SettlmtDocPartner _Partner $projection.SettlmtDoc = _Partner.SettlmtDoc
[0..1] R_OutputRequestTP _OutputRequest _OutputRequest.OutputControlApplicationObject = $projection.SettlmtDoc and _OutputRequest.OutputControlApplObjectType = 'SETTLEMENT_DOCUMENT'
[1..1] E_SettlmtMgmtDoc _Extension $projection.SettlmtDoc = _Extension.SettlmtMgmtDoc
[0..*] R_SettlmtDocItemTP _SettlmtDocItem
[0..*] R_SettlmtDocCustPrcgElmntTP _CustomerPricingElement
[0..*] R_SettlmtDocSuplrPrcgElmntTP _SupplierPricingElement
[0..*] R_SettlmtDocPartnerTP _SettlmtDocPartner

Annotations (12)

NameValueLevelField
EndUserText.label Settlement Document - TP view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.representativeKey SettlmtDoc view
ObjectModel.sapObjectNodeType.name SettlementDocument view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
Analytics.technicalName RWLFSDOCTP view

Fields (205)

KeyFieldSource TableSource FieldDescription
KEY SettlmtDoc R_SettlmtDoc SettlmtDoc Settlement Doc.
SettlmtDocType R_SettlmtDoc SettlmtDocType Settlement Document Type
SettlmtDocCat R_SettlmtDoc SettlmtDocCat Settlement Document Category
SettlmtProcessType R_SettlmtDoc SettlmtProcessType Settlement Process Type
SettlmtProcessCat R_SettlmtDoc SettlmtProcessCat Settlement Process Category
LogisticsDataEntryCat R_SettlmtDoc LogisticsDataEntryCat Entry Category
SettlmtCat R_SettlmtDoc SettlmtCat Settl. Category
SupplierPricingProcedure R_SettlmtDoc SupplierPricingProcedure SuplrPrcgProc.
CustomerPricingProcedure R_SettlmtDoc CustomerPricingProcedure CustPrcgProc.
PostingDate R_SettlmtDoc PostingDate Posting Date for GR
SettlmtMgmtAcctgTransfSts R_SettlmtDoc SettlmtMgmtAcctgTransfSts Posting Status
InvoicingParty R_SettlmtDoc InvoicingParty Supplier
PayeeParty R_SettlmtDoc PayeeParty Payee
BillToParty R_SettlmtDoc BillToParty Inv. Recipient
PayerParty R_SettlmtDoc PayerParty Payer
PurchasingOrganization R_SettlmtDoc PurchasingOrganization Purchasing Organization
PurchasingGroup R_SettlmtDoc PurchasingGroup Purchasing Group
SalesOrganization R_SettlmtDoc SalesOrganization Sales Organization
DistributionChannel R_SettlmtDoc DistributionChannel RefDistCh-Cust/Mat.
Division R_SettlmtDoc Division Internal Division ID
SuplrSettlmtCompanyCode R_SettlmtDoc SuplrSettlmtCompanyCode Suppl. Company Code
CustSettlmtCompanyCode R_SettlmtDoc CustSettlmtCompanyCode Cust. Company Code
CreatedByUser R_SettlmtDoc CreatedByUser User Name
CreationDate R_SettlmtDoc CreationDate Time Stamp
CreationTime R_SettlmtDoc CreationTime Time of Change
LastChangeDate R_SettlmtDoc LastChangeDate Time Stamp
DocumentDate R_SettlmtDoc DocumentDate Journal Entry Date
DocumentReferenceID R_SettlmtDoc DocumentReferenceID Reference
AssignmentReference R_SettlmtDoc AssignmentReference Assignment Reference
SettlmtDocCurrency R_SettlmtDoc SettlmtDocCurrency Doc. Currency
ExchangeRate R_SettlmtDoc ExchangeRate Exchange rate
ExchangeRateIsFixed R_SettlmtDoc ExchangeRateIsFixed Fixed Exch.Rate
ExchangeRateDate R_SettlmtDoc ExchangeRateDate Translatn Date
SupplierTotalGrossAmount R_SettlmtDoc SupplierTotalGrossAmount Supplier Total Gross Amount
SupplierTotalNetAmount R_SettlmtDoc SupplierTotalNetAmount Supplier Total Net Amount
SupplierTotalTaxAmount R_SettlmtDoc SupplierTotalTaxAmount Supplier Total Tax Amount
CustomerTotalGrossAmount R_SettlmtDoc CustomerTotalGrossAmount Customer Total Gross Amount
CustomerTotalNetAmount R_SettlmtDoc CustomerTotalNetAmount Extracted Net Value
CustomerTotalTaxAmount R_SettlmtDoc CustomerTotalTaxAmount Customer Total Tax Amount
SupplierPaymentTerms R_SettlmtDoc SupplierPaymentTerms Supplier Payment Terms
SupplierCashDiscount1Days R_SettlmtDoc SupplierCashDiscount1Days Supplier First Payment in Days
SupplierCashDiscount2Days R_SettlmtDoc SupplierCashDiscount2Days Supplier Second Payment in Days
SupplierNetPaymentDays R_SettlmtDoc SupplierNetPaymentDays Supplier Cash Discount Days
SupplierCashDiscount1Percent R_SettlmtDoc SupplierCashDiscount1Percent Supplier Discount for 1st Payment in %
SupplierCashDiscount2Percent R_SettlmtDoc SupplierCashDiscount2Percent Supplier Discount for 2nd Payment in %
SupplierPaymentMethod R_SettlmtDoc SupplierPaymentMethod Supplier Payment Method
CustomerPaymentTerms R_SettlmtDoc CustomerPaymentTerms Pyt Terms
CustomerCashDiscount1Days R_SettlmtDoc CustomerCashDiscount1Days Customer 1st Payment in Days
CustomerCashDiscount2Days R_SettlmtDoc CustomerCashDiscount2Days Customer 2nd Payment in Days
CustomerNetPaymentDays R_SettlmtDoc CustomerNetPaymentDays Customer Cash Discount Days
CustomerCashDiscount1Percent R_SettlmtDoc CustomerCashDiscount1Percent Customer Discount for 1st Payment in %
CustomerCashDiscount2Percent R_SettlmtDoc CustomerCashDiscount2Percent Customer Discount for 2nd Payment in %
CustomerPaymentMethod R_SettlmtDoc CustomerPaymentMethod Cust Pmt Method
SuplrTotEligibleAmtForCshDisc R_SettlmtDoc SuplrTotEligibleAmtForCshDisc Suplr Cash Disc Bas
CustTotEligibleAmtForCshDisc R_SettlmtDoc CustTotEligibleAmtForCshDisc Cust Cash Disc Bas
SettlmtDocIsCanceled R_SettlmtDoc SettlmtDocIsCanceled Doc. Reversed
CanceledSettlmtDoc R_SettlmtDoc CanceledSettlmtDoc Reversed Document
SupplierPricingDocument R_SettlmtDoc SupplierPricingDocument Supplier Document Condition
CustomerPricingDocument R_SettlmtDoc CustomerPricingDocument Customer Document Condition
SupplierAdditionalValueDays R_SettlmtDoc SupplierAdditionalValueDays Supplier Additional Value Days
SupplierFixedValueDate R_SettlmtDoc SupplierFixedValueDate Supplier Fixed Value Date
CustomerAdditionalValueDays R_SettlmtDoc CustomerAdditionalValueDays Customer Additional Value Days
CustomerFixedValueDate R_SettlmtDoc CustomerFixedValueDate Customer Fixed Value Date
SupplyingCountry R_SettlmtDoc SupplyingCountry Supplying Ctry/Reg.
StateCentralBankPaymentReason R_SettlmtDoc StateCentralBankPaymentReason SCB Ind.
CreditControlArea R_SettlmtDoc CreditControlArea Credit Control Area
SettlmtDocActivityReason R_SettlmtDoc SettlmtDocActivityReason Header Document Creation Activity Reason
PaymentReference R_SettlmtDoc PaymentReference Payment Reference
SupplierPaymentCurrency R_SettlmtDoc SupplierPaymentCurrency Payt Currency
SupplierPaytCurrencyExchRate R_SettlmtDoc SupplierPaytCurrencyExchRate Supp. Payt Currency Exch. Rate
CustomerPaymentCurrency R_SettlmtDoc CustomerPaymentCurrency Payt Currency
CustomerPaytCurrencyExchRate R_SettlmtDoc CustomerPaytCurrencyExchRate Cust. Payt Currency Exch. Rate
SettlmtApplSts R_SettlmtDoc SettlmtApplSts Appl. Status
ExchangeRateType R_SettlmtDoc ExchangeRateType Exch. Rate Type
SalesOffice R_SettlmtDoc SalesOffice Sales Office
SalesGroup R_SettlmtDoc SalesGroup Sales Group
SettlmtReltdRefDocCat SettlmtReltdRefDocCat Contract Cat.
SettlmtReltdRefDoc SettlmtReltdRefDoc Contract
SettlmtReltdCndnContr R_SettlmtDoc SettlmtReltdCndnContr Related Condition Contract
SettlmtDocSmmrznCat R_SettlmtDoc SettlmtDocSmmrznCat Summarization
CreditControlAreaCurrency R_SettlmtDoc CreditControlAreaCurrency Credit Control Area Currency
ReleasedCreditAmount R_SettlmtDoc ReleasedCreditAmount Credit Value
SettlmtClassificationCat R_SettlmtDoc SettlmtClassificationCat Classification Cat.
SettlmtPartnerCat R_SettlmtDoc SettlmtPartnerCat Settlmt Part Cat
SupplierSettlmtStatus R_SettlmtDoc SupplierSettlmtStatus Settl. Status Supp.
CustomerSettlmtStatus R_SettlmtDoc CustomerSettlmtStatus Settl. Status Cust.
SupplierSettlmtDocCat R_SettlmtDoc SupplierSettlmtDocCat Doc. Type - Suppl.
CustomerSettlmtDocCat R_SettlmtDoc CustomerSettlmtDocCat Settlmt Doc Type
SupplierSettlmtBlkgReason R_SettlmtDoc SupplierSettlmtBlkgReason Supplier Settlement Blocking Reason
CustomerSettlmtBlkgReason R_SettlmtDoc CustomerSettlmtBlkgReason Customer Settlement Blocking Reason
FiscalPeriod R_SettlmtDoc FiscalPeriod Tax period
CndnContrType R_SettlmtDoc CndnContrType Contract Type
CndnContrProcessCategory R_SettlmtDoc CndnContrProcessCategory Process Category
SettlmtDateCat R_SettlmtDoc SettlmtDateCat Settlement Date Type
ActualSettlmtDate R_SettlmtDoc ActualSettlmtDate Actual Settl. Date
SettlmtDateSequentialID R_SettlmtDoc SettlmtDateSequentialID Settlement Date ID
SettlmtDocIncmpltnsRsn R_SettlmtDoc SettlmtDocIncmpltnsRsn Incomplete Rsn
AlternativeInvoicingParty R_SettlmtDoc AlternativeInvoicingParty Alternative Supplier
CombinedSettlmtPostgSts R_SettlmtDoc CombinedSettlmtPostgSts Posting Status 2
DocIntrastatRelevance R_SettlmtDoc DocIntrastatRelevance Intrastat Rel.
TaxDepartureCountry R_SettlmtDoc TaxDepartureCountry Tx Dep Ctry/Reg
TaxDestinationCountry R_SettlmtDoc TaxDestinationCountry Tx Des Ctry/Reg
IsEUTriangularDeal R_SettlmtDoc IsEUTriangularDeal Is EU Triangular Deal
SupplierVATRegistration R_SettlmtDoc SupplierVATRegistration VAT Registration No.
CustomerVATRegistration R_SettlmtDoc CustomerVATRegistration VAT Registration No.
IntrastatDeclnGdsFlwCat R_SettlmtDoc IntrastatDeclnGdsFlwCat Goods Flow
SettlmtDate R_SettlmtDoc SettlmtDate Settlement Date
SettlmtBusProcVar R_SettlmtDoc SettlmtBusProcVar Proc. Category
SettlmtDocCollSts R_SettlmtDoc SettlmtDocCollSts Collective Settlement Status
SettlmtDocIsCollvDoc R_SettlmtDoc SettlmtDocIsCollvDoc Document is Collective Document
CollSettlmtBlkgReason R_SettlmtDoc CollSettlmtBlkgReason Collective Settlement Blocking Reason
SuplrSettlmtCoCodeTaxCountry R_SettlmtDoc SuplrSettlmtCoCodeTaxCountry Tax Ctry/Reg. CoCode
CustSettlmtCoCodeTaxCountry R_SettlmtDoc CustSettlmtCoCodeTaxCountry Tax Country/Region Company Code Customer
SettlmtBusProcCat R_SettlmtDoc SettlmtBusProcCat Use Case Type
PostingPartnerCat R_SettlmtDoc PostingPartnerCat Posting Partner
SettlmtPeriodStartDate R_SettlmtDoc SettlmtPeriodStartDate Start Date of Period
SettlmtPeriodEndDate R_SettlmtDoc SettlmtPeriodEndDate End Date of Period
SettlmtApplStsGrp R_SettlmtDoc SettlmtApplStsGrp Status Group
JournalEntryCreationDate JournalEntryCreationDate Journal Entry Creation Date
JournalEntryCreationTime JournalEntryCreationTime Journal Entry Creation Time
ContractAccount ContractAccount Contract Acct
ApplElmntBehaviorGrp ApplElmntBehaviorGrp Element Behavior Group
SettlmtHasDvtgCndnContrData SettlmtHasDvtgCndnContrData Dev. Settl Data Item
SettlmtDocAuthznCat SettlmtDocAuthznCat Authorization Cat.
SettlmtDocChangeState R_SettlmtDoc SettlmtDocChangeState Change State
_OutputRequest _OutputRequest
_SettlmtDocItem _SettlmtDocItem
_Partner _Partner
_SettlmtDocPartner _SettlmtDocPartner
_BankData _BankData
_SupplierPricingElement _SupplierPricingElement
_CustomerPricingElement _CustomerPricingElement
_SettlmtDocType _SettlmtDocType
_SettlmtDocCat _SettlmtDocCat
_SettlmtProcessType _SettlmtProcessType
_SettlmtProcessCat _SettlmtProcessCat
_LogisticsDataEntryCat _LogisticsDataEntryCat
_SettlmtCat _SettlmtCat
_SettlmtMgmtAcctgTransfSts _SettlmtMgmtAcctgTransfSts
_InvoicingParty _InvoicingParty
_PayeeParty _PayeeParty
_BillToParty _BillToParty
_PayerParty _PayerParty
_PurchasingOrganization _PurchasingOrganization
_PurchasingGroup _PurchasingGroup
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SuplrSettlmtCompanyCode _SuplrSettlmtCompanyCode
_CustSettlmtCompanyCode _CustSettlmtCompanyCode
_CreatedByUser _CreatedByUser
_SettlmtDocCurrency _SettlmtDocCurrency
_SupplierPaymentTerms _SupplierPaymentTerms
_CustomerPaymentTerms _CustomerPaymentTerms
_CanceledSettlmtDoc _CanceledSettlmtDoc
_SupplyingCountry _SupplyingCountry
_CreditControlArea _CreditControlArea
_SettlmtDocActivityReason _SettlmtDocActivityReason
_SupplierPaymentCurrency _SupplierPaymentCurrency
_CustomerPaymentCurrency _CustomerPaymentCurrency
_SettlmtApplSts _SettlmtApplSts
_SettlmtApplStsGrp _SettlmtApplStsGrp
_SettlmtApplStsGrpStsAssgmt _SettlmtApplStsGrpStsAssgmt
_ExchangeRateType _ExchangeRateType
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_SettlmtDocSmmrznCat _SettlmtDocSmmrznCat
_CreditControlAreaCurrency _CreditControlAreaCurrency
_SettlmtClassificationCat _SettlmtClassificationCat
_SettlmtPartnerCat _SettlmtPartnerCat
_SupplierSettlmtStatus _SupplierSettlmtStatus
_CustomerSettlmtStatus _CustomerSettlmtStatus
_SupplierSettlmtDocCat _SupplierSettlmtDocCat
_CustomerSettlmtDocCat _CustomerSettlmtDocCat
_SupplierSettlmtBlkgReason _SupplierSettlmtBlkgReason
_CustomerSettlmtBlkgReason _CustomerSettlmtBlkgReason
_SettlmtReltdCndnContr _SettlmtReltdCndnContr
_CndnContrType _CndnContrType
_SettlmtDateCat _SettlmtDateCat
_SettlmtDocIncmpltnsRsn _SettlmtDocIncmpltnsRsn
_AlternativeInvoicingParty _AlternativeInvoicingParty
_CombinedSettlmtPostgSts _CombinedSettlmtPostgSts
_DocIntrastatRelevance _DocIntrastatRelevance
_TaxDepartureCountry _TaxDepartureCountry
_TaxDestinationCountry _TaxDestinationCountry
_IntrastatDeclnGdsFlwCat _IntrastatDeclnGdsFlwCat
_SettlmtBusProcVar _SettlmtBusProcVar
_SettlmtDocCollSts _SettlmtDocCollSts
_SettlmtDocIsCollvDoc _SettlmtDocIsCollvDoc
_CollSettlmtBlkgReason _CollSettlmtBlkgReason
_SuplrSettlmtCoCodeTaxCountry _SuplrSettlmtCoCodeTaxCountry
_CustSettlmtCoCodeTaxCountry _CustSettlmtCoCodeTaxCountry
_SettlmtBusProcCat _SettlmtBusProcCat
_PostingPartnerCat _PostingPartnerCat
_InvoicingPartyCompany _InvoicingPartyCompany
_PayeePartyCompany _PayeePartyCompany
_AltvInvoicingPartyCompany _AltvInvoicingPartyCompany
_BillToPartyCompany _BillToPartyCompany
_PayerPartyCompany _PayerPartyCompany
_SalesArea _SalesArea
_CndnContrProcessCategory _CndnContrProcessCategory
_CreditControlAreaText _CreditControlAreaText
_SettlmtDocAuthznCat _SettlmtDocAuthznCat
_FsclCalDateForSuplrCoCode _FsclCalDateForSuplrCoCode
_FsclCalDateForCustCoCode _FsclCalDateForCustCoCode

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_SettlmtDocTP.
-- 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_SettlmtDocTP AS
SELECT
  SettlmtDoc.SettlmtDoc AS SettlmtDoc,
  SettlmtDoc.SettlmtDocType AS SettlmtDocType,
  SettlmtDoc.SettlmtDocCat AS SettlmtDocCat,
  SettlmtDoc.SettlmtProcessType AS SettlmtProcessType,
  SettlmtDoc.SettlmtProcessCat AS SettlmtProcessCat,
  SettlmtDoc.LogisticsDataEntryCat AS LogisticsDataEntryCat,
  SettlmtDoc.SettlmtCat AS SettlmtCat,
  SettlmtDoc.SupplierPricingProcedure AS SupplierPricingProcedure,
  SettlmtDoc.CustomerPricingProcedure AS CustomerPricingProcedure,
  SettlmtDoc.PostingDate AS PostingDate,
  SettlmtDoc.SettlmtMgmtAcctgTransfSts AS SettlmtMgmtAcctgTransfSts,
  SettlmtDoc.InvoicingParty AS InvoicingParty,
  SettlmtDoc.PayeeParty AS PayeeParty,
  SettlmtDoc.BillToParty AS BillToParty,
  SettlmtDoc.PayerParty AS PayerParty,
  SettlmtDoc.PurchasingOrganization AS PurchasingOrganization,
  SettlmtDoc.PurchasingGroup AS PurchasingGroup,
  SettlmtDoc.SalesOrganization AS SalesOrganization,
  SettlmtDoc.DistributionChannel AS DistributionChannel,
  SettlmtDoc.Division AS Division,
  SettlmtDoc.SuplrSettlmtCompanyCode AS SuplrSettlmtCompanyCode,
  SettlmtDoc.CustSettlmtCompanyCode AS CustSettlmtCompanyCode,
  SettlmtDoc.CreatedByUser AS CreatedByUser,
  SettlmtDoc.CreationDate AS CreationDate,
  SettlmtDoc.CreationTime AS CreationTime,
  SettlmtDoc.LastChangeDate AS LastChangeDate,
  SettlmtDoc.DocumentDate AS DocumentDate,
  SettlmtDoc.DocumentReferenceID AS DocumentReferenceID,
  SettlmtDoc.AssignmentReference AS AssignmentReference,
  SettlmtDoc.SettlmtDocCurrency AS SettlmtDocCurrency,
  SettlmtDoc.ExchangeRate AS ExchangeRate,
  SettlmtDoc.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  SettlmtDoc.ExchangeRateDate AS ExchangeRateDate,
  SettlmtDoc.SupplierTotalGrossAmount AS SupplierTotalGrossAmount,
  SettlmtDoc.SupplierTotalNetAmount AS SupplierTotalNetAmount,
  SettlmtDoc.SupplierTotalTaxAmount AS SupplierTotalTaxAmount,
  SettlmtDoc.CustomerTotalGrossAmount AS CustomerTotalGrossAmount,
  SettlmtDoc.CustomerTotalNetAmount AS CustomerTotalNetAmount,
  SettlmtDoc.CustomerTotalTaxAmount AS CustomerTotalTaxAmount,
  SettlmtDoc.SupplierPaymentTerms AS SupplierPaymentTerms,
  SettlmtDoc.SupplierCashDiscount1Days AS SupplierCashDiscount1Days,
  SettlmtDoc.SupplierCashDiscount2Days AS SupplierCashDiscount2Days,
  SettlmtDoc.SupplierNetPaymentDays AS SupplierNetPaymentDays,
  SettlmtDoc.SupplierCashDiscount1Percent AS SupplierCashDiscount1Percent,
  SettlmtDoc.SupplierCashDiscount2Percent AS SupplierCashDiscount2Percent,
  SettlmtDoc.SupplierPaymentMethod AS SupplierPaymentMethod,
  SettlmtDoc.CustomerPaymentTerms AS CustomerPaymentTerms,
  SettlmtDoc.CustomerCashDiscount1Days AS CustomerCashDiscount1Days,
  SettlmtDoc.CustomerCashDiscount2Days AS CustomerCashDiscount2Days,
  SettlmtDoc.CustomerNetPaymentDays AS CustomerNetPaymentDays,
  SettlmtDoc.CustomerCashDiscount1Percent AS CustomerCashDiscount1Percent,
  SettlmtDoc.CustomerCashDiscount2Percent AS CustomerCashDiscount2Percent,
  SettlmtDoc.CustomerPaymentMethod AS CustomerPaymentMethod,
  SettlmtDoc.SuplrTotEligibleAmtForCshDisc AS SuplrTotEligibleAmtForCshDisc,
  SettlmtDoc.CustTotEligibleAmtForCshDisc AS CustTotEligibleAmtForCshDisc,
  SettlmtDoc.SettlmtDocIsCanceled AS SettlmtDocIsCanceled,
  SettlmtDoc.CanceledSettlmtDoc AS CanceledSettlmtDoc,
  SettlmtDoc.SupplierPricingDocument AS SupplierPricingDocument,
  SettlmtDoc.CustomerPricingDocument AS CustomerPricingDocument,
  SettlmtDoc.SupplierAdditionalValueDays AS SupplierAdditionalValueDays,
  SettlmtDoc.SupplierFixedValueDate AS SupplierFixedValueDate,
  SettlmtDoc.CustomerAdditionalValueDays AS CustomerAdditionalValueDays,
  SettlmtDoc.CustomerFixedValueDate AS CustomerFixedValueDate,
  SettlmtDoc.SupplyingCountry AS SupplyingCountry,
  SettlmtDoc.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
  SettlmtDoc.CreditControlArea AS CreditControlArea,
  SettlmtDoc.SettlmtDocActivityReason AS SettlmtDocActivityReason,
  SettlmtDoc.PaymentReference AS PaymentReference,
  SettlmtDoc.SupplierPaymentCurrency AS SupplierPaymentCurrency,
  SettlmtDoc.SupplierPaytCurrencyExchRate AS SupplierPaytCurrencyExchRate,
  SettlmtDoc.CustomerPaymentCurrency AS CustomerPaymentCurrency,
  SettlmtDoc.CustomerPaytCurrencyExchRate AS CustomerPaytCurrencyExchRate,
  SettlmtDoc.SettlmtApplSts AS SettlmtApplSts,
  SettlmtDoc.ExchangeRateType AS ExchangeRateType,
  SettlmtDoc.SalesOffice AS SalesOffice,
  SettlmtDoc.SalesGroup AS SalesGroup,
  SettlmtReltdRefDocCat,
  SettlmtReltdRefDoc,
  SettlmtDoc.SettlmtReltdCndnContr AS SettlmtReltdCndnContr,
  SettlmtDoc.SettlmtDocSmmrznCat AS SettlmtDocSmmrznCat,
  SettlmtDoc.CreditControlAreaCurrency AS CreditControlAreaCurrency,
  SettlmtDoc.ReleasedCreditAmount AS ReleasedCreditAmount,
  SettlmtDoc.SettlmtClassificationCat AS SettlmtClassificationCat,
  SettlmtDoc.SettlmtPartnerCat AS SettlmtPartnerCat,
  SettlmtDoc.SupplierSettlmtStatus AS SupplierSettlmtStatus,
  SettlmtDoc.CustomerSettlmtStatus AS CustomerSettlmtStatus,
  SettlmtDoc.SupplierSettlmtDocCat AS SupplierSettlmtDocCat,
  SettlmtDoc.CustomerSettlmtDocCat AS CustomerSettlmtDocCat,
  SettlmtDoc.SupplierSettlmtBlkgReason AS SupplierSettlmtBlkgReason,
  SettlmtDoc.CustomerSettlmtBlkgReason AS CustomerSettlmtBlkgReason,
  SettlmtDoc.FiscalPeriod AS FiscalPeriod,
  SettlmtDoc.CndnContrType AS CndnContrType,
  SettlmtDoc.CndnContrProcessCategory AS CndnContrProcessCategory,
  SettlmtDoc.SettlmtDateCat AS SettlmtDateCat,
  SettlmtDoc.ActualSettlmtDate AS ActualSettlmtDate,
  SettlmtDoc.SettlmtDateSequentialID AS SettlmtDateSequentialID,
  SettlmtDoc.SettlmtDocIncmpltnsRsn AS SettlmtDocIncmpltnsRsn,
  SettlmtDoc.AlternativeInvoicingParty AS AlternativeInvoicingParty,
  SettlmtDoc.CombinedSettlmtPostgSts AS CombinedSettlmtPostgSts,
  SettlmtDoc.DocIntrastatRelevance AS DocIntrastatRelevance,
  SettlmtDoc.TaxDepartureCountry AS TaxDepartureCountry,
  SettlmtDoc.TaxDestinationCountry AS TaxDestinationCountry,
  SettlmtDoc.IsEUTriangularDeal AS IsEUTriangularDeal,
  SettlmtDoc.SupplierVATRegistration AS SupplierVATRegistration,
  SettlmtDoc.CustomerVATRegistration AS CustomerVATRegistration,
  SettlmtDoc.IntrastatDeclnGdsFlwCat AS IntrastatDeclnGdsFlwCat,
  SettlmtDoc.SettlmtDate AS SettlmtDate,
  SettlmtDoc.SettlmtBusProcVar AS SettlmtBusProcVar,
  SettlmtDoc.SettlmtDocCollSts AS SettlmtDocCollSts,
  SettlmtDoc.SettlmtDocIsCollvDoc AS SettlmtDocIsCollvDoc,
  SettlmtDoc.CollSettlmtBlkgReason AS CollSettlmtBlkgReason,
  SettlmtDoc.SuplrSettlmtCoCodeTaxCountry AS SuplrSettlmtCoCodeTaxCountry,
  SettlmtDoc.CustSettlmtCoCodeTaxCountry AS CustSettlmtCoCodeTaxCountry,
  SettlmtDoc.SettlmtBusProcCat AS SettlmtBusProcCat,
  SettlmtDoc.PostingPartnerCat AS PostingPartnerCat,
  SettlmtDoc.SettlmtPeriodStartDate AS SettlmtPeriodStartDate,
  SettlmtDoc.SettlmtPeriodEndDate AS SettlmtPeriodEndDate,
  SettlmtDoc.SettlmtApplStsGrp AS SettlmtApplStsGrp,
  JournalEntryCreationDate,
  JournalEntryCreationTime,
  ContractAccount,
  ApplElmntBehaviorGrp,
  SettlmtHasDvtgCndnContrData,
  SettlmtDocAuthznCat,
  SettlmtDoc.SettlmtDocChangeState AS SettlmtDocChangeState
FROM R_SettlmtDoc AS SettlmtDoc
LEFT OUTER JOIN R_SettlmtDocPartner AS _Partner ON SettlmtDoc = _Partner.SettlmtDoc  -- association [0..*]
LEFT OUTER JOIN R_OutputRequestTP AS _OutputRequest ON _OutputRequest.OutputControlApplicationObject = SettlmtDoc AND _OutputRequest.OutputControlApplObjectType = 'SETTLEMENT_DOCUMENT'  -- association [0..1]
LEFT OUTER JOIN E_SettlmtMgmtDoc AS _Extension ON SettlmtDoc = _Extension.SettlmtMgmtDoc  -- association [1..1]
LEFT OUTER JOIN R_SettlmtDocItemTP AS _SettlmtDocItem ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SettlmtDocCustPrcgElmntTP AS _CustomerPricingElement ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SettlmtDocSuplrPrcgElmntTP AS _SupplierPricingElement ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SettlmtDocPartnerTP AS _SettlmtDocPartner ON /* condition not available in parsed metadata */  -- association [0..*]
;