R_TrdgDoc

DDL: R_TRDGDOC Type: view_entity COMPOSITE

Trading Document

R_TrdgDoc is a Composite CDS View that provides data about "Trading Document" in SAP S/4HANA. It reads from 1 data source (R_TrdgDocHeaderBasic) and exposes 241 fields with key field TradingDocument. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_TrdgDocHeaderBasic TrdgDocHeaderBasic from

Associations (4)

CardinalityTargetAliasCondition
[0..*] R_TrdgDocPartner _TrdgDocPartner $projection.TradingDocument = _TrdgDocPartner.TradingDocument
[0..*] R_TrdgDocSlsPrcgElmnt _SalesPricingElement $projection.TradingDocument = _SalesPricingElement.TradingDocument
[0..*] R_TrdgDocPurgPrcgElmnt _PurchasingPricingElement $projection.TradingDocument = _PurchasingPricingElement.TradingDocument
[0..*] R_TrdgDocItem _TrdgDocItem $projection.TradingDocument = _TrdgDocItem.TradingDocument

Annotations (12)

NameValueLevelField
EndUserText.label Trading Document view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.compositionRoot false view
ObjectModel.representativeKey TradingDocument view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Analytics.dataExtraction.enabled false view
Analytics.internalName #LOCAL view
Metadata.allowExtensions false view

Fields (241)

KeyFieldSource TableSource FieldDescription
KEY TradingDocument R_TrdgDocHeaderBasic TradingDocument Trading Contract
TradingDocumentType R_TrdgDocHeaderBasic TradingDocumentType Contract Type
TrdgDocCategory R_TrdgDocHeaderBasic TrdgDocCategory TC Category
TrdgDocApplicationStatus R_TrdgDocHeaderBasic TrdgDocApplicationStatus Only Copy Appr.TC
SalesDocumentType R_TrdgDocHeaderBasic SalesDocumentType Sales Doc. Type
SalesDocumentCondition R_TrdgDocHeaderBasic SalesDocumentCondition
CreatedByUser R_TrdgDocHeaderBasic CreatedByUser User Name
LastChangedByUser R_TrdgDocHeaderBasic LastChangedByUser User Name
TrdgDocPersonResponsible R_TrdgDocHeaderBasic TrdgDocPersonResponsible Pers. Respons.
CreationDate R_TrdgDocHeaderBasic CreationDate Time Stamp
CreationTime R_TrdgDocHeaderBasic CreationTime Time of Change
LastChangeDate R_TrdgDocHeaderBasic LastChangeDate Time Stamp
LastChangeTime R_TrdgDocHeaderBasic LastChangeTime Time changed
TrdgDocDate R_TrdgDocHeaderBasic TrdgDocDate Posting Date
SalesOrganization R_TrdgDocHeaderBasic SalesOrganization Sales Organization
DistributionChannel R_TrdgDocHeaderBasic DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision R_TrdgDocHeaderBasic OrganizationDivision Org. Division
SalesGroup R_TrdgDocHeaderBasic SalesGroup Sales Group
SalesOffice R_TrdgDocHeaderBasic SalesOffice Sales Office
SoldToParty R_TrdgDocHeaderBasic SoldToParty Sold-to Party
AdditionalCustomerGroup1 R_TrdgDocHeaderBasic AdditionalCustomerGroup1 Customer Grp 1
AdditionalCustomerGroup2 R_TrdgDocHeaderBasic AdditionalCustomerGroup2 Customer Grp 2
AdditionalCustomerGroup3 R_TrdgDocHeaderBasic AdditionalCustomerGroup3 Customer Grp 3
AdditionalCustomerGroup4 R_TrdgDocHeaderBasic AdditionalCustomerGroup4 Customer Grp 4
AdditionalCustomerGroup5 R_TrdgDocHeaderBasic AdditionalCustomerGroup5 Customer Grp 5
CreditControlArea R_TrdgDocHeaderBasic CreditControlArea Credit Control Area
SDDocumentCategory R_TrdgDocHeaderBasic SDDocumentCategory Document Cat.
SalesDocumentDate R_TrdgDocHeaderBasic SalesDocumentDate Document Date
SalesOrderReason R_TrdgDocHeaderBasic SalesOrderReason Sales Document Reason
SDDocumentCollectiveNumber R_TrdgDocHeaderBasic SDDocumentCollectiveNumber Collective No.
CustomerPurchaseOrderType R_TrdgDocHeaderBasic CustomerPurchaseOrderType Pur. Ord. Type
CustomerPurchaseOrderSuplmnt R_TrdgDocHeaderBasic CustomerPurchaseOrderSuplmnt Supplement
BindingPeriodValidityStartDate R_TrdgDocHeaderBasic BindingPeriodValidityStartDate Valid From
BindingPeriodValidityEndDate R_TrdgDocHeaderBasic BindingPeriodValidityEndDate Binding Period
TrdgDocSlsValidityStartDate R_TrdgDocHeaderBasic TrdgDocSlsValidityStartDate
TrdgDocSlsValidityEndDate R_TrdgDocHeaderBasic TrdgDocSlsValidityEndDate
TrdgDocProdUsgeCat R_TrdgDocHeaderBasic TrdgDocProdUsgeCat
ForeignTrade R_TrdgDocHeaderBasic ForeignTrade Official No.
TrdgDocSlsPersonName R_TrdgDocHeaderBasic TrdgDocSlsPersonName Name
PhoneNumber1 R_TrdgDocHeaderBasic PhoneNumber1 Telephone 1
TrdgDocSlsNrOfFollowUps R_TrdgDocHeaderBasic TrdgDocSlsNrOfFollowUps
DocumentReferenceID R_TrdgDocHeaderBasic DocumentReferenceID Reference
TrdgDocCurrency R_TrdgDocHeaderBasic TrdgDocCurrency TrCont currency
TrdgDocTotalNetAmount R_TrdgDocHeaderBasic TrdgDocTotalNetAmount Net Value
TrdgDocExchangeRate R_TrdgDocHeaderBasic TrdgDocExchangeRate
TrdgDocExchangeRateType R_TrdgDocHeaderBasic TrdgDocExchangeRateType Fix.rate type (EMU)
TrdgDocExchangeRateDate R_TrdgDocHeaderBasic TrdgDocExchangeRateDate Exch. Rate Date
TrdgDocSalesCurrency R_TrdgDocHeaderBasic TrdgDocSalesCurrency Doc. Currency
TrdgDocSalesExchangeRate R_TrdgDocHeaderBasic TrdgDocSalesExchangeRate
TrdgDocSalesExchangeRateType R_TrdgDocHeaderBasic TrdgDocSalesExchangeRateType
TrdgDocSalesPricingDate R_TrdgDocHeaderBasic TrdgDocSalesPricingDate
TrdgDocSalesPricingProcedure R_TrdgDocHeaderBasic TrdgDocSalesPricingProcedure
CustomerTaxClassification1 R_TrdgDocHeaderBasic CustomerTaxClassification1 Alt.Tax Class.
CustomerTaxClassification2 R_TrdgDocHeaderBasic CustomerTaxClassification2 Tax Cls.2 Cust.
CustomerTaxClassification3 R_TrdgDocHeaderBasic CustomerTaxClassification3 Tax Cls.3 Cust.
CustomerTaxClassification4 R_TrdgDocHeaderBasic CustomerTaxClassification4 Tax Cls.4 Cust.
CustomerTaxClassification5 R_TrdgDocHeaderBasic CustomerTaxClassification5 Tax Cls.5 Cust.
CustomerTaxClassification6 R_TrdgDocHeaderBasic CustomerTaxClassification6 Tax Cls.6 Cust.
CustomerTaxClassification7 R_TrdgDocHeaderBasic CustomerTaxClassification7 Tax Cls.7 Cust.
CustomerTaxClassification8 R_TrdgDocHeaderBasic CustomerTaxClassification8 Tax Cls.8 Cust.
CustomerTaxClassification9 R_TrdgDocHeaderBasic CustomerTaxClassification9 Tax Cls.9 Cust.
TaxDepartureCountry R_TrdgDocHeaderBasic TaxDepartureCountry Tx Dep Ctry/Reg
VATRegistrationCountry R_TrdgDocHeaderBasic VATRegistrationCountry CtryRgnSlsTxNo.
ShippingCondition R_TrdgDocHeaderBasic ShippingCondition Shipping Conditions
CompleteDeliveryIsDefined R_TrdgDocHeaderBasic CompleteDeliveryIsDefined Complete Dlv.
DeliveryBlockReason R_TrdgDocHeaderBasic DeliveryBlockReason Delivery Block
CompanyCode R_TrdgDocHeaderBasic CompanyCode Receiver Company Code
HeaderBillingBlockReason R_TrdgDocHeaderBasic HeaderBillingBlockReason Billing Block
ControllingArea R_TrdgDocHeaderBasic ControllingArea Controlling Area
CustomerCreditAccount R_TrdgDocHeaderBasic CustomerCreditAccount Credit Account
CustomerCreditGroup R_TrdgDocHeaderBasic CustomerCreditGroup Planning group
CreditRepresentativeGroup R_TrdgDocHeaderBasic CreditRepresentativeGroup Rep. group
CustomerRiskCategory R_TrdgDocHeaderBasic CustomerRiskCategory Risk Category
ControllingAreaCurrency R_TrdgDocHeaderBasic ControllingAreaCurrency Currency
CreditBlockReleaseDate R_TrdgDocHeaderBasic CreditBlockReleaseDate Release date
NextCreditCheckDate R_TrdgDocHeaderBasic NextCreditCheckDate Next Check
NextShippingDate R_TrdgDocHeaderBasic NextShippingDate Next date
ReleasedCreditAmount R_TrdgDocHeaderBasic ReleasedCreditAmount Credit Value
TrdgDocAddlExpnsBlkRsn R_TrdgDocHeaderBasic TrdgDocAddlExpnsBlkRsn
TrdgDocSuplrBillgBlkRsn R_TrdgDocHeaderBasic TrdgDocSuplrBillgBlkRsn
AccountingExchangeRate R_TrdgDocHeaderBasic AccountingExchangeRate Exch.Rate Acct.
TrdgDocSlsExternalReference R_TrdgDocHeaderBasic TrdgDocSlsExternalReference Your Reference
TrdgDocIsComplete R_TrdgDocHeaderBasic TrdgDocIsComplete
LastCustomerContactDate R_TrdgDocHeaderBasic LastCustomerContactDate Last Contact Dt
TrdgDocQuantityIsComplete R_TrdgDocHeaderBasic TrdgDocQuantityIsComplete Full Quantities
TrdgDocReleaseStatus R_TrdgDocHeaderBasic TrdgDocReleaseStatus Release for Doc
TrdgDocExternalIdentifier R_TrdgDocHeaderBasic TrdgDocExternalIdentifier Ext. Identifier
TrdgDocBusProcessCategory R_TrdgDocHeaderBasic TrdgDocBusProcessCategory
TrdgDocSrceDocType R_TrdgDocHeaderBasic TrdgDocSrceDocType Source Doc
TradingDocumentGoodsReceiver R_TrdgDocHeaderBasic TradingDocumentGoodsReceiver
IsEUTriangularDeal R_TrdgDocHeaderBasic IsEUTriangularDeal Is EU Triangular Deal
TrdgDocHdrIsExtended R_TrdgDocHeaderBasic TrdgDocHdrIsExtended Dummy
TrdgDocSuccessorArchived R_TrdgDocHeaderBasic TrdgDocSuccessorArchived Network Status
TrdgDocHasCnsldtdItem R_TrdgDocHeaderBasic TrdgDocHasCnsldtdItem
TrdgDocVarContrSettlmt R_TrdgDocHeaderBasic TrdgDocVarContrSettlmt Process Variant
TrdgDocIsInApproval R_TrdgDocHeaderBasic TrdgDocIsInApproval Approval Started
TrdgDocBatDetnProcedure R_TrdgDocHeaderBasic TrdgDocBatDetnProcedure Search Proced.
TrdgDocProcgStatus R_TrdgDocHeaderBasic TrdgDocProcgStatus
TrdgDocProcessingLastAction R_TrdgDocHeaderBasic TrdgDocProcessingLastAction Last ActionCode
TrdgDocProcgLastSequence R_TrdgDocHeaderBasic TrdgDocProcgLastSequence Last Seq. No.
TradingProcessVariantType R_TrdgDocHeaderBasic TradingProcessVariantType TEW Type
WBSElementInternalID R_TrdgDocHeaderBasic WBSElementInternalID WBS Internal ID
TrdgDocPricingType R_TrdgDocHeaderBasic TrdgDocPricingType Pricing
TrdgDocPurpose R_TrdgDocHeaderBasic TrdgDocPurpose Purpose Type
TrdgDocLastChangedCategory R_TrdgDocHeaderBasic TrdgDocLastChangedCategory
TrdgDocPOByCustomer R_TrdgDocHeaderBasic TrdgDocPOByCustomer
Supplier BusinessDataBasic Supplier Supplier
TrdgDocPurgShipgInstrn BusinessDataBasic TrdgDocPurgShipgInstrn
SupplierConfirmationControlKey BusinessDataBasic SupplierConfirmationControlKey Conf. Control
TrdgDocMnlPOSplit BusinessDataBasic TrdgDocMnlPOSplit
UnderlyingPurchaseOrderItem BusinessDataBasic UnderlyingPurchaseOrderItem PO Item
TrdgDocPrcDetnExchRate BusinessDataBasic TrdgDocPrcDetnExchRate
TrdgDocIsRlvtPoDProcg BusinessDataBasic TrdgDocIsRlvtPoDProcg
PurchasingOrganization BusinessDataBasic PurchasingOrganization Purchasing Organization
PurchasingGroup BusinessDataBasic PurchasingGroup Purchasing Group
PurchasingDocumentOrderDate BusinessDataBasic PurchasingDocumentOrderDate PO Date
TrdgDocPurgReqdDeliveryDate BusinessDataBasic TrdgDocPurgReqdDeliveryDate
TrdgDocPurgDeliveryDateType BusinessDataBasic TrdgDocPurgDeliveryDateType
TrdgDocSlsReqdDeliveryDate BusinessDataBasic TrdgDocSlsReqdDeliveryDate
TrdgDocSlsDeliveryDateType BusinessDataBasic TrdgDocSlsDeliveryDateType
TrdgDocPurgCurrency BusinessDataBasic TrdgDocPurgCurrency
TrdgDocPurgExchangeRate BusinessDataBasic TrdgDocPurgExchangeRate
TrdgDocPurgExchangeRateType BusinessDataBasic TrdgDocPurgExchangeRateType
TrdgDocPurgPaymentTerms BusinessDataBasic TrdgDocPurgPaymentTerms
TrdgDocSalesPaymentTerms BusinessDataBasic TrdgDocSalesPaymentTerms
TrdgDocSalesFixedValueDate BusinessDataBasic TrdgDocSalesFixedValueDate
TrdgDocPurgFixedValueDate BusinessDataBasic TrdgDocPurgFixedValueDate
TrdgDocPurgPricingDate BusinessDataBasic TrdgDocPurgPricingDate
SupplyingPlant BusinessDataBasic SupplyingPlant Supplying Plant
TrdgDocPurgIncotermsVersion BusinessDataBasic TrdgDocPurgIncotermsVersion
TrdgDocPurgIncotermsLoc1Text BusinessDataBasic TrdgDocPurgIncotermsLoc1Text
TrdgDocPurgIncotermsLoc2Text BusinessDataBasic TrdgDocPurgIncotermsLoc2Text
TrdgDocSalesIncotermsVersion BusinessDataBasic TrdgDocSalesIncotermsVersion
TrdgDocSlsIncotermsLoc1Text BusinessDataBasic TrdgDocSlsIncotermsLoc1Text
TrdgDocSlsIncotermsLoc2Text BusinessDataBasic TrdgDocSlsIncotermsLoc2Text
QuotationSubmissionDate BusinessDataBasic QuotationSubmissionDate Quotation Date
TrdgDocSalesPaymentMethod BusinessDataBasic TrdgDocSalesPaymentMethod
TrdgDocPurgValidityStartDate BusinessDataBasic TrdgDocPurgValidityStartDate
TrdgDocPurgValidityEndDate BusinessDataBasic TrdgDocPurgValidityEndDate
SupplierQuotationExternalID BusinessDataBasic SupplierQuotationExternalID Quotation
SupplierRespSalesPersonName BusinessDataBasic SupplierRespSalesPersonName Salesperson
SupplierPhoneNumber BusinessDataBasic SupplierPhoneNumber Telephone
CorrespncInternalReference BusinessDataBasic CorrespncInternalReference Our Reference
TrdgDocPurgDocExtReference BusinessDataBasic TrdgDocPurgDocExtReference
InternalFinancialDocument BusinessDataBasic InternalFinancialDocument Financ.Doc.No.
DepreciationPercentage BusinessDataBasic DepreciationPercentage Depreciation
FixedExchangeRateIsUsed BusinessDataBasic FixedExchangeRateIsUsed Fixed exch.rate
TrdgDocPurgDocCat BusinessDataBasic TrdgDocPurgDocCat
PurchasingDocumentType BusinessDataBasic PurchasingDocumentType RFQ Type
ShippingType BusinessDataBasic ShippingType Shipping Type
PurchaseOrderByCustomer BusinessDataBasic PurchaseOrderByCustomer Purchase Order Number
CustomerPurchaseOrderDate BusinessDataBasic CustomerPurchaseOrderDate Purchase Order Date
TrdgDocPurgPricingProcedure BusinessDataBasic TrdgDocPurgPricingProcedure
DownPaymentType BusinessDataBasic DownPaymentType Down Payment
DownPaymentPercentageOfTotAmt BusinessDataBasic DownPaymentPercentageOfTotAmt Down Payment %
DownPaymentAmount BusinessDataBasic DownPaymentAmount Downpayment
DownPaymentDueDate BusinessDataBasic DownPaymentDueDate Due Date for DP
TrdgDocPurgDocCndn BusinessDataBasic TrdgDocPurgDocCndn
SlsIncotermsClassification BusinessDataBasic SlsIncotermsClassification
PurgIncotermsClassification BusinessDataBasic PurgIncotermsClassification
TrdgDocPurgDelivAddrCat BusinessDataBasic TrdgDocPurgDelivAddrCat
PaymentGuaranteeProcedure BusinessDataBasic PaymentGuaranteeProcedure Paym.Guar.Proc.
PaymentTermsName BusinessDataBasic PaymentTermsName Description
PurgIncotermsTransferLocation BusinessDataBasic PurgIncotermsTransferLocation
SlsIncotermsTransferLocation BusinessDataBasic SlsIncotermsTransferLocation
PurchaseOrderByShipToParty BusinessDataBasic PurchaseOrderByShipToParty
_SalesPricingElement _SalesPricingElement
_TrdgDocPartner _TrdgDocPartner
_PurchasingPricingElement _PurchasingPricingElement
_TrdgDocItem _TrdgDocItem
_CustomerSalesArea R_TrdgDocHeaderBasic _CustomerSalesArea
_TrdgDocLastChgdCat R_TrdgDocHeaderBasic _TrdgDocLastChgdCat
_TradingDocumentType R_TrdgDocHeaderBasic _TradingDocumentType
_TrdgDocCategory R_TrdgDocHeaderBasic _TrdgDocCategory
_TrdgDocApplStatus R_TrdgDocHeaderBasic _TrdgDocApplStatus
_TrdgDocHasCnsldtdItem R_TrdgDocHeaderBasic _TrdgDocHasCnsldtdItem
_SalesDocumentType R_TrdgDocHeaderBasic _SalesDocumentType
_CreatedByUser R_TrdgDocHeaderBasic _CreatedByUser
_TrdgDocVarContrSettlmt R_TrdgDocHeaderBasic _TrdgDocVarContrSettlmt
_LastChangedByUser R_TrdgDocHeaderBasic _LastChangedByUser
_SalesOrganization R_TrdgDocHeaderBasic _SalesOrganization
_DistributionChannel R_TrdgDocHeaderBasic _DistributionChannel
_OrganizationDivision R_TrdgDocHeaderBasic _OrganizationDivision
_SalesGroup R_TrdgDocHeaderBasic _SalesGroup
_SalesOffice R_TrdgDocHeaderBasic _SalesOffice
_SoldToParty R_TrdgDocHeaderBasic _SoldToParty
_TrdgDocProcgStatus R_TrdgDocHeaderBasic _TrdgDocProcgStatus
_AdditionalCustomerGroup1 R_TrdgDocHeaderBasic _AdditionalCustomerGroup1
_AdditionalCustomerGroup2 R_TrdgDocHeaderBasic _AdditionalCustomerGroup2
_AdditionalCustomerGroup3 R_TrdgDocHeaderBasic _AdditionalCustomerGroup3
_AdditionalCustomerGroup4 R_TrdgDocHeaderBasic _AdditionalCustomerGroup4
_AdditionalCustomerGroup5 R_TrdgDocHeaderBasic _AdditionalCustomerGroup5
_CreditControlArea R_TrdgDocHeaderBasic _CreditControlArea
_SalesOrderReason R_TrdgDocHeaderBasic _SalesOrderReason
_SDDocumentCategory R_TrdgDocHeaderBasic _SDDocumentCategory
_CustomerPurchaseOrderType R_TrdgDocHeaderBasic _CustomerPurchaseOrderType
_TrdgDocCurrency R_TrdgDocHeaderBasic _TrdgDocCurrency
_TrdgDocSalesCurrency R_TrdgDocHeaderBasic _TrdgDocSalesCurrency
_TrdgDocPricingType R_TrdgDocHeaderBasic _TrdgDocPricingType
_ShippingCondition R_TrdgDocHeaderBasic _ShippingCondition
_DeliveryBlockReason R_TrdgDocHeaderBasic _DeliveryBlockReason
_CompanyCode R_TrdgDocHeaderBasic _CompanyCode
_HeaderBillingBlockReason R_TrdgDocHeaderBasic _HeaderBillingBlockReason
_TrdgDocExchangeRateType R_TrdgDocHeaderBasic _TrdgDocExchangeRateType
_TrdgDocIsComplete R_TrdgDocHeaderBasic _TrdgDocIsComplete
_TrdgDocSlsExchangeRateType R_TrdgDocHeaderBasic _TrdgDocSlsExchangeRateType
_TrdgDocSlsPricingProcedure R_TrdgDocHeaderBasic _TrdgDocSlsPricingProcedure
_ControllingArea R_TrdgDocHeaderBasic _ControllingArea
_SalesArea R_TrdgDocHeaderBasic _SalesArea
_CustomerCreditAccount R_TrdgDocHeaderBasic _CustomerCreditAccount
_ControllingAreaCurrency R_TrdgDocHeaderBasic _ControllingAreaCurrency
_TrdgDocReleaseStatus R_TrdgDocHeaderBasic _TrdgDocReleaseStatus
_TrdgDocBusProcCategory R_TrdgDocHeaderBasic _TrdgDocBusProcCategory
_TradingProcessVariantType R_TrdgDocHeaderBasic _TradingProcessVariantType
_TrdgDocSrceDocType R_TrdgDocHeaderBasic _TrdgDocSrceDocType
_TrdgDocPurpose R_TrdgDocHeaderBasic _TrdgDocPurpose
_TrdgDocSuccssrArchived R_TrdgDocHeaderBasic _TrdgDocSuccssrArchived
_WBSElementInternalID R_TrdgDocHeaderBasic _WBSElementInternalID
_SalesOrderType R_TrdgDocHeaderBasic _SalesOrderType
_MatlUsageIndicator R_TrdgDocHeaderBasic _MatlUsageIndicator
_TaxDepartureCountry R_TrdgDocHeaderBasic _TaxDepartureCountry
_VATRegistrationCountry R_TrdgDocHeaderBasic _VATRegistrationCountry
_TrdgDocAddlExpnsBlkRsn R_TrdgDocHeaderBasic _TrdgDocAddlExpnsBlkRsn
_TrdgDocSuplrBillgBlkRsn R_TrdgDocHeaderBasic _TrdgDocSuplrBillgBlkRsn
_Supplier BusinessDataBasic _Supplier
_PurchasingOrganization BusinessDataBasic _PurchasingOrganization
_PurchasingGroup BusinessDataBasic _PurchasingGroup
_Currency BusinessDataBasic _Currency
_PaymentGuaranteeProcedure BusinessDataBasic _PaymentGuaranteeProcedure
_PurgIncotermsClassification BusinessDataBasic _PurgIncotermsClassification
_ShippingType BusinessDataBasic _ShippingType
_SlsIncotermsClassification BusinessDataBasic _SlsIncotermsClassification
_SupplyingPlant BusinessDataBasic _SupplyingPlant
_TrdgDocPurgDelivAddrCat BusinessDataBasic _TrdgDocPurgDelivAddrCat
_TrdgDocPurgDocCat BusinessDataBasic _TrdgDocPurgDocCat
_TrdgDocPurgExchangeRateType BusinessDataBasic _TrdgDocPurgExchangeRateType
_TrdgDocPurgIncotermsVersion BusinessDataBasic _TrdgDocPurgIncotermsVersion
_TrdgDocPurgPaymentTerms BusinessDataBasic _TrdgDocPurgPaymentTerms
_TrdgDocSalesPaymentTerms BusinessDataBasic _TrdgDocSalesPaymentTerms
_TrdgDocSlsIncotermsVersion BusinessDataBasic _TrdgDocSlsIncotermsVersion
_ShippingInstruction BusinessDataBasic _ShippingInstruction

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_TrdgDoc.
-- 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_TrdgDoc AS
SELECT
  TrdgDocHeaderBasic.TradingDocument AS TradingDocument,
  TrdgDocHeaderBasic.TradingDocumentType AS TradingDocumentType,
  TrdgDocHeaderBasic.TrdgDocCategory AS TrdgDocCategory,
  TrdgDocHeaderBasic.TrdgDocApplicationStatus AS TrdgDocApplicationStatus,
  TrdgDocHeaderBasic.SalesDocumentType AS SalesDocumentType,
  TrdgDocHeaderBasic.SalesDocumentCondition AS SalesDocumentCondition,
  TrdgDocHeaderBasic.CreatedByUser AS CreatedByUser,
  TrdgDocHeaderBasic.LastChangedByUser AS LastChangedByUser,
  TrdgDocHeaderBasic.TrdgDocPersonResponsible AS TrdgDocPersonResponsible,
  TrdgDocHeaderBasic.CreationDate AS CreationDate,
  TrdgDocHeaderBasic.CreationTime AS CreationTime,
  TrdgDocHeaderBasic.LastChangeDate AS LastChangeDate,
  TrdgDocHeaderBasic.LastChangeTime AS LastChangeTime,
  TrdgDocHeaderBasic.TrdgDocDate AS TrdgDocDate,
  TrdgDocHeaderBasic.SalesOrganization AS SalesOrganization,
  TrdgDocHeaderBasic.DistributionChannel AS DistributionChannel,
  TrdgDocHeaderBasic.OrganizationDivision AS OrganizationDivision,
  TrdgDocHeaderBasic.SalesGroup AS SalesGroup,
  TrdgDocHeaderBasic.SalesOffice AS SalesOffice,
  TrdgDocHeaderBasic.SoldToParty AS SoldToParty,
  TrdgDocHeaderBasic.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  TrdgDocHeaderBasic.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  TrdgDocHeaderBasic.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  TrdgDocHeaderBasic.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  TrdgDocHeaderBasic.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  TrdgDocHeaderBasic.CreditControlArea AS CreditControlArea,
  TrdgDocHeaderBasic.SDDocumentCategory AS SDDocumentCategory,
  TrdgDocHeaderBasic.SalesDocumentDate AS SalesDocumentDate,
  TrdgDocHeaderBasic.SalesOrderReason AS SalesOrderReason,
  TrdgDocHeaderBasic.SDDocumentCollectiveNumber AS SDDocumentCollectiveNumber,
  TrdgDocHeaderBasic.CustomerPurchaseOrderType AS CustomerPurchaseOrderType,
  TrdgDocHeaderBasic.CustomerPurchaseOrderSuplmnt AS CustomerPurchaseOrderSuplmnt,
  TrdgDocHeaderBasic.BindingPeriodValidityStartDate AS BindingPeriodValidityStartDate,
  TrdgDocHeaderBasic.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  TrdgDocHeaderBasic.TrdgDocSlsValidityStartDate AS TrdgDocSlsValidityStartDate,
  TrdgDocHeaderBasic.TrdgDocSlsValidityEndDate AS TrdgDocSlsValidityEndDate,
  TrdgDocHeaderBasic.TrdgDocProdUsgeCat AS TrdgDocProdUsgeCat,
  TrdgDocHeaderBasic.ForeignTrade AS ForeignTrade,
  TrdgDocHeaderBasic.TrdgDocSlsPersonName AS TrdgDocSlsPersonName,
  TrdgDocHeaderBasic.PhoneNumber1 AS PhoneNumber1,
  TrdgDocHeaderBasic.TrdgDocSlsNrOfFollowUps AS TrdgDocSlsNrOfFollowUps,
  TrdgDocHeaderBasic.DocumentReferenceID AS DocumentReferenceID,
  TrdgDocHeaderBasic.TrdgDocCurrency AS TrdgDocCurrency,
  TrdgDocHeaderBasic.TrdgDocTotalNetAmount AS TrdgDocTotalNetAmount,
  TrdgDocHeaderBasic.TrdgDocExchangeRate AS TrdgDocExchangeRate,
  TrdgDocHeaderBasic.TrdgDocExchangeRateType AS TrdgDocExchangeRateType,
  TrdgDocHeaderBasic.TrdgDocExchangeRateDate AS TrdgDocExchangeRateDate,
  TrdgDocHeaderBasic.TrdgDocSalesCurrency AS TrdgDocSalesCurrency,
  TrdgDocHeaderBasic.TrdgDocSalesExchangeRate AS TrdgDocSalesExchangeRate,
  TrdgDocHeaderBasic.TrdgDocSalesExchangeRateType AS TrdgDocSalesExchangeRateType,
  TrdgDocHeaderBasic.TrdgDocSalesPricingDate AS TrdgDocSalesPricingDate,
  TrdgDocHeaderBasic.TrdgDocSalesPricingProcedure AS TrdgDocSalesPricingProcedure,
  TrdgDocHeaderBasic.CustomerTaxClassification1 AS CustomerTaxClassification1,
  TrdgDocHeaderBasic.CustomerTaxClassification2 AS CustomerTaxClassification2,
  TrdgDocHeaderBasic.CustomerTaxClassification3 AS CustomerTaxClassification3,
  TrdgDocHeaderBasic.CustomerTaxClassification4 AS CustomerTaxClassification4,
  TrdgDocHeaderBasic.CustomerTaxClassification5 AS CustomerTaxClassification5,
  TrdgDocHeaderBasic.CustomerTaxClassification6 AS CustomerTaxClassification6,
  TrdgDocHeaderBasic.CustomerTaxClassification7 AS CustomerTaxClassification7,
  TrdgDocHeaderBasic.CustomerTaxClassification8 AS CustomerTaxClassification8,
  TrdgDocHeaderBasic.CustomerTaxClassification9 AS CustomerTaxClassification9,
  TrdgDocHeaderBasic.TaxDepartureCountry AS TaxDepartureCountry,
  TrdgDocHeaderBasic.VATRegistrationCountry AS VATRegistrationCountry,
  TrdgDocHeaderBasic.ShippingCondition AS ShippingCondition,
  TrdgDocHeaderBasic.CompleteDeliveryIsDefined AS CompleteDeliveryIsDefined,
  TrdgDocHeaderBasic.DeliveryBlockReason AS DeliveryBlockReason,
  TrdgDocHeaderBasic.CompanyCode AS CompanyCode,
  TrdgDocHeaderBasic.HeaderBillingBlockReason AS HeaderBillingBlockReason,
  TrdgDocHeaderBasic.ControllingArea AS ControllingArea,
  TrdgDocHeaderBasic.CustomerCreditAccount AS CustomerCreditAccount,
  TrdgDocHeaderBasic.CustomerCreditGroup AS CustomerCreditGroup,
  TrdgDocHeaderBasic.CreditRepresentativeGroup AS CreditRepresentativeGroup,
  TrdgDocHeaderBasic.CustomerRiskCategory AS CustomerRiskCategory,
  TrdgDocHeaderBasic.ControllingAreaCurrency AS ControllingAreaCurrency,
  TrdgDocHeaderBasic.CreditBlockReleaseDate AS CreditBlockReleaseDate,
  TrdgDocHeaderBasic.NextCreditCheckDate AS NextCreditCheckDate,
  TrdgDocHeaderBasic.NextShippingDate AS NextShippingDate,
  TrdgDocHeaderBasic.ReleasedCreditAmount AS ReleasedCreditAmount,
  TrdgDocHeaderBasic.TrdgDocAddlExpnsBlkRsn AS TrdgDocAddlExpnsBlkRsn,
  TrdgDocHeaderBasic.TrdgDocSuplrBillgBlkRsn AS TrdgDocSuplrBillgBlkRsn,
  TrdgDocHeaderBasic.AccountingExchangeRate AS AccountingExchangeRate,
  TrdgDocHeaderBasic.TrdgDocSlsExternalReference AS TrdgDocSlsExternalReference,
  TrdgDocHeaderBasic.TrdgDocIsComplete AS TrdgDocIsComplete,
  TrdgDocHeaderBasic.LastCustomerContactDate AS LastCustomerContactDate,
  TrdgDocHeaderBasic.TrdgDocQuantityIsComplete AS TrdgDocQuantityIsComplete,
  TrdgDocHeaderBasic.TrdgDocReleaseStatus AS TrdgDocReleaseStatus,
  TrdgDocHeaderBasic.TrdgDocExternalIdentifier AS TrdgDocExternalIdentifier,
  TrdgDocHeaderBasic.TrdgDocBusProcessCategory AS TrdgDocBusProcessCategory,
  TrdgDocHeaderBasic.TrdgDocSrceDocType AS TrdgDocSrceDocType,
  TrdgDocHeaderBasic.TradingDocumentGoodsReceiver AS TradingDocumentGoodsReceiver,
  TrdgDocHeaderBasic.IsEUTriangularDeal AS IsEUTriangularDeal,
  TrdgDocHeaderBasic.TrdgDocHdrIsExtended AS TrdgDocHdrIsExtended,
  TrdgDocHeaderBasic.TrdgDocSuccessorArchived AS TrdgDocSuccessorArchived,
  TrdgDocHeaderBasic.TrdgDocHasCnsldtdItem AS TrdgDocHasCnsldtdItem,
  TrdgDocHeaderBasic.TrdgDocVarContrSettlmt AS TrdgDocVarContrSettlmt,
  TrdgDocHeaderBasic.TrdgDocIsInApproval AS TrdgDocIsInApproval,
  TrdgDocHeaderBasic.TrdgDocBatDetnProcedure AS TrdgDocBatDetnProcedure,
  TrdgDocHeaderBasic.TrdgDocProcgStatus AS TrdgDocProcgStatus,
  TrdgDocHeaderBasic.TrdgDocProcessingLastAction AS TrdgDocProcessingLastAction,
  TrdgDocHeaderBasic.TrdgDocProcgLastSequence AS TrdgDocProcgLastSequence,
  TrdgDocHeaderBasic.TradingProcessVariantType AS TradingProcessVariantType,
  TrdgDocHeaderBasic.WBSElementInternalID AS WBSElementInternalID,
  TrdgDocHeaderBasic.TrdgDocPricingType AS TrdgDocPricingType,
  TrdgDocHeaderBasic.TrdgDocPurpose AS TrdgDocPurpose,
  TrdgDocHeaderBasic.TrdgDocLastChangedCategory AS TrdgDocLastChangedCategory,
  TrdgDocHeaderBasic.TrdgDocPOByCustomer AS TrdgDocPOByCustomer,
  BusinessDataBasic.Supplier AS Supplier,
  BusinessDataBasic.TrdgDocPurgShipgInstrn AS TrdgDocPurgShipgInstrn,
  BusinessDataBasic.SupplierConfirmationControlKey AS SupplierConfirmationControlKey,
  BusinessDataBasic.TrdgDocMnlPOSplit AS TrdgDocMnlPOSplit,
  BusinessDataBasic.UnderlyingPurchaseOrderItem AS UnderlyingPurchaseOrderItem,
  BusinessDataBasic.TrdgDocPrcDetnExchRate AS TrdgDocPrcDetnExchRate,
  BusinessDataBasic.TrdgDocIsRlvtPoDProcg AS TrdgDocIsRlvtPoDProcg,
  BusinessDataBasic.PurchasingOrganization AS PurchasingOrganization,
  BusinessDataBasic.PurchasingGroup AS PurchasingGroup,
  BusinessDataBasic.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  BusinessDataBasic.TrdgDocPurgReqdDeliveryDate AS TrdgDocPurgReqdDeliveryDate,
  BusinessDataBasic.TrdgDocPurgDeliveryDateType AS TrdgDocPurgDeliveryDateType,
  BusinessDataBasic.TrdgDocSlsReqdDeliveryDate AS TrdgDocSlsReqdDeliveryDate,
  BusinessDataBasic.TrdgDocSlsDeliveryDateType AS TrdgDocSlsDeliveryDateType,
  BusinessDataBasic.TrdgDocPurgCurrency AS TrdgDocPurgCurrency,
  BusinessDataBasic.TrdgDocPurgExchangeRate AS TrdgDocPurgExchangeRate,
  BusinessDataBasic.TrdgDocPurgExchangeRateType AS TrdgDocPurgExchangeRateType,
  BusinessDataBasic.TrdgDocPurgPaymentTerms AS TrdgDocPurgPaymentTerms,
  BusinessDataBasic.TrdgDocSalesPaymentTerms AS TrdgDocSalesPaymentTerms,
  BusinessDataBasic.TrdgDocSalesFixedValueDate AS TrdgDocSalesFixedValueDate,
  BusinessDataBasic.TrdgDocPurgFixedValueDate AS TrdgDocPurgFixedValueDate,
  BusinessDataBasic.TrdgDocPurgPricingDate AS TrdgDocPurgPricingDate,
  BusinessDataBasic.SupplyingPlant AS SupplyingPlant,
  BusinessDataBasic.TrdgDocPurgIncotermsVersion AS TrdgDocPurgIncotermsVersion,
  BusinessDataBasic.TrdgDocPurgIncotermsLoc1Text AS TrdgDocPurgIncotermsLoc1Text,
  BusinessDataBasic.TrdgDocPurgIncotermsLoc2Text AS TrdgDocPurgIncotermsLoc2Text,
  BusinessDataBasic.TrdgDocSalesIncotermsVersion AS TrdgDocSalesIncotermsVersion,
  BusinessDataBasic.TrdgDocSlsIncotermsLoc1Text AS TrdgDocSlsIncotermsLoc1Text,
  BusinessDataBasic.TrdgDocSlsIncotermsLoc2Text AS TrdgDocSlsIncotermsLoc2Text,
  BusinessDataBasic.QuotationSubmissionDate AS QuotationSubmissionDate,
  BusinessDataBasic.TrdgDocSalesPaymentMethod AS TrdgDocSalesPaymentMethod,
  BusinessDataBasic.TrdgDocPurgValidityStartDate AS TrdgDocPurgValidityStartDate,
  BusinessDataBasic.TrdgDocPurgValidityEndDate AS TrdgDocPurgValidityEndDate,
  BusinessDataBasic.SupplierQuotationExternalID AS SupplierQuotationExternalID,
  BusinessDataBasic.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  BusinessDataBasic.SupplierPhoneNumber AS SupplierPhoneNumber,
  BusinessDataBasic.CorrespncInternalReference AS CorrespncInternalReference,
  BusinessDataBasic.TrdgDocPurgDocExtReference AS TrdgDocPurgDocExtReference,
  BusinessDataBasic.InternalFinancialDocument AS InternalFinancialDocument,
  BusinessDataBasic.DepreciationPercentage AS DepreciationPercentage,
  BusinessDataBasic.FixedExchangeRateIsUsed AS FixedExchangeRateIsUsed,
  BusinessDataBasic.TrdgDocPurgDocCat AS TrdgDocPurgDocCat,
  BusinessDataBasic.PurchasingDocumentType AS PurchasingDocumentType,
  BusinessDataBasic.ShippingType AS ShippingType,
  BusinessDataBasic.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  BusinessDataBasic.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
  BusinessDataBasic.TrdgDocPurgPricingProcedure AS TrdgDocPurgPricingProcedure,
  BusinessDataBasic.DownPaymentType AS DownPaymentType,
  BusinessDataBasic.DownPaymentPercentageOfTotAmt AS DownPaymentPercentageOfTotAmt,
  BusinessDataBasic.DownPaymentAmount AS DownPaymentAmount,
  BusinessDataBasic.DownPaymentDueDate AS DownPaymentDueDate,
  BusinessDataBasic.TrdgDocPurgDocCndn AS TrdgDocPurgDocCndn,
  BusinessDataBasic.SlsIncotermsClassification AS SlsIncotermsClassification,
  BusinessDataBasic.PurgIncotermsClassification AS PurgIncotermsClassification,
  BusinessDataBasic.TrdgDocPurgDelivAddrCat AS TrdgDocPurgDelivAddrCat,
  BusinessDataBasic.PaymentGuaranteeProcedure AS PaymentGuaranteeProcedure,
  BusinessDataBasic.PaymentTermsName AS PaymentTermsName,
  BusinessDataBasic.PurgIncotermsTransferLocation AS PurgIncotermsTransferLocation,
  BusinessDataBasic.SlsIncotermsTransferLocation AS SlsIncotermsTransferLocation,
  BusinessDataBasic.PurchaseOrderByShipToParty AS PurchaseOrderByShipToParty,
  TrdgDocHeaderBasic._CustomerSalesArea AS _CustomerSalesArea,
  TrdgDocHeaderBasic._TrdgDocLastChgdCat AS _TrdgDocLastChgdCat,
  TrdgDocHeaderBasic._TradingDocumentType AS _TradingDocumentType,
  TrdgDocHeaderBasic._TrdgDocCategory AS _TrdgDocCategory,
  TrdgDocHeaderBasic._TrdgDocApplStatus AS _TrdgDocApplStatus,
  TrdgDocHeaderBasic._TrdgDocHasCnsldtdItem AS _TrdgDocHasCnsldtdItem,
  TrdgDocHeaderBasic._SalesDocumentType AS _SalesDocumentType,
  TrdgDocHeaderBasic._CreatedByUser AS _CreatedByUser,
  TrdgDocHeaderBasic._TrdgDocVarContrSettlmt AS _TrdgDocVarContrSettlmt,
  TrdgDocHeaderBasic._LastChangedByUser AS _LastChangedByUser,
  TrdgDocHeaderBasic._SalesOrganization AS _SalesOrganization,
  TrdgDocHeaderBasic._DistributionChannel AS _DistributionChannel,
  TrdgDocHeaderBasic._OrganizationDivision AS _OrganizationDivision,
  TrdgDocHeaderBasic._SalesGroup AS _SalesGroup,
  TrdgDocHeaderBasic._SalesOffice AS _SalesOffice,
  TrdgDocHeaderBasic._SoldToParty AS _SoldToParty,
  TrdgDocHeaderBasic._TrdgDocProcgStatus AS _TrdgDocProcgStatus,
  TrdgDocHeaderBasic._AdditionalCustomerGroup1 AS _AdditionalCustomerGroup1,
  TrdgDocHeaderBasic._AdditionalCustomerGroup2 AS _AdditionalCustomerGroup2,
  TrdgDocHeaderBasic._AdditionalCustomerGroup3 AS _AdditionalCustomerGroup3,
  TrdgDocHeaderBasic._AdditionalCustomerGroup4 AS _AdditionalCustomerGroup4,
  TrdgDocHeaderBasic._AdditionalCustomerGroup5 AS _AdditionalCustomerGroup5,
  TrdgDocHeaderBasic._CreditControlArea AS _CreditControlArea,
  TrdgDocHeaderBasic._SalesOrderReason AS _SalesOrderReason,
  TrdgDocHeaderBasic._SDDocumentCategory AS _SDDocumentCategory,
  TrdgDocHeaderBasic._CustomerPurchaseOrderType AS _CustomerPurchaseOrderType,
  TrdgDocHeaderBasic._TrdgDocCurrency AS _TrdgDocCurrency,
  TrdgDocHeaderBasic._TrdgDocSalesCurrency AS _TrdgDocSalesCurrency,
  TrdgDocHeaderBasic._TrdgDocPricingType AS _TrdgDocPricingType,
  TrdgDocHeaderBasic._ShippingCondition AS _ShippingCondition,
  TrdgDocHeaderBasic._DeliveryBlockReason AS _DeliveryBlockReason,
  TrdgDocHeaderBasic._CompanyCode AS _CompanyCode,
  TrdgDocHeaderBasic._HeaderBillingBlockReason AS _HeaderBillingBlockReason,
  TrdgDocHeaderBasic._TrdgDocExchangeRateType AS _TrdgDocExchangeRateType,
  TrdgDocHeaderBasic._TrdgDocIsComplete AS _TrdgDocIsComplete,
  TrdgDocHeaderBasic._TrdgDocSlsExchangeRateType AS _TrdgDocSlsExchangeRateType,
  TrdgDocHeaderBasic._TrdgDocSlsPricingProcedure AS _TrdgDocSlsPricingProcedure,
  TrdgDocHeaderBasic._ControllingArea AS _ControllingArea,
  TrdgDocHeaderBasic._SalesArea AS _SalesArea,
  TrdgDocHeaderBasic._CustomerCreditAccount AS _CustomerCreditAccount,
  TrdgDocHeaderBasic._ControllingAreaCurrency AS _ControllingAreaCurrency,
  TrdgDocHeaderBasic._TrdgDocReleaseStatus AS _TrdgDocReleaseStatus,
  TrdgDocHeaderBasic._TrdgDocBusProcCategory AS _TrdgDocBusProcCategory,
  TrdgDocHeaderBasic._TradingProcessVariantType AS _TradingProcessVariantType,
  TrdgDocHeaderBasic._TrdgDocSrceDocType AS _TrdgDocSrceDocType,
  TrdgDocHeaderBasic._TrdgDocPurpose AS _TrdgDocPurpose,
  TrdgDocHeaderBasic._TrdgDocSuccssrArchived AS _TrdgDocSuccssrArchived,
  TrdgDocHeaderBasic._WBSElementInternalID AS _WBSElementInternalID,
  TrdgDocHeaderBasic._SalesOrderType AS _SalesOrderType,
  TrdgDocHeaderBasic._MatlUsageIndicator AS _MatlUsageIndicator,
  TrdgDocHeaderBasic._TaxDepartureCountry AS _TaxDepartureCountry,
  TrdgDocHeaderBasic._VATRegistrationCountry AS _VATRegistrationCountry,
  TrdgDocHeaderBasic._TrdgDocAddlExpnsBlkRsn AS _TrdgDocAddlExpnsBlkRsn,
  TrdgDocHeaderBasic._TrdgDocSuplrBillgBlkRsn AS _TrdgDocSuplrBillgBlkRsn,
  BusinessDataBasic._Supplier AS _Supplier,
  BusinessDataBasic._PurchasingOrganization AS _PurchasingOrganization,
  BusinessDataBasic._PurchasingGroup AS _PurchasingGroup,
  BusinessDataBasic._Currency AS _Currency,
  BusinessDataBasic._PaymentGuaranteeProcedure AS _PaymentGuaranteeProcedure,
  BusinessDataBasic._PurgIncotermsClassification AS _PurgIncotermsClassification,
  BusinessDataBasic._ShippingType AS _ShippingType,
  BusinessDataBasic._SlsIncotermsClassification AS _SlsIncotermsClassification,
  BusinessDataBasic._SupplyingPlant AS _SupplyingPlant,
  BusinessDataBasic._TrdgDocPurgDelivAddrCat AS _TrdgDocPurgDelivAddrCat,
  BusinessDataBasic._TrdgDocPurgDocCat AS _TrdgDocPurgDocCat,
  BusinessDataBasic._TrdgDocPurgExchangeRateType AS _TrdgDocPurgExchangeRateType,
  BusinessDataBasic._TrdgDocPurgIncotermsVersion AS _TrdgDocPurgIncotermsVersion,
  BusinessDataBasic._TrdgDocPurgPaymentTerms AS _TrdgDocPurgPaymentTerms,
  BusinessDataBasic._TrdgDocSalesPaymentTerms AS _TrdgDocSalesPaymentTerms,
  BusinessDataBasic._TrdgDocSlsIncotermsVersion AS _TrdgDocSlsIncotermsVersion,
  BusinessDataBasic._ShippingInstruction AS _ShippingInstruction
FROM R_TrdgDocHeaderBasic AS TrdgDocHeaderBasic
LEFT OUTER JOIN R_TrdgDocPartner AS _TrdgDocPartner ON TradingDocument = _TrdgDocPartner.TradingDocument  -- association [0..*]
LEFT OUTER JOIN R_TrdgDocSlsPrcgElmnt AS _SalesPricingElement ON TradingDocument = _SalesPricingElement.TradingDocument  -- association [0..*]
LEFT OUTER JOIN R_TrdgDocPurgPrcgElmnt AS _PurchasingPricingElement ON TradingDocument = _PurchasingPricingElement.TradingDocument  -- association [0..*]
LEFT OUTER JOIN R_TrdgDocItem AS _TrdgDocItem ON TradingDocument = _TrdgDocItem.TradingDocument  -- association [0..*]
;