R_TRDGDOCHEADERBASIC
Header of Trading Document
R_TRDGDOCHEADERBASIC is a CDS View in S/4HANA. Header of Trading Document. It contains 160 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_TrdgDoc | view_entity | from | COMPOSITE | Trading Document |
| R_TrdgDocItmSlsPrcgElmnt | view_entity | inner | COMPOSITE | Sales Pricing Element of Trading Doc Itm |
| R_TrdgDocSlsPrcgElmnt | view_entity | inner | COMPOSITE | Sales Pricing Element of Trading Doc |
Fields (160)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | TradingDocument | TradingDocument | 2 |
| _AdditionalCustomerGroup1 | _AdditionalCustomerGroup1 | 1 | |
| _AdditionalCustomerGroup2 | _AdditionalCustomerGroup2 | 1 | |
| _AdditionalCustomerGroup3 | _AdditionalCustomerGroup3 | 1 | |
| _AdditionalCustomerGroup4 | _AdditionalCustomerGroup4 | 1 | |
| _AdditionalCustomerGroup5 | _AdditionalCustomerGroup5 | 1 | |
| _CompanyCode | _CompanyCode | 1 | |
| _ControllingArea | _ControllingArea | 1 | |
| _ControllingAreaCurrency | _ControllingAreaCurrency | 1 | |
| _CreatedByUser | _CreatedByUser | 1 | |
| _CreditControlArea | _CreditControlArea | 1 | |
| _CustomerCreditAccount | _CustomerCreditAccount | 1 | |
| _CustomerPurchaseOrderType | _CustomerPurchaseOrderType | 1 | |
| _CustomerSalesArea | _CustomerSalesArea | 1 | |
| _DeliveryBlockReason | _DeliveryBlockReason | 1 | |
| _DistributionChannel | _DistributionChannel | 1 | |
| _HeaderBillingBlockReason | _HeaderBillingBlockReason | 1 | |
| _LastChangedByUser | _LastChangedByUser | 1 | |
| _MatlUsageIndicator | _MatlUsageIndicator | 1 | |
| _OrganizationDivision | _OrganizationDivision | 1 | |
| _SalesArea | _SalesArea | 1 | |
| _SalesDocumentType | _SalesDocumentType | 1 | |
| _SalesGroup | _SalesGroup | 1 | |
| _SalesOffice | _SalesOffice | 1 | |
| _SalesOrderReason | _SalesOrderReason | 1 | |
| _SalesOrderType | _SalesOrderType | 1 | |
| _SalesOrganization | _SalesOrganization | 1 | |
| _SDDocumentCategory | _SDDocumentCategory | 1 | |
| _ShippingCondition | _ShippingCondition | 1 | |
| _SoldToParty | _SoldToParty | 1 | |
| _TaxDepartureCountry | _TaxDepartureCountry | 1 | |
| _TradingDocumentType | _TradingDocumentType | 1 | |
| _TradingProcessVariantType | _TradingProcessVariantType | 1 | |
| _TrdgDocAddlExpnsBlkRsn | _TrdgDocAddlExpnsBlkRsn | 1 | |
| _TrdgDocApplStatus | _TrdgDocApplStatus | 1 | |
| _TrdgDocBusProcCategory | _TrdgDocBusProcCategory | 1 | |
| _TrdgDocCategory | _TrdgDocCategory | 1 | |
| _TrdgDocCurrency | _TrdgDocCurrency | 1 | |
| _TrdgDocExchangeRateType | _TrdgDocExchangeRateType | 1 | |
| _TrdgDocHasCnsldtdItem | _TrdgDocHasCnsldtdItem | 1 | |
| _TrdgDocIsComplete | _TrdgDocIsComplete | 1 | |
| _TrdgDocLastChgdCat | _TrdgDocLastChgdCat | 1 | |
| _TrdgDocPricingType | _TrdgDocPricingType | 1 | |
| _TrdgDocProcgStatus | _TrdgDocProcgStatus | 1 | |
| _TrdgDocPurpose | _TrdgDocPurpose | 1 | |
| _TrdgDocReleaseStatus | _TrdgDocReleaseStatus | 1 | |
| _TrdgDocSalesCurrency | _TrdgDocSalesCurrency | 1 | |
| _TrdgDocSlsExchangeRateType | _TrdgDocSlsExchangeRateType | 1 | |
| _TrdgDocSlsPricingProcedure | _TrdgDocSlsPricingProcedure | 1 | |
| _TrdgDocSrceDocType | _TrdgDocSrceDocType | 1 | |
| _TrdgDocSuccssrArchived | _TrdgDocSuccssrArchived | 1 | |
| _TrdgDocSuplrBillgBlkRsn | _TrdgDocSuplrBillgBlkRsn | 1 | |
| _TrdgDocVarContrSettlmt | _TrdgDocVarContrSettlmt | 1 | |
| _VATRegistrationCountry | _VATRegistrationCountry | 1 | |
| _WBSElementInternalID | _WBSElementInternalID | 1 | |
| AccountingExchangeRate | AccountingExchangeRate | 1 | |
| AdditionalCustomerGroup1 | AdditionalCustomerGroup1 | 1 | |
| AdditionalCustomerGroup2 | AdditionalCustomerGroup2 | 1 | |
| AdditionalCustomerGroup3 | AdditionalCustomerGroup3 | 1 | |
| AdditionalCustomerGroup4 | AdditionalCustomerGroup4 | 1 | |
| AdditionalCustomerGroup5 | AdditionalCustomerGroup5 | 1 | |
| BindingPeriodValidityEndDate | BindingPeriodValidityEndDate | 1 | |
| BindingPeriodValidityStartDate | BindingPeriodValidityStartDate | 1 | |
| CompanyCode | CompanyCode | 1 | |
| CompleteDeliveryIsDefined | CompleteDeliveryIsDefined | 1 | |
| ControllingArea | ControllingArea | 1 | |
| ControllingAreaCurrency | ControllingAreaCurrency | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDate | CreationDate | 1 | |
| CreationTime | CreationTime | 1 | |
| CreditBlockReleaseDate | CreditBlockReleaseDate | 1 | |
| CreditControlArea | CreditControlArea | 1 | |
| CreditRepresentativeGroup | CreditRepresentativeGroup | 1 | |
| CustomerCreditAccount | CustomerCreditAccount | 1 | |
| CustomerCreditGroup | CustomerCreditGroup | 1 | |
| CustomerPurchaseOrderSuplmnt | CustomerPurchaseOrderSuplmnt | 1 | |
| CustomerPurchaseOrderType | CustomerPurchaseOrderType | 1 | |
| CustomerRiskCategory | CustomerRiskCategory | 1 | |
| CustomerTaxClassification1 | CustomerTaxClassification1 | 1 | |
| CustomerTaxClassification2 | CustomerTaxClassification2 | 1 | |
| CustomerTaxClassification3 | CustomerTaxClassification3 | 1 | |
| CustomerTaxClassification4 | CustomerTaxClassification4 | 1 | |
| CustomerTaxClassification5 | CustomerTaxClassification5 | 1 | |
| CustomerTaxClassification6 | CustomerTaxClassification6 | 1 | |
| CustomerTaxClassification7 | CustomerTaxClassification7 | 1 | |
| CustomerTaxClassification8 | CustomerTaxClassification8 | 1 | |
| CustomerTaxClassification9 | CustomerTaxClassification9 | 1 | |
| DeliveryBlockReason | DeliveryBlockReason | 1 | |
| DistributionChannel | DistributionChannel | 2 | |
| DocumentReferenceID | DocumentReferenceID | 1 | |
| ForeignTrade | ForeignTrade | 1 | |
| HeaderBillingBlockReason | HeaderBillingBlockReason | 1 | |
| IsEUTriangularDeal | IsEUTriangularDeal | 1 | |
| LastChangeDate | LastChangeDate | 1 | |
| LastChangedByUser | LastChangedByUser | 1 | |
| LastChangeTime | LastChangeTime | 1 | |
| LastCustomerContactDate | LastCustomerContactDate | 1 | |
| NextCreditCheckDate | NextCreditCheckDate | 1 | |
| NextShippingDate | NextShippingDate | 1 | |
| OrganizationDivision | OrganizationDivision | 2 | |
| PhoneNumber1 | PhoneNumber1 | 1 | |
| ReleasedCreditAmount | ReleasedCreditAmount | 1 | |
| SalesDocumentCondition | SalesDocumentCondition | 1 | |
| SalesDocumentDate | SalesDocumentDate | 1 | |
| SalesDocumentType | SalesDocumentType | 1 | |
| SalesGroup | SalesGroup | 1 | |
| SalesOffice | SalesOffice | 1 | |
| SalesOrderReason | SalesOrderReason | 1 | |
| SalesOrganization | SalesOrganization | 2 | |
| SDDocumentCategory | SDDocumentCategory | 1 | |
| SDDocumentCollectiveNumber | SDDocumentCollectiveNumber | 1 | |
| ShippingCondition | ShippingCondition | 1 | |
| SoldToParty | SoldToParty | 2 | |
| TaxDepartureCountry | TaxDepartureCountry | 1 | |
| TradingDocumentGoodsReceiver | TradingDocumentGoodsReceiver | 1 | |
| TradingDocumentType | TradingDocumentType | 1 | |
| TradingProcessVariantType | TradingProcessVariantType | 1 | |
| TrdgDocAddlExpnsBlkRsn | TrdgDocAddlExpnsBlkRsn | 1 | |
| TrdgDocApplicationStatus | TrdgDocApplicationStatus | 1 | |
| TrdgDocBatDetnProcedure | TrdgDocBatDetnProcedure | 1 | |
| TrdgDocBusProcessCategory | TrdgDocBusProcessCategory | 1 | |
| TrdgDocCategory | TrdgDocCategory | 1 | |
| TrdgDocCurrency | TrdgDocCurrency | 1 | |
| TrdgDocDate | TrdgDocDate | 1 | |
| TrdgDocExchangeRate | TrdgDocExchangeRate | 1 | |
| TrdgDocExchangeRateDate | TrdgDocExchangeRateDate | 1 | |
| TrdgDocExchangeRateType | TrdgDocExchangeRateType | 1 | |
| TrdgDocExternalIdentifier | TrdgDocExternalIdentifier | 1 | |
| TrdgDocHasCnsldtdItem | TrdgDocHasCnsldtdItem | 1 | |
| TrdgDocHdrIsExtended | TrdgDocHdrIsExtended | 1 | |
| TrdgDocIsComplete | TrdgDocIsComplete | 1 | |
| TrdgDocIsInApproval | TrdgDocIsInApproval | 1 | |
| TrdgDocLastChangedCategory | TrdgDocLastChangedCategory | 1 | |
| TrdgDocPersonResponsible | TrdgDocPersonResponsible | 1 | |
| TrdgDocPOByCustomer | TrdgDocPOByCustomer | 1 | |
| TrdgDocPricingType | TrdgDocPricingType | 1 | |
| TrdgDocProcessingLastAction | TrdgDocProcessingLastAction | 1 | |
| TrdgDocProcgLastSequence | TrdgDocProcgLastSequence | 1 | |
| TrdgDocProcgStatus | TrdgDocProcgStatus | 1 | |
| TrdgDocProdUsgeCat | TrdgDocProdUsgeCat | 1 | |
| TrdgDocPurpose | TrdgDocPurpose | 1 | |
| TrdgDocQuantityIsComplete | TrdgDocQuantityIsComplete | 1 | |
| TrdgDocReleaseStatus | TrdgDocReleaseStatus | 1 | |
| TrdgDocSalesCurrency | TrdgDocSalesCurrency | 1 | |
| TrdgDocSalesExchangeRate | TrdgDocSalesExchangeRate | 1 | |
| TrdgDocSalesExchangeRateType | TrdgDocSalesExchangeRateType | 1 | |
| TrdgDocSalesPricingDate | TrdgDocSalesPricingDate | 1 | |
| TrdgDocSalesPricingProcedure | TrdgDocSalesPricingProcedure | 1 | |
| TrdgDocSlsExternalReference | TrdgDocSlsExternalReference | 1 | |
| TrdgDocSlsNrOfFollowUps | TrdgDocSlsNrOfFollowUps | 1 | |
| TrdgDocSlsPersonName | TrdgDocSlsPersonName | 1 | |
| TrdgDocSlsValidityEndDate | TrdgDocSlsValidityEndDate | 1 | |
| TrdgDocSlsValidityStartDate | TrdgDocSlsValidityStartDate | 1 | |
| TrdgDocSrceDocType | TrdgDocSrceDocType | 1 | |
| TrdgDocSuccessorArchived | TrdgDocSuccessorArchived | 1 | |
| TrdgDocSuplrBillgBlkRsn | TrdgDocSuplrBillgBlkRsn | 1 | |
| TrdgDocTotalNetAmount | TrdgDocTotalNetAmount | 1 | |
| TrdgDocVarContrSettlmt | TrdgDocVarContrSettlmt | 1 | |
| VATRegistrationCountry | VATRegistrationCountry | 1 | |
| WBSElementInternalID | WBSElementInternalID | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Header of Trading Document
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_TRDGDOCHEADERBASIC (
TRADINGDOCUMENT,
_ADDITIONALCUSTOMERGROUP1,
_ADDITIONALCUSTOMERGROUP2,
_ADDITIONALCUSTOMERGROUP3,
_ADDITIONALCUSTOMERGROUP4,
_ADDITIONALCUSTOMERGROUP5,
_COMPANYCODE,
_CONTROLLINGAREA,
_CONTROLLINGAREACURRENCY,
_CREATEDBYUSER,
_CREDITCONTROLAREA,
_CUSTOMERCREDITACCOUNT,
_CUSTOMERPURCHASEORDERTYPE,
_CUSTOMERSALESAREA,
_DELIVERYBLOCKREASON,
_DISTRIBUTIONCHANNEL,
_HEADERBILLINGBLOCKREASON,
_LASTCHANGEDBYUSER,
_MATLUSAGEINDICATOR,
_ORGANIZATIONDIVISION,
_SALESAREA,
_SALESDOCUMENTTYPE,
_SALESGROUP,
_SALESOFFICE,
_SALESORDERREASON,
_SALESORDERTYPE,
_SALESORGANIZATION,
_SDDOCUMENTCATEGORY,
_SHIPPINGCONDITION,
_SOLDTOPARTY,
_TAXDEPARTURECOUNTRY,
_TRADINGDOCUMENTTYPE,
_TRADINGPROCESSVARIANTTYPE,
_TRDGDOCADDLEXPNSBLKRSN,
_TRDGDOCAPPLSTATUS,
_TRDGDOCBUSPROCCATEGORY,
_TRDGDOCCATEGORY,
_TRDGDOCCURRENCY,
_TRDGDOCEXCHANGERATETYPE,
_TRDGDOCHASCNSLDTDITEM,
_TRDGDOCISCOMPLETE,
_TRDGDOCLASTCHGDCAT,
_TRDGDOCPRICINGTYPE,
_TRDGDOCPROCGSTATUS,
_TRDGDOCPURPOSE,
_TRDGDOCRELEASESTATUS,
_TRDGDOCSALESCURRENCY,
_TRDGDOCSLSEXCHANGERATETYPE,
_TRDGDOCSLSPRICINGPROCEDURE,
_TRDGDOCSRCEDOCTYPE,
_TRDGDOCSUCCSSRARCHIVED,
_TRDGDOCSUPLRBILLGBLKRSN,
_TRDGDOCVARCONTRSETTLMT,
_VATREGISTRATIONCOUNTRY,
_WBSELEMENTINTERNALID,
ACCOUNTINGEXCHANGERATE,
ADDITIONALCUSTOMERGROUP1,
ADDITIONALCUSTOMERGROUP2,
ADDITIONALCUSTOMERGROUP3,
ADDITIONALCUSTOMERGROUP4,
ADDITIONALCUSTOMERGROUP5,
BINDINGPERIODVALIDITYENDDATE,
BINDINGPERIODVALIDITYSTARTDATE,
COMPANYCODE,
COMPLETEDELIVERYISDEFINED,
CONTROLLINGAREA,
CONTROLLINGAREACURRENCY,
CREATEDBYUSER,
CREATIONDATE,
CREATIONTIME,
CREDITBLOCKRELEASEDATE,
CREDITCONTROLAREA,
CREDITREPRESENTATIVEGROUP,
CUSTOMERCREDITACCOUNT,
CUSTOMERCREDITGROUP,
CUSTOMERPURCHASEORDERSUPLMNT,
CUSTOMERPURCHASEORDERTYPE,
CUSTOMERRISKCATEGORY,
CUSTOMERTAXCLASSIFICATION1,
CUSTOMERTAXCLASSIFICATION2,
CUSTOMERTAXCLASSIFICATION3,
CUSTOMERTAXCLASSIFICATION4,
CUSTOMERTAXCLASSIFICATION5,
CUSTOMERTAXCLASSIFICATION6,
CUSTOMERTAXCLASSIFICATION7,
CUSTOMERTAXCLASSIFICATION8,
CUSTOMERTAXCLASSIFICATION9,
DELIVERYBLOCKREASON,
DISTRIBUTIONCHANNEL,
DOCUMENTREFERENCEID,
FOREIGNTRADE,
HEADERBILLINGBLOCKREASON,
ISEUTRIANGULARDEAL,
LASTCHANGEDATE,
LASTCHANGEDBYUSER,
LASTCHANGETIME,
LASTCUSTOMERCONTACTDATE,
NEXTCREDITCHECKDATE,
NEXTSHIPPINGDATE,
ORGANIZATIONDIVISION,
PHONENUMBER1,
RELEASEDCREDITAMOUNT,
SALESDOCUMENTCONDITION,
SALESDOCUMENTDATE,
SALESDOCUMENTTYPE,
SALESGROUP,
SALESOFFICE,
SALESORDERREASON,
SALESORGANIZATION,
SDDOCUMENTCATEGORY,
SDDOCUMENTCOLLECTIVENUMBER,
SHIPPINGCONDITION,
SOLDTOPARTY,
TAXDEPARTURECOUNTRY,
TRADINGDOCUMENTGOODSRECEIVER,
TRADINGDOCUMENTTYPE,
TRADINGPROCESSVARIANTTYPE,
TRDGDOCADDLEXPNSBLKRSN,
TRDGDOCAPPLICATIONSTATUS,
TRDGDOCBATDETNPROCEDURE,
TRDGDOCBUSPROCESSCATEGORY,
TRDGDOCCATEGORY,
TRDGDOCCURRENCY,
TRDGDOCDATE,
TRDGDOCEXCHANGERATE,
TRDGDOCEXCHANGERATEDATE,
TRDGDOCEXCHANGERATETYPE,
TRDGDOCEXTERNALIDENTIFIER,
TRDGDOCHASCNSLDTDITEM,
TRDGDOCHDRISEXTENDED,
TRDGDOCISCOMPLETE,
TRDGDOCISINAPPROVAL,
TRDGDOCLASTCHANGEDCATEGORY,
TRDGDOCPERSONRESPONSIBLE,
TRDGDOCPOBYCUSTOMER,
TRDGDOCPRICINGTYPE,
TRDGDOCPROCESSINGLASTACTION,
TRDGDOCPROCGLASTSEQUENCE,
TRDGDOCPROCGSTATUS,
TRDGDOCPRODUSGECAT,
TRDGDOCPURPOSE,
TRDGDOCQUANTITYISCOMPLETE,
TRDGDOCRELEASESTATUS,
TRDGDOCSALESCURRENCY,
TRDGDOCSALESEXCHANGERATE,
TRDGDOCSALESEXCHANGERATETYPE,
TRDGDOCSALESPRICINGDATE,
TRDGDOCSALESPRICINGPROCEDURE,
TRDGDOCSLSEXTERNALREFERENCE,
TRDGDOCSLSNROFFOLLOWUPS,
TRDGDOCSLSPERSONNAME,
TRDGDOCSLSVALIDITYENDDATE,
TRDGDOCSLSVALIDITYSTARTDATE,
TRDGDOCSRCEDOCTYPE,
TRDGDOCSUCCESSORARCHIVED,
TRDGDOCSUPLRBILLGBLKRSN,
TRDGDOCTOTALNETAMOUNT,
TRDGDOCVARCONTRSETTLMT,
VATREGISTRATIONCOUNTRY,
WBSELEMENTINTERNALID,
PRIMARY KEY (TRADINGDOCUMENT)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- 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
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA