Fields (167)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | srvb_name | srvb_name | 2 |
| KEY | srvc_name | srvc_name | 1 |
| KEY | version | version | 3 |
| KEY | WorkflowId | WorkflowId | 113 |
| __KEY1 | S____KEY1 | 79 | |
| __KEY2 | S____KEY2 | 14 | |
| __KEY3 | S____KEY3 | 6 | |
| __KEY4 | S____KEY4 | 1 | |
| _WF_INITIATOR | S___WF_INITIATOR | 113 | |
| _WF_PRIORITY | S___WF_PRIORITY | 113 | |
| _WF_VERSION | S___WF_VERSION | 113 | |
| abap_language_version | abap_language_version | 1 | |
| ACCOUNT_ACTION | ACCOUNT_ACTION | 1 | |
| ACCOUNTINGDOCUMENTTYPE | ACCOUNTINGDOCUMENTTYPE | 2 | |
| AGENT | AGENT | 5 | |
| AGENTDET_ACCTYPE | AGENTDET_ACCTYPE | 1 | |
| AGENTDET_BUKRS | AGENTDET_BUKRS | 1 | |
| AMOUNTINCOMPANYCODECURRENCY | AMOUNTINCOMPANYCODECURRENCY | 2 | |
| AMOUNTINFUNCTIONALCURRENCY | AMOUNTINFUNCTIONALCURRENCY | 1 | |
| AMOUNTINGLOBALCURRENCY | AMOUNTINGLOBALCURRENCY | 1 | |
| AMOUNTINTHIRDCURRENCY | AMOUNTINTHIRDCURRENCY | 1 | |
| AMT_TEXT | AMT_TEXT | 1 | |
| AUTOAPPROVAL | AUTOAPPROVAL | 22 | |
| AUTOMATICAPPROVAL | AUTOMATICAPPROVAL | 1 | |
| BO_APPROVER | BO_APPROVER | 5 | |
| BO_NOTE | BO_NOTE | 1 | |
| BUKRS | BUKRS | 2 | |
| BUSINESSOBJECTTYPE | BUSINESSOBJECTTYPE | 1 | |
| CAINSTALLMENTPLANORIG | CAINSTALLMENTPLANORIG | 1 | |
| CALLBACKEXECUTED | CALLBACKEXECUTED | 3 | |
| CAWORKFLOWCHANGEID | CAWORKFLOWCHANGEID | 1 | |
| CAWORKFLOWCHECKPROCESS | CAWORKFLOWCHECKPROCESS | 6 | |
| CAWORKFLOWCHECKREASON | CAWORKFLOWCHECKREASON | 6 | |
| changed_at | changed_at | 2 | |
| changed_by | changed_by | 2 | |
| changed_on | changed_on | 2 | |
| CHGREQDOC | CHGREQDOC | 1 | |
| COMPANYCODE | COMPANYCODE | 1 | |
| COUNTER | COUNTER | 2 | |
| CPWF_DEFINITION_ID | CPWF_DEFINITION_ID | 1 | |
| CR_ID | CR_ID | 4 | |
| CREATEDBY | CREATEDBY | 1 | |
| CREATEDBYNAME | CREATEDBYNAME | 1 | |
| CREDIT_MEMO_REQUEST | CREDIT_MEMO_REQUEST | 1 | |
| CURRENCY | CURRENCY | 1 | |
| CUSTOMNUMBERVALUE | CUSTOMNUMBERVALUE | 1 | |
| dcl_type | dcl_type | 1 | |
| DECISION | DECISION | 30 | |
| description | description | 2 | |
| DESP_OTR_ALIAS | DESP_OTR_ALIAS | 1 | |
| DOCUMENTNUMBER | DOCUMENTNUMBER | 1 | |
| DOCUMENTNUMBER001 | DOCUMENTNUMBER001 | 1 | |
| DRAFUUID | DRAFUUID | 1 | |
| EMPTY_USER | EMPTY_USER | 2 | |
| EPIC_ITEM_SOURCE | EPIC_ITEM_SOURCE | 1 | |
| EVENT_CREATOR | EVENT_CREATOR | 1 | |
| EXCLUDEDAGENTS | EXCLUDEDAGENTS | 5 | |
| EXCLUDEDAGENTSLIST | EXCLUDEDAGENTSLIST | 19 | |
| EXTENDED | EXTENDED | 2 | |
| FIELDLOGISTICSTRANSFERPLANT | FIELDLOGISTICSTRANSFERPLANT | 1 | |
| FLDLOGSSUPLRITEMUUID | FLDLOGSSUPLRITEMUUID | 1 | |
| FLDLOGSSUPLRITMPOITMUNIQUEID | FLDLOGSSUPLRITMPOITMUNIQUEID | 1 | |
| INITIATOR | INITIATOR | 23 | |
| INITIATOR_COMMENTS | INITIATOR_COMMENTS | 1 | |
| INITIATORCOMMENT | INITIATORCOMMENT | 1 | |
| IS_FINAL_APPROVAL | IS_FINAL_APPROVAL | 1 | |
| IS_FIRST_APPROVAL | IS_FIRST_APPROVAL | 1 | |
| IS_OUTCOME_ERROR | IS_OUTCOME_ERROR | 1 | |
| IS_RETURNED_APPROVAL | IS_RETURNED_APPROVAL | 1 | |
| ITEM | ITEM | 1 | |
| ITEMTYPE | ITEMTYPE | 1 | |
| IV_PROCESSOR | IV_PROCESSOR | 3 | |
| language | language | 2 | |
| LASTAPPROVEDATE | LASTAPPROVEDATE | 5 | |
| LASTAPPROVER | LASTAPPROVER | 22 | |
| LASTAPPROVETIME | LASTAPPROVETIME | 5 | |
| LASTAPPROVEUSER | LASTAPPROVEUSER | 5 | |
| LASTPROCESSEDBY | LASTPROCESSEDBY | 1 | |
| LV_ASSIGNEE | LV_ASSIGNEE | 1 | |
| LV_DUE_DATE | LV_DUE_DATE | 1 | |
| MAPPING_GUID | MAPPING_GUID | 1 | |
| MV_PROPOSED_STATUS | MV_PROPOSED_STATUS | 1 | |
| MV_PROPOSED_STS_NAME | MV_PROPOSED_STS_NAME | 1 | |
| NAMEOFCHECK | NAMEOFCHECK | 1 | |
| NOCOMMITWORK | NOCOMMITWORK | 1 | |
| NOTIFICATIONID | NOTIFICATIONID | 1 | |
| NOTIFICATIONTYPE | NOTIFICATIONTYPE | 1 | |
| OBJECTCATEGORY | OBJECTCATEGORY | 1 | |
| OBJECTSTATUS | OBJECTSTATUS | 1 | |
| OBJID | OBJID | 2 | |
| OTYPE | OTYPE | 2 | |
| PAYMENTBLOCK | PAYMENTBLOCK | 1 | |
| PAYREQN_PAYMENT_METHOD | PAYREQN_PAYMENT_METHOD | 1 | |
| PAYREQN_PRIORITY | PAYREQN_PRIORITY | 1 | |
| PAYREQN_REQN_NUM | PAYREQN_REQN_NUM | 1 | |
| PERFORM_TASK | PERFORM_TASK | 2 | |
| PONUMBER | PONUMBER | 1 | |
| PR_ITEM | PR_ITEM | 1 | |
| PR_NO | PR_NO | 1 | |
| PREVIOUSAPPROVERLIST | PREVIOUSAPPROVERLIST | 26 | |
| PREVIOUSAPPROVERLIST001 | PREVIOUSAPPROVERLIST001 | 1 | |
| PRNUMBER | PRNUMBER | 1 | |
| PROCESSOR | PROCESSOR | 3 | |
| PROCESSORRESPONSIBLE | PROCESSORRESPONSIBLE | 2 | |
| PROJECTBILLINGREQUESTUUID | PROJECTBILLINGREQUESTUUID | 1 | |
| PROJECTUUID | PROJECTUUID | 1 | |
| PSDOC_APP_STATUS | PSDOC_APP_STATUS | 1 | |
| PSDOC_ID | PSDOC_ID | 1 | |
| PSDOC_RESULT | PSDOC_RESULT | 1 | |
| PURCHASE_REQ_ITEM_NUM | PURCHASE_REQ_ITEM_NUM | 2 | |
| PURCHASE_REQ_NUMBER | PURCHASE_REQ_NUMBER | 2 | |
| PURCHASERRESPONSIBLE | PURCHASERRESPONSIBLE | 2 | |
| QUALITYTASKID | QUALITYTASKID | 1 | |
| QUALITYTASKINTERNALID | QUALITYTASKINTERNALID | 1 | |
| QUOTATIONNUMBER | QUOTATIONNUMBER | 1 | |
| REJECTEDNAME | REJECTEDNAME | 1 | |
| REJECTEDREASON | REJECTEDREASON | 1 | |
| REJECTEDUNAME | REJECTEDUNAME | 1 | |
| RELEASECODE | RELEASECODE | 2 | |
| RELINDICATORNEW | RELINDICATORNEW | 1 | |
| RELSTATUSNEW | RELSTATUSNEW | 1 | |
| REQN_TYPE | REQN_TYPE | 1 | |
| REQUESTDESC | REQUESTDESC | 1 | |
| REQUESTERLIST | REQUESTERLIST | 4 | |
| REQUESTOR | REQUESTOR | 6 | |
| RETURNSORDERTYPE | RETURNSORDERTYPE | 1 | |
| REVERSALREASON | REVERSALREASON | 1 | |
| REVIEW_CURTYP | REVIEW_CURTYP | 1 | |
| REVIEW_ITEMTYPE | REVIEW_ITEMTYPE | 1 | |
| REVIEW_ITEMTYPE_CAT | REVIEW_ITEMTYPE_CAT | 1 | |
| REWORK | REWORK | 4 | |
| REWORK_REQUEST | REWORK_REQUEST | 2 | |
| REWORKNOTREQUIRED | REWORKNOTREQUIRED | 7 | |
| REWORKREQUESTEDBY | REWORKREQUESTEDBY | 16 | |
| RFQNUMBER | RFQNUMBER | 1 | |
| RPL_PR_NUMBER | RPL_PR_NUMBER | 1 | |
| RTGV_ID | RTGV_ID | 1 | |
| SALES_DOCUMENT | SALES_DOCUMENT | 1 | |
| SDDOCUMENTREASON | SDDOCUMENTREASON | 1 | |
| SDOC_RESULT | SDOC_RESULT | 1 | |
| SETTL_DOC_APP_STATUS | SETTL_DOC_APP_STATUS | 1 | |
| SETTL_DOC_ID | SETTL_DOC_ID | 1 | |
| SOLDTOPARTY | SOLDTOPARTY | 1 | |
| SOLDTOPARTY_NAME | SOLDTOPARTY_NAME | 1 | |
| SOURCECOMPANYCODE | SOURCECOMPANYCODE | 1 | |
| SOURCEPOITEM | SOURCEPOITEM | 1 | |
| SOURCINGSUPPLIERLISTNUMBER | SOURCINGSUPPLIERLISTNUMBER | 1 | |
| STEP_NAME | STEP_NAME | 1 | |
| SUBMITTER | SUBMITTER | 2 | |
| SUPPLIERCONFIRMATIONANUMBER | SUPPLIERCONFIRMATIONANUMBER | 2 | |
| SUPPLIERLISTNUMBER001 | SUPPLIERLISTNUMBER001 | 1 | |
| switch_state | switch_state | 1 | |
| switchable | switchable | 1 | |
| TASK_TITLE | TASK_TITLE | 4 | |
| TEST | TEST | 1 | |
| TEST_LONG | TEST_LONG | 1 | |
| TESTTIMESTAMP | TESTTIMESTAMP | 2 | |
| TO_WF_PRIORITY | TO_WF_PRIORITY | 1 | |
| TOTAL_NETAMOUNT | TOTAL_NETAMOUNT | 1 | |
| TOTAL_STEP | TOTAL_STEP | 1 | |
| TOTALACTUALAMOUNT | TOTALACTUALAMOUNT | 1 | |
| TRANSACTION_CURRENCY | TRANSACTION_CURRENCY | 1 | |
| URLEXTENSION | URLEXTENSION | 1 | |
| WAERS | WAERS | 2 | |
| WBSELEMENTS | WBSELEMENTS | 1 | |
| WORKFLOWSCENARIO | WORKFLOWSCENARIO | 1 | |
| WRBTR | WRBTR | 2 |
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 METADATA (
SRVB_NAME,
SRVC_NAME,
VERSION,
WORKFLOWID,
__KEY1,
__KEY2,
__KEY3,
__KEY4,
_WF_INITIATOR,
_WF_PRIORITY,
_WF_VERSION,
ABAP_LANGUAGE_VERSION,
ACCOUNT_ACTION,
ACCOUNTINGDOCUMENTTYPE,
AGENT,
AGENTDET_ACCTYPE,
AGENTDET_BUKRS,
AMOUNTINCOMPANYCODECURRENCY,
AMOUNTINFUNCTIONALCURRENCY,
AMOUNTINGLOBALCURRENCY,
AMOUNTINTHIRDCURRENCY,
AMT_TEXT,
AUTOAPPROVAL,
AUTOMATICAPPROVAL,
BO_APPROVER,
BO_NOTE,
BUKRS,
BUSINESSOBJECTTYPE,
CAINSTALLMENTPLANORIG,
CALLBACKEXECUTED,
CAWORKFLOWCHANGEID,
CAWORKFLOWCHECKPROCESS,
CAWORKFLOWCHECKREASON,
CHANGED_AT,
CHANGED_BY,
CHANGED_ON,
CHGREQDOC,
COMPANYCODE,
COUNTER,
CPWF_DEFINITION_ID,
CR_ID,
CREATEDBY,
CREATEDBYNAME,
CREDIT_MEMO_REQUEST,
CURRENCY,
CUSTOMNUMBERVALUE,
DCL_TYPE,
DECISION,
DESCRIPTION,
DESP_OTR_ALIAS,
DOCUMENTNUMBER,
DOCUMENTNUMBER001,
DRAFUUID,
EMPTY_USER,
EPIC_ITEM_SOURCE,
EVENT_CREATOR,
EXCLUDEDAGENTS,
EXCLUDEDAGENTSLIST,
EXTENDED,
FIELDLOGISTICSTRANSFERPLANT,
FLDLOGSSUPLRITEMUUID,
FLDLOGSSUPLRITMPOITMUNIQUEID,
INITIATOR,
INITIATOR_COMMENTS,
INITIATORCOMMENT,
IS_FINAL_APPROVAL,
IS_FIRST_APPROVAL,
IS_OUTCOME_ERROR,
IS_RETURNED_APPROVAL,
ITEM,
ITEMTYPE,
IV_PROCESSOR,
LANGUAGE,
LASTAPPROVEDATE,
LASTAPPROVER,
LASTAPPROVETIME,
LASTAPPROVEUSER,
LASTPROCESSEDBY,
LV_ASSIGNEE,
LV_DUE_DATE,
MAPPING_GUID,
MV_PROPOSED_STATUS,
MV_PROPOSED_STS_NAME,
NAMEOFCHECK,
NOCOMMITWORK,
NOTIFICATIONID,
NOTIFICATIONTYPE,
OBJECTCATEGORY,
OBJECTSTATUS,
OBJID,
OTYPE,
PAYMENTBLOCK,
PAYREQN_PAYMENT_METHOD,
PAYREQN_PRIORITY,
PAYREQN_REQN_NUM,
PERFORM_TASK,
PONUMBER,
PR_ITEM,
PR_NO,
PREVIOUSAPPROVERLIST,
PREVIOUSAPPROVERLIST001,
PRNUMBER,
PROCESSOR,
PROCESSORRESPONSIBLE,
PROJECTBILLINGREQUESTUUID,
PROJECTUUID,
PSDOC_APP_STATUS,
PSDOC_ID,
PSDOC_RESULT,
PURCHASE_REQ_ITEM_NUM,
PURCHASE_REQ_NUMBER,
PURCHASERRESPONSIBLE,
QUALITYTASKID,
QUALITYTASKINTERNALID,
QUOTATIONNUMBER,
REJECTEDNAME,
REJECTEDREASON,
REJECTEDUNAME,
RELEASECODE,
RELINDICATORNEW,
RELSTATUSNEW,
REQN_TYPE,
REQUESTDESC,
REQUESTERLIST,
REQUESTOR,
RETURNSORDERTYPE,
REVERSALREASON,
REVIEW_CURTYP,
REVIEW_ITEMTYPE,
REVIEW_ITEMTYPE_CAT,
REWORK,
REWORK_REQUEST,
REWORKNOTREQUIRED,
REWORKREQUESTEDBY,
RFQNUMBER,
RPL_PR_NUMBER,
RTGV_ID,
SALES_DOCUMENT,
SDDOCUMENTREASON,
SDOC_RESULT,
SETTL_DOC_APP_STATUS,
SETTL_DOC_ID,
SOLDTOPARTY,
SOLDTOPARTY_NAME,
SOURCECOMPANYCODE,
SOURCEPOITEM,
SOURCINGSUPPLIERLISTNUMBER,
STEP_NAME,
SUBMITTER,
SUPPLIERCONFIRMATIONANUMBER,
SUPPLIERLISTNUMBER001,
SWITCH_STATE,
SWITCHABLE,
TASK_TITLE,
TEST,
TEST_LONG,
TESTTIMESTAMP,
TO_WF_PRIORITY,
TOTAL_NETAMOUNT,
TOTAL_STEP,
TOTALACTUALAMOUNT,
TRANSACTION_CURRENCY,
URLEXTENSION,
WAERS,
WBSELEMENTS,
WORKFLOWSCENARIO,
WRBTR,
PRIMARY KEY (SRVB_NAME, SRVC_NAME, VERSION, WORKFLOWID)
);
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