A_SalesSchedgAgrmtDelivSched

Delivery Schedule | view: ASDSCHEDGAGRMTDS | TRAN | Extraction: Not supported | Component: Customer Scheduling Agreement
Tables used: VBAPVBKDVEDAVBAKVBAKVBAPVBKDVEDAVBAPVBLB
Column Name Description
SalesSchedulingAgreement Sales Document
SalesSchedulingAgreementItem Sales Document Item
IntDeliveryScheduleNumber Internal delivery schedule number
SchedulingAgreementReleaseType Release type Show values
Column Name Description
Column Name Description
📏 Sales unit (OrderQuantityUnit):
CustRcvdCumltvQtyByFsclYrChg Cumulative quantity reached on date zero setting made
LastReceiptQuantity Last delivery quantity received by the customer
CumulativeReceiptQuantity Cumulative Quantity Received by Customer
HghstDelivGoAheadCumltvQty Highest delivery go-ahead cumulative quantity
ActlMatlGoAheadCumltvQty Actual cumulative material go-ahead quantity
ActlProdnGoAheadCumltvQty Actual cumulative production go-ahead quantity
ActlDelivGoAheadCumltvQty Actual cumulative delivery go-ahead quantity
HghstMatlGoAheadCumltvQty Highest cumulative material go-ahead quantity
LastDeliveryCumltvIssdQty Cumulative issued quantity for the last delivery
ExternalAgentCumltvIssdQty Cumulative quantity issued by external agent
CumulativeIssuedQuantity Cumulative issued quantity
CumulativeDeliveredQuantity Cumulative qty for delivery/MAIS in base unit of measure
CumulativeInTransitQuantity Difference between customer and current cumulative qties
SalesSchedgAgrmtInTrnstQty Quantity in transit on the basis of the specified delivery
Column Name Description
DeliveryScheduleStartDate Valid-from date of delivery schedule
DeliveryScheduleEndDate Valid-to date of delivery schedule
DeliveryScheduleDate Delivery Schedule Date
LastDeliveryDocPostingDate Last Delivery Date
CreationDate Date on which the record was created
CreationTime Entry time
JITHorizonEndDate JIT Horizon
DeliveryScheduleCreationDate Delivery schedule date of creation
ProdnGoAheadPeriodStartDate Start of production go-ahead
ProductionGoAheadPeriodEndDate End of production go-ahead
MaterialGoAheadPeriodStartDate Start of material go-ahead
MaterialGoAheadPeriodEndDate End of material go-ahead
CumltvQtyFsclYearRsetDate Date on which cumulative received quantity set to zero
LastDeliveryNoteSentDate Date of last delivery sent by external agent to customer
LastChangeDate Last Changed On
Column Name Description
SchedulingAgreementReleaseType Release type Show values
ScheduleLineDateKey Date Key for Schedule Line Date Show values
MatlGoAheadValidityPeriodUnit Material go-ahead - unit validity period Show values
ProdnGoAheadValidityPeriodUnit Production go-ahead - Unit validity period Show values
Column Name Description Domain name
CustomerDeliveryScheduleNumber Delivery Schedule TEXT17
CreatedByUser Name of Person Responsible for Creating the Object USNAM
CustomerFiscalYear Customer Fiscal Year GJAHR
RequirementsStatusKey Requirements status key CHAR1
DelivSchedFreeDefinedAttrib01 Additional data field 1 for delivery schedules TEXT35
DelivSchedFreeDefinedAttrib02 Additional data field 2 for delivery schedules TEXT35
DelivSchedFreeDefinedAttrib03 Additional data field 3 for delivery schedules TEXT35
DelivSchedFreeDefinedAttrib04 Additional data field 4 for delivery schedules CHAR10
DelivSchedFreeDefinedAttrib05 Additional data field 5 for delivery schedules CHAR10
CustomerPointOfConsumption Customer point of consumption CHAR14
HighPriorityStockKey Key for high priority stock CHAR1
MatlGoAheadValidityPeriod Material go-ahead - validity period NUM3
ProdnGoAheadValidityPeriod Production go-ahead - validity period NUM3
LastDeliveryNoteSentByExtAgt Last dlv. note sent by ext. service agent to the customer CHAR20
Master Data Relations Join Conditions
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • A_SALESSCHEDGAGRMTDELIVSCHED.SALESORGANIZATION == TVKOV.VKORG
  • A_SALESSCHEDGAGRMTDELIVSCHED.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • A_SALESSCHEDGAGRMTDELIVSCHED.MANDT == TVKOV.MANDT
Sales unit
  • Sales unit
  • Client
  • A_SALESSCHEDGAGRMTDELIVSCHED.ORDERQUANTITYUNIT == T006.MSEHI
  • A_SALESSCHEDGAGRMTDELIVSCHED.MANDT == T006.MANDT
Division in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • Division
  • A_SALESSCHEDGAGRMTDELIVSCHED.SALESORGANIZATION == TVTA.VKORG
  • A_SALESSCHEDGAGRMTDELIVSCHED.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • A_SALESSCHEDGAGRMTDELIVSCHED.MANDT == TVTA.MANDT
  • A_SALESSCHEDGAGRMTDELIVSCHED.ORGANIZATIONDIVISION == TVTA.SPART
Sales organization in order header
  • Sales Organization
  • Client
  • A_SALESSCHEDGAGRMTDELIVSCHED.SALESORGANIZATION == TVKO.VKORG
  • A_SALESSCHEDGAGRMTDELIVSCHED.MANDT == TVKO.MANDT
Order type in order header
  • Sales Scheduling Agreement Type
  • Client
  • A_SALESSCHEDGAGRMTDELIVSCHED.SALESSCHEDGAGRMTTYPE == TVAK.AUART
  • A_SALESSCHEDGAGRMTDELIVSCHED.MANDT == TVAK.MANDT