ACCGO_T_SNPDRFT is a standard SAP table in SAP ECC (or) S/4HANA which stores I_CONTRACTSNAPSHOT I_CONTRACTSNAPSHOT data. There are total 53 fields in ACCGO_T_SNPDRFT table.This blog post provides key technical details of SAP table ACCGO_T_SNPDRFT, including its availability across SAP S/4HANA versions and the list of CDS views for ACCGO_T_SNPDRFT table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | Package for Contracts CDS Views (ACCGO_ACM_CNTRCTS) |
| Technical Component | SAP Agricultural Contract Management (LO-AGR) |
SAP ACCGO_T_SNPDRFT Table Fields
The following is the list of fields that are available in SAP ACCGO_T_SNPDRFT table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | CLNT (3) | |
| DRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | SYSUUID | RAW (16) | |
| DOCUMENTID | Trading Contract | TKONN | TKONN | CHAR (10) | |
| SNAPSHOTID | Trading Contract | TKONN | TKONN | CHAR (10) | |
| DATEANDTIME | Snapshot Timestamp | /ACCGO/E_SNP_TMPSTMP | TZNTSTMPS | DEC (15) | |
| SNAPSHOTLEVEL | ACM Contract Snapshot Level | /ACCGO/E_CNTRCT_SNP_LEVEL | /ACCGO/D_CNTRCT_SNP_LEVEL | CHAR (1) | |
| TPOSN | Item Number of Trading Contract | TPOSN | TPOSN | NUMC (6) | |
| TRADINGCONTRACTEXTERNALID | External Identifier in Trading Contract | TKONN_EX | TKONN_EX | CHAR (30) | |
| CONTRACTNUM | Snapshot ID | /ACCGO/E_SNAP_ID | /ACCGO/D_SNAP_ID | CHAR (30) | |
| OUTPUTPROCESSINGSTATUS | Output Processing | /ACCGO/E_OUTPUT_PROC | /ACCGO/D_OUTPUT_PROC | CHAR (1) | |
| RELEVANTFORSIGNATUREIND | Snapshot Signature Relevancy | /ACCGO/E_SNP_REL_SIG | /ACCGO/D_SNP_REL_SIG | CHAR (1) | |
| SIGNATURESTATUS | Signature Status | /ACCGO/E_SIGNATURE_STATUS | /ACCGO/D_SIGNATURE_STATUS | CHAR (1) | |
| SNAPSHOTLEVELTXT | Snapshot Level Description | /ACCGO/E_SNAPSHOT_LVL_TXT | CHAR10 | CHAR (10) | |
| TRADERID | Amending Trader ID | /ACCGO/E_AMEND_TRADERID | /ACCGO/D_TRADER_ID | CHAR (12) | |
| ORIGINALTRADERID | Responsible Trader ID | /ACCGO/E_RESP_TRADERID | /ACCGO/D_TRADER_ID | CHAR (12) | |
| SNAPSHOTSTATUS | Snapshot Status | /ACCGO/E_SNAPSHOT_STATUS | BTBSTA | CHAR (1) | |
| FIELDNAME | Snapshot Field Name | /ACCGO/E_SNP_FIELD_NAME | /ACCGO/D_SNP_FIELD_NAME | CHAR (30) | |
| FIELDDESCRIPTION | Snapshot Admin Fields | /ACCGO/E_SNP_FIELD_DESC | /ACCGO/D_SNP_FIELD_DESC | CHAR (40) | |
| VALUE | Snapshots Field Value for Change Relevant Fields | /ACCGO/E_SNP_FIELD_VALUE | CHAR60 | CHAR (60) | |
| VALUEADDITIONAL | Snapshots Field Value for Change Relevant Fields | /ACCGO/E_SNP_FIELD_VALUE | CHAR60 | CHAR (60) | |
| VALUEDESCRIPTION | Short Text for Fixed Values | VAL_TEXT | DDTEXT | CHAR (60) | |
| PURPOSETEXT | Short Text for Fixed Values | VAL_TEXT | DDTEXT | CHAR (60) | |
| COUNTERPARTY | Customer Number | KUNNR | KUNNR | CHAR (10) | |
| CONTRACTAPPLICATIONSTATUS | Application Status of Trading Contract | BTBSTA | BTBSTA | CHAR (1) | |
| CONTRACTTYPE | Trading Contract Type | TCTYP | TCTYP | CHAR (4) | |
| CONTRACTTYPENAME | Name of Trading Contract Type | TCTYP_BEZ | TEXT40 | CHAR (40) | |
| CREATEDBY | Name of Person who Created the Object | ERNAM | USNAM | CHAR (12) | |
| CREATEDBYNAME | Full Name of Person | AD_NAMTEXT | TEXT80 | CHAR (80) | |
| CREATEDON | Date on which the record was created | ERDAT | DATUM | DATS (8) | |
| SALESORGANIZATION | Sales Organization | VKORG | VKORG | CHAR (4) | |
| SALESORGANIZATIONNAME | Name | VTXTK | TEXT20 | CHAR (20) | |
| DISTRIBUTIONCHANNEL | Distribution Channel | VTWEG | VTWEG | CHAR (2) | |
| DISTRIBUTIONCHANNELNAME | Distribution Channel Description | DISTRIBUTIONCHANNELNAME | TEXT20 | CHAR (20) | |
| DIVISON | Division | SPART | SPART | CHAR (2) | |
| DIVISONNAME | Name | VTXTK | TEXT20 | CHAR (20) | |
| PURCHASINGORGANIZATION | Purchasing organization | EKORG | EKORG | CHAR (4) | |
| PURCHASINGORGANIZATIONNAME | Description of purchasing organization | EKOTX | TEXT20 | CHAR (20) | |
| PURCHASINGGROUP | Purchasing Group | EKGRP | EKGRP | CHAR (3) | |
| PURCHASINGGROUPNAME | Purchasing Group Name | MM_A_PURG_GRP_NAME | TEXT18 | CHAR (18) | |
| TRDGCONTRPURGINCOTERMSLOC1TEXT | Incoterms Location 1 | INCO2_L | INCO_L | CHAR (70) | |
| TRDGCONTRSLSINCOTERMSLOC1TEXT | Incoterms Location 1 | INCO2_L | INCO_L | CHAR (70) | |
| TRANSACTINGCTPTY | Reference to other vendor | LIFN2 | LIFNR | CHAR (10) | |
| COMMODITY | Commodity | TBA_STOEFFCHEN | TBA_STOEFFCHEN | CHAR (18) | |
| PLANT | Plant | WERKS_D | WERKS | CHAR (4) | |
| PLANTNAME | Plant Name | WERKS_NAME | TEXT30 | CHAR (30) | |
| ACMYOURREFERENCE | Your Reference | IHREZ | TEXT12 | CHAR (12) | |
| ACMCUSTOMERREFERENCE | Customer Reference | BSTKD | BSTKD | CHAR (35) | |
| HASACTIVEENTITY | Draft – Indicator – Has active document | SDRAFT_HAS_ACTIVE | BOOLE | CHAR (1) | |
| DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | TZNTSTMPL | DEC (21) | |
| DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | TZNTSTMPL | DEC (21) | |
| DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | SYSUUID | RAW (16) | |
| DRAFTENTITYCONSISTENCYSTATUS | Draft Consistency Status | SDRAFT_CONSISTENCY_STATUS | SDRAFT_CONSISTENCY_STATUS | CHAR (1) | |
| DRAFTENTITYOPERATIONCODE | Draft – Operation Code | SDRAFT_OPERATION_CODE | SDRAFT_OPERATION_CODE | CHAR (1) |
Availability
The SAP table ACCGO_T_SNPDRFT is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for ACCGO_T_SNPDRFT table
There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.
