METADATA

METADATA is an SAP database table in S/4HANA. It contains 167 fields.

Fields (167)

KeyField CDS FieldsUsed 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)
);