_SALESORDER
_SALESORDER is an SAP database table in S/4HANA. It contains 90 fields.
Fields (90)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | SalesOrder | SalesOrder | 4 |
| _BillingStatus | _BillingStatus | 1 | |
| _BusinessArea | _BusinessArea | 2 | |
| _CustomerGroup | _CustomerGroup | 1 | |
| _DeliveryStatus | _DeliveryStatus | 1 | |
| _DistributionChannel | _DistributionChannel | 6 | |
| _LifeCycleStatus | _LifeCycleStatus | 1 | |
| _OrganizationDivision | _Division,_OrganizationDivision | 4 | |
| _OverallDeliveryStatus | _OverallDeliveryStatus | 2 | |
| _OverallSDProcessStatus | _OverallSDProcessStatus | 2 | |
| _OverallStatus | _OverallStatus | 1 | |
| _SalesGroup | _SalesGroup | 4 | |
| _SalesOffice | _SalesOffice | 4 | |
| _SalesOrderType | _SalesDocumentType,_SalesOrderType | 5 | |
| _SalesOrganization | _SalesOrganization | 6 | |
| _SoldToParty | _Customer,_SoldToParty | 6 | |
| _TransactionCurrency | _TransactionCurrency | 2 | |
| AdditionalCustomerGroup1 | AdditionalCustomerGroup1 | 1 | |
| AdditionalCustomerGroup2 | AdditionalCustomerGroup2 | 1 | |
| AdditionalCustomerGroup3 | AdditionalCustomerGroup3 | 1 | |
| AdditionalCustomerGroup4 | AdditionalCustomerGroup4 | 1 | |
| AdditionalCustomerGroup5 | AdditionalCustomerGroup5 | 1 | |
| BillingCompanyCode | BillingCompanyCode | 3 | |
| BusinessArea | BusinessArea | 7 | |
| buyer_id | BuyerID,BuyerIdentifier | 3 | |
| ContractDownPaymentStatus | ContractDownPaymentStatus | 1 | |
| CostCenter | CostCenter | 2 | |
| CreatedByUser | CreatedByUser | 3 | |
| CreationDate | CreationDate | 10 | |
| CreationDateTime | CreationDateTime | 1 | |
| CreationTime | CreationTime | 9 | |
| CreditControlArea | CreditControlArea | 2 | |
| CustomerGroup | CustomerGroup | 3 | |
| CustomerPaymentTerms | CustomerPaymentTerms | 1 | |
| CustomerPurchaseOrderDate | CustomerPurchaseOrderDate | 2 | |
| DeliveryBlockReason | DeliveryBlockReason | 2 | |
| DistributionChannel | DistributionChannel | 45 | |
| HdrGeneralIncompletionStatus | HdrGeneralIncompletionStatus | 1 | |
| HeaderBillgIncompletionStatus | HeaderBillgIncompletionStatus | 1 | |
| HeaderBillingBlockReason | HeaderBillingBlockReason | 1 | |
| HeaderDelivIncompletionStatus | HeaderDelivIncompletionStatus | 1 | |
| id | SalesOrderId | 1 | |
| IncotermsClassification | HeaderIncotermsClassification | 1 | |
| LastChangeDate | LastChangeDate | 2 | |
| LastChangedDateTime | LastChangeDateTime | 1 | |
| lifecycle_status | lifecycle_status | 1 | |
| MasterSalesContract | MasterSalesContract | 1 | |
| OrderID | OrderID | 1 | |
| OrganizationDivision | OrganizationDivision | 41 | |
| OverallBillingBlockStatus | OverallBillingBlockStatus | 1 | |
| OverallChmlCmplncStatus | OverallChmlCmplncStatus | 1 | |
| OverallDangerousGoodsStatus | OverallDangerousGoodsStatus | 1 | |
| OverallDelivConfStatus | OverallDelivConfStatus | 1 | |
| OverallDeliveryBlockStatus | OverallDeliveryBlockStatus | 1 | |
| OverallDeliveryStatus | OverallDeliveryStatus | 3 | |
| OverallOrdReltdBillgStatus | OverallOrdReltdBillgStatus | 1 | |
| OverallPricingIncompletionSts | OverallPricingIncompletionSts | 1 | |
| OverallSafetyDataSheetStatus | OverallSafetyDataSheetStatus | 1 | |
| OverallSDDocumentRejectionSts | OverallSDDocumentRejectionSts | 1 | |
| OverallSDProcessStatus | OverallSDProcessStatus | 4 | |
| OverallTotalDeliveryStatus | OverallTotalDeliveryStatus | 2 | |
| OverallTrdCmplncEmbargoSts | OverallTrdCmplncEmbargoSts | 1 | |
| OvrlTrdCmplncLegalCtrlChkSts | OvrlTrdCmplncLegalCtrlChkSts | 1 | |
| OvrlTrdCmplncSnctndListChkSts | OvrlTrdCmplncSnctndListChkSts | 1 | |
| PaymentMethod | PaymentMethod | 1 | |
| PricingDate | PricingDate | 7 | |
| PurchaseOrderByCustomer | PurchaseOrderByCustomer | 1 | |
| SalesDocApprovalReason | SalesOrderApprovalReason | 1 | |
| SalesDocApprovalStatus | SalesDocApprovalStatus | 2 | |
| SalesDocumentType | SalesOrderType | 1 | |
| SalesGroup | SalesGroup | 13 | |
| SalesOffice | SalesOffice | 12 | |
| SalesOrderBillingStatus | SalesOrderBillingStatus | 1 | |
| SalesOrderCondition | SalesOrderCondition | 1 | |
| SalesOrderDate | SalesOrderDate | 3 | |
| SalesOrderDeliveryStatus | SalesOrderDeliveryStatus | 1 | |
| SalesOrderID | SalesOrderID | 5 | |
| SalesOrderLifeCycleStatus | SalesOrderLifeCycleStatus | 1 | |
| SalesOrderType | SalesOrderType | 42 | |
| SalesOrderUUID | SalesOrderUUID | 1 | |
| SalesOrganization | SalesOrganization | 47 | |
| SDDocumentReason | SDDocumentReason | 1 | |
| seller_id | SellerIdentifier | 1 | |
| ShippingCondition | ShippingCondition | 1 | |
| ShippingType | SlsOrdShippingType | 2 | |
| SoldToParty | Customer,SoldToParty | 21 | |
| TotalBlockStatus | TotalBlockStatus | 2 | |
| TotalCreditCheckStatus | TotalCreditCheckStatus | 1 | |
| TotalNetAmount | TotalNetAmount | 9 | |
| TransactionCurrency | SalesOrderTransactionCurrency,TransactionCurrency | 9 |