_STATUS

_STATUS is an SAP database table in S/4HANA. It contains 49 fields.

Fields (49)

KeyField CDS FieldsUsed in Views
_CalendarDate _CalendarDate 1
AccountingDocumentStatus AccountingDocumentStatus 1
ActivityStatusName ActivityStatusName 2
BillOfExchangeAcceptStatusName BillOfExchangeAcceptStatusName 1
ChangeLogUTCDateTime ChangeLogUTCDateTime 1
CompletionStatus Status 1
ConsolidationTaskStatusText ConsolidationTaskStatusText 2
CreatedByUser CreatedByUser 1
CreatedByUserName CreatedByUserName 1
Criticality Criticality 1
description description 1
DomainText PricingStatusText 2
EWMHandlingUnitIsNotInStock EWMHandlingUnitIsNotInStock 1
EWMHandlingUnitIsNotLoaded EWMHandlingUnitIsNotLoaded 1
EWMHandlingUnitIsNotPlanned EWMHandlingUnitIsNotPlanned 1
EWMHandlingUnitIsNotUnloaded EWMHandlingUnitIsNotUnloaded 1
EWMHUAttrbtChngIsNotBlocked EWMHUAttrbtChngIsNotBlocked 1
EWMHUContentChangeIsNotBlocked EWMHUContentChangeIsNotBlocked 1
EWMHUIsNotBlockedByCustoms EWMHUIsNotBlockedByCustoms 1
EWMHUIsNotPackedForShipping EWMHUIsNotPackedForShipping 1
EWMHUMvmntChangeIsNotBlocked EWMHUMvmntChangeIsNotBlocked 1
EWMHUPostingChangeIsNotBlocked EWMHUPostingChangeIsNotBlocked 1
EWMTranspUnitIsNotAssigned EWMTranspUnitIsNotAssigned 1
FinSGLErrorItemStatusText FinSGLErrorItemStatusText 3
FldLogsNumberOfItemsPicked FldLogsNumberOfItemsPicked 1
FldLogsNumberOfItemsReceived FldLogsNumberOfItemsReceived 1
FldLogsNumberOfItmsToBeRcvd FldLogsNumberOfItmsToBeRcvd 1
FlxMtPlObjVarStatusDescription FlxMtPlObjVarStatusDescription 1
IntcoValChnDocItmStsCritlty IntcoValChnDocItmStsCritlty 2
IntcoValueChainDocStsCritlty IntcoValueChainDocStsCritlty 1
InternalOrderSystemStatus ACMSettlementGroupStatus,ACMSettlementUnitStatus,InternalOrderSystemStatus 3
MaterialStockRptProcedStatus MaterialStockRptProcedStatus 1
OperationActivitySFIGroup OperationActivitySFIGroup 1
OrderStatusInternalID OrderStatusInternalID 1
PackingInstructionNumber PackingInstructionNumber 1
PackingInstructionText PackingInstructionText 1
ParkedByUser ParkedByUser 1
PaymentProcessingStatus PaymentProcessingStatus 1
SCMDeliveryStatus SCMDeliveryStatus 1
SCMDeliveryStatusDurnInHours SCMDeliveryStatusDurnInHours 1
SCMDeliveryStatusStrtDate SCMDeliveryStatusStrtDate 2
StatusCode Status,StatusCode 2
StatusDesc StatusDesc 1
statusName statusName 1
SystemStatusName SystemStatusName 1
TaskProcessingStatus TaskProcessingStatus 1
VarCnfUIExtensionStatusText VarCnfUIExtensionStatusText 1
Workflow Workflow 1
WorkItem WorkItem 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _STATUS (
    _CALENDARDATE,
    ACCOUNTINGDOCUMENTSTATUS,
    ACTIVITYSTATUSNAME,
    BILLOFEXCHANGEACCEPTSTATUSNAME,
    CHANGELOGUTCDATETIME,
    COMPLETIONSTATUS,
    CONSOLIDATIONTASKSTATUSTEXT,
    CREATEDBYUSER,
    CREATEDBYUSERNAME,
    CRITICALITY,
    DESCRIPTION,
    DOMAINTEXT,
    EWMHANDLINGUNITISNOTINSTOCK,
    EWMHANDLINGUNITISNOTLOADED,
    EWMHANDLINGUNITISNOTPLANNED,
    EWMHANDLINGUNITISNOTUNLOADED,
    EWMHUATTRBTCHNGISNOTBLOCKED,
    EWMHUCONTENTCHANGEISNOTBLOCKED,
    EWMHUISNOTBLOCKEDBYCUSTOMS,
    EWMHUISNOTPACKEDFORSHIPPING,
    EWMHUMVMNTCHANGEISNOTBLOCKED,
    EWMHUPOSTINGCHANGEISNOTBLOCKED,
    EWMTRANSPUNITISNOTASSIGNED,
    FINSGLERRORITEMSTATUSTEXT,
    FLDLOGSNUMBEROFITEMSPICKED,
    FLDLOGSNUMBEROFITEMSRECEIVED,
    FLDLOGSNUMBEROFITMSTOBERCVD,
    FLXMTPLOBJVARSTATUSDESCRIPTION,
    INTCOVALCHNDOCITMSTSCRITLTY,
    INTCOVALUECHAINDOCSTSCRITLTY,
    INTERNALORDERSYSTEMSTATUS,
    MATERIALSTOCKRPTPROCEDSTATUS,
    OPERATIONACTIVITYSFIGROUP,
    ORDERSTATUSINTERNALID,
    PACKINGINSTRUCTIONNUMBER,
    PACKINGINSTRUCTIONTEXT,
    PARKEDBYUSER,
    PAYMENTPROCESSINGSTATUS,
    SCMDELIVERYSTATUS,
    SCMDELIVERYSTATUSDURNINHOURS,
    SCMDELIVERYSTATUSSTRTDATE,
    STATUSCODE,
    STATUSDESC,
    STATUSNAME,
    SYSTEMSTATUSNAME,
    TASKPROCESSINGSTATUS,
    VARCNFUIEXTENSIONSTATUSTEXT,
    WORKFLOW,
    WORKITEM
);