SAP Table CIFSDLSTPSCO

Transfer Structure for Sales Scheduling Agreement Items

CIFSDLSTPSCO (Transfer Structure for Sales Scheduling Agreement Items) 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 CIFSDLSTPSCO to other SAP tables.

Source: CIFSDLSTPSCO (Transfer Structure for Sales Scheduling Agreement Items)

CIFSDLSTPSCO 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
TDSCO Type of Sales Contract SDLS_TDSCO CHAR 1 0
1 SD Scheduling Agreement
AUART Sales Document Type AUART CHAR 4 0
DOC_NUMBER Document Number (Purchasing/Sales...) CIFDOC CHAR 12 0
ITM_NUMBER Item Number of Document (Purchasing, Sales...) CIFITEM NUMC 6 0
VKORG Sales Organization VKORG CHAR 4 0
VTWEG Distribution Channel VTWEG CHAR 2 0
SPART Division SPART CHAR 2 0
MATNR Material Number CIFMATNR CHAR 40 0
LOCFR Plant CIFPLANT CHAR 20 0
LOCTO Sold-to party with length 20 for APO KUNAG_20 CHAR 20 0
VALFR Runtime Start CIFDATEF DEC 15 0
VALTO Runtime End CIFDATET DEC 15 0
ABDIS MRP for delivery schedule types ABDIS CHAR 1 0
NULL Delivery schedules are not used
A Requiremnts acc. to fore.dlv.sched/Delivery acc. to validity
B Requirements and deliveries according to validity
C Requirements acc. to fore.dlv.sched/Deliveries acc. to JIT
D Requirements acc. to validity/Deliveries acc. to JIT
E JIT delivery schedules are not used
PLAVO Planning delivery schedule instruction PLAVO CHAR 4 0
SP_STK_IND Special Stock Indicator CIFSPECSTO CHAR 1 0
SPEC_STOCK Key for Special Stock Section CIFSSKEY CHAR 16 0
APOMS APO as Planning System APOMS CHAR 1 0
NULL Planning and Release Generation in ERP
1 Planning and Release Generation in APO
COUNTER Internal Counter CIFCOUNT INT4 10 0
SCO_ACTIVE Sales Contract is Active SDLS_CIF_ACTIVE CHAR 1 0
X Yes
NULL No
VRKME Sales Unit SDLS_SLSUNIT UNIT 3 0
MEINS Base unit of measure CIFBASUNIT UNIT 3 0
UMVKZ Numerator (factor) for conversion of sales quantity into SKU UMVKZ DEC 5 0
UMVKN Denominator (Divisor) for Conversion of Sales Qty into SKU UMVKN DEC 5 0
POSEX Item Number of the Underlying Purchase Order POSEX CHAR 6 0
KDMAT Customer Material Number in APO KDMAT_APO CHAR 40 0
KNREF Customer description of partner (plant, storage location) KNREF CHAR 30 0
ABLAD Unloading Point ABLAD CHAR 25 0
KTEXT Search term for product proposal KTEXT_V CHAR 40 0
BSTKD Customer Purchase Order Number CIFBSTKD CHAR 35 0
BSTZD Purchase order number supplement BSTZD CHAR 4 0
ABRVW Usage Indicator ABRVW CHAR 3 0
IHREZ Your Reference IHREZ CHAR 12 0
KUNAG Sold-to party with length 20 for APO KUNAG_20 CHAR 20 0
INCO1 Incoterms (Part 1) INCO1 CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 0
KDGRP Customer group KDGRP CHAR 2 0
LPRIO Delivery Priority LPRIO NUMC 2 0
MATKL Material Group MATKL CHAR 9 0
ROUTE Route ROUTE CHAR 6 0
VSBED Shipping Conditions VSBED CHAR 2 0
VSTEL Shipping Point/Receiving Point VSTEL CHAR 4 0
VPZUO Allocation Indicator VPZUO CHAR 1 0
NULL No consumption with customer requirements
1 Consume planning with assembly
2 Consume planning w/o assembly
3 Consume planning material (w/o assembly)
ABLFZ Rounding quantity for delivery ABLFZ QUAN 13 3
USR01 Customer-Specific Field 1 SDLS_USR01 CHAR 35 0
USR02 Customer-Specific Field 2 SDLS_USR02 CHAR 35 0
USR03 Customer-Specific Field 3 SDLS_USR03 CHAR 35 0
USR04 Customer-Specific Field 4 SDLS_USR04 CHAR 10 0
USR05 Customer-Specific Field 5 SDLS_USR05 CHAR 10 0
RESET_CDQ Reset Cumulative Quantities at Change of Year SDLS_RESET_CDQ CHAR 1 0
A Standard = Automatic Reset of Cumulative Qty at Year Change
B No Reset of Cumulative Quantities at Year Change
C Not Supported
D Reset FZ at Year Change Using Cumulative Quantity Correction
VBTYP 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
VBKLT SD document indicator VBKLT CHAR 1 0
NULL No classification
A Billing request (line item billing)
B Delivery order
C Scheduling agreement with delivery order
D Invoice correction request
E Delivery order correction
F Repair processing: Leading serviceable material
G Repair processing: Leading service product
H Scheduling agreement with external service agent processing
I Consignment issue by external service agent
K Correct consignment issue by external service agent
R Order for Billing Between Company Codes (RRICB)
DSPROF Not More Closely Defined Area, Possibly Used for Patchlevels CHAR4 CHAR 4 0
CFPROF Not More Closely Defined Area, Possibly Used for Patchlevels CHAR4 CHAR 4 0