1. Home
  2. Resources
  3. SAP Tables
  4. CIF_SL_DOC - Interface structure for Sales & Distribution document

SAP Table CIF_SL_DOC

Interface structure for Sales & Distribution document

CIF_SL_DOC (Interface structure for Sales & Distribution document) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CIF_SL_DOC to other SAP tables.

CIF_SL_DOC table fields

Field Data element Checktable Datatype Length Decimals
METHOD Method to be Executed During the Transfer of an Object CIFMETHOD CHAR 1 0
D Delete (for example a schedule line)
C Change (for example a schedule line)
N New (for example a schedule line)
R Remove total object (for example deletion of an order)
A Add, Stock is Added or Reduced
M Maintain, New or Change but not Delete
DOC_NUMBER Document Number (Purchasing/Sales...) CIFDOC CHAR 12 0
ITM_NUMBER Item number of the SD document POSNR NUMC 6 0
ATPCAT ATP Category in APO CIFATPCAT CHAR 2 0
DOC_TYPE SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
� Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
ORD_TYPE Sales Document Type AUART CHAR 4 0
SALES_ORG Sales Organization VKORG CHAR 4 0
DIVISION Division SPART CHAR 2 0
DISTR_CHAN Distribution Channel VTWEG CHAR 2 0
SLSOFF Sales Office VKBUR CHAR 4 0
SLSGRP Sales Group VKGRP CHAR 3 0
SOLD_TO Sold-to party with length 20 for APO KUNAG_20 CHAR 20 0
COMPL_DLV Complete delivery defined for each sales order? AUTLF CHAR 1 0
X Yes
NULL No
ITEM_CATEG Sales document item category PSTYV CHAR 4 0
CREATOR Name of Person who Created the Object ERNAM CHAR 12 0
PRODUCT Material Number CIFMATNR CHAR 40 0
LOCATION Plant CIFPLANT CHAR 20 0
STORE_LOC Storage Location CIFSTORLOC CHAR 4 0
BATCH Batch Number CHARG_D CHAR 10 0
SHIP_TO Sold-to party with length 20 for APO KUNAG_20 CHAR 20 0
SHIP_POINT Shipping Point/Receiving Point VSTEL CHAR 4 0
ROUTE Route ROUTE CHAR 6 0
SHP_COND Shipping Conditions VSBED CHAR 2 0
DLV_PRIO Delivery Priority LPRIO NUMC 2 0
PART_DLV Partial delivery at item level KZTLF CHAR 1 0
NULL Partial delivery allowed
A Create a delivery with qty greater than zero
B Create only one delivery (also with quantity = 0)
C Only complete delivery allowed
D No limit to subsequent deliveries
MAX_PL_DLV Maximum Number of Partial Deliveries Allowed Per Item ANTLF DEC 1 0
ALLOC Product allocation determination procedure KOSCH CHAR 18 0
LOGSYS Logical system LOGSYS CHAR 10 0
BSTNK Document Number (Purchasing/Sales...) CIFDOC CHAR 12 0
POSNR Sales Document Item POSNR_VA NUMC 6 0
LOCTYPE APO Location Type CIFLOCTYPE CHAR 4 0
PSSPARAM PASS Parameter CIFPSSPAR CHAR 1 0
RRFLAG Rounding Rule Indicator CIFRRFLAG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
OVERR_LOC Location CIFLOCNO CHAR 20 0
OVERR_LOCT APO Location Type CIFLOCTYPE CHAR 4 0
ATP_DUEDAT ATP Due Date CIFATPDUED DEC 15 0
CONS_LOC Location CIFLOCNO CHAR 20 0
CONS_LOCT APO Location Type CIFLOCTYPE CHAR 4 0
TPDS_FLAG TPDS Indicator CIFTPDSFLG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
DIR_SHP_NC Direct Delivery Without Consolidation CIFDIRSHNC CHAR 1 0
ITM_USAGE Usage of Higher-Level Item CIFITMUSE CHAR 2 0
ITM_USAGET Usage of Item Category CIFITMUSET CHAR 4 0
ITM_ANCHOR Sales Document Item POSNR_VA NUMC 6 0
GEOROUTE Geocoding Route CIFGEOROUT CHAR 10 0
GEOROUTE_I Change Indicator for Geocoding Route CIFGEOROUI CHAR 1 0
CARRIER Business Partner ID PARTNER_ID CHAR 10 0
CARRIER_I Change Indicator for Transportation Service Provider CIFCARRIND CHAR 1 0
OVR_RULE_NUM_LOC BIN1 data element for SYST SYBIN1 INT1 3 0
RBACONTROL Control of Rules-Based ATP Check RBACONTROL CHAR 1 0
NULL Subitems Allowed, Plant Substitution in Item Not Allowed
C Subitems and Plant Substitution in Item Not Allowed
D Subitems Not Allowed, Plant Substitution in Item Allowed
E Subitems and Plant Substitution in Item Allowed
N Rules-Based ATP Check Not Allowed