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.