Fields (181)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | DocNumber | DocNumber | 1 |
| KEY | DocumentItemNumber | DocumentItemNumber | 1 |
| KEY | SalesOrder | SalesOrder | 5 |
| _AdditionalCustomerGroup1 | _AdditionalCustomerGroup1 | 1 | |
| _AdditionalCustomerGroup2 | _AdditionalCustomerGroup2 | 1 | |
| _AdditionalCustomerGroup3 | _AdditionalCustomerGroup3 | 1 | |
| _AdditionalCustomerGroup4 | _AdditionalCustomerGroup4 | 1 | |
| _AdditionalCustomerGroup5 | _AdditionalCustomerGroup5 | 1 | |
| _BillingCompanyCode | _BillingCompanyCode | 1 | |
| _ControllingArea | _ControllingArea | 1 | |
| _CreatedByUser | _CreatedByUser | 1 | |
| _CustomerAccountAssgmtGroup | _CustomerAccountAssgmtGroup | 1 | |
| _CustomerCreditAccount | _CustomerCreditAccount | 1 | |
| _CustomerGroup | _CustomerGroup | 1 | |
| _CustomerPaymentTerms | _CustomerPaymentTerms | 1 | |
| _CustomerPriceGroup | _CustomerPriceGroup | 1 | |
| _CustomerPurchaseOrderType | _CustomerPurchaseOrderType | 1 | |
| _DeliveryBlockReason | _DeliveryBlockReason | 1 | |
| _DeliveryDateTypeRule | _DeliveryDateTypeRule | 1 | |
| _DistributionChannel | _DistributionChannel | 1 | |
| _DownPaymentStatus | _DownPaymentStatus | 1 | |
| _HdrGeneralIncompletionStatus | _HdrGeneralIncompletionStatus | 1 | |
| _HeaderBillingBlockReason | _HeaderBillingBlockReason | 1 | |
| _IncotermsClassification | _IncotermsClassification | 1 | |
| _IncotermsVersion | _IncotermsVersion | 1 | |
| _LastChangedByUser | _LastChangedByUser | 1 | |
| _OrganizationDivision | _OrganizationDivision | 1 | |
| _OverallBillingBlockStatus | _OverallBillingBlockStatus | 1 | |
| _OverallChmlCmplncStatus | _OverallChmlCmplncStatus | 1 | |
| _OverallDangerousGoodsStatus | _OverallDangerousGoodsStatus | 1 | |
| _OverallDeliveryBlockStatus | _OverallDeliveryBlockStatus | 1 | |
| _OverallDeliveryStatus | _OverallDeliveryStatus | 1 | |
| _OverallOrdReltdBillgStatus | _OverallOrdReltdBillgStatus | 1 | |
| _OverallSDDocReferenceStatus | _OverallSDDocReferenceStatus | 1 | |
| _OverallSDDocumentRejectionSts | _OverallSDDocumentRejectionSts | 1 | |
| _OverallSDProcessStatus | _OverallSDProcessStatus | 1 | |
| _OvrlItmGeneralIncompletionSts | _OvrlItmGeneralIncompletionSts | 1 | |
| _OvrlSftyDataSheetSts | _OvrlSftyDataSheetSts | 1 | |
| _OvrlTradeCmplncEmbargoStatus | _OvrlTradeCmplncEmbargoStatus | 1 | |
| _OvrlTrdCmplncLegalCtrlChkSts | _OvrlTrdCmplncLegalCtrlChkSts | 1 | |
| _OvTrdCmplncSnctndListChkSts | _OvTrdCmplncSnctndListChkSts | 1 | |
| _PriceListType | _PriceListType | 1 | |
| _SalesDistrict | _SalesDistrict | 1 | |
| _SalesDocApprovalStatus | _SalesDocApprovalStatus | 1 | |
| _SalesGroup | _SalesGroup | 1 | |
| _SalesOffice | _SalesOffice | 1 | |
| _SalesOrderApprovalReason | _SalesOrderApprovalReason | 1 | |
| _SalesOrderType | _SalesOrderType | 1 | |
| _SDDocumentReason | _SDDocumentReason | 1 | |
| _SDPricingProcedure | _SDPricingProcedure | 1 | |
| _ShippingCondition | _ShippingCondition | 1 | |
| _ShippingType | _ShippingType | 1 | |
| _TaxDepartureCountry | _TaxDepartureCountry | 1 | |
| _TotalBlockStatus | _TotalBlockStatus | 1 | |
| _TotalCreditCheckStatus | _TotalCreditCheckStatus | 1 | |
| _TransactionCurrency | _TransactionCurrency | 1 | |
| _VATRegistrationCountry | _VATRegistrationCountry | 1 | |
| AccountingDocExternalReference | AccountingDocExternalReference | 3 | |
| AdditionalCustomerGroup1 | AdditionalCustomerGroup1 | 3 | |
| AdditionalCustomerGroup2 | AdditionalCustomerGroup2 | 3 | |
| AdditionalCustomerGroup3 | AdditionalCustomerGroup3 | 3 | |
| AdditionalCustomerGroup4 | AdditionalCustomerGroup4 | 3 | |
| AdditionalCustomerGroup5 | AdditionalCustomerGroup5 | 3 | |
| AlternativeExchangeRateType | AlternativeExchangeRateType | 1 | |
| AssignmentReference | AssignmentReference | 3 | |
| BillingCompanyCode | BillingCompanyCode | 3 | |
| BillingDocumentDate | BillingDocumentDate | 3 | |
| BillToParty | BillToParty | 1 | |
| BusinessSolutionOrder | BusinessSolutionOrder | 3 | |
| Commodity | Commodity | 1 | |
| CompanyCode | CompanyCode | 1 | |
| CompleteDeliveryIsDefined | CompleteDeliveryIsDefined | 3 | |
| ContractEndDate | ContractEndDate | 1 | |
| ContractStartDate | ContractStartDate | 1 | |
| ControllingArea | ControllingArea | 3 | |
| Counterparty | Counterparty | 1 | |
| CreatedByUser | CreatedByUser | 4 | |
| CreationDate | CreationDate | 3 | |
| CreationTime | CreationTime | 3 | |
| Customer | Customer | 1 | |
| CustomerAccountAssignmentGroup | CustomerAccountAssignmentGroup | 3 | |
| CustomerCreditAccount | CustomerCreditAccount | 3 | |
| CustomerGroup | CustomerGroup | 3 | |
| CustomerPaymentTerms | CustomerPaymentTerms | 3 | |
| CustomerPriceGroup | CustomerPriceGroup | 3 | |
| CustomerPurchaseOrderDate | CustomerPurchaseOrderDate | 3 | |
| CustomerPurchaseOrderType | CustomerPurchaseOrderType | 3 | |
| DeliveryBlockReason | DeliveryBlockReason | 3 | |
| DeliveryDateTypeRule | DeliveryDateTypeRule | 3 | |
| DistributionChannel | DistributionChannel | 5 | |
| DocumentType | DocumentType | 1 | |
| ExchangeRate | ExchangeRate | 1 | |
| ExchangeRateDate | ExchangeRateDate | 1 | |
| ExchangeRateType | ExchangeRateType | 1 | |
| extended_status | consumption_status | 1 | |
| FixedValueDate | FixedValueDate | 3 | |
| HdrGeneralIncompletionStatus | HdrGeneralIncompletionStatus | 3 | |
| HeaderBillingBlockReason | HeaderBillingBlockReason | 3 | |
| IncotermsClassification | IncotermsClassification | 3 | |
| IncotermsLocation1 | IncotermsLocation1 | 3 | |
| IncotermsLocation2 | IncotermsLocation2 | 3 | |
| IncotermsVersion | IncotermsVersion | 3 | |
| IsEUTriangularDeal | IsEUTriangularDeal | 3 | |
| LastChangeDate | LastChangeDate | 2 | |
| LastChangeDateTime | LastChangeDateTime | 3 | |
| LastChangedByUser | LastChangedByUser | 3 | |
| lifecycle_status | extended_status | 1 | |
| Material | Material | 1 | |
| MeansOfTransportRefMaterial | MeansOfTransportRefMaterial | 1 | |
| MeansOfTransportType | MeansOfTransportType | 1 | |
| OrderCombinationIsAllowed | OrderCombinationIsAllowed | 2 | |
| OrderQuantity | OrderQuantity | 1 | |
| OrderQuantityUnit | OrderQuantityUnit | 1 | |
| OrganizationDivision | OrganizationDivision | 5 | |
| OutputRequestUUID | OutputRequestUUID | 1 | |
| OverallBillingBlockStatus | OverallBillingBlockStatus | 3 | |
| OverallChmlCmplncStatus | OverallChmlCmplncStatus | 3 | |
| OverallDangerousGoodsStatus | OverallDangerousGoodsStatus | 3 | |
| OverallDeliveryBlockStatus | OverallDeliveryBlockStatus | 3 | |
| OverallDeliveryStatus | OverallDeliveryStatus | 3 | |
| OverallOrdReltdBillgStatus | OverallOrdReltdBillgStatus | 3 | |
| OverallSafetyDataSheetStatus | OverallSafetyDataSheetStatus | 3 | |
| OverallSDDocReferenceStatus | OverallSDDocReferenceStatus | 3 | |
| OverallSDDocumentRejectionSts | OverallSDDocumentRejectionSts | 3 | |
| OverallSDProcessStatus | OverallSDProcessStatus | 3 | |
| OverallTrdCmplncEmbargoSts | OverallTrdCmplncEmbargoSts | 3 | |
| OvrlItmGeneralIncompletionSts | OvrlItmGeneralIncompletionSts | 3 | |
| OvrlTrdCmplncLegalCtrlChkSts | OvrlTrdCmplncLegalCtrlChkSts | 3 | |
| OvrlTrdCmplncSnctndListChkSts | OvrlTrdCmplncSnctndListChkSts | 3 | |
| PayerParty | PayerParty | 1 | |
| PaymentMethod | PaymentMethod | 3 | |
| PaymentTerms | PaymentTerms | 1 | |
| PrecedingDocument | SalesOrder | 1 | |
| PrepaymentAgreement | PrepaymentAgreement | 1 | |
| PrepaymentAgrmtRefBusObject | PrepaymentAgrmtRefBusObject | 1 | |
| PrepaymentDocumentItemNumber | PrepaymentDocumentItemNumber | 1 | |
| PrepaymentTotalAmt | PrepaymentTotalAmt | 1 | |
| PrepaymentTotalAmtCrcy | PrepaymentTotalAmtCrcy | 1 | |
| PrepaymentUnassignedAmt | PrepaymentUnassignedAmt | 1 | |
| PrepaymentUnassignedAmtCrcy | PrepaymentUnassignedAmtCrcy | 1 | |
| PriceListType | PriceListType | 3 | |
| PricingDate | PricingDate | 3 | |
| ProposedBillingDocumentType | ProposedBillingDocumentType | 1 | |
| PurchaseOrder | PurchaseOrder | 1 | |
| PurchaseOrderByCustomer | PurchaseOrderByCustomer | 3 | |
| PurchaseOrderByShipToParty | PurchaseOrderByShipToParty | 3 | |
| ReceivingPoint | ReceivingPoint | 3 | |
| ReferenceDistributionChannel | ReferenceDistributionChannel | 3 | |
| ReferenceSDDocument | ReferenceSDDocument | 3 | |
| ReferenceSDDocumentCategory | ReferenceSDDocumentCategory | 2 | |
| RequestedDeliveryDate | RequestedDeliveryDate | 3 | |
| SalesDistrict | SalesDistrict | 3 | |
| SalesDocApprovalStatus | SalesDocApprovalStatus | 3 | |
| SalesDocument | SalesDocument | 1 | |
| SalesDocumentCreationDateTime | SalesDocumentCreationDateTime | 2 | |
| SalesDocumentDate | SalesDocumentDate | 1 | |
| SalesDocumentType | SalesDocumentType | 1 | |
| SalesGroup | SalesGroup | 3 | |
| SalesOffice | SalesOffice | 3 | |
| SalesOrderApprovalReason | SalesOrderApprovalReason | 3 | |
| SalesOrderDate | SalesOrderDate | 4 | |
| SalesOrderDownPaymentStatus | SalesOrderDownPaymentStatus | 3 | |
| SalesOrderProcessingType | SalesOrderProcessingType | 2 | |
| SalesOrderType | SalesOrderType | 3 | |
| SalesOrganization | SalesOrganization,SalesOrganizationForFilter | 5 | |
| SDDocumentCategory | SDDocumentCategory | 1 | |
| SDDocumentReason | SDDocumentReason | 4 | |
| SDPricingProcedure | SDPricingProcedure | 3 | |
| ServicesRenderedDate | ServicesRenderedDate | 3 | |
| ShippingCondition | ShippingCondition | 3 | |
| ShippingType | ShippingType | 3 | |
| ShipToParty | ShipToParty | 1 | |
| SlsDocIsRlvtForProofOfDeliv | SlsDocIsRlvtForProofOfDeliv | 3 | |
| SoldToParty | SoldToParty | 4 | |
| SpecialProcessingCode | SpecialProcessingCode | 1 | |
| TaxDepartureCountry | TaxDepartureCountry | 3 | |
| TotalBlockStatus | TotalBlockStatus | 3 | |
| TotalCreditCheckStatus | TotalCreditCheckStatus | 3 | |
| TotalNetAmount | TotalNetAmount | 6 | |
| TransactionCurrency | TransactionCurrency | 6 | |
| VATRegistrationCountry | VATRegistrationCountry | 3 |
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.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SALESORDER (
DOCNUMBER,
DOCUMENTITEMNUMBER,
SALESORDER,
_ADDITIONALCUSTOMERGROUP1,
_ADDITIONALCUSTOMERGROUP2,
_ADDITIONALCUSTOMERGROUP3,
_ADDITIONALCUSTOMERGROUP4,
_ADDITIONALCUSTOMERGROUP5,
_BILLINGCOMPANYCODE,
_CONTROLLINGAREA,
_CREATEDBYUSER,
_CUSTOMERACCOUNTASSGMTGROUP,
_CUSTOMERCREDITACCOUNT,
_CUSTOMERGROUP,
_CUSTOMERPAYMENTTERMS,
_CUSTOMERPRICEGROUP,
_CUSTOMERPURCHASEORDERTYPE,
_DELIVERYBLOCKREASON,
_DELIVERYDATETYPERULE,
_DISTRIBUTIONCHANNEL,
_DOWNPAYMENTSTATUS,
_HDRGENERALINCOMPLETIONSTATUS,
_HEADERBILLINGBLOCKREASON,
_INCOTERMSCLASSIFICATION,
_INCOTERMSVERSION,
_LASTCHANGEDBYUSER,
_ORGANIZATIONDIVISION,
_OVERALLBILLINGBLOCKSTATUS,
_OVERALLCHMLCMPLNCSTATUS,
_OVERALLDANGEROUSGOODSSTATUS,
_OVERALLDELIVERYBLOCKSTATUS,
_OVERALLDELIVERYSTATUS,
_OVERALLORDRELTDBILLGSTATUS,
_OVERALLSDDOCREFERENCESTATUS,
_OVERALLSDDOCUMENTREJECTIONSTS,
_OVERALLSDPROCESSSTATUS,
_OVRLITMGENERALINCOMPLETIONSTS,
_OVRLSFTYDATASHEETSTS,
_OVRLTRADECMPLNCEMBARGOSTATUS,
_OVRLTRDCMPLNCLEGALCTRLCHKSTS,
_OVTRDCMPLNCSNCTNDLISTCHKSTS,
_PRICELISTTYPE,
_SALESDISTRICT,
_SALESDOCAPPROVALSTATUS,
_SALESGROUP,
_SALESOFFICE,
_SALESORDERAPPROVALREASON,
_SALESORDERTYPE,
_SDDOCUMENTREASON,
_SDPRICINGPROCEDURE,
_SHIPPINGCONDITION,
_SHIPPINGTYPE,
_TAXDEPARTURECOUNTRY,
_TOTALBLOCKSTATUS,
_TOTALCREDITCHECKSTATUS,
_TRANSACTIONCURRENCY,
_VATREGISTRATIONCOUNTRY,
ACCOUNTINGDOCEXTERNALREFERENCE,
ADDITIONALCUSTOMERGROUP1,
ADDITIONALCUSTOMERGROUP2,
ADDITIONALCUSTOMERGROUP3,
ADDITIONALCUSTOMERGROUP4,
ADDITIONALCUSTOMERGROUP5,
ALTERNATIVEEXCHANGERATETYPE,
ASSIGNMENTREFERENCE,
BILLINGCOMPANYCODE,
BILLINGDOCUMENTDATE,
BILLTOPARTY,
BUSINESSSOLUTIONORDER,
COMMODITY,
COMPANYCODE,
COMPLETEDELIVERYISDEFINED,
CONTRACTENDDATE,
CONTRACTSTARTDATE,
CONTROLLINGAREA,
COUNTERPARTY,
CREATEDBYUSER,
CREATIONDATE,
CREATIONTIME,
CUSTOMER,
CUSTOMERACCOUNTASSIGNMENTGROUP,
CUSTOMERCREDITACCOUNT,
CUSTOMERGROUP,
CUSTOMERPAYMENTTERMS,
CUSTOMERPRICEGROUP,
CUSTOMERPURCHASEORDERDATE,
CUSTOMERPURCHASEORDERTYPE,
DELIVERYBLOCKREASON,
DELIVERYDATETYPERULE,
DISTRIBUTIONCHANNEL,
DOCUMENTTYPE,
EXCHANGERATE,
EXCHANGERATEDATE,
EXCHANGERATETYPE,
EXTENDED_STATUS,
FIXEDVALUEDATE,
HDRGENERALINCOMPLETIONSTATUS,
HEADERBILLINGBLOCKREASON,
INCOTERMSCLASSIFICATION,
INCOTERMSLOCATION1,
INCOTERMSLOCATION2,
INCOTERMSVERSION,
ISEUTRIANGULARDEAL,
LASTCHANGEDATE,
LASTCHANGEDATETIME,
LASTCHANGEDBYUSER,
LIFECYCLE_STATUS,
MATERIAL,
MEANSOFTRANSPORTREFMATERIAL,
MEANSOFTRANSPORTTYPE,
ORDERCOMBINATIONISALLOWED,
ORDERQUANTITY,
ORDERQUANTITYUNIT,
ORGANIZATIONDIVISION,
OUTPUTREQUESTUUID,
OVERALLBILLINGBLOCKSTATUS,
OVERALLCHMLCMPLNCSTATUS,
OVERALLDANGEROUSGOODSSTATUS,
OVERALLDELIVERYBLOCKSTATUS,
OVERALLDELIVERYSTATUS,
OVERALLORDRELTDBILLGSTATUS,
OVERALLSAFETYDATASHEETSTATUS,
OVERALLSDDOCREFERENCESTATUS,
OVERALLSDDOCUMENTREJECTIONSTS,
OVERALLSDPROCESSSTATUS,
OVERALLTRDCMPLNCEMBARGOSTS,
OVRLITMGENERALINCOMPLETIONSTS,
OVRLTRDCMPLNCLEGALCTRLCHKSTS,
OVRLTRDCMPLNCSNCTNDLISTCHKSTS,
PAYERPARTY,
PAYMENTMETHOD,
PAYMENTTERMS,
PRECEDINGDOCUMENT,
PREPAYMENTAGREEMENT,
PREPAYMENTAGRMTREFBUSOBJECT,
PREPAYMENTDOCUMENTITEMNUMBER,
PREPAYMENTTOTALAMT,
PREPAYMENTTOTALAMTCRCY,
PREPAYMENTUNASSIGNEDAMT,
PREPAYMENTUNASSIGNEDAMTCRCY,
PRICELISTTYPE,
PRICINGDATE,
PROPOSEDBILLINGDOCUMENTTYPE,
PURCHASEORDER,
PURCHASEORDERBYCUSTOMER,
PURCHASEORDERBYSHIPTOPARTY,
RECEIVINGPOINT,
REFERENCEDISTRIBUTIONCHANNEL,
REFERENCESDDOCUMENT,
REFERENCESDDOCUMENTCATEGORY,
REQUESTEDDELIVERYDATE,
SALESDISTRICT,
SALESDOCAPPROVALSTATUS,
SALESDOCUMENT,
SALESDOCUMENTCREATIONDATETIME,
SALESDOCUMENTDATE,
SALESDOCUMENTTYPE,
SALESGROUP,
SALESOFFICE,
SALESORDERAPPROVALREASON,
SALESORDERDATE,
SALESORDERDOWNPAYMENTSTATUS,
SALESORDERPROCESSINGTYPE,
SALESORDERTYPE,
SALESORGANIZATION,
SDDOCUMENTCATEGORY,
SDDOCUMENTREASON,
SDPRICINGPROCEDURE,
SERVICESRENDEREDDATE,
SHIPPINGCONDITION,
SHIPPINGTYPE,
SHIPTOPARTY,
SLSDOCISRLVTFORPROOFOFDELIV,
SOLDTOPARTY,
SPECIALPROCESSINGCODE,
TAXDEPARTURECOUNTRY,
TOTALBLOCKSTATUS,
TOTALCREDITCHECKSTATUS,
TOTALNETAMOUNT,
TRANSACTIONCURRENCY,
VATREGISTRATIONCOUNTRY,
PRIMARY KEY (DOCNUMBER, DOCUMENTITEMNUMBER, SALESORDER)
);Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- 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