I_SALESDOCUMENT

CDS View
179 Fields 94 CDS Views

Sales Document

I_SALESDOCUMENT is a CDS View in S/4HANA. Sales Document. It contains 179 fields. 94 CDS views read from this table.

CDS Views using this table (94)

ViewTypeJoinVDMDescription
C_CostRevnReassgmtSalesDocVH view from CONSUMPTION Sales Document Value Help
C_Cust360FulfillmentIssueCnt view_entity from CONSUMPTION Customer 360 Count of Fulfillment Issues
C_Customer360_Issues view from CONSUMPTION Customer 360 Issues
C_Customer360ApprovalBusDoc view_entity from CONSUMPTION Customer 360 business doc approvals
C_Customer360FulfillmentIssue view_entity from CONSUMPTION Customer 360 Fullfillment Issues
C_DelivProcFlowSalesDocument view from CONSUMPTION Delivery Process Flow - Node Sales Document
C_DspDocFlwSalesDocAttrib view from CONSUMPTION Sales Documents Attributes for DDF
C_DspDocFlwSalesDocVH view_entity from CONSUMPTION Sales Documents VH for DDF
C_DspDocFlwSDContractAttrib view from CONSUMPTION SD Contract Attributes for DDF
C_DuplicateSalesDocument view from CONSUMPTION Duplicate Sales Documents
C_EBRRSalesOrderMonitorItem view inner CONSUMPTION EBRR Sales Order Monitor Item
C_ESJIQuotationQuery view from CONSUMPTION Quotation
C_EvtBsdRevnRecgnSalesOrdWlItm view left_outer CONSUMPTION Worklist Rev. Rec. Issues - Sales Orders
C_Incompl_SalesDocWL_F2430 view from CONSUMPTION Incomplete Sales Documents
C_MassChangeSalesContract view from CONSUMPTION Mass Change of Sales Contract
C_MassChangeSalesDocument view from CONSUMPTION Mass Change of Sales Document
C_MassChangeSalesOrder view from CONSUMPTION Mass Change of Sales Order
C_MassChangeSalesQuotation view from CONSUMPTION Mass Change of Sales Quotation
C_MassChangeSlsSchedgAgrmt view from CONSUMPTION Mass Change of Sales Scheduling Agreement
C_MassChgCreditMemoReq view from CONSUMPTION Mass Change of Credit Memo Request
C_MassChgCustomerReturn view from CONSUMPTION Mass Change of Customer Returns
C_MassChgDebitMemoReq view from CONSUMPTION Mass Change of Debit Memo Request
C_MassChgSlsOrdWthoutChrg view from CONSUMPTION Mass Change of Sales Order Without Charge
C_Openbillingrequest view inner CONSUMPTION Open Billing Request
C_RetsReferenceDocumentUnion view_entity from CONSUMPTION Returns Reference Document
C_RetsReferenceDocumentUnion view_entity union_all CONSUMPTION Returns Reference Document
C_ReturnRefDocItem_F1708 view inner CONSUMPTION Return Reference Document Item
C_SalesChangeDocItemDEX view inner CONSUMPTION Data Extraction for Change Document Item
C_SalesDocumentByObjectStatus view from CONSUMPTION Sales Documents by Object Status
C_SalesDocumentList view_entity from CONSUMPTION List of sales documents
C_SalesDocumentSchedLineDEX view inner CONSUMPTION Data Extraction for Sales Document Schedule Lines
C_SalesDocumentSchedLineDEX_1 view inner CONSUMPTION Data Extraction for Sales Document Schedule Lines
C_Salesorderomparamdet view from CONSUMPTION Output Parameter Determination for Sales
C_SlsDocFlfllmntAnalyzer view from CONSUMPTION Track Sales Orders
C_SlsDocFlfmtIssue view from CONSUMPTION Sales Order Fulfillment Issues
C_SlsDocFlfmtSlsDoc view from CONSUMPTION Sales Doc Fulfillment: Sales Document
CIC_SalesDocument view_entity from Sales Document (Industry Cloud Solutions)
FAC_AUDIT_Z3_SALESHDRITM view inner Sales Document Header & Items
FAC_AUDIT_Z3_SALESHDRITM view union_all Sales Document Header & Items
finoc_hard_dependency_soi view_entity inner Orgl Change: SOI Hard Dependencies
FINOC_RT_SOI_FILL view inner Orgl Change: Fill Runtime for Sales Doc
FINOC_RT_SOI_OBJ_STATUS view inner Orgl Chg: SDocItms with object status
I_ARProcessFlowDocumentVH view from COMPOSITE Document Number
I_ARProcessFlowDocumentVH view union_all COMPOSITE Document Number
I_BillOfMaterialHeader view left_outer COMPOSITE BOM Header details
I_CentralFinanceSalesDocument view union_all COMPOSITE Central Finance Sales Document: Header
I_CreditMemoRequest view from BASIC Credit Memo Request
I_CustomerReturn view from BASIC Returns Order
I_DebitMemoRequest view from BASIC Debit Memo Request
I_MM_SalesOrderValueHelp view from COMPOSITE Sales Order Value Help
I_MPSDDetails view from COMPOSITE Sales Document Details
I_MRPSalesDemand view inner COMPOSITE MRP Sales Demand
I_Order2CashSalesOrder view from BASIC Sales order
I_SalesContract view from BASIC Sales Contract
I_SalesDocumentBillingPlan view_entity inner COMPOSITE Billing Plan of Sales Document
I_SalesDocumentBillingPlanItem view_entity inner COMPOSITE Billing Plan Item of Sales Document
I_SalesDocumentStdVH view from COMPOSITE Sales Document
I_SalesInquiry view from BASIC Sales Inquiry
I_SalesItemProposal view from BASIC Sales Item Proposal
I_SalesOrder view from BASIC Sales Order
I_SalesOrderBOMHeader view inner BASIC Sales Order Bill Of Material Header
I_SalesOrderCube view from COMPOSITE Sales Order - Cube
I_SalesOrderWithoutCharge view from BASIC Sales Order Without Charge
I_SalesQuotation view from BASIC Sales Quotation
I_SalesSchedgAgrmt view from BASIC Sales Scheduling Agreement
I_SlsOrdFlfmtSalesOrder view from COMPOSITE SOFM Sales Order
P_AllwdOrdTypPerSlsOrg view from CONSUMPTION
P_ARProcessFlowQuotation view from CONSUMPTION AR Process Flow - Quotation
P_ARProcessFlowSalesDoc view from CONSUMPTION Sales Document details for AR process flow
P_DuplicateSalesDocumentGrpg view from CONSUMPTION Grouping Criteria for Duplicate Sales Documents
P_EvtBsdRevnRecSalesOrderIss view inner CONSUMPTION Event based rev. rec. sales order issue
P_LogcDocSales view_entity from CONSUMPTION
P_MassChgSlsDocHdrReadRequest view_entity from CONSUMPTION Mass Chg of Sales Doc Header Read Req
P_PrdtdDelivProcgDlyApplyData view inner CONSUMPTION
P_PrdtdDelivProcgDlyTrngData view inner COMPOSITE
P_PrepaymentRefDocTotalAmount view inner COMPOSITE Prepayment Document Total Amount
P_PrepaymentRefDocTotAmtSales view_entity inner COMPOSITE
P_ProductProposalSlsOrderItem view inner COMPOSITE
P_RFM_SlsOrdIssueCancelDate view from COMPOSITE
P_RFM_SlsOrdIssueHdrSitn view union_all COMPOSITE
P_SalesContractSituation view from COMPOSITE
P_SalesDocEmployeeResponsible view from CONSUMPTION
P_SalesDocumentByObjectStatus view from CONSUMPTION Sales Documents and Items by Object Status
P_SalesOrderFlfmtContact2 view from COMPOSITE
P_SalesOrderInSupplyPurgIssue1 view inner COMPOSITE
P_SalesOrderInSupplyPurgIssue4 view inner COMPOSITE
P_SalesQuotationSituation view from COMPOSITE
P_SlsDocItemPrdtvApplyData view inner CONSUMPTION
P_SlsDocItemPrdtvTrngData view inner COMPOSITE
P_SlsOrdFlfmtProcessFlow1 view from COMPOSITE
P_SlsOrdFlfmtProcessFlow11 view from COMPOSITE
P_SlsOrdProcFlow11 view from CONSUMPTION
P_SOFAProcFlow00 view from COMPOSITE
P_WhereUsdPrftCtrSlsOrderItem view from CONSUMPTION

Fields (179)

KeyField CDS FieldsUsed in Views
KEY PurchasingDocument DocNumber 1
KEY SalesDocument CustomerReturn,DocNumber,Document,SalesDocument,SalesOrder 21
KEY SalesDocumentType DocumentType,SalesDocumentType,SalesOrderType 31
KEY SoldToParty Counterparty,SoldToParty 31
KEY TradingContract DocNumber 1
_AdditionalCustomerGroup1 _AdditionalCustomerGroup1 1
_AdditionalCustomerGroup2 _AdditionalCustomerGroup2 1
_AdditionalCustomerGroup3 _AdditionalCustomerGroup3 1
_AdditionalCustomerGroup4 _AdditionalCustomerGroup4 1
_AdditionalCustomerGroup5 _AdditionalCustomerGroup5 1
_BillingCompanyCode _BillingCompanyCode 2
_BusinessArea _BusinessArea 1
_CentralCreditCheckStatus _CentralCreditCheckStatus 1
_CentralCreditChkTechErrSts _CentralCreditChkTechErrSts 1
_ControllingArea _ControllingArea 1
_ControllingAreaCurrency _ControllingAreaCurrency 1
_CostCenter _CostCenter 1
_CostCenterBusinessArea _CostCenterBusinessArea 1
_CreatedByUser _CreatedByUser 1
_CustomerAccountAssgmtGroup _CustomerAccountAssgmtGroup 1
_CustomerGroup _CustomerGroup 1
_CustomerPaymentTerms _CustomerPaymentTerms 1
_DeliveryBlockReason _DeliveryBlockReason 2
_DistributionChannel _DistributionChannel 2
_ExchangeRateType _ExchangeRateType 1
_ExprtInsurCreditCheckStatus _ExprtInsurCreditCheckStatus 1
_FinDocCreditCheckStatus _FinDocCreditCheckStatus 1
_HdrGeneralIncompletionStatus _HdrGeneralIncompletionStatus 2
_HeaderBillgIncompletionStatus _HeaderBillgIncompletionStatus 2
_HeaderBillingBlockReason _HeaderBillingBlockReason 2
_HeaderDelivIncompletionStatus _HeaderDelivIncompletionStatus 2
_IncotermsClassification _IncotermsClassification 2
_IncotermsVersion _IncotermsVersion 1
_Item _Item 1
_MaxDocValueCreditCheckStatus _MaxDocValueCreditCheckStatus 1
_OrganizationDivision _OrganizationDivision 2
_OverallBillingBlockStatus _OverallBillingBlockStatus 1
_OverallChmlCmplncStatus _OverallChmlCmplncStatus 1
_OverallDangerousGoodsStatus _OverallDangerousGoodsStatus 1
_OverallDelivConfStatus _OverallDelivConfStatus 1
_OverallDeliveryBlockStatus _OverallDeliveryBlockStatus 1
_OverallDeliveryStatus _OverallDeliveryStatus 1
_OverallOrdReltdBillgStatus _OverallOrdReltdBillgStatus 1
_OverallPricingIncompletionSts _OverallPricingIncompletionSts 2
_OverallPurchaseConfStatus _OverallPurchaseConfStatus 2
_OverallSDDocReferenceStatus _OverallSDDocReferenceStatus 1
_OverallSDDocumentRejectionSts _OverallSDDocumentRejectionSts 1
_OverallSDProcessStatus _OverallSDProcessStatus 1
_OverallTotalDeliveryStatus _OverallTotalDeliveryStatus 1
_OverallTotalSDDocRefStatus _OverallTotalSDDocRefStatus 1
_OvrlItmBillingIncompletionSts _OvrlItmBillingIncompletionSts 2
_OvrlItmDelivIncompletionSts _OvrlItmDelivIncompletionSts 2
_OvrlItmGeneralIncompletionSts _OvrlItmGeneralIncompletionSts 2
_OvrlSftyDataSheetSts _OvrlSftyDataSheetSts 1
_OvrlTradeCmplncEmbargoStatus _OvrlTradeCmplncEmbargoStatus 1
_OvrlTrdCmplncLegalCtrlChkSts _OvrlTrdCmplncLegalCtrlChkSts 1
_OvTrdCmplncSnctndListChkSts _OvTrdCmplncSnctndListChkSts 1
_Partner _Partner 1
_PaymentTermCreditCheckStatus _PaymentTermCreditCheckStatus 1
_PaytAuthsnCreditCheckSts _PaytAuthsnCreditCheckSts 2
_ReferenceSDDocumentCategory _ReferenceSDDocumentCategory 1
_SalesArea _SalesArea 1
_SalesDistrict _SalesDistrict 1
_SalesDocApprovalReason _SalesDocApprovalReason 1
_SalesDocApprovalStatus _SalesDocApprovalStatus 2
_SalesDocumentType _SalesDocumentType 4
_SalesGroup _SalesGroup 1
_SalesOffice _SalesOffice 1
_SalesOrganization _SalesOrganization 5
_SDDocumentCategory _SDDocumentCategory 4
_SDDocumentReason _SDDocumentReason 4
_ShippingCondition _ShippingCondition 1
_ShippingType _ShippingType 1
_SoldToParty _SoldToParty 7
_StatisticsCurrency _StatisticsCurrency 1
_TotalBlockStatus _TotalBlockStatus 1
_TotalCreditCheckStatus _TotalCreditCheckStatus 1
_TransactionCurrency _TransactionCurrency 4
AccountingDocExternalReference AccountingDocExternalReference 1
AdditionalCustomerGroup1 AdditionalCustomerGroup1 7
AdditionalCustomerGroup2 AdditionalCustomerGroup2 7
AdditionalCustomerGroup3 AdditionalCustomerGroup3 7
AdditionalCustomerGroup4 AdditionalCustomerGroup4 7
AdditionalCustomerGroup5 AdditionalCustomerGroup5 7
AgrmtValdtyEndDate ValidityEndDate 1
AgrmtValdtyStartDate ValidityStartDate 1
AlternativePricingDate AlternativePricingDate 1
BillingCompanyCode BillingCompanyCode,bukrs,CompanyCode 11
BillingDocumentDate BillingDocumentDate 5
BindingPeriodValidityEndDate BindingPeriodValidityEndDate,ValidityEndDate 3
BindingPeriodValidityStartDate BindingPeriodValidityStartDate,ValidityStartDate 3
BusinessArea BusinessArea 1
BusinessSolutionOrder BusinessSolutionOrder 4
CompanyCode CompanyCode 1
CompleteDeliveryIsDefined CompleteDeliveryIsDefined 7
ControllingArea ControllingArea 5
ControllingAreaCurrency ControllingAreaCurrency 1
ControllingObject ControllingObject 1
CostCenter CostCenter 5
CreatedByUser CreatedByUser 11
CreationDate CreationDate 16
CreationTime CreationTime 6
CreditBlockReleaseDate CreditBlockReleaseDate 1
CreditControlArea CreditControlArea 5
CustomerAccountAssignmentGroup CustomerAccountAssignmentGroup 3
CustomerCreditAccount CustomerCreditAccount 1
CustomerGroup CustomerGroup 5
CustomerPaymentTerms CustomerPaymentTerms 4
CustomerPurchaseOrderDate CustomerPurchaseOrderDate 5
CustomerPurchaseOrderSuplmnt CustomerPurchaseOrderSuplmnt 4
CustomerPurchaseOrderType CustomerPurchaseOrderType 4
DeliveryBlockReason DeliveryBlockReason 7
DistributionChannel DistributionChannel 30
DocumentCurrency PrepaymentTotalAmtCrcy 1
ExchangeRateDate ExchangeRateDate 2
ExchangeRateType ExchangeRateType 3
ExprtInsurCreditCheckStatus ExprtInsurCreditCheckStatus 2
ExternalDocLastChangeDateTime ExternalDocLastChangeDateTime 1
ExternalDocumentID ExternalDocumentID 1
FinDocCreditCheckStatus FinDocCreditCheckStatus 2
FiscalPeriod FiscalPeriod 2
FiscalYear FiscalYear 2
FixedValueDate FixedValueDate 1
HdrGeneralIncompletionStatus HdrGeneralIncompletionStatus 1
HeaderBillgIncompletionStatus HeaderBillgIncompletionStatus 1
HeaderBillingBlockReason HeaderBillingBlockReason 5
HeaderDelivIncompletionStatus HeaderDelivIncompletionStatus 1
IncotermsClassification IncotermsClassification 5
IncotermsLocation1 IncotermsLocation1 3
IncotermsLocation2 IncotermsLocation2 3
IncotermsTransferLocation IncotermsTransferLocation 4
IncotermsVersion IncotermsVersion 5
LastChangeDate LastChangeDate 7
LastChangeDateTime LastChangeDateTime 5
LastChangedByUser LastChangedByUser 4
MaxDocValueCreditCheckStatus MaxDocValueCreditCheckStatus 1
NextCreditCheckDate NextCreditCheckDate 1
OrderID OrderID 2
OrganizationDivision OrganizationDivision 21
OverallDeliveryStatus OverallDeliveryStatus 1
OverallOrdReltdBillgStatus OverallOrdReltdBillgStatus 2
OverallPricingIncompletionSts OverallPricingIncompletionSts 1
OverallSDDocumentRejectionSts OverallSDDocumentRejectionSts 2
OverallSDProcessStatus OverallSDProcessStatus 8
OverallTotalDeliveryStatus OverallTotalDeliveryStatus 4
OvrlItmBillingIncompletionSts OvrlItmBillingIncompletionSts 1
OvrlItmDelivIncompletionSts OvrlItmDelivIncompletionSts 1
OvrlItmGeneralIncompletionSts OvrlItmGeneralIncompletionSts 1
PaymentMethod PaymentMethod 4
PaymentPlan PaymentPlan 2
PaytAuthsnCreditCheckSts PaytAuthsnCreditCheckSts 3
PriceDetnExchangeRate ExchangeRate,PriceDetnExchangeRate 3
PricingDate PricingDate 6
PurchaseOrderByCustomer PurchaseOrderByCustomer 12
PurchasingDocumentType DocumentType 1
ReferenceSDDocument ReferenceSDDocument,SalesDocument 2
ReferenceSDDocumentCategory ReferenceSDDocumentCategory 1
ReleasedCreditAmount ReleasedCreditAmount 1
RequestedDeliveryDate RequestedDeliveryDate 15
SalesDistrict SalesDistrict 5
SalesDocApprovalReason SalesDocApprovalReason 1
SalesDocApprovalStatus SalesDocApprovalStatus 3
SalesDocumentDate DocumentDate,SalesDocumentDate,SalesOrderDate 14
SalesDocumentProcessingType SalesDocumentProcessingType 8
SalesGroup SalesGroup 18
SalesOffice SalesOffice 18
SalesOrganization SalesOrganization 29
SDDocumentCategory SalesOrderCategory,SDDocumentCategory 20
SDDocumentCollectiveNumber SDDocumentCollectiveNumber 3
SDDocumentReason SDDocumentReason 9
ServicesRenderedDate ServicesRenderedDate 3
ShippingCondition ShippingCondition 7
ShippingType ShippingType 3
StatisticsCurrency StatisticsCurrency 3
TotalBlockStatus TotalBlockStatus 1
TotalCreditCheckStatus TotalCreditCheckStatus 1
TotalNetAmount TotalNetAmount 14
TradingContractType DocumentType 1
TransactionCurrency PrepaymentTotalAmtCrcy,TransactionCurrency 16

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.

-- Sales Document
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SALESDOCUMENT (
    PURCHASINGDOCUMENT,
    SALESDOCUMENT,
    SALESDOCUMENTTYPE,
    SOLDTOPARTY,
    TRADINGCONTRACT,
    _ADDITIONALCUSTOMERGROUP1,
    _ADDITIONALCUSTOMERGROUP2,
    _ADDITIONALCUSTOMERGROUP3,
    _ADDITIONALCUSTOMERGROUP4,
    _ADDITIONALCUSTOMERGROUP5,
    _BILLINGCOMPANYCODE,
    _BUSINESSAREA,
    _CENTRALCREDITCHECKSTATUS,
    _CENTRALCREDITCHKTECHERRSTS,
    _CONTROLLINGAREA,
    _CONTROLLINGAREACURRENCY,
    _COSTCENTER,
    _COSTCENTERBUSINESSAREA,
    _CREATEDBYUSER,
    _CUSTOMERACCOUNTASSGMTGROUP,
    _CUSTOMERGROUP,
    _CUSTOMERPAYMENTTERMS,
    _DELIVERYBLOCKREASON,
    _DISTRIBUTIONCHANNEL,
    _EXCHANGERATETYPE,
    _EXPRTINSURCREDITCHECKSTATUS,
    _FINDOCCREDITCHECKSTATUS,
    _HDRGENERALINCOMPLETIONSTATUS,
    _HEADERBILLGINCOMPLETIONSTATUS,
    _HEADERBILLINGBLOCKREASON,
    _HEADERDELIVINCOMPLETIONSTATUS,
    _INCOTERMSCLASSIFICATION,
    _INCOTERMSVERSION,
    _ITEM,
    _MAXDOCVALUECREDITCHECKSTATUS,
    _ORGANIZATIONDIVISION,
    _OVERALLBILLINGBLOCKSTATUS,
    _OVERALLCHMLCMPLNCSTATUS,
    _OVERALLDANGEROUSGOODSSTATUS,
    _OVERALLDELIVCONFSTATUS,
    _OVERALLDELIVERYBLOCKSTATUS,
    _OVERALLDELIVERYSTATUS,
    _OVERALLORDRELTDBILLGSTATUS,
    _OVERALLPRICINGINCOMPLETIONSTS,
    _OVERALLPURCHASECONFSTATUS,
    _OVERALLSDDOCREFERENCESTATUS,
    _OVERALLSDDOCUMENTREJECTIONSTS,
    _OVERALLSDPROCESSSTATUS,
    _OVERALLTOTALDELIVERYSTATUS,
    _OVERALLTOTALSDDOCREFSTATUS,
    _OVRLITMBILLINGINCOMPLETIONSTS,
    _OVRLITMDELIVINCOMPLETIONSTS,
    _OVRLITMGENERALINCOMPLETIONSTS,
    _OVRLSFTYDATASHEETSTS,
    _OVRLTRADECMPLNCEMBARGOSTATUS,
    _OVRLTRDCMPLNCLEGALCTRLCHKSTS,
    _OVTRDCMPLNCSNCTNDLISTCHKSTS,
    _PARTNER,
    _PAYMENTTERMCREDITCHECKSTATUS,
    _PAYTAUTHSNCREDITCHECKSTS,
    _REFERENCESDDOCUMENTCATEGORY,
    _SALESAREA,
    _SALESDISTRICT,
    _SALESDOCAPPROVALREASON,
    _SALESDOCAPPROVALSTATUS,
    _SALESDOCUMENTTYPE,
    _SALESGROUP,
    _SALESOFFICE,
    _SALESORGANIZATION,
    _SDDOCUMENTCATEGORY,
    _SDDOCUMENTREASON,
    _SHIPPINGCONDITION,
    _SHIPPINGTYPE,
    _SOLDTOPARTY,
    _STATISTICSCURRENCY,
    _TOTALBLOCKSTATUS,
    _TOTALCREDITCHECKSTATUS,
    _TRANSACTIONCURRENCY,
    ACCOUNTINGDOCEXTERNALREFERENCE,
    ADDITIONALCUSTOMERGROUP1,
    ADDITIONALCUSTOMERGROUP2,
    ADDITIONALCUSTOMERGROUP3,
    ADDITIONALCUSTOMERGROUP4,
    ADDITIONALCUSTOMERGROUP5,
    AGRMTVALDTYENDDATE,
    AGRMTVALDTYSTARTDATE,
    ALTERNATIVEPRICINGDATE,
    BILLINGCOMPANYCODE,
    BILLINGDOCUMENTDATE,
    BINDINGPERIODVALIDITYENDDATE,
    BINDINGPERIODVALIDITYSTARTDATE,
    BUSINESSAREA,
    BUSINESSSOLUTIONORDER,
    COMPANYCODE,
    COMPLETEDELIVERYISDEFINED,
    CONTROLLINGAREA,
    CONTROLLINGAREACURRENCY,
    CONTROLLINGOBJECT,
    COSTCENTER,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    CREDITBLOCKRELEASEDATE,
    CREDITCONTROLAREA,
    CUSTOMERACCOUNTASSIGNMENTGROUP,
    CUSTOMERCREDITACCOUNT,
    CUSTOMERGROUP,
    CUSTOMERPAYMENTTERMS,
    CUSTOMERPURCHASEORDERDATE,
    CUSTOMERPURCHASEORDERSUPLMNT,
    CUSTOMERPURCHASEORDERTYPE,
    DELIVERYBLOCKREASON,
    DISTRIBUTIONCHANNEL,
    DOCUMENTCURRENCY,
    EXCHANGERATEDATE,
    EXCHANGERATETYPE,
    EXPRTINSURCREDITCHECKSTATUS,
    EXTERNALDOCLASTCHANGEDATETIME,
    EXTERNALDOCUMENTID,
    FINDOCCREDITCHECKSTATUS,
    FISCALPERIOD,
    FISCALYEAR,
    FIXEDVALUEDATE,
    HDRGENERALINCOMPLETIONSTATUS,
    HEADERBILLGINCOMPLETIONSTATUS,
    HEADERBILLINGBLOCKREASON,
    HEADERDELIVINCOMPLETIONSTATUS,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    MAXDOCVALUECREDITCHECKSTATUS,
    NEXTCREDITCHECKDATE,
    ORDERID,
    ORGANIZATIONDIVISION,
    OVERALLDELIVERYSTATUS,
    OVERALLORDRELTDBILLGSTATUS,
    OVERALLPRICINGINCOMPLETIONSTS,
    OVERALLSDDOCUMENTREJECTIONSTS,
    OVERALLSDPROCESSSTATUS,
    OVERALLTOTALDELIVERYSTATUS,
    OVRLITMBILLINGINCOMPLETIONSTS,
    OVRLITMDELIVINCOMPLETIONSTS,
    OVRLITMGENERALINCOMPLETIONSTS,
    PAYMENTMETHOD,
    PAYMENTPLAN,
    PAYTAUTHSNCREDITCHECKSTS,
    PRICEDETNEXCHANGERATE,
    PRICINGDATE,
    PURCHASEORDERBYCUSTOMER,
    PURCHASINGDOCUMENTTYPE,
    REFERENCESDDOCUMENT,
    REFERENCESDDOCUMENTCATEGORY,
    RELEASEDCREDITAMOUNT,
    REQUESTEDDELIVERYDATE,
    SALESDISTRICT,
    SALESDOCAPPROVALREASON,
    SALESDOCAPPROVALSTATUS,
    SALESDOCUMENTDATE,
    SALESDOCUMENTPROCESSINGTYPE,
    SALESGROUP,
    SALESOFFICE,
    SALESORGANIZATION,
    SDDOCUMENTCATEGORY,
    SDDOCUMENTCOLLECTIVENUMBER,
    SDDOCUMENTREASON,
    SERVICESRENDEREDDATE,
    SHIPPINGCONDITION,
    SHIPPINGTYPE,
    STATISTICSCURRENCY,
    TOTALBLOCKSTATUS,
    TOTALCREDITCHECKSTATUS,
    TOTALNETAMOUNT,
    TRADINGCONTRACTTYPE,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (PURCHASINGDOCUMENT, SALESDOCUMENT, SALESDOCUMENTTYPE, SOLDTOPARTY, TRADINGCONTRACT)
);

Learn More