PRF_C_ITEM - Item table for PRF
Item table for PRF information is stored in SAP table PRF_C_ITEM.
It is part of development package ID-LO-PRF-BL in software component FI-LOC-LO. This development package consists of objects that can be grouped under "Cross Country localization � PRF Business Logic".
It is part of development package ID-LO-PRF-BL in software component FI-LOC-LO. This development package consists of objects that can be grouped under "Cross Country localization � PRF Business Logic".
Fields for table PRF_C_ITEM
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | |
HEADER_KEY | Guid for unique identification of PRF Record | X | PRF_REC_GUID | CHAR | 64 | |
VERS_NO | Data Element for Item Version | X | PRF_VERS_NO | NUMC | 8 | |
.INCLUDE | PRF_S_SAP_ITEM_FLDS | 0 | ||||
ITEM_APPROVAL_STATUS | Approval status of PRF | PRF_APPRV_STATUS | CHAR | 2 | ||
ITEM_STATUS | Status of PRF | PRF_STATUS | CHAR | 4 | * | |
VENDOR_ID | Vendor Id | PRF_LIFNR | CHAR | 20 | * | |
VENDOR_NAM | Vendor Name | PRF_VEND_NAM | CHAR | 200 | ||
VENDOR_VATNO | VAT Registration Number | PRF_VAT_REG_NO | CHAR | 40 | ||
TOTAL_CONTRACT_VAL | Total Contract Value | PRF_TOTAL_CTR_VAL | CURR | 8 | ||
TOTAL_VAL_CURR | Type of Currency | PRF_CUR_KEY | CUKY | 10 | ||
CONTRACT_VALUE | Data Element for Contract Value | PRF_CTR_VAL | CURR | 8 | ||
CTR_START_DT | Contract Start Date | PRF_CTR_ST_DATE | DATS | 16 | ||
CTR_END_DT | Contract End Date | PRF_CTR_END_DATE | DATS | 16 | ||
CURRENCY_KEY | Type of Currency | PRF_CUR_KEY | CUKY | 10 | ||
PO_GRP | Purchasing group | PRF_EKGRP | CHAR | 20 | * | |
CALC_REF_DATE | Record Expiration Calculation reference date | PRF_CALC_REF_DATE | DATS | 16 | ||
AMEND_VALUE | Data Element for Amendment Value | PRF_AMENDMT_VAL | CURR | 8 | ||
AMEND_CURR | Type of Currency | PRF_CUR_KEY | CUKY | 10 | ||
AMEND_STARTDT | Amendment Start Date | PRF_AMENDT_STRT_DT | DATS | 16 | ||
AMEND_REASN | Text for Amendment Reason | PRF_AMENDMT_RSN_TXT | CHAR | 280 | ||
NODE_VERS | Data Element for Item Version | PRF_VERS_NO | NUMC | 8 | ||
ELMT_LAYOUT_XML | Component of the Version Number | CHAR2 | CHAR | 4 | ||
SRM_GUID | SRM Document Guid | PRF_SRM_GUID | RAW | 16 | ||
PARNT_RELEASE_ST | Parent Document Release Status | PRF_PARNT_DOC_STATUS | CHAR | 2 | ||
.INCLUDE | FLD_S_ELEMENTS | 0 | ||||
SON_MUL | SON or MUL | PRF_SON_MUL | CHAR | 2 | ||
SONID | Standing Offer Notice Identifier | PRF_SON_ID | CHAR | 40 | ||
AUST_IND | Aus Indicator | PRF_AUS_IND | CHAR | 2 | ||
ATMID | Approach to market identifier | PRF_ATM_ID | CHAR | 40 | ||
PROCUR_METD | PRF Procurement Method | PRF_PROCUR_METD | CHAR | 4 | ||
CPR_JUSTIF | CPR Justification | PRF_CPR_JUSTIF | CHAR | 200 | ||
UNSPSC_CODE | UNSPS Code | PRF_UNSPSCODE | CHAR | 16 | ||
CTR_DESC | PRF Contract Description | PRF_CTR_DESC | CHAR | 510 | ||
PUB_AUST | Aus Indicator | PRF_AUS_IND | CHAR | 2 | ||
PUB_BLK_REASON | PRF Publication Blocking Code | PRF_PUB_BLK_REASON | CHAR | 4 | ||
PUB_BLK_JUSTF | Text for Publication blocking justification | PRF_PUB_BLK_JUST | CHAR | 200 | ||
CONSULT_SERV_IND | Flag indicating consultancy services used | PRF_CONS_IND | CHAR | 2 | ||
JUSTIF_CONSULT | Consultancy Justification | PRF_CONS_REASON | CHAR | 4 | ||
CONSULT_OTH_DESC | Other description for Consultancy | PRF_CONSULT_ADDL_DESCR | CHAR | 200 | ||
CONF_PROV_IND | Confidentiality Provision Indicator | PRF_CONF_PROV_IND | CHAR | 2 | ||
CONFID_IND | Flag indicating Confidential Information Required | PRF_CONFID_IND | CHAR | 2 | ||
CONFID_REASON | Confidentiality Reason | PRF_CIREASON | CHAR | 4 | ||
CONFID_TXT | Text for Confidentiality Reason | PRF_CONFID_TXT | CHAR | 510 | ||
CONFID_OP_IND | Flag indicating contract output contains confidential info | PRF_CONFID_OP_IND | CHAR | 2 | ||
CONFID_OP_REASON | Confidentiality Output Reason Code | PRF_CIOUT_REASON | CHAR | 4 | ||
CONFID_OP_TXT | Text for Confidentiality Output Reason | PRF_CONFID_OP_TXT | CHAR | 510 | ||
CONTACT_CODE | PRF Contact Name Code | PRF_CONTACT_CODE | CHAR | 8 | ||
OFFICE_PCODE | PRF Office Postcode | PRF_OFFICE_PCODE | CHAR | 8 | ||
MATERIAL_GROUP | Data Element for Material Group | PRF_MAT_GRP | CHAR | 18 | * | |
GL_ACCOUNT | Data Element for G/L Account | PRF_GL_ACCOUNT | CHAR | 20 | * | |
CN_IDENTIFCTN | Char 15 | CHAR15 | CHAR | 30 | ||
PRF_CTR_START_DT | Contract Start Date | PRF_CTR_ST_DATE | DATS | 16 | ||
PRF_CTR_END_DT | Contract End Date | PRF_CTR_END_DATE | DATS | 16 | ||
LTR_EXEMPT_IND | PRF LTR Exemption Indicator | PRF_LTR_EXMP_IND | CHAR | 2 | ||
LTR_EXEMPT_CODE | PRF LTR Exemption Code | PRF_LTR_EXMP_CODE | CHAR | 4 | * | |
LTR_COND_CODE | PRF LTR Condition Code | PRF_LTR_COND_CODE | CHAR | 4 | * |