R_TrdgDoc
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)
| Source | Alias | Join Type |
|---|---|---|
| R_TrdgDocHeaderBasic | TrdgDocHeaderBasic | from |
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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..*]
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA